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.
N955SPBarto Jerrel C · Kula, HIN956SPN3812q LLC · San Diego, CAN957ESVolar I LLC · Edmond, OKN959JATriple Eagle Aviation LLC · Cambridge, VTN959UAUniversity Of Alaska Anchorage · Anchorage, AKN95BPPeraton Services LLC · Bozeman, MTN960MSMt San Antonio Community College District · Walnut, CAN960TAInnoutaero LLC · Stockton, CAN963ACYoung Paul J · Hudson, MAN963JADeland Aviation LLC · Deland, FLN963SPAero Aircraft 11 LLC · Jacksonville, FLN963TASvetfur Aviation LLC · Camden, SCN964SPDirty Side Down Aviation LLC · Georgetown, TXN965BBBascom Kimber Keith · Mckinney, TXN966ACWhiskey Charlie Aero LLC · Poway, CAN967SAElizabeth City State University · Elizabeth City, NCN968LLewis University · Romeoville, ILN968SPMindy Limited LLC · Muscatine, IAN969FGMustang Sally Aviation LLC · Camden, SCN969SPB R S Leasing Inc · Wilmington, DEN96FASilver Express Co · Miami, FLN9710ASky Mobility LLC · Warrington, PAN971TABanner Aviation LLC · Trabuco Canyon, CAN972BBBig Red Buffalo LLC · Hagerman, IDN972TAConfluence Systems Consulting · San Jose, CAN972WWChapel Hill Flying Club Inc DBA · Sanford, NCN973HAAb Prop Plane I LLC · Metairie, LAN974DBPhoenix East Aviation LLC · Daytona Beach, FLN974SPTexas State Technical College · Waco, TXN974TASky Peak Aviation LLC · Los Angeles, CAN975TAMitchell David G · Cadiz, OHN978APAviation Leasing Company LLC · Ooltewah, TNN978FASky Training LLC · West Milford, NJN978SAMarine Tech One LLC · Dover, DEN978SPLlp Leasing Group LLC · Lewes, DEN979WDDolphin Leasing LLC · Daytona Beach, FLN97ATRainier Flight Service LLC · Renton, WAN97PDBoeing Employees Flying Association Inc · Renton, WAN97VACamps Bay Aviation LLC · Waukegan, ILN980SPFisher Stables And Arena Inc · Gladewater, TXN981SFAtp Aircraft 1 LLC · Wilmington, DEN981SPLlp Leasing Group LLC · Lewes, DEN981TWKent Mark · Holden, MAN982SPScott Kenneth C · Erie, CON983FAFreedom Aviation Inc · Lynchburg, VAN983JAGulf Coast Aviation LLC · New Orleans, LAN983SPBusiness Mens Flying Club Inc · Naperville, ILN984JAKinman Plumbing Co Inc · Louisville, KYN984SPRedstone Arsenal Flying Activity · Redstone Arsenal, ALN987FAChristiansen Aviation LLC · Wilmington, DE
Back to Cessna 172S