Skip to content

Registered aircraft · 432

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 ('2072728')
  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 ('2072728')
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.

N70826Chabay Shawna P · Greenleaf, IDBuilt 1968 · S/N 18259380 N70845Registered aircraftBuilt 1968 · S/N 18259390 N70849Hedrick Chad A · Goshen, OHS/N 18259393 N70861Importico William J · Bridgewater, NJBuilt 1968 · S/N 18259397 N70867Phantom Flyer LLC · Yelm, WABuilt 1968 · S/N 18259400 N70872Johorn LLC · Downingtown, PABuilt 1968 · S/N 18259402 N70884Walbert Frank J · Pagosa Springs, COBuilt 1969 · S/N 18259405 N70885Bates Ranches · Condon, ORBuilt 1968 · S/N 18259406 N70888Nbw Wings LLC · Cave Creek, AZBuilt 1968 · S/N 18259408 N70892Williams Tyler D · Tracy, CABuilt 1968 · S/N 18259410 N70901Ckt Aviation LLC · Anchorage, AKBuilt 1968 · S/N 18259411 N70902Bienz David E · Scottsdale, AZBuilt 1968 · S/N 18259412 N70913Sunset Aviation LLC · New Iberia, LABuilt 1968 · S/N 18259416 N70915Patterson Thomas L · Bryan, TXBuilt 1968 · S/N 18259417 N70917Edwards Guy A · Sedalia, COBuilt 1968 · S/N 18259419 N70920Lannoye Tyler G · Leeds, NDBuilt 1968 · S/N 18259420 N70933Beta Flight LLC · South Burlington, VTS/N 18259423 N70938Dawson Ranch Aviation LLC · Encinal, TXBuilt 1968 · S/N 18259425 N70949Saucier Brock D · Dallas, TXBuilt 1968 · S/N 18259431 N70956Holdsworth Randy L · Zoar, OHBuilt 1968 · S/N 18259435 N70966Kelly David M · Hedgesville, WVS/N 18259437 N70967Bramblett Steve · Bennington, OKBuilt 1968 · S/N 18259438 N70974Ross Donald Malcolm · Lawton, OKBuilt 1968 · S/N 18259439 N70977Soran Patrick David · Reno, NVBuilt 1968 · S/N 18259440 N70981Broken Rainbow Enterprises Inc · Torrey, UTBuilt 1968 · S/N 18259443 N70984Rau Brian C · Medina, NDBuilt 1968 · S/N 18259445 N70986Hobby John J · Durango, COBuilt 1968 · S/N 18259446 N70988Kelley Ronald C · Deer Lodge, MTBuilt 1968 · S/N 18259448 N71002Sheepdog Aviation LLC · Murfreesboro, TNBuilt 1968 · S/N 18259454 N710061 Lowflyer Inc · Harrisonville, MOBuilt 1968 · S/N 18259455 N71007Farmer Gary E · Saint Augustine, FLBuilt 1968 · S/N 18259456 N71009Fairhurst George D II · Kailua, HIFirst renewal noticeS/N 18259457 N71016Fiesbeck Kirt E · Saint Joseph, MIBuilt 1968 · S/N 18259459 N71028Hawkins Joann L · Cupertino, CABuilt 1968 · S/N 18259462 N71033Guthmiller David L · Lake Havasu City, AZBuilt 1968 · S/N 18259465 N71040Benegar Al · Visalia, CAS/N 18259469 N71041Velez-Colon Luis X · Cibolo, TXBuilt 1968 · S/N 18259470 N71045Bandstra Larry J · Heath Springs, SCBuilt 1968 · S/N 18259471 N71047Lakehouse Aviation LLC · Peoria, ILBuilt 1968 · S/N 18259472 N71050Shutt Noel M · Atascadero, CABuilt 1968 · S/N 18259473 N71065Setty Matthew M · Reno, NVBuilt 1968 · S/N 18259479 N71069Johnson Wayne L · Spokane, WABuilt 1968 · S/N 18259481 N71070Taylor Mark R · Washington, UTBuilt 1968 · S/N 18259482 N71074Bas Part Sales LLC · Greeley, COBuilt 1968 · S/N 18259484 N71076Vrem Kelly L · Washington, UTBuilt 1968 · S/N 18259485 N71077Duch Jose M · Miami, FLBuilt 1968 · S/N 18259486 N71084Mccarty Kennith E · Eagle River, AKBuilt 1968 · S/N 18259490 N71099Michie Robert B · Austin, TXS/N 18259495 N71107Jrf Enterprises LLC · Salem, ORS/N 18259497 N71114Aeropaws Aviation LLC · Front Royal, VABuilt 1968 · S/N 18259499

Back to Cessna 182M