Skip to content

Registered aircraft · 66

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 = 'ABC INC' OR list_contains(g.other_registrant_names, 'ABC 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 = 'ABC INC' OR list_contains(g.other_registrant_names, 'ABC 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 = 'ABC INC' OR list_contains(g.other_registrant_names, 'ABC 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.

N1703RDJI MAVIC 3 · S/N 1581F67QC2359014U09HSecaucus, NJ N1707RDJI MAVIC 3 · S/N 1581F67QC234S01416XWSecaucus, NJ N170GRDJI MAVIC 3 · S/N 1581F67QC235A0146CQ3Secaucus, NJ N171QCDJI MAVIC 3 PRO · S/N 1581F67QC2359014PNX5Secaucus, NJ N171RDDJI MAVIC 3 PRO · S/N 1581F67QC2355014K285Secaucus, NJ N1728BDJI MAVIC 3 PRO · S/N 1581F67QC2356014P0B3Secaucus, NJ N200WDDJI PHANTOM 4 · S/N 07DDD6L0B10623Secaucus, NJ N202WDDJI PHANTOM 4 · S/N 07DDD630B10403Secaucus, NJ N208WDDJI PHANTOM 4 · S/N 07DDD6N0B10310Secaucus, NJ N217WDDJI PHANTOM 4 · S/N 07DDD670B11370Secaucus, NJ N218WDDJI PHANTOM 4 · S/N 07DDD780B11859Secaucus, NJ N271FADJI AIR 3 · S/N 1581F6N8A23ACML349T2Secaucus, NJ N271HADJI MINI 4 PRO · S/N 1581F6Z9A23AGML3SMZ7Secaucus, NJ N279ABDJI PHANTOM 4 PRO+ · S/N 0AXCE7G0B30687Secaucus, NJ N281ABDJI MAVIC 2 PRO · S/N 163DFCP001WG0DSecaucus, NJ N283ABDJI MAVIC 2 PRO · S/N 163DFCD001XH0PSecaucus, NJ N284ABDJI MAVIC 2 PRO · S/N 1633G93002W029New York, NY N285ABDJI PHANTOM 4 PRO V2.0 · S/N 11UCF740A50041Secaucus, NJ N286ABDJI MATRICE 210 V1 · S/N 0G0DF180230004Seacaucus, NJ N287ABDJI MAVIC 2 PRO · S/N 163DFCD001C45FSecaucus, NJ N292ABDJI MAVIC 2 ENTERPRISE · S/N 298DG6E001NJB4Secaucus, NJ N293ABDJI MAVIC 2 PRO · S/N 163DFAF001B92GSecaucus, NJ N294NQDJI AIR 3 · S/N 1581F6N8A23ALML36MY5Secaucus, NJ N294QQDJI AIR 3 · S/N 1581F6N8A23ALML3L7JXSecaucus, NJ N294RCDJI AIR 3 · S/N 1581F6N8A23ALML35U2JSecaucus, NJ N294SQDJI AIR 3 · S/N 1581F6N8A23AKML3S65SSecaucus, NJ N294TZDJI AIR 3 · S/N 1581F6N8A23C1ML38Y33Secaucus, NJ N294VADJI AIR 3 · S/N 1581F6N8A23ALML37GJQSecaucus, NJ N3185ADJI MINI 3 PRO · S/N 1581F4XF723C9M0ST0USSecaucus, NJ N3186ZDJI MINI 3 PRO · S/N 1581F4XF723C9M0ST0TKSecaucus, NJ N319ABDJI INSPIRE 1 · S/N W13DDH09060219Secaucus, NJ N338ABDJI INSPIRE 1 · S/N W13DDH09060205Secaucus, NJ N341ABDJI INSPIRE 1 · S/N W13DDA27060904New York, NY N41WDDJI AIR 2S · S/N 3YTBJ8P00304UTSecaucus, NJ N430WDDJI MAVIC 2 ENTERP DUAL · S/N 298DG8TR01H570Secaucus, NJ N431WDDJI MAVIC 2 PRO · S/N 163CG9VR0A2QY6Secaucus, NJ N432WDDJI MAVIC 2 PRO · S/N 163CG9VR0A2QNWSecaucus, NJ N434WDDJI MAVIC 2 PRO · S/N 163CG9VR0A2RMSSeacaucus, NJ N452ABDJI MAVIC PRO · S/N 08QCE5D012222SYSecaucus, NJ N458ABDJI MAVIC PRO · S/N 08Q4F460012079Secaucus, NJ N467ABDJI MAVIC PRO · S/N 08QDE4T01202R2Secaucus, NJ N52WDDJI MAVIC 3 · S/N 1581F45TB21B31BE04BVSecaucus, NJ N590ABDJI INSPIRE 1 · S/N W13DCA22020847Secaucus, NJ N62WDDJI AIR 2S · S/N 3YTBJ850030083Secaucus, NJ N68WDDJI PHANTOM 4 · S/N 07DDD4C0B10279Secaucus, NJ N705WDDJI PHANTOM 4 · S/N 07DDD6L0B10640Secaucus, NJ N941XQDJI MAVIC 3 · S/N 1581F45TB21AF1AE02MYSecaucus, NJ N9452ADJI MAVIC 3 · S/N 1581F45TB21AF1BE059VSecaucus, NJ N9454JDJI AIR 2S · S/N 3YTBJ79003037WSecaucus, NJ N9455EDJI MINI 3 PRO · S/N 1581F4XFC2254006281CSecaucus, NJ

Back to Abc Inc