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 ('1380144')
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 ('1380144')
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.
N75567Vintage Flyers Inc · Benton, KSN75569Huston Thomas W · Sanger, TXN75577Caruso Aircraft Service LLC · Saint Marys, PAN755JPJpm Flying Service LLC · Marine, ILN75623Wings Of Flight Foundation · Mesa, AZN75758Independent Dusting Svc Inc · El Campo, TXN75761Pippert James R · Dysart, IAN75804Raaz Neil Alan · Colleyville, TXN75811Bottolene Brian J · Monticello, MNN75817Schwab Coyle P · St Charles, ILN75937Independent Dusting Service Inc · El Campo, TXN75939August Aero LLC · Kalispell, MTN75980Owls Head Transportation Museum · Owls Head, MEN75MRSimply Living LLC · Fort Myers, FLN75TQWoods Michael · Malahide DublinN777JGMorris Justin J · Cozad, NEN790DBMoore George C · Fincastle, VAN79500Meck Michael B · Durham, NCN79553Stuart Fredrick E · Jacksonville, FLN79561Rucinski Thomas A · Paramus, NJN7995Sg Squadron LLC · Park City, UTN81235Mauro Frank C · Torrance, CAN849MAerospace Trust Management LLC Trustee · Wilmington, DEN851WMHartness Thomas P · Woodruff, SCN9030HRothrock Cara J · Streator, ILN9039HParamount Overseas Productions Inc · Los Angeles, CAN9040HRothrock Cara J · Streator, ILN91098Boyd Darrell M · Claremore, OKN9136HT J P Aviation Inc · Garrettsville, OHN9215HLight Flight Balloons Inc · Street, MDN93WWM J Bravo Inc · Wichita, KSN9478H3g Classic Aviation Inc · Wilmington, DEN94DRAirplanes Of Kankakee · Kankakee, ILN9691HFerry Donald A · Shakopee, MNN9744HMbsp Enterprises Inc · Wilmington, DEN9752HHill Lawrence · Eloy, AZN9782HDp131 Associates LLC · Chester, VAN9826HJohnson Lawrence F · Colville, WAFirst renewal noticeN9844HKille Edward J · Piles Grove, NJN9912HAerospace Trust Management LLC Trustee · Wilmington, DEN9965HTec Aviation LLC · Euclid, OH
Back to Boeing B75N1