Skip to content

Registered aircraft · 2,099

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 ('2075816')
  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 ('2075816')
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.

N1216MHayward Flying Club · Hayward, CABuilt 1975 · S/N 18264245 N121RAJohnson Owen M III · Seattle, WABuilt 1972 · S/N 18261660 N1220MMcginty Flying Service LLC · Jones, LABuilt 1975 · S/N 18264246 N1228MHillsboro Flying Club · Hillsboro, ORBuilt 1975 · S/N 18264247 N122TTEveraert Filip L · Midland, MIBuilt 1974 · S/N 18262858 N1233FFlyboyz LLC · Bourbon, MOS/N 182-61270 N1233MFrench Rollie T · Vermillion, SDBuilt 1975 · S/N 18264251 N1236MRutherford Dustin · Simi Valley, CABuilt 1975 · S/N 18264252 N1239MMonarch M Miller · Ocala, FLBuilt 1975 · S/N 18264254 N123DBN123db LLC · Madison, NJFirst renewal noticeBuilt 1973 · S/N 18262088 N123GLAir Care Leasing LLC · Lamar, COBuilt 1973 · S/N 18261902 N1240MElk Creek Investments LLC · Helena, MTBuilt 1975 · S/N 18264255 N1242MHenninger Bradley J · Green Cove Springs, FLS/N 18264256 N1243MRegistered aircraftBuilt 1975 · S/N 18264257 N1245BPositive Flight LLC · San Ramon, CABuilt 1975 · S/N 18264060 N1245SMccain Michael E · Sun Valley, NVBuilt 1976 · S/N 18264814 N1247SShurma Ramesh · Hayward, CABuilt 1976 · S/N 18264816 N1248SBodolay John M · Fredericksburg, VABuilt 1976 · S/N 18264817 N1249SClemans Alan J · Guymon, OKBuilt 1976 · S/N 18264818 N124KChicken Hawk Aviation LLC Series 2 · Waxahachie, TXBuilt 1975 · S/N 18263803 N1250SNew Oasis Market Inc · Blacksburg, VABuilt 1976 · S/N 18264819 N1251SPt Air LLC · Madison, WIBuilt 1976 · S/N 18264820 N1252MNyquist David · Boulder, COBuilt 1975 · S/N 18264259 N1253SHale Jeffrey D · Reno, NVBuilt 1976 · S/N 18264822 N1254SStewart Donald K · Holbrook, MABuilt 1976 · S/N 18264823 N1255MCammack Lockwood P · Mount Pleasant, TXFirst renewal noticeBuilt 1975 · S/N 18264261 N1256SBrant P Rouse Dds Plc · Tahlequah, OKBuilt 1976 · S/N 18264825 N1257SKidd Bryce · Clovis, NMBuilt 1976 · S/N 18264826 N125MWMishler Kenneth C · Lawrence, KSBuilt 1973 · S/N 18262211 N125WAHorton Kelly · Hollis, OKBuilt 1975 · S/N 18263594 N1261SRed Arrows Aviation LLC · Lakeway, TXBuilt 1976 · S/N 18264829 N1262MRtw Aviation LLC · Fort Lauderdale, FLFirst renewal noticeBuilt 1975 · S/N 18264265 N1262SSopatyk Brian D · Boise, IDBuilt 1976 · S/N 18264830 N1263SAlabama Law Enforcement Agency · Montgomery, ALBuilt 1976 · S/N 18264831 N1265SColeman Douglas · Ocean Springs, MSBuilt 1976 · S/N 18264833 N1266SBarton Jonathan E · Tehachapi, CABuilt 1976 · S/N 18264834 N1267SWhitmore James W · Grass Valley, CABuilt 1976 · S/N 18264835 N1268MHuffer Tyle · Kenansville, NCBuilt 1975 · S/N 18264266 N1269MEagle High Properties LLC · Calhoun, LABuilt 1975 · S/N 18264267 N1269SMriaudio Inc · Carlsbad, CAS/N 18264837 N126MPSorensen P Grahame · Salt Lake City, UTBuilt 1974 · S/N 18262809 N1272SAfrican Parks Aviation Inc Trustee · Cheyenne, WYFirst renewal noticeBuilt 1976 · S/N 18264840 N1274MGarner Tom Trustee · Agua Dulce, CABuilt 1975 · S/N 18264271 N1274SDiamond E Electrical Services LLC · Bryant, ARBuilt 1976 · S/N 18264842 N1278SSac Exec LLC · Sacramento, CABuilt 1976 · S/N 18264846 N1279MSturdy Wings Aviation LLC · Mcpherson, KSBuilt 1975 · S/N 18264272 N1279SCavu Aviation LLC · Haiku, HIBuilt 1976 · S/N 18264847 N127RLSkylane Of Ohio LLC · London, OHS/N 18262910 N1281SChief Cornerstone LLC · Billings, MTBuilt 1976 · S/N 18264849 N1288SFrench Oil Co · Midland, TXBuilt 1976 · S/N 18264855

Back to Cessna 182P