Skip to content

Registered aircraft · 1,565

Aircraft of this model in the FAA registry, by N-number.

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 ('2072732')
  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 ('2072732')
ORDER BY n_number

Run 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.

N97240N97240 LLC · Amherst, MABuilt 1979 · S/N 18267030 N97246Duggins Robert W · Van Nuys, CAS/N 18267034 N97257Moser Keith W · Huntington, INBuilt 1979 · S/N 18267037 N97281Wackerli Steve B · Idaho Falls, IDFirst renewal noticeBuilt 1979 · S/N 18267041 N97282Jav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 18267042 N97288Bolle Aviation LLC · Clare, MIBuilt 1979 · S/N 18267044 N97295J-Air LLC · Guthrie, OKBuilt 1979 · S/N 18267047 N97298Roberts And Connell Llp · San Luis Obispo, CABuilt 1979 · S/N 18267048 N97300Jaeger Kurt · Bermuda Dunes, CABuilt 1979 · S/N 18267050 N97309Afana Lawrence L Jr · Phoenix, AZS/N 18267054 N97345Postupack Peter Jr · New Cumberland, PABuilt 1979 · S/N 18267063 N97361Sky 4 Me LLC · Greendale, WIS/N 18267067 N97365Sugg Robert Michael · Covington, GABuilt 1979 · S/N 18267069 N97380Rsf Services LLC · Salem, ORBuilt 1979 · S/N 18267073 N97385182q LLC · Tyler, TXS/N 18267076 N97386Ratcliffe & Sons Inc · Madill, OKS/N 18267077 N97396Sds Aviation Inc · Buford, GABuilt 1979 · S/N 18267079 N97398Dbat Flying Club LLC · Reno, NVBuilt 1979 · S/N 18267080 N973JMMarc Inc · Bolton, MSBuilt 1978 · S/N 18266734 N97410Skynuke LLC · Bechtelsville, PABuilt 1979 · S/N 18267082 N97413Northwoods Air LLC · Orono, MEBuilt 1979 · S/N 18267083 N97433Menyhay William Csaba · Clovis, CABuilt 1979 · S/N 18267090 N97435Wipaire Inc · South Saint Paul, MNBuilt 1979 · S/N 18267091 N97437Carr Jeffrey A · Worthington, KYS/N 18267093 N97443Miller Charles L Jr · Eunice, LABuilt 1979 · S/N 18267095 N97446Mpm Wizard Enterprise LLC · Hawthorne, CAFirst renewal noticeBuilt 1979 · S/N 18267096 N97452Taylor Michael Riding · Friday Harbor, WAFirst renewal noticeBuilt 1979 · S/N 18267099 N97453Stofer William B · Warsaw, INBuilt 1979 · S/N 18267100 N97456Harrington Co · Butte, MTBuilt 1979 · S/N 18267101 N97467Kg Rentals LLC · Edmond, OKBuilt 1979 · S/N 18267104 N97469Wooten James E · Avinger, TXBuilt 1979 · S/N 18267105 N97485Strong Neil E · Pittsburg, TXBuilt 1979 · S/N 18267109 N97487Bruns Gregg R · West Chester, OHBuilt 1979 · S/N 18267110 N97503Mercury International LLC · Cheyenne, WYBuilt 1979 · S/N 18267114 N97508Sale Reported · Hurricane, WVSale reportedBuilt 1979 · S/N 18267116 N97513Registration Pending · Colona, ILRegistration pendingBuilt 1979 · S/N 18267117 N97523Rwp LLC · Bloomington, INBuilt 1979 · S/N 18267119 N97533Associated Pilots Inc · Winchester, MABuilt 1979 · S/N 18267123 N97540Popeye And Olives Adventures LLC · Helena, MTBuilt 1979 · S/N 18267127 N97543Carter Michael E · Dallas, GAS/N 18267128 N97553Gregor Anthony J · Bethesda, OHBuilt 1979 · S/N 18267129 N97563Fenell Jeffrey A · Stahlstown, PAS/N 18267133 N97578Utecht Thomas A · Friant, CABuilt 1979 · S/N 18267135 N97580Wardall Wesley David · Ione, CABuilt 1979 · S/N 18267137 N97596Aero-Sphere Inc · Longmont, COBuilt 1979 · S/N 18267143 N97601Zapata Michael III · Cary, NCBuilt 1979 · S/N 18267145 N97611Bravo Aviation Co · San Antonio, TXBuilt 1979 · S/N 18267147 N97622Paul A Leep Md P C · Chassell, MIBuilt 1979 · S/N 18267148 N97627Speer Paul B · Vancouver, WABuilt 1979 · S/N 18267150 N97633Graham Brown Aircraft Rentals LLC · Wilmington, DEBuilt 1979 · S/N 18267152

Back to Cessna 182Q