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.

N4711KFhk Inc · Verona, PABuilt 1975 · S/N 18263710 N4715KSki Town Aviation Management LLC · Steamboat Springs, COBuilt 1975 · S/N 18263714 N4716KGlobal Acquisition Ltd · Davenport, IABuilt 1975 · S/N 18263715 N4719KOneninekilo LLC · West Linn, ORBuilt 1975 · S/N 18263718 N471BCHyndman Antonio · Canton, TXBuilt 1976 · S/N 18264591 N4720KGeorge Joseph Q · Granbury, TXBuilt 1975 · S/N 18263719 N4724KWalgrove Venice LLC · Santa Monica, CABuilt 1975 · S/N 18263723 N4725KBoomerang Air LLC · Cedar Park, TXBuilt 1975 · S/N 18263724 N4726KEllis Thomas Troy · Slidell, LABuilt 1975 · S/N 18263725 N4727KSchau Donna · Post Falls, IDBuilt 1975 · S/N 18263726 N4728KCloud Dodgers Flying Club Inc · The Villages, FLBuilt 1975 · S/N 18263727 N4729KAlkire Jay · Boerne, TXBuilt 1975 · S/N 18263728 N476KETrexel Paul C · Willits, CABuilt 1975 · S/N 18264067 N479JLLopez Jesus D · Garfield, ARS/N 18264124 N47PSPalm Springs Air Museum Inc · Palm Springs, CABuilt 1973 · S/N 18262767 N47WZPengilly Sky LLC · Ellicottville, NYBuilt 1975 · S/N 18263911 N4800HBellings Jerry A · Neshkoro, WIBuilt 1972 · S/N 18261310 N48WEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1973 · S/N 18262161 N495EMAround The Patch LLC · Memphis, TNBuilt 1974 · S/N 18263485 N4999PPaul Bonnie Jean · Del Rio, TXS/N 18260958 N499MMBrown George P III · Houston, TXS/N 18261871 N49JSN49js LLC · Missoula, MTBuilt 1973 · S/N 18261975 N4ECPhantom Five Inc · Saint Louis, MOBuilt 1974 · S/N 18263038 N4FPWareham Darryl V · Mill Creek, WABuilt 1972 · S/N 18261050 N4GLWest Christina · Missouri City, TXBuilt 1973 · S/N 18262723 N4RQJ&P Aero LLC · Corsicana, TXBuilt 1984 · S/N 18262739 N505ABFredrickson Kenneth · Port Angeles, WABuilt 1974 · S/N 18263391 N509ARRegistered aircraftBuilt 1976 · S/N 18264456 N50CHBaker Harold · Byrdstown, TNBuilt 1975 · S/N 18264297 N50JCJg Air LLC · Wilmington, DEBuilt 1976 · S/N 18264656 N512JGJacobs Gareth · Woodruff, SCBuilt 1972 · S/N 18261972 N512KMWhite Holdings LLC · Washington, INBuilt 1975 · S/N 18263878 N517PCAfrican Bible Colleges Inc · Karval, COBuilt 1973 · S/N 18261628 N520CDYounger Helen J · Fair Oaks Ranch, TXBuilt 1976 · S/N 18265118 N52204Rench Eugene G · Owosso, MIS/N 18262452 N52213Rosner Peter · Acton, MABuilt 1973 · S/N 18262457 N52214Peterson Todd W · Beavercreek, ORBuilt 1973 · S/N 18262458 N52225Robinett Douglas · Laguna Niguel, CABuilt 1973 · S/N 18262466 N52226Kettell Merrilee · Eureka, MTBuilt 1973 · S/N 18262467 N52251Sims Robert M · Mc Ewen, TNBuilt 1973 · S/N 18262485 N52253Blue Viking Enterprises LLC · San Jose, CABuilt 1973 · S/N 18262487 N52255Springville Flying Club · Spanish Fork, UTBuilt 1973 · S/N 18262488 N52256Hutchinson Scott N · Broadlands, VAS/N 18262489 N52301Harmes Brian M · Harrisburg, PABuilt 1973 · S/N 18262515 N52304Haney Michael W · Tehachapi, CABuilt 1973 · S/N 18262516 N52305Ada Forestry Division · Malvern, ARBuilt 1973 · S/N 18262517 N52306Scott Construction Inc · Lake Delton, WIBuilt 1973 · S/N 18262518 N52308Registered aircraftBuilt 1973 · S/N 18262520 N52314Universal Aviatiors Academy Inc · El Monte, CABuilt 1973 · S/N 18262521 N52318Shephard Donald · Lake Havasu City, AZBuilt 1973 · S/N 18262524

Back to Cessna 182P