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 ('8682000')
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 ('8682000')
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.
N372TBSoho Aviation Corp · New York, NYN373EMJm Tbm 850 LLC · Huntingdon Valley, PAN375BZWaddingham William B · Rancho Cucamonga, CAN37AXAshlin Air LLC · Gulf Breeze, FLN37TCJelec Holdings LLC · Bluefield, WVN389HCLittle Wing Aviation LLC · Irvine, CAN394EWEjb Aviation LLC · Saline, MIN394RWA & P Holdings LLC · Enid, OKN3EKFineline Aviation LLC · Georgetown, TXN3GSSchaeffer Aviation LLC · Bend, ORN3HPOne Golf Tango LLC · Kalamazoo, MIN401LVDlm Aviation LLC · Annapolis, MDN402KWSoutheastern Tank & Tower Inc · Lake Park, GAN408DHTbm900 Jm LLC · Steamboat Springs, CON408GTYost Carson L R · Houston, TXN414GJRegistered aircraftN415CJOcmulgee Aero LLC · Eastman, GAN417KG4jn LLC · Acton, MAN418AZafl LLC · Bloomington, INN422AZGiostyle LLC · Napa, CAN422JFBlue Docs LLC · Belmont, MAN422QN850km LLC · Lawton, OKN426C3 Dog Night Aviation LLC · Lewes, DEN426LMPeifer Charles R · Albuquerque, NMN427CTuffy LLC · Fremont, NEN427TBSavi Aviation LLC · Cape Coral, FLN428ZGxy Transport LLC · Greeley, CON442DSSantori Aviation LLC · Helena, MTN444BT500 Knot LLC · Granbury, TXN449CACharlie Alpha LLC · Ketchum, IDN449MASierra Tango LLC · Springdale, ARN44TMTeam Marshall LLC · Weedsport, NYN44WNAdams Aviation Services Inc Trustee · Wilmington, DEN452MAHahn Aerospace LLC · Armonk, NYN461JHeising Aircraft Services LLC · Billings, MTN461LMEyelife Properties LLC · Wilmington, DEN461WCBeach Bird 2 LLC · Beaumont, TXN463RDFlanes Ltd Trustee · Wilmington, DEN46DCecep LLC · El Paso, TXN477JNUfa Equipment LLC · Naples, FLN479HNspace LLC · Spicewood, TXN481JBTower Aviation LLC · Palm Beach Gardens, FLN4884MSierra Charlie Mike LLC · Lafayette, LAN488PTBot II Logistics LLC · Kodak, TNN491SCSouthern Cross Aircraft LLC · Fort Lauderdale, FLN4920YWindsock Aviation LLC · Old Saybrook, CTN495PCAviation Tools Inc · Bedminster, NJN49RSAgs Aviation LLC · Billings, MTN500RW578 Inc Trustee · Wilmington, DEN507BCTbm Partners LLC · Spring, TX
Back to Socata TBM 700