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.

N58909Plantation Farms Inc · Wall, TXFirst renewal noticeBuilt 1973 · S/N 18262390 N58923Singh Jaspal · Sacramento, CABuilt 1973 · S/N 18262394 N58924Quicksilver Air Inc · Fairbanks, AKS/N 18262395 N58926Hawkeye Aviation Inc · Yakima, WABuilt 1973 · S/N 18262397 N58944Cassada Josh A · Charlevoix, MIBuilt 1973 · S/N 18262415 N58949M & M Aircraft LLC · Cresson, TXBuilt 1973 · S/N 18262420 N58954Musheinesh Issa A · Bloomfield Hills, MIBuilt 1973 · S/N 18262424 N58960Regan Ed · Torrance, CABuilt 1973 · S/N 18262428 N58961Monteith Andrew W · Lebanon, PABuilt 1973 · S/N 18262429 N58964Likens Tony G · Longville, MNBuilt 1973 · S/N 18262432 N58967Whatsup LLC · Mccomb, MSBuilt 1973 · S/N 18262435 N58976Pennington Tony D · Corpus Christi, TXBuilt 1973 · S/N 18262439 N5897CGot Wings LLC · Woodbury, NYBuilt 1973 · S/N 18262437 N58981Skloss Anthony W · Edinburg, TXBuilt 1973 · S/N 18262441 N58989Texas Wings In The Air II LLC · Santa Teresa, NMBuilt 1973 · S/N 18262442 N58994Aviation Trust Co LLC Trustee · Oklahoma City, OKS/N 18262444 N58998Coach Aviation LLC · Dover, DES/N 18262446 N58999United Indian Missions DBA · Tucson, AZBuilt 1973 · S/N 18262447 N589RRock & Roe LLC · Corpus Christi, TXBuilt 1975 · S/N 18264115 N58MGMullins Tennis Jr · Chapmanville, WVBuilt 1973 · S/N 18262358 N5904JHodge Marcus · Mansfield, LABuilt 1975 · S/N 18263572 N5905JF92 Aviation Llp · Dover, OKBuilt 1975 · S/N 18263573 N5911JAveightor LLC · Alba, TXBuilt 1975 · S/N 18263574 N5914JFreedom One Inc · San Jose, CABuilt 1975 · S/N 18263575 N5922JMerlin Iron Works LLC · Westwood, KSBuilt 1975 · S/N 18263577 N5926JVintage Aviation LLC · Billings, MTBuilt 1975 · S/N 18263581 N5932JOwen Stephen M · Wiggins, MSBuilt 1975 · S/N 18263583 N5935JSwinden Jonathan · Danville, PABuilt 1975 · S/N 18263585 N5950GSmylie Michael Dean · Douglas, WYBuilt 1974 · S/N 18263310 N5966JWydronek Joseph A · Tucson, AZBuilt 1975 · S/N 18263590 N5984Eberle Larry L · Humble, TXBuilt 1971 · S/N 18260841 N5984JZogleman Enterprises Inc · Viola, KSBuilt 1975 · S/N 18263599 N5985JRuby Crest LLC · Girdwood, AKBuilt 1975 · S/N 18263600 N5995JYachal Benedick · Wilsey, KSBuilt 1975 · S/N 18263604 N5996JEvergreen Flying Club Inc · Medina, WABuilt 1975 · S/N 18263605 N59CKSig Properties LLC · Helena, ARFirst renewal noticeBuilt 1972 · S/N 18261416 N59KHKrause Wesley A · Big Bear City, CABuilt 1972 · S/N 18261378 N5SCGarrett John R II · Waxhaw, NCS/N 18261939 N5VEMurphee Koby T · Spirit Lake, IDBuilt 1976 · S/N 18264950 N5ZBBlue Aviation Inc · Venice, FLFirst renewal noticeBuilt 1972 · S/N 18261631 N6002JSeibert John E · Anchorage, AKBuilt 1975 · S/N 18263607 N6010FGlodowski Brian D · Bergland, MIBuilt 1975 · S/N 18264061 N6039JMccullough Charles Acie · Grand Saline, TXBuilt 1975 · S/N 18263616 N6045JCavender Michael J · Tucson, AZBuilt 1975 · S/N 18263617 N6050JTri-M LLC · Nikiski, AKS/N 18263619 N6055FKlein Eric L · Tucson, AZBuilt 1975 · S/N 18264072 N6056FRkc Aviation Inc · Wilmington, DEBuilt 1975 · S/N 18264073 N6061FGustafson John S · Aledo, TXBuilt 1975 · S/N 18264077 N6062FWildcat Airplane Co LLC · Portland, ORBuilt 1975 · S/N 18264078 N6066FMeyer Justin R · Telluride, COBuilt 1975 · S/N 18264082

Back to Cessna 182P