Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('1152746')
ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('1152746')
ORDER BY n_numberRun 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.
N58BNMinus 7 Inc · Boulder, CON58HESoaring Ventures LLC · La Quinta, CAN58JDGrossman Kenneth R · Merced, CAN58JMLucky 7 Operating LLC · Many, LAN58TKTwa Partners LLC · Billings, MTN6037GMojo Travel LLC · Wellington, CON6039TLindsey Kenneth H · Kalispell, MTN607GSGaines Robert G · Howell, MIN60ETChankhunthod Anawat · Saratoga, CAN66568Trapp Aviation Ltd · Lebanon, OHN6669XEdm-Van LLC · Maple Lake, MNN6683YGate Post Aviation LLC · Woodbury, CTN6734UR E Bentz Inc · Monroe, LAN6741MCooper Aviation LLC · Georgetown, SCN6748VCannon Oil & Gas Well Services Inc · Rock Springs, WYN6758XAc Green LLC · Athens, OHN695TClay Kennamer Livestock Farms LLC · Hollywood, ALN742NEPotkulski Daniel M · Locust Grove, GAN769ACAircraft Propulsion Leasing LLC · Holland, OHN77NWRizor Justin · Phoenix, AZN800JCThomas Bonner Enterprises LLC · Lubbock, TXN81AJAircraft Propulsion Leasing LLC · Holland, OHN826MTG T Acft Inc · Franklin Square, NYN858TCH2 Transportation LLC · Macon, GAN8WWLcam Aviation LLC · Springfield, MON905AAGraber Joel C · Collins, MSN919PJDel Rosso Peter · Los Angeles, CAN95WHPage William R · Bermuda Dunes, CAN97RTeh LLC · Mccall, ID
Back to Beech 58TC