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 ('2072434')
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 ('2072434')
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.
N737CXEb Flight Training LLC · Daytona Beach, FLN737CZMt Vernon Airport Authority · Mount Vernon, ILN737DASky II LLC · Lees Summit, MON737DCBirkenhead Judy · College Park, MDN737DDSorbi Aviation Inc · El Cajon, CAN737DESky Creation Inc · Torrance, CAN737DGEagle Aviation LLC · Spearfish, SDN737DJYoungs Farm Blue Mountain Ranch LLC · Paulina, ORN737DLRobertson Steven J Trustee · Escondido, CAN737DPAero Photo · Spicewood, TXN737DRVannote Eugene L · Belews Creek, NCN737DSEmpty Nest LLC · Glen Ellen, CAN737DTAdvance Aviation LLC · Mount Vernon, IAN737DVSuperior Flying Services LLC · Superior, WIN737DWMh Aviation Inc · Lancaster, CAN737DYAsset Flight LLC · Beaumont, TXN737ECBlock Craig L · Murrieta, CAN737EERising Wings Aviation Inc · Casper, WYN737EGWilson Scott A · Livingston, LAN737EHGiese Douglas S · San Angelo, TXN737EMPreston Richard R Trustee · Albuquerque, NMN737EPN737ep Partners LLC · Blue Jay, CAN737ESNovember Seven Echo Sierra LLC · Pineville, LAN737ETOptima Aviation LLC DBA · Lewisville, TXN737EWOklahoma Airmen Flying Club Inc · Jenks, OKN737FDMeadows Stone & Paving Inc · Gassaway, WVN737FHEagle Simulator LLC · Lake Oswego, ORN737FJVero Technical Support Inc · Pensacola, FLN737GAN737ga LLC · Jupiter, FLN737GCDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYN737GEFlying Neutrons LLC · Lebanon, OHN737GJJaars Inc · Waxhaw, NCN737GKGeneral Aviation LLC · Henderson, NVN737GLFlying Panthers Flight School Inc · Citrus Heights, CAN737GMFive Rivers Flight Training LLC · Livermore, CAN737GPWilliams Allen E · Redlands, CAN737GRRick Aviation Inc · Newport News, VAN737GSRising Wings Aviation Inc · Casper, WYN737GUWings Over Texas Holdings LLC · Denton, TXN737GVTas Aviation Of Defiance Inc · Defiance, OHN737GZSauk Valley Aviation Inc · Sterling, ILN737HDNotam Aviation LLC · Portage Des Sioux, MON737HELaurel Highlands Aeronautical Academy · Latrobe, PAN737HGGuyair Inc · Saint Charles, MON737HHG A W Flying Club Corp · Palos Heights, ILN737HJPersonal Aviation Inc · Poway, CAN737HMMeyer Raymond · Ukiah, CAN737HVSchuler Eric C · Fort Salonga, NYN737HWCag Aircraft Holdings LLC · Crystal River, FLN737HYSeven 4 Zulu LLC · San Diego, CA
Back to Cessna 172N