Skip to content

Registered aircraft · 71

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'PYKA INC' OR list_contains(g.other_registrant_names, 'PYKA INC') ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'PYKA INC' OR list_contains(g.other_registrant_names, 'PYKA INC')
  ORDER BY g.n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_name = 'PYKA INC' OR list_contains(g.other_registrant_names, 'PYKA INC')
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N103PYPyka PELICAN · S/N 16056PS0065Alameda, CA N109PYPyka PELICAN · S/N 16056PS0066Alameda, CA N111PYPyka PELICAN · S/N 16056PS0067Alameda, CA N1348TPyka PELICAN · S/N 16056PS0036Built 2024 · Alameda, CA N1349UPyka PELICAN CARGO · S/N 16056PC0010Alameda, CA N1351NPyka PELICAN CARGO · S/N 16056PC0008Alameda, CA N1352QPyka PELICAN · S/N 16056PS0039Built 2024 · Alameda, CA N1353GPyka PELICAN CARGO · S/N 16056PC0006Built 2023 · Alameda, CA N1357DPyka PELICAN · S/N 16056PS0038Built 2025 · Alameda, CA N1367ZPyka PELICAN · S/N 16056PS0037Built 2025 · Alameda, CA N136RPPyka PELICAN CARGO · S/N 16056PC0009Alameda, CA N136XPPyka PELICAN · S/N 16056PS0035Built 2024 · Alameda, CA N136ZPPyka PELICAN CARGO · S/N 16056PC0007Built 2024 · Alameda, CA N210PYPyka PELICAN · S/N 16056PS0070Alameda, CA N221PYPyka PELICAN · S/N 16056PS0071Alameda, CA N223PYPyka PELICAN · S/N 16056PS0072Alameda, CA N265NAPyka PELICAN · S/N 16056PS0063Alameda, CA N354WSPyka PA02 · S/N 1796F00164E833EA39E0Built 2020 · Alameda, CA N487RSPyka PA02 · S/N 6907Built 2022 · Alameda, CA N4880PPyka PELICAN · S/N 16056PS0055Alameda, CA N4881PPyka PELICAN · S/N 16056PS0060Alameda, CA N4882PPyka PELICAN · S/N 16056PS0048Alameda, CA N4884PPyka PELICAN · S/N 16056PS0061Alameda, CA N4885PPyka PELICAN · S/N 16056PS0062Alameda, CA N4886PPyka PELICAN · S/N 16056PS0049Alameda, CA N4887PPyka PELICAN · S/N 16056PS0064Alameda, CA N4888PPyka PELICAN · S/N 16056PS0045Alameda, CA N4889PPyka PELICAN · S/N 16056PS0058Alameda, CA N488MPPyka PELICAN · S/N 16056PS0056Alameda, CA N488NPPyka PELICAN · S/N 16056PS0046Alameda, CA N488VAPyka PELICAN · S/N 16056PS0057Alameda, CA N488XPPyka PELICAN · S/N 16056PS0059Alameda, CA N488YPPyka PELICAN · S/N 16056PS0047Alameda, CA N489APPyka PELICAN · S/N 16056PS0050Alameda, CA N489BPPyka PELICAN · S/N 16056PS0051Alameda, CA N489CWPyka PELICAN · S/N 16056PS0053Alameda, CA N489DWPyka PELICAN · S/N 16056PS0052Alameda, CA N489EWPyka PELICAN · S/N 16056PS0054Alameda, CA N531WPPyka DROPSHIP · S/N 16056DS0001Built 2026 · Alameda, CA N587MPPyka PELICAN · S/N 16056PS0073Alameda, CA N587NPPyka PELICAN · S/N 16056PS0068Alameda, CA N587PPPyka PELICAN · S/N 16056PS0069Alameda, CA N587QPPyka PELICAN · S/N 16056PS0074Alameda, CA N605PKPyka PELICAN · S/N 16056PS0025Oakland, CA N653BSPyka P-400B · S/N 6902Oakland, CA N663HPPyka DROPSHIP · S/N 16056DS0002Alameda, CA N663JPPyka DROPSHIP · S/N 16056DS0003Alameda, CA N663KPPyka DROPSHIP · S/N 16056DS0005Alameda, CA N679GRPyka DROPSHIP · S/N 16056DS0004Alameda, CA N760EEPyka PELICAN · S/N 16056PS0044Alameda, CA

Back to Pyka Inc