Skip to content

Registered aircraft · 487

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

N246TRegistered aircraftBuilt 1981 · S/N 18268091 N2494EDuran Louis · Chino, CABuilt 1982 · S/N 18268207 N250CW250 Charlie Whiskey LLC · Topeka, KSBuilt 1982 · S/N 18268273 N252HPFino Al Cielo LLC · Jacksonville, FLBuilt 1983 · S/N 18268320 N2653Barr Air Patrol LLC · Mesquite, TXBuilt 1982 · S/N 18268297 N2659KWickline Wayne · Flower Mound, TXBuilt 1985 · S/N 18268502 N2660Applegate Land Holdings LLC · Jacksonville, ORBuilt 1981 · S/N 18268100 N27VPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N 18268451 N2835EGonzalez Roberto Jr · Madera, CAS/N 18268213 N2888ESterett Terry Alan Jr · New Port Richey, FLBuilt 1982 · S/N 18268218 N2889EWesellhigh LLC · West End, NCBuilt 1982 · S/N 18268219 N2911EAsphaltresource.Com LLC · Schwenksville, PABuilt 1982 · S/N 18268220 N291SPBarr Air Patrol LLC · Mesquite, TXBuilt 1986 · S/N 18268546 N2986EYbarguen Johnny C · Rosenberg, TXBuilt 1982 · S/N 18268225 N3014EConstantine Carl A · Arroyo Grande, CABuilt 1982 · S/N 18268226 N3022EBoulais Aaron · Upland, CABuilt 1982 · S/N 18268227 N3049EConnor Leslie W · Venice, FLBuilt 1982 · S/N 18268229 N3067EGlass Bruce D · Crystal Lake, ILBuilt 1982 · S/N 18268231 N311TLM & N Enterprises LLC · Topeka, KSBuilt 1981 · S/N 18267937 N3172EKruchten Larry A · Scottsdale, AZBuilt 1982 · S/N 18268237 N3195ECatlett John W · Briggsville, ARBuilt 1982 · S/N 18268238 N323KWBlue Cedar Aviation LLC · Raymore, MOBuilt 1985 · S/N 18268480 N323TSKnippen Ronald M · Fort Jennings, OHBuilt 1982 · S/N 18268154 N3246EKauffman Gerald E · Bedford, PABuilt 1982 · S/N 18268239 N331SPReinfeldt Phillip R · Burnsville, MNS/N 18268441 N3329ERichards Erick F · Stamford, TXS/N 18268242 N3376EFresh Air LLC · Camarillo, CABuilt 1982 · S/N 18268243 N357HTBas Part Sales LLC · Greeley, COS/N 18267806 N35VHBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N 18268129 N38180Raymond Katherine · Akron, OHBuilt 1981 · S/N 18267880 N4048MJoel Massey Real Estate LLC · Flowery Branch, GABuilt 1981 · S/N 182-67993 N411PBStarfire Consulting LLC · Nisswa, MNBuilt 1983 · S/N 18268309 N413TAInfinite Runway LLC · Union City, CABuilt 1981 · S/N 18267922 N41MCGarner John B · Newark, DEBuilt 1984 · S/N 18268379 N422HDaniel Harwell Md Pllc DBA · Tulsa, OKBuilt 1981 · S/N 18268053 N425KAHerrmann Laura Jean Trustee · Saint Bonifacius, MNS/N 18268454 N42AVIsland Aero LLC · East Northport, NYBuilt 1982 · S/N 18268267 N42BHDondelinger Consulting LLC · Brainerd, MNS/N 18268199 N430MState Of Louisiana · Baton Rouge, LAS/N 18268250 N432TSModern Air Solutions LLC · Panama City Beach, FLBuilt 1981 · S/N 18267862 N441SPPendragon Aviation LLC · Sylvania, GABuilt 1982 · S/N 18268215 N44LMDelpenn Flyers Inc · Dover, DEBuilt 1981 · S/N 18268030 N450JTN450jt LLC · Colleyville, TXBuilt 1981 · S/N 18268032 N4580EDe Baca Land & Cattle LLC · Jacksboro, TXBuilt 1982 · S/N 18268244 N4582ERelis Enterprises LLC · Ravenel, SCBuilt 1982 · S/N 18268245 N4601ETen Two Holdings LLC · Somers, MTBuilt 1982 · S/N 18268248 N4617EState Of Michigan · Lansing, MIBuilt 1982 · S/N 18268251 N4646HMilton Djana · Lakewood, WABuilt 1981 · S/N 18267847 N4648ERandall John Kelly · Fremont, OHBuilt 1982 · S/N 18268254 N4655EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268255

Back to Cessna 182R