active Legal form GmbH Gesellschaft mit beschränkter Haftung

Just Friends Productions GmbH

KölnKöln, DEU ·HRB 109312 Köln

Handelsregister API View JSON Collapse

{
    "name": "Just Friends Productions GmbH",
    "status": "ACTIVE"
}

Live API

GEThandelsregister.ai/api/v1/fetch-organization

?q=e367f863807950b628e3e5f521c8d0bd

&features=financial_kpi

&features=balance_sheet_accounts

&features=related_persons

&features=shareholders

&features=ubos

&features=history

&features=annual_financial_statements__html

curl -H 'X-API-KEY: YOUR_API_KEY' \
  "https://handelsregister.ai/api/v1/fetch-organization?q=e367f863807950b628e3e5f521c8d0bd&features=financial_kpi&features=balance_sheet_accounts&features=related_persons&features=shareholders&features=ubos&features=history&features=annual_financial_statements__html"

# pip install handelsregister
from handelsregister import Handelsregister

client = Handelsregister(api_key="YOUR_API_KEY")  # or set HANDELSREGISTER_API_KEY
organization = client.fetch_organization(
    q="e367f863807950b628e3e5f521c8d0bd",
    features=[
        "financial_kpi",
        "balance_sheet_accounts",
        "related_persons",
        "shareholders",
        "ubos",
        "history",
        "annual_financial_statements__html",
    ],
)
print(organization["name"])

// npm install handelsregister
import { Handelsregister } from 'handelsregister';

const client = new Handelsregister('YOUR_API_KEY'); // or set HANDELSREGISTER_API_KEY
const organization = await client.fetchOrganization({
  q: 'e367f863807950b628e3e5f521c8d0bd',
  features: [
    'financial_kpi',
    'balance_sheet_accounts',
    'related_persons',
    'shareholders',
    'ubos',
    'history',
    'annual_financial_statements__html',
  ],
});
console.log(organization.name);

// npm install handelsregister
const { Handelsregister } = require('handelsregister');

const client = new Handelsregister(process.env.HANDELSREGISTER_API_KEY);
(async () => {
  const organization = await client.fetchOrganization({
    q: 'e367f863807950b628e3e5f521c8d0bd',
    features: [
      'financial_kpi',
      'balance_sheet_accounts',
      'related_persons',
      'shareholders',
      'ubos',
      'history',
      'annual_financial_statements__html',
    ],
  });
  console.log(organization.name);
})();

JSON preview

{
    "entity_id": "e367f863807950b628e3e5f521c8d0bd",
    "name": "Just Friends Productions GmbH",
    "status": "ACTIVE",
    "legal_form": "GmbH",
    "registration_date": "2021-11-18T00:00:00+00:00",
    "address": {
        "street": "Butzweilerhofallee",
        "house_number": "2-4",
        "postal_code": "50829",
        "city": "Köln",
        "country": "DEU"
    },
    "registration": {
        "register_type": "HRB",
        "register_number": "109312",
        "court": "Köln"
    }
}

"purpose": "…"

Register to retrieve the full JSON response in the playground. A monthly plan lets you expand every JSON field directly here.

Register for free

"representation_scheme": { … }

Register to retrieve the full JSON response in the playground. A monthly plan lets you expand every JSON field directly here.

Register for free

"capital": { … }

Register to retrieve the full JSON response in the playground. A monthly plan lets you expand every JSON field directly here.

Register for free

"industry_classification": { … }

Register to retrieve the full JSON response in the playground. A monthly plan lets you expand every JSON field directly here.

Register for free

"history": [ … ]

Register to retrieve the full JSON response in the playground. A monthly plan lets you expand every JSON field directly here.

Register for free

"financial_kpi": [ … ]

Register to retrieve the full JSON response in the playground. A monthly plan lets you expand every JSON field directly here.

Register for free

"related_persons": { … }

Register to retrieve the full JSON response in the playground. A monthly plan lets you expand every JSON field directly here.

Register for free

"shareholders": { … }

Register to retrieve the full JSON response in the playground. A monthly plan lets you expand every JSON field directly here.

Register for free

"ubos": { … }

Register to retrieve the full JSON response in the playground. A monthly plan lets you expand every JSON field directly here.

Register for free

"balance_sheet_accounts": [ … ]

Register to retrieve the full JSON response in the playground. A monthly plan lets you expand every JSON field directly here.

Register for free

"annual_financial_statements__html": [ … ]

Register to retrieve the full JSON response in the playground. A monthly plan lets you expand every JSON field directly here.

Register for free

Base fields

entity_id string

Stable handelsregister.ai identifier (32-char hex string).

name string

Registered legal name of the entity.

status enum

ACTIVE, TERMINATED, DISSOLVED or INSOLVENT.

legal_form string

Legal form (GmbH, AG, KG, …) when available.

address object

Postal address with street, house_number, postal_code, city, county, state, country and coordinates.

registration object

Register record with court, register_type and register_number.

registration_date date

Initial entry into the commercial register (ISO date).

purpose string

Stated business purpose (Unternehmensgegenstand).

representation_scheme object

General representation scheme: { current: [...], history: [...] } with effective_from/effective_to per version.

capital object

Registered capital: { current, history }. current carries amount, currency and kind (STAMMKAPITAL, GRUNDKAPITAL, HAFTSUMME, GENEHMIGTES_KAPITAL, BEDINGTES_KAPITAL, VARIABLES_KAPITAL — open enum); each history entry has value, effective_from and effective_to (null = still in force). change_amount on a history entry is unsigned and does not always equal the difference between two consecutive amounts, so derive increases and decreases from the amounts. Partnerships and other entities without registered capital return current: null and an empty history.

contact_data object

website, phone_number and email when available.

industry_classification object

Industry codes per WZ2008 and WZ2025 with labels.

keywords array<string>

Keywords derived from the business purpose.

products_and_services array<string>

Product and service descriptions when available.

history array<object>

Chronological log of all register changes (name, seat, capital, representation, …).

features=financial_kpi

financial_kpi array<object>

Per fiscal year: revenue, employees, active_total (balance-sheet total), net_income, material_expenses, personnel_expenses.

features=balance_sheet_accounts

balance_sheet_accounts array<object>

Per fiscal year: hierarchical balance-sheet line items from the published annual statement.

features=profit_and_loss_account

profit_and_loss_account array<object>

Per fiscal year: hierarchical profit-and-loss line items.

features=related_persons

related_persons object

Authorized representatives: { current: [...], past: [...] } — managing directors, board members, signatories. Each person carries organization_representation_scheme and role_representation_scheme (current scheme + history).

features=shareholders

shareholders object

Shareholders: { total_capital, entries: [...], history: { current_as_of, past: [...] } }. Each entry carries shareholder, contribution, contribution_ratio and role; history.past delivers previous shareholder lists with an as_of date. total_capital, contribution and contribution_ratio may be null (e.g. for partnerships).

features=ubos

ubos object

Ultimate beneficial owners: { beneficial_owners, unresolved_beneficial_owners, coverage } as recorded in the transparency register.

features=shareholdings

shareholdings object

Stakes this entity holds in others: { holdings: { current: [...] }, summary }. Each holding links another organization by entity_id.

features=publications

publications array<object>

Official commercial-register publications (date, title, full text).

features=annual_financial_statements__html

annual_financial_statements__html array<object>

Published annual statements with document_html (rendered HTML), document_type, document_title, document_date, language and year.

Overview

Legal form: GmbH
Address: Butzweilerhofallee 2-4
50829 Köln
Commercial register: HRB 109312, Köln
Registration date: November 18, 2021
Industry: Herstellung von Verpackungsmitteln aus Kunststoffen
Fernsehveranstalter und Verbreitung von Videoinhalten
Herstellung von Gipserzeugnissen für den Bau
Registered capital: 25,000.00 EUR
Representation rules: Ist nur ein Geschäftsführer bestellt, so vertritt er die Gesellschaft allein. Sind mehrere Geschäftsführer bestellt, so wird die Gesellschaft durch zwei Geschäftsführer oder durch einen Geschäftsführer gemeinsam mit einem Prokuristen vertreten.
Purpose: die Entwicklung und Produktion von faktischen Inhalten für den deutschsprachigen Raum für verschiedene Abnehmer, d. h. Sender und Plattformen innerhalb und außerhalb der ProSiebenSat.1-Gruppe.

Financials

Employees 2022

35

Total assets 2022

6,02 Mio. €

Net income 2022

0 €

Balance sheet

2022

Assets 6,02 Mio

Current Assets 99,1 % 5,97 Mio
Fixed Assets 0,7 % 39,7 k
Prepaid Expenses 0,2 % 14,0 k

Liabilities and Equity 6,02 Mio

Liabilities 82,0 % 4,94 Mio
Provisions 17,6 % 1,06 Mio
Equity 0,4 % 25,0 k

Full balance sheet line items with an API key Get API key →

Authorized representatives

Cornelia Landgraf since 2022 Managing Director
Martin Anton Metzger since 2022 Managing Director
Sylvia Fahrenkrog-Petersen since 2023 Managing Director

4 former representatives · viewable with an API key Get API key →

Ownership & holdings

Shareholders

Seven.One Studios GmbH DEU AG München, HRB 168018 100.0 % 25k €

Ultimate beneficial owners (UBOs)

The ultimate beneficial owners behind these holdings could not be conclusively identified.

History

2024
08.05.

Exit of position

H***** P**** · Managing Director
04.01.

Change of address

Just Friends Productions GmbH
04.01.

Change of bylaws

Just Friends Productions GmbH
04.01.

Change of company name

Just Friends Productions GmbH
03.01.

Change of address

Just Friends Productions GmbH
2023
06.10.

Member entry

Sylvia Fahrenkrog-Petersen · Managing Director
26.04.

Correction of entity data

Just Friends Productions GmbH
2022
16.12.

Enterprise agreement

Just Friends Productions GmbH

41 more events including all details Get API key →

Annual statements

Original published statements, ordered by fiscal year.

1 document

Fiscal year	Document	Published	Access
2022	Jahresabschluss	Published May 6, 2024	Via the API

All financial statements via the API

Register documents

Bring original register extracts and company documents into your application as PDF or XML.

GET/v1/fetch-document

View the document API

Current extract (AD) PDF
Chronological extract (CD) PDF
Structured content (SI, XML) XML
Shareholders list PDF
Articles of association PDF

Explore more companies

Handelsregister API · MCP

Company data in your AI chat

Ask about directors, ownership and financial figures. Our MCP server connects your assistant to the Handelsregister API.

MCP documentation

Connect your assistant

Open Connectors in Claude and add a custom connector.
Enter this server URL and add the connector:
https://mcp.handelsregister.ai/mcp
Connect with your handelsregister.ai account, then enable the connector in your chat via “+” → “Connectors”.

In ChatGPT on the web, open Settings → Apps and create a custom app. Developer mode must be enabled for your account.
Use “handelsregister” as the name, OAuth for authentication and this server URL:
https://mcp.handelsregister.ai/mcp
Sign in with your handelsregister.ai account, create the app and select it from the tools menu in your chat.

Run once in your terminal:

Terminal

claude mcp add --transport http handelsregister https://mcp.handelsregister.ai/mcp \
  --header "X-API-Key: YOUR_API_KEY"

Replace YOUR_API_KEY with your handelsregister.ai API key.

Add this MCP server as a tool in your application:

Python

from openai import OpenAI

client = OpenAI()
response = client.responses.create(
    model="gpt-6-astra",
    input="Show me the directors, shareholders and latest available financial figures for Just Friends Productions GmbH. Include fiscal years and sources.\n\nentity_id: e367f863807950b628e3e5f521c8d0bd",
    tools=[{
        "type": "mcp",
        "server_label": "handelsregister",
        "server_url": "https://mcp.handelsregister.ai/mcp",
        "headers": {"X-API-Key": "YOUR_API_KEY"},
        "require_approval": "never",
    }],
)
print(response.output_text)

Replace YOUR_API_KEY with your handelsregister.ai API key.

Add this configuration to your MCP client:

JSON

{
  "mcpServers": {
    "handelsregister": {
      "url": "https://mcp.handelsregister.ai/mcp",
      "headers": { "X-API-Key": "YOUR_API_KEY" }
    }
  }
}

Replace YOUR_API_KEY with your handelsregister.ai API key.

Ask about this company

Once connected, ask your assistant this question:

Show me the directors, shareholders and latest available financial figures for Just Friends Productions GmbH. Include fiscal years and sources.

entity_ide367f863807950b628e3e5f521c8d0bd

Copying failed. Please select the text and copy it manually.