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.
N773SPFox Flying Club Inc · Wheaton, ILN7744SVista Air Inc · Pacoima, CAN775SP775sp LLC · Blaine, MNN776AASolo Aircraft Rental LLC · Farmingdale, NYN776VB40ac LLC · Hartford, WIN777HEUsoarflorida LLC · Fort Myers, FLN778AASolo Aircraft Rental LLC · Farmingdale, NYN780BWBridgewater State University · North Dartmouth, MAN780JAPhoenix East Aviation LLC · Daytona Beach, FLN7815DAviation Training LLC · Wilmington, DEN781JAPhoenix East Aviation LLC · Daytona Beach, FLN781SAMeyers Terry E · Galesburg, NDN781SPJw Wings LLC · Midlothian, TXN782JAAanonsen Per · Flagler Beach, FLN783SFBremfour Aviation Group Inc · Wilmington, DEN784SAEastern Cincinnati Aviation Inc · Batavia, OHN784SPSaz Dynamics LLC · Daly City, CAN786CPWings Over Texas Holdings LLC · Denton, TXN786SAGulf Aviation Holdings I LLC · Seattle, WAN786SPDevacana Transport Ltd · Lewes, DEN787GLTfa Holding Corp · Daytona Beach, FLN787LFH&R Aviation LLC · West Linn, ORN787SPSierra Tango Ventures LLC · Monte Sereno, CAN787WWDye Kent · Washington, PAN789EPEastbourne Holdings LLC · Woodstock, GAFirst renewal noticeN789PFSherman Aviation LLC · Fairfield, NJN790SPMustang Sally Aviation LLC · Camden, SCN792MD150th Aero Flying Club Inc · Morristown, NJN792SALynn John R Jr · Laconia, NHN792SPUniversity Of Alaska Anchorage · Anchorage, AKN793SPLeading Edge Aviation Inc · Doylestown, PAN796SPOpensky Airways LLC · Los Angeles, CAN796WWCrist Aviation Services LLC · Woodland, CAN797SPSundowners Inc · Fort Myers, FLN798SPPrecision Design Inc · Wilmington, DEN798TCLinfield William Kent · South Lyon, MIN802NMFlight Operations Aircraft LLC · Wilmington, DEN802SPEdb Air Inc · Wilsonville, ORN803SPDodson International Parts Inc · Rantoul, KSN805AABradley Air Investments LLC · New Ulm, TXN805FWMedary Aviation LLC · Brookings, SDN805SPCertified Aviation LLC · Morristown, NJN806SPAir Marion Inc · Marion, INN807PAAnson Air LLC · Sugar Land, TXN807SPCawthon James B · Chelsea, ALN80BFAir Future Airways Corp · Miami, FLN810SABlack Hound Aviation LLC · Austin, TXN814MVSterling Flight Training LLC · Jacksonville, FLN815SPPlane Fun Inc Tr Trustee · Snellville, GAN816KWChristiansen Aviation LLC · Wilmington, DE
Back to Cessna 172S