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.

N128JRMorris Dylan L · Garden Plain, KSBuilt 1976 · S/N 18264785 N1290MGardner Michael John · Ashland, ILBuilt 1975 · S/N 18264275 N1291MCon Air Aviation LLC · Westerville, OHBuilt 1975 · S/N 18264276 N1291SAvidyne Corp · Melbourne, FLBuilt 1976 · S/N 18264858 N1292MCool Change Rentals LLC · Beaufort, NCBuilt 1975 · S/N 18264277 N1293SMeyer Raymond · Belding, MIBuilt 1976 · S/N 18264860 N1294SSheehan Dennis M · Stoughton, WIBuilt 1976 · S/N 18264861 N1297SAlpine Skylane LLC · Alpine, WYS/N 18264864 N1298MRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1975 · S/N 18264280 N1298SHighlane LLC · Phoenix, AZBuilt 1976 · S/N 18264865 N1299SAero Guard Aviation Insurance LLC · Lincoln, NEBuilt 1976 · S/N 18264866 N129CSGoldenstein Steven H Jr · Jurupa Valley, CABuilt 1975 · S/N 18264167 N12BCCentral Ohio Flyers Assn · Columbus, OHBuilt 1973 · S/N 18261895 N12FJClement Nicolas · Littleton, MABuilt 1973 · S/N 18261732 N12WRJjc Flyers LLC · Gladwin, MIBuilt 1975 · S/N 18263552 N1302LStelling Scott W · Johns Island, SCBuilt 1975 · S/N 18263615 N1302SSetnar Stephen Roger · Seaford, DEFirst renewal noticeS/N 18264868 N1303SClemens Dennis Patrick · Arnold, CABuilt 1976 · S/N 18264869 N1308SCecil Donald C · Willows, CABuilt 1976 · S/N 18264873 N1309SBlackburn Mark R · Saint Paul, KSBuilt 1976 · S/N 18264874 N130TCVogt Richard L · Panama City Beach, FLBuilt 1976 · S/N 18264999 N1311SCutlass 661 LLC · Orange Park, FLBuilt 1976 · S/N 18264876 N1312SMid Valley Aviation LLC · Groveland, CAS/N 18264877 N1315MSpitzer John R · Rockford, ILBuilt 1975 · S/N 18264285 N1317MScallcess LLC · Boynton Beach, FLBuilt 1975 · S/N 18264287 N1317SWarrior Ink · Whittier, CABuilt 1976 · S/N 18264881 N1320SInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 18264884 N1321SKibler Ronald P · Kennesaw, GABuilt 1976 · S/N 18264885 N1323MWatson Laura · Gates Mills, OHBuilt 1975 · S/N 18264288 N1325SD Angelo Holdings Inc · Gilbert, AZBuilt 1976 · S/N 18264889 N1327SFields Leif D · Gridley, CABuilt 1976 · S/N 18264891 N1328SScott Adrienne Diann · College Station, TXBuilt 1976 · S/N 18264892 N1331SScenic Adventures LLC · Silverthorne, COBuilt 1976 · S/N 18264895 N1332SCottrell Brian D · West Palm Beach, FLBuilt 1976 · S/N 18264896 N1336SJ And D Petroleum Co · Tallahassee, FLBuilt 1976 · S/N 18264899 N133VWAlpine Katmai LLC · Alpine, WYBuilt 1975 · S/N 18263927 N1342SFreeworld Aviation LLC · Dixon, ILBuilt 1976 · S/N 18264905 N1343SComalander Christopher R · Beaumont, TXBuilt 1976 · S/N 18264906 N1345SGrant Larry · Sebring, FLBuilt 1976 · S/N 18264908 N1347SEskridge Steven Barry · Winona, MSBuilt 1976 · S/N 18264910 N1349SSwiss Edm Wirecut Inc · Prospect Heights, ILBuilt 1976 · S/N 18264912 N1351SEllard James M · Danielsville, GABuilt 1976 · S/N 18264914 N1352SEjw Enterprises LLC · Aguila, AZS/N 18264915 N1353SHerrick Kendall D · Johnson, KSS/N 18264916 N1355SFlight Services Limited LLC · Bennett, COBuilt 1976 · S/N 18264918 N1356MYbarra Xavier · Uvalde, TXS/N 18264294 N1356STc Aviation LLC · Atlanta, GABuilt 1976 · S/N 18264919 N1357SSmith & Smith Inc · Hurricane, WVBuilt 1976 · S/N 18264920 N1359MJtal Holdings LLC · Wilmington, DEBuilt 1975 · S/N 18264296 N1363SAlabama Law Enforcement Agency · Montgomery, ALBuilt 1976 · S/N 18264926

Back to Cessna 182P