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.
N6478DBrezovich Ivan A · Birmingham, ALN6480DFlyright Aviation LLC · North Las Vegas, NVN6481JCape Flight Instruction Inc · Cotuit, MAN6486JSpredemann Carl A · Emmett, IDN6487DWayne County Airport Board · Monticello, KYN6490DCampbell James W · Joshua, TXN6492ELeadmon Lorren Dale Jr · Mechanicsville, MDN6498FWisener Randall G · Addison, ALN649GCAviation Paradise LLC · Homestead, FLN64PDPapa Delta LLC · Eddyville, KYN64SFSafe Flight Instrument Corp · White Plains, NYN6503DManubay John M · Sinking Spring, PAN6506DWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTN6511GBuerk James R · Smethport, PAN6512DCajun Wings LLC · Bourg, LAN6513DGhia Flying Venture LLC · Scottsdale, AZN6514JJuggernautaviation LLC · Lewes, DEN6517DSlaboszewski Donald W Jr · Joliet, ILN6519JDms Defense LLC · Annapolis, MDN6521DWaade Odd · Bellingham, WAN6523DAir Shares LLC · Casper, WYN6524DZuckerman Zvi A · Boardman, OHN6525DAerospace Testing Engineering & Certification Inc · Seattle, WAN6529DG Force Advantage LLC · Lewes, DEN6532FCouch Walter Jack · Patterson, LAN6532JGarner Aviation LLC · Tampa, FLN6535GBbjs Investments LLC · Burlington, WIN6537DCunningham Edward A · Washington, DCN6537FWheels Up Aviation LLC · Pittsburgh, PAN6538FMbk Leasing And Consulting LLC · Lakeland, FLN6543DBatte Randall E · Forest, MSN6545DCosta Flying Service Inc · Painted Post, NYN6548ESewell William G Jr · Bremen, GAN6549DBbjs Investments LLC · Waukesha, WIN654ALMoore Howard · Camden, TNN6552FAir Planes LLC · Soddy Daisy, TNN6553DLlv Aviation LLC · Wilmington, DEN6553EZa Airport Rental LLC · Zanesville, OHN6554DHancock Jeffrey D · Delta, CON6555JTeton Leasing LLC · Pocatello, IDN6565JTaylor Aviation Of Seminole Ok LLC · Seminole, OKN6568EMcnerney John P · New Haven, VTN656DMKingsky Flight Academy LLC · Lakeland, FLN656SFSkyfusion II LLC · Atlanta, GAFirst renewal noticeN6571DBlazing Sun Aviation LLC · Encinitas, CAN6572DWalkowicz Eddie · Garland, TXN6573DPeabody Jeffery L · Vinemont, ALN6574DFly Carolina LLC · Concord, NCN6574GPplforu LLC · Fort Worth, TXN6587EG & M Aircraft Inc · Wheat Ridge, CO
Back to Cessna 172N