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.
N582SPSvanberg Craig Emile · Dayt Bch Sh, FLN584SPTexas State Technical College At Waco · Waco, TXN587SPPinnacle Aviation Services Inc · Encinitas, CAN589SPHillsboro Aero Academy LLC · Hillsboro, ORN590SPTubreaux Aviation Services LLC · Shreveport, LAN595DBStar Magic (Www) Inc · New York, NYN595SPSchool Of Missionary Aviation Technology · Ionia, MIN5961JAtp Aircraft 2 LLC · Wilmington, DEN596FAOcala Aviation Services Inc · Ocala, FLN597SPViolet Sparkle Pearl LLC · Hanover, NHN598SPFb Aviation LLC · Minot, MEN6009MKd 172 Ventures I LLC · Bellevue, WAN6009POh Air LLC · Mentor, OHN6009VMaui Aviators LLC · Pukalani, HIFirst renewal noticeN6012U6012u LLC · Union Gap, WAN6012ZChristiansen Aviation LLC · Wilmington, DEN6013JAerodrome LLC · Louisville, KYN60143H2 Link Company · Lewes, DEN60155Jls Aviation LLC · Sarasota, FLN6017LAviation Training LLC · Wilmington, DEN6017NGood Dog Leasing LLC · Vienna, VAN6018KChristiansen Aviation LLC · Wilmington, DEN6018ZWarner Aviation Co · Council Bluffs, IAN6019VChristiansen Aviation LLC · Wilmington, DEN6021FB R S Leasing Inc · Wilmington, DEN6021KRegistration Pending · Grand Forks, NDRegistration pendingN6023VChristiansen Aviation LLC · Wilmington, DEN6024EDhs Operations LLC · Wilmington, DEN6024TDouglass Bruce · Conway, MAN6026SPhoneix East Aviation LLC · Daytona Beach, FLN6026ZAerodynamic LLC · Aurora, ORN6027ZSpacely Space Sprockets LLC · Aurora, ORN6028YPuerto Rico Aircraft Leasing Corp · Ceiba, PRN602NDRainer Flight Service LLC · Renton, WAN602TCSanderson Kimberly L · Swartz, LAN602TLCoast Flight Training And Management Inc · San Diego, CAN6031LRegistered aircraftN6031WWings Over Texas Holdings LLC · Denton, TXN60337Lewis University · Romeoville, ILN6033SSuburban Air Corp · Castro Valley, CAN6034BFxe Flightcenter Corp · Fort Lauderdale, FLN6034DDuro Vincent · Highland, CAN6034FToth Norman J · Spring Hill, FLN60363Cumulus Aviation Services LLC · Port Orange, FLN6036YChristiansen Aviation LLC · Wilmington, DEN60372Above And Beyond Aviation LLC · Austin, TXN60395American Aviation Inc · Brooksville, FLN60397Vector USA LLC · Olive Branch, MSN603NDFm Aviation Services LLC · Arlington, VAN6042NCal Aggie Flying Farmers · Davis, CA
Back to Cessna 172S