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 ('2072424')
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 ('2072424')
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.
N8287LShirk Matthew · Auburn, INN8289LFaust Stanley J · Nashua, NHN8290LPretty Plane LLC · Nixa, MON8291LUsglap LLC · Fort Morgan, CON8292LBrown Troy M · Austin, TXN8484GAileron Aviation Inc · Cookeville, TNN8568QSkyhawk Aero LLC · Montevideo, MNN8800ZGuest Marc E · Davidsonville, MDN8804ZPoorboy Flying Club LLC · Erick, OKFirst renewal noticeN8806ZFrancechi Marc Anthony · Phoenix, AZN8813ZDuman Adrianna A · Los Angeles, CAN8815ZAerowood Aviation LLC · Monroe, NCN8817ZRegistration Pending · Redmond, WARegistration pendingN8826ZQuincy Flyers LLC · Havana, FLN8827ZSmith Eric E · Greensboro, GAN8828ZCecchini Frank Adam · Round Mountain, NVN8829ZBas Part Sales LLC · Greeley, CON8831ZMayer John C · Reiles Acres, NDN8832ZRiese Daniel II · New Port Richey, FLN8835ZMaloney Eric T · Houston, DEN8838ZG2g Aviation LLC · Wray, CON8839ZCole Samuel L M III · Kenai, AKN8844ZTerry L Fowler LLC · Greenbrier, ARN8845ZCartwright Adam C · Homestead, FLFirst renewal noticeN8847ZChristian Matthew T · Sebring, FLN8848ZMix Gary · Hoagland, INN8849ZBagwell Aaron Edward · Mount Vernon, WAN89WWAley Jeffrey S II · Granby, CON97JBVieira Nunes Da Silva Raphael · Ethel, LAN9843XTidwell Gregery D · Modesto, CAN995NABucher Devin V · Kalispell, MT
Back to Cessna 172H