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 ('2072731')
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 ('2072731')
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.
N5448NRadial Enterprises LLC · New Carlisle, OHN5451NMiller Geoffrey J · Tucson, AZN5454NLeisure Flight LLC · Franklin, TNN5455NPage Michael C Trustee · Stuart, FLN5456EKais Air LLC · Terre Haute, INN5456NBazar Paula · Woodland Hills, CAN5463NM Sipolt Air LLC · Paradise Valley, AZN5471NRiley Aviation LLC · Columbia, TNN5473NVan Wagenen Robert F · Watsonville, CAN5478NSkylane Aviation Club LLC · New Orleans, LAN5479NTahoe Flying Club Inc · Truckee, CAN5481E81 Echo LLC · Cincinnati, OHN5481NUlrey Stephen S · Lake Bluff, ILN5484NYeoul 182 LLC · Sanford, FLN5490ERoberson Terry K · Tampa, FLN5491NLacefield Tommie C · Niceville, FLN5493NOcaid Equipment Leasing LLC · Spring Valley, NYN5496EFair John C · Rockport, TXN5497NBeelieve LLC · Carmel, INN54BKDanny J Daigle LLC · Greenville, MEN5515NAronoff Raymond · Katy, TXN5529NTime 2 Fly LLC · Conroe, TXN5533EEnergy Transfer Aviation LLC · Spring, TXN5534NClifford English · Mesa, AZN5535NBerry William Trustee · Harrison, ARN5536NBrown Peter L · Riverton, CTN5542NRegistration Pending · Denver, CORegistration pendingN5544NSkydive Co · Fairburn, GAN5553EVogel Mark · North Bethesda, MDN559KMRegistered aircraftN5601EMarshall Joseph · Uniontown, OHN5622ECivil Air Patrol Inc · Maxwell Afb, ALN565SMMuller Scott B · Verbank, NYN566HCThomas Charles Stephen Trustee · Lakeway, TXN569ARN717dz LLC · Lovell, WYN56TVKoerper Md LLC · Las Cruces, NMN57711Moss Donald C Jr · Morristown, TNN586RJThayer Terry · Lafayette, INN58JKWander Aviation LLC · Klamath Falls, ORN5983ESweet R Kent Trustee · Reno, NVN5QUnusual Attitudes LLC · Thomas, OKN600HFSky Fox Aviation LLC · Eureka, CAN600RLElk Properties LLC · Monroe, LAN6088ERacoon Aviation LLC · San Antonio, TXN6107EDelta-V Ceramic Technologies Inc · San Jose, CAN6111NMcgyver Airshows LLC · Wilmington, DEN6117EViveros Ezequiel · Calexico, CAN6117NTaylor Willis P III · Suffolk, VAN6122NBernhard Andreas P F · Palm City, FLN6128NJones Charles C · Mccall, ID
Back to Cessna 182R