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.
N547NDSpartan Education LLC · Tulsa, OKN548EPGulf Coast Aviation LLC · New Orleans, LAN548NDAerosim Academy Inc · Sanford, FLN548SPMinter Barry · Rockport, MON5491JChristiansen Aviation LLC · Wilmington, DEN549NDSpartan Education LLC · Tulsa, OKN550ERCoco Aircraft Inc · Merritt Island, FLN550NDPhoenix East Aviation LLC · Daytona Beach, FLN5518GChristiansen Aviation LLC · Wilmington, DEN5518WChristiansen Aviation LLC · Wilmington, DEN551ERSunrise Aviation Inc · Ormond Beach, FLN551ESNimno 551es LLC · Pompano Beach, FLN551NDCoast Flight Training And Management Inc · San Diego, CAFirst renewal noticeN5520NChristiansen Aviation LLC · Wilmington, DEN5520SChristiansen Aviation LLC · Wilmington, DEN5520UChristiansen Aviation LLC · Wilmington, DEN5520XUS Aviation Training Solutions Inc · Titusville, FLN55218Christiansen Aviation LLC · Wilmington, DEN5521QEckmann Sheri L · Santa Barbara, CAN5521SChristiansen Aviation LLC · Wilmington, DEN5522A5522a LLC · Bethany, OKN5522SAmeriflyers Of Texas Inc · Addison, TXN5522XChristiansen Aviation LLC · Wilmington, DEN55231Golf November Aero LLC · Sunnyvale, CAN55234Alien Invaders LLC · Medina, WAN5523QDolphin Leasing LLC · Daytona Beach, FLN5523VDolphin Leasing LLC · Daytona Beach, FLN5526JBravo Leasing LLC · Daytona Beach, FLN55285Aerosim Academy Inc · Sanford, FLN55292Aerosim Academy Inc · Sanford, FLN55294Heavy Metal Air LLC · Farmingdale, NYN55296Heavy Metal Air LLC · Farmingdale, NYN55297Goodhue LLC · Myrtle Beach, SCN5529ZAerosim Academy Inc · Sanford, FLN552NDOdegaard Wings Inc · Kindred, NDN552SPEngineers Flying Club Inc · Bethany, OKN553RARich Aviation Services LLC · Fort Worth, TXN554TADelta Charlie Aviation LLC · Aliso Viejo, CAN555YSEdb Air Inc · Wilsonville, ORN556ERSunrise Aviation Inc · Ormond Beach, FLN556NDRainier Flight Service LLC · Renton, WAN556SPTexas State Technical College · Waco, TXN557NDAerosim Academy Inc · Sanford, FLN558NDPhoenix East Aviation LLC · Daytona Beach, FLN559SP1.2 Gpa LLC · Rapid City, SDN55SVSilverhawk Aviation Academy LLC · Caldwell, IDN560FASteffel Farms LLC · Olivia, MNN561NDSpartan Education LLC · Tulsa, OKN561SAWingsleasing LLC · Wichita, KSN562ABNavigation Leasing LLC · Castle Rock, CO
Back to Cessna 172S