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.

N7439QSpoer Jonathan M · Agoura Hills, CABuilt 1972 · S/N 18261079 N7440NDrewes Farms Inc · Craig, MOS/N 18263218 N7440QAircraft Holding LLC · Orem, UTBuilt 1972 · S/N 18261080 N7441NAir Impressions Inc · Waco, TXBuilt 1974 · S/N 18263219 N7441QRegistered aircraftRegistration pendingBuilt 1972 · S/N 18261081 N7444QGroffman Armand Rossini · Los Alamos, NMBuilt 1972 · S/N 18261084 N7445NSkyplane Pilots LLC · Bluffton, SCS/N 18263223 N7445QPennino James B · Rancho Cucamonga, CABuilt 1972 · S/N 18261085 N7446QAvco Patrol LLC · Lyndon, KSBuilt 1972 · S/N 18261086 N7448QWilkus Michael J · Mound, MNBuilt 1972 · S/N 18261088 N744EFTango Alpha Sierra LLC · Austin, TXBuilt 1976 · S/N 18264796 N7454QHattieville Leasing LLC · Morrilton, ARBuilt 1972 · S/N 18261094 N7457QThompson Erick O · South Jordan, UTBuilt 1972 · S/N 18261097 N7459QBeemer David A · Bath, MEBuilt 1972 · S/N 18261099 N7463QDelaney David M · Bullard, TXBuilt 1972 · S/N 18261103 N7465QMiller Jay M · Grantsville, MDBuilt 1972 · S/N 18261105 N7466QBrewster Lawrence M III · Ola, IDBuilt 1972 · S/N 18261106 N7469QDornan Michael · Puyallup, WABuilt 1972 · S/N 18261109 N7471QBattle Fish South Inc · Tunica, MSBuilt 1972 · S/N 18261111 N7472QApogee Air LLC · Newark, CABuilt 1972 · S/N 18261112 N7474QCattani Brent A · Gilbert, AZBuilt 1972 · S/N 18261114 N7474SCastaneda Jose · Yakima, WABuilt 1974 · S/N 18263032 N7477QSalmon Ernest P · Thousand Oaks, CABuilt 1972 · S/N 18261117 N747JLWillis Robert K · Lake Havasu City, AZBuilt 1975 · S/N 18264279 N7480QDecatur Aero Club Inc · Decatur, ILBuilt 1972 · S/N 18261120 N7484QPlanebroker.Com LLC · Miramar Beach, FLBuilt 1972 · S/N 18261124 N7489QLlano Masonry LLC · Lubbock, TXBuilt 1972 · S/N 18261129 N74MKBunn Joseph D · Hugo, OKBuilt 1974 · S/N 18262919 N74VTStorsteen Erik M · Gardena, CABuilt 1974 · S/N 18262982 N7529NNoam Eli M · New York, NYS/N 18263232 N7531NDreampad LLC · New York, NYBuilt 1974 · S/N 18263233 N7536NRomence Louis Wm · Grand Rapids, MIBuilt 1974 · S/N 18263237 N7537GConway John F · Cumming, GABuilt 1974 · S/N 18263321 N7556NSmith Chad R · West Plains, MOBuilt 1974 · S/N 18263245 N7558NRegistration Pending · Benton, ARRegistration pendingBuilt 1974 · S/N 18263247 N7566NBoedecker Brock · Sheridan, WYBuilt 1974 · S/N 18263255 N7570NHoussiere Daniel D · Arcadia, CAS/N 18263259 N7571NCasteneda Jose · Yakima, WABuilt 1974 · S/N 18263260 N7577NAaron Aviation LLC · San Diego, CABuilt 1974 · S/N 18263263 N757RJCenter Brian · Garwood, TXBuilt 1976 · S/N 18264805 N7580NSparling George · Grand Prairie, TXBuilt 1974 · S/N 18263266 N759WRAlmond Kevin L · Waxahachie, TXBuilt 1974 · S/N 18263231 N75DWBliss Gregory A · Saint Johns, FLBuilt 1975 · S/N 18263906 N7600HArslanian Brian Haroutun · Brookhaven, GABuilt 1972 · S/N 18261288 N7600JBuchanan Jamie · Deforest, WIBuilt 1976 · S/N 18264689 N7616NFox Tim · Obion, TNBuilt 1974 · S/N 18263274 N76182Vaughan Steven T · Overland Park, KSBuilt 1976 · S/N 18264888 N7619NAir Alday LLC · Pompano Beach, FLBuilt 1974 · S/N 18263277 N761PJGateway Flying Club Inc · Blaine, MNBuilt 1976 · S/N 18264787 N7691GBorden John A · Hoover, ALBuilt 1974 · S/N 18263327

Back to Cessna 182P