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.
N528NDAerosim Academy Inc · Sanford, FLN528SCMaxxum Financial Group Inc · Destrehan, LAN528SVFox Leasing Group LLC · Hollywood, FLN5290ESpacely Space Sprockets LLC · Aurora, ORN5290HLevy James L · Clifton Park, NYN5290VSpartan Education LLC · Tulsa, OKN5291ALewis Aeronautical LLC · San Antonio, TXN5291WMaxxum Financial Group Inc · Destrehan, LAN5296DZack Gary J · Sunderland, VTN5296ZSouthern Sky LLC · Henderson, NVN5297EAtd Pilot Training LLC · Kansas City, MON5297GChristiansen Aviation LLC · Wilmington, DEN5298NJ3m Airops LLC · Daytona Beach, FLN5298SSix Ten Ventures LLC · Grand Prairie, TXN529ERPs N529er LLC · Green Bay, WIN529NDPhoenix East Aviation LLC · Daytona Beach, FLN53039Laurel Highlands Aeronautical Academy · Latrobe, PAN5303JGulf Coast Aviation LLC · New Orleans, LAN5303TMorey Airplane Co Inc · Middleton, WIN53068Legends Air Center LLC · Bentonville, ARN5306CSo Cal Leasing LLC · El Cajon, CAN5306UAircraft Solutions Group LLC · Englewood, CON53070Wnc Aviation LLC · Arden, NCN5309FMedary Aviation LLC · Brookings, SDN5309VFlight Training Aircraft LLC · Wilmington, DEN530AUWateractive43 LLC · Auburn, CAN530ERZima Aviation LLC · Huntington, CAN530MTAcron Aviation Academy Inc · Sanford, FLN530NDAerosim Academy Inc · Sanford, FLN530PSSpartan Education LLC · Tulsa, OKN53116Wnc Aviation LLC · Arden, NCN5311HBas Part Sales LLC · Greeley, CON5312SGace Flying Club · Ronkonkoma, NYN5312VBounds Justin M · Houston, TXN5315EEastern Cincinnati Aviation Inc · Batavia, OHN5316GBerg Philip L · Chatsworth, CAN53176Perfect Agreements Leasing Inc · Trabuco Canyon, CAN531NDN531nd LLC · Sammamish, WAN53205Southern Aircraft Consultancy Inc Trustee · Casper, WYN5321AJust Plane Stuff Inc · Jackson, MSN5322PSky Peak Aviation LLC · Los Angeles, CAN53237Jet Air Inc · Iowa City, IAN5324GFloris Flight Services LLC · Midland, TXN5325NSchindler Lawrence A · Chino Valley, AZN5327GDirty Side Down Aviation LLC · Georgetown, TXN5327JEdb Air Inc · Wilsonville, ORN53289Christiansen Aviation LLC · Wilmington, DEN5328YGa Holdings LLC · Moffett Field, CAN5328ZBartow Municipal Airport Development Authority · Bartow, FLN532NDAia Bravo LLC · Henderson, NV
Back to Cessna 172S