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 ('2072738', '2072739')
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 ('2072738', '2072739')
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.
N163DDN163dd LLC · Columbus, MTN166CPAircraft Guaranty Corp Trustee · Oklahoma City, OKN166PAMacmillan Performance LLC · Torrance, CAN1684ZPetty Venture Investment LLC · Scottsdale, AZN16917Degraffenreid Ronald A · Shawnee, OKN1692LSheldon Steven R · Las Vegas, NVN16VLDaro Associates LLC · Mahwah, NJN1717TJaaack Air LLC · Henderson, NVN171LPFarbish Peter B · Denver, CON173EMGasa Capital LLC · Laredo, TXN1744LDdd Aviation LLC · Phoenix, AZN1745LPark West Communities Inc · Lake Havasu City, AZN177VZCollinair LLC · Coppell, TXN178JMDcd Aviation LLC · Heber, CAN179VBAdl Tracey LLC · Warrenton, VAN180BWJ&B Flight Service LLC · Brownsville, TXN1810SSwift Current Resources LLC · Billings, MTN1815UJanson James A · Eagle, IDN181GSTravel Services LLC · Metropolis, ILN181LBWatts Rodney · Hot Springs, SDN1821ZTubbs George L · Colby, KSN182AHShelby Ronnie F · Comanche, OKN182DUAlba Alfonso Jose Munk · Key Biscayne, FLN182GAGaman LLC · Tulsa, OKN182GNWorthington Greg · San Francisco, CAN182HZElings Heath R · Conrad, MTN182JZMercer Fraser Co · Eureka, CAFirst renewal noticeN182LKEllison William G · Telluride, CON182LPTristar Aviation Management Nevada LLC · Las Vegas, NVN182MCOwle Aviation LLC · Mount Vernon, WAN182MEMcfann Aiden J · Timnath, CON182MGTurnidge Austin Michael · Seattle, WAN182MUTru Flight Materials LLC · Wilmington, DEN182PADecicco John Anthony · Clovis, CAN182PPPatch Patricia A Trustee · Titusville, FLN182QAAircraft Guaranty Corp Trustee · Oklahoma City, OKN182TCDasko LLC · Louisa, KYN182TSLynch Larry E · West Branch, IAN182WNTyson Stephen E · Marion, IAN183MKRude Daniel · Leesburg, VAN189JPMontana Skies LLC · Kalispell, MTN19194Smokey Bear Air LLC · Cascade Locks, ORN191FAHarvey Taz E · Danville, CAN19277Roundtree Sod Service Inc · Jacksonville, FLN193VBAli Suleiman Md Inc · Beckley, WVN1957KVan Bortel Aircraft Inc · Arlington, TXN1982KN1982k LLC · Wilmington, DEN1986VSpeer 182 LLC · Kalispell, MTN19CMRedrock Aviation LLC · Missoula, MTN19SCSacred Heart Medical Group Inc · Riverside, CA
Back to Cessna T182T