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 ('2072418')
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 ('2072418')
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.
N5298RMurray Wanda Joyce Trustee · Proctor, MTN530WBDmb Aircraft Inc · Wilmington, DEN5312HSkywarrior Flight Training Inc · Pensacola, FLN5317HHottel Cessna LLC · Prescott, AZN5322RFreetown Partners LLC · Newark, DEN5323HCook James N · Mission Viejo, CAN5334HThirty-Four Hotel · Houlton, MEN5339HBering Capital LLC · Anchorage, AKN5341HHoffman Calhoun E · Barnwell, SCN5344HA&F Aviation Services LLC · Collierville, TNN5347HMonterey Bay Aviation Inc · Watsonville, CAN5351HHayes Jeffery M · Yatesville, GAN5351QBarrett Dannie P · Halfway, ORN5362HMccue Tedd R · Eveleth, MNN5365QWelborn Mark · Boonville, NCN5367HWingsleasing LLC · Wichita, KSN536JRSale Reported · Port Orange, FLSale reportedN5371QTimber Creek Flyers Lc · Albion, IAN5375RArctic Flying Club · Fairbanks, AKN5376HPires Fernando L · Hilmar, CAN5391HHansen Alvin Kent · Winamac, INN5395HHansen James R · Kenmore, WAN5397RIowa Lakes Community College · Estherville, IAN539PBHumphrey Daryle C · Graford, TXN5400HF & J Air LLC · Abbeville, SCN5401HDms Leasing Company LLC · Las Vegas, NVN5402RBarsto Aviation Inc · Wilmington, DEN5408HSchmidt Kelly D · Lake Elmo, MNN5408RRegistration Pending · Brookland, ARRegistration pendingN5409RMclane Tucker · Newton, MAN5411HEarth Grazer Inc · Homer Glen, ILN5420HChildress Bradley M · Rolling Prairie, INN5424QBeltzville Aero LLC · Lehighton, PAN5426QLen Emery Photography LLC · Springfield, VTN5432HArmstrong Aviation Services LLC · Freeport, PAN5435HWindham Brealon A · Kingsville, TXN5436HTrue Course Air LLC · Rich Hill, MON5437HBuena Vista Flying Club Inc · Richland Center, WIN5437RSchafer Brian L · Carleton, MIN5439HMeyer Aviation Group LLC · Grand Island, NEN5441HKlein Darrell J · Deland, FLN5442HJones Gareth B · Goldsboro, NCN5444HIowa Lakes Community College · Estherville, IAN5446HBlizzard William F Jr · Barboursville, WVN5449HMoorhead Aviation Services LLC · Moorhead, MNN5450HLima-001 LLC · Muscatine, IAN5455HMiller Michael R · Portage, MIN5459HWard John W · Troutdale, ORN5462QLeading Edge Flight Academy LLC · Bend, ORN5468HPrjc Properties LLC · Vonore, TN
Back to Cessna 172M