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 ('2072439', '2072442')
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 ('2072439', '2072442')
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.
N7261ZChristiansen Aviation LLC · Wilmington, DEN72675Chapel Hill Flying Club Inc DBA · Sanford, NCN726CPCivil Air Patrol · Maxwell Afb, ALN7275REdb Air Inc · Wilsonville, ORN727SPElite Approach LLC · Chesterfield, MON728SPFleetshares N728sp Inc · Leesburg, VAN729MTHochreiter Heinrich · Bellingham, WAN729SPMars Aerospace Inc · Bay Shore, NYN72EFN72ef LLC · Canton, GAN732CPCivil Air Patrol · Maxwell Afb, ALN735RRMiga Holdings LLC · Flower Mound, TXN739TWAviolease LLC · Vancouver, WAN740SPJet Air Inc · Iowa City, IAN741WBEastern Kentucky University · Richmond, KYN742TWTumbleweed Leasing Co Inc · Salt Lake City, UTN743SPSilverhawk Aviation Academy LLC · Caldwell, IDN743TWTumbleweed Leasing Co Inc · Salt Lake City, UTN745BPlanelease LLC · Venice, CAN745SPBanks Douglas Trent III · Huntsville, ALN746DWEastern Kentucky University · Richmond, KYN747APB R S Leasing Inc · Wilmington, DEN747LTRoth James D · Shady Shores, TXN748CPCivil Air Patrol · Maxwell Afb, ALN748SPBg-Ip LLC · Saratoga, CAN74DWBas Part Sales LLC · Greeley, CON751CPCivil Air Patrol · Maxwell Afb, ALN751MLQueensland Air LLC · Chicago, ILFirst renewal noticeN751SPHagele Aviation LLC · Hillsboro, ORN752DWFlying Start Aero Services LLC · Reno, NVN753GWAtp Aircraft 4 LLC · Wilmington, DEN754CPCivil Air Patrol · Maxwell Afb, ALN754SPNavy Annapolis Flight Center Inc · Edgewater, MDN755SPNavy Annapolis Flight Center Inc · Edgewater, MDN756SPCrest Airpark · Kent, WAN75727Silverhawk Aviation Academy Oregon LLC · Ontario, ORN762CPCivil Air Patrol · Maxwell Afb, ALN763CPCivil Air Patrol · Maxwell Afb, ALN763SPSix Ten Ventures LLC · Grand Prairie, TXN764SPColonial Air Inc · New Bedford, MAN766PDTexas State Technical College · Waco, TXN766SPMaxxum Financial Group Inc · Destrehan, LAN767CLMls Aviation LLC · Yorba Linda, CAN767CRAtp Aircraft 2 LLC · Wilmington, DEN768SPLast Sea LLC · Saint Augustine, FLN769CPCivil Air Patrol · Maxwell Afb, ALN769FGMustang Sally Aviation LLC · Camden, SCN769SPWings Over Texas Holdings LLC · Denton, TXN772GKAmerican Aircraft Brokers LLC · Aurora, ORN772MSSchmidt Barnet M · Oradell, NJN773BAMustang Sally Aviation LLC · Camden, SC
Back to Cessna 172S