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.

N1441SHustad Kenneth H · Spokane, WABuilt 1976 · S/N 18264989 N1442DBiggs James R · Piney Flats, TNBuilt 1973 · S/N 18262106 N1442MLorenzo Blake D · Wynne, ARBuilt 1975 · S/N 18264332 N1442STodd Philip A · Wendell, NCBuilt 1976 · S/N 18264990 N1443MBahnmiller Dennis D · Highwood, MTBuilt 1975 · S/N 18264333 N1444SEagle Forestry Services Inc · Monticello, ARBuilt 1976 · S/N 18264992 N1445SHagemann Karl B · Santa Clarita, CABuilt 1976 · S/N 18264993 N1447SRegistered aircraftFirst renewal noticeBuilt 1976 · S/N 18264995 N1448SWild Heart Springs LLC · Wilder, IDBuilt 1976 · S/N 18264996 N1450SLocklear Jackie R · Concord, NCBuilt 1976 · S/N 18264998 N1451MSquatchair LLC · Roseburg, ORBuilt 1975 · S/N 18264335 N1453SVenice Flying Club Inc · Sarasota, FLBuilt 1976 · S/N 18265001 N1454SJackson Mike · Lakeside, AZBuilt 1976 · S/N 18265002 N1456SPremium Holdings LLC · Spokane, WABuilt 1976 · S/N 18265004 N1462SRiverside Aviation LLC · Oakland, IABuilt 1976 · S/N 18265009 N1464SRauch Andrew J · Timnath, COBuilt 1976 · S/N 18265011 N1466SCombs Brent L · Dallas, SDBuilt 1976 · S/N 18265013 N1469SS & J Farms · Floydada, TXBuilt 1976 · S/N 18265016 N1473M182p LLC · Oklahoma City, OKBuilt 1975 · S/N 18264340 N1473SBattin Robert C · Cartersville, GABuilt 1976 · S/N 18265020 N1475SMurdoch-Haig Alexandra · Kailua, HIBuilt 1976 · S/N 18265022 N1476SBk1 Farms LLC · Rock Port, MOBuilt 1976 · S/N 18265023 N1478MWestern Wind Aviation LLC · Suisun City, CABuilt 1975 · S/N 18264343 N147KLarson David W · New Iberia, LABuilt 1975 · S/N 18264068 N147MCSoloman Lynell J · Forks, WABuilt 1976 · S/N 18265026 N1480SAll In One Aviation LLC · Burleson, TXBuilt 1976 · S/N 18265027 N1481STraylor Margie · Cave Creek, AZBuilt 1976 · S/N 18265028 N1483MMaster Aviation LLC · Augusta, GAS/N 18264348 N1484SRoland Michael T · Gualala, CABuilt 1976 · S/N 18265031 N1485SMitchell Daniel P · Marseilles, ILBuilt 1976 · S/N 18265032 N1486MBrewer Donald S · Paragould, ARBuilt 1975 · S/N 18264349 N1486SBurdine Aviation Inc · Glidden, IABuilt 1976 · S/N 18265033 N1487SSkovira Michael D · Scottdale, PABuilt 1976 · S/N 18265034 N1489MBrinker Corp Inc · Glen Elder, KSBuilt 1975 · S/N 18264350 N1489SBender Roger J · Overgaard, AZBuilt 1976 · S/N 18265036 N1490SEfna LLC · Wichita, KSBuilt 1976 · S/N 18265037 N1492SBurr John R · Salem, VABuilt 1976 · S/N 18265039 N1494S1494 Sierra Inc · Waynesville, OHBuilt 1976 · S/N 18265041 N1496MMustang Sally Aviation LLC · Camden, SCS/N 18264352 N1498MSoaring Utah Inc · Sandy, UTBuilt 1975 · S/N 18264353 N1498SNull Perry D · Gallup, NMBuilt 1976 · S/N 18265045 N1499SSkylane Pictures LLC · Los Angeles, CABuilt 1976 · S/N 18265046 N14BABurris & Macomber P L L C Trustee · Tucson, AZS/N 18261211 N14VCG5 LLC · Gallup, NMS/N 18264127 N14YYNorthwoods Air LLC · Orono, MEBuilt 1972 · S/N 18261390 N1501MMeszler Christopher P · Spring Branch, TXBuilt 1975 · S/N 18264354 N1506MBonn Steven · Hummelstown, PABuilt 1975 · S/N 18264356 N1509MChalk 2 Inc · Apple Valley, CABuilt 1975 · S/N 18264357 N1514MVaquera Moises C · Orland, CABuilt 1975 · S/N 18264359 N1530MSinclair Justin Michael · Annandale, VABuilt 1975 · S/N 18264365

Back to Cessna 182P