Skip to content

Registered aircraft · 784

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

N4873DRagan Matthew T · Boulder City, NVBuilt 1958 · S/N 34973 N4876DAcute Holdings LLC · Jenks, OKBuilt 1958 · S/N 34976 N4878DCache La Poudre LLC · Fairfield Bay, ARBuilt 1958 · S/N 34978 N4880DBernstein Timothy D · Faith, SDBuilt 1958 · S/N 34980 N4881DBurt Compton Enterprises Inc · Marfa, TXBuilt 1958 · S/N 34981 N4883DKingdom Air Corps · Sutton, AKBuilt 1958 · S/N 34983 N4884DGarcia Robert · Arcadia, CABuilt 1958 · S/N 34984 N4886DRegistered aircraftBuilt 1958 · S/N 34986 N4887DShank Lawrence · Pagosa Springs, COBuilt 1958 · S/N 34987 N4888DRegistered aircraftBuilt 1958 · S/N 34988 N4893DMazone Robert J · Deer Park, WABuilt 1958 · S/N 34993 N4895DMissouri Aviation Inc · Leeton, MOBuilt 1958 · S/N 34995 N4896DBrown Jason · Edwards, COS/N 34996 N4897DHall Leah · Diamond Springs, CABuilt 1958 · S/N 34997 N4898DAcute Holdings LLC · Jenks, OKBuilt 1958 · S/N 34998 N4903DSam Air LLC · Madison, SDBuilt 1958 · S/N 51003 N4906DHutchison Robert T · Big Lake, AKBuilt 1958 · S/N 51006 N4916DHoward Dan E · Hurricane, UTBuilt 1958 · S/N 51016 N4917DWright Tyler C · Wilmington, NCBuilt 1958 · S/N 51017 N4919DDewitz Mark A · Good Thunder, MNBuilt 1958 · S/N 51019 N4921DMills Air Service Inc · Marstons Mills, MABuilt 1958 · S/N 51021 N4924DRobinson Anthony D · Brookshire, TXBuilt 1958 · S/N 51024 N4929DUnion Flyers LLC · Union, SCBuilt 1958 · S/N 51029 N4930DToribio LLC · San Antonio, TXS/N 51030 N4940DAirborne One LLC · Kalispell, MTS/N 51040 N4942DN4942d LLC · Greenfield, NHBuilt 1958 · S/N 51042 N4944DSelkirk Associates Inc · Wilmington, DEBuilt 1958 · S/N 51044 N4947DEnstrom Thomas · New Berlin, NYBuilt 1958 · S/N 51047 N4948DSobrado Victor M · Norman, OKBuilt 1958 · S/N 51048 N4954DTracy Scott J · Santa Barbara, CAFirst renewal noticeBuilt 1958 · S/N 51054 N4957DCummings Roy E · Fort Scott, KSBuilt 1958 · S/N 51057 N4958DHarmon Jon E · Turner, MTBuilt 1958 · S/N 51058 N4960DRasmussen Scott M · Santa Cruz, CABuilt 1958 · S/N 51060 N4962DMcdonald Richard Reid · Rock Island, WAS/N 51062 N4964DGrizzly Air Service Inc · Paris, TXBuilt 1958 · S/N 51064 N4967DSchmieding Michael A · Salem, ORBuilt 1958 · S/N 51067 N4968DNelson Scott D · Blackfoot, IDBuilt 1958 · S/N 51068 N4969DFarwick Kobbe L · Lenexa, KSS/N 51069 N4970DMayes Nicholas R · Williams, CABuilt 1958 · S/N 51070 N4971DBolin William E · Smithville, OHBuilt 1958 · S/N 51071 N4972DPaulsden LLC · Caldwell, IDBuilt 1958 · S/N 51072 N4973DKilo Aviation LLC · East Peoria, ILBuilt 1958 · S/N 51073 N4974DPatton John W · Mancos, COBuilt 1958 · S/N 51074 N4976DConstenius Kurt N · Tucson, AZBuilt 1958 · S/N 51076 N4977DErdmann Gary A · North Pole, AKS/N 51077 N4978DCanterbury James A · Dixon, ILBuilt 1958 · S/N 51078 N4979DTrissell Flying Service Inc · Clarksville, TXBuilt 1958 · S/N 51079 N4981D23s Flyers LLC · Seeley Lake, MTBuilt 1958 · S/N 51081 N4984DDon Cat LLC · Shelby, MTS/N 51084 N4986DDodson Zachary S · Eastville, VAS/N 51086

Back to Cessna 182A