Skip to content

Registered aircraft · 3,572

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

N4334RAir Dakota Flite Inc · Hettinger, NDBuilt 1974 · S/N 17263087 N4338RThompson Group Inc · Stockton, CABuilt 1974 · S/N 17263091 N4339RBurke Brian · Westlake, OHBuilt 1974 · S/N 17263092 N433PTPilot Training Center LLC · Miami, FLBuilt 1974 · S/N 17263088 N433RMRocky Mountain College · Billings, MTBuilt 1974 · S/N 17262914 N4341ROleary Paul V · Gold Creek, MTBuilt 1974 · S/N 17263094 N4343REndless Sky Aviation Inc · Syracuse, NYBuilt 1974 · S/N 17263096 N4346RFlyhnz LLC · Oxford, NCBuilt 1974 · S/N 17263097 N4347RAvair LLC · Westville, INS/N 17265205 N4349RVaughan James · Meansville, GABuilt 1974 · S/N 17263100 N4350RB2 West Corp · Winona, MNBuilt 1974 · S/N 17263101 N4351RVertol Systems Co Inc · Destin, FLBuilt 1974 · S/N 17263102 N4352RQuad City Area Flying Eagles · Milan, ILBuilt 1974 · S/N 17263103 N4358RBig M Flying Club Inc · Aberdeen, WABuilt 1974 · S/N 17263109 N4360RGrasshopper Flying Club Inc · Poughkeepsie, NYBuilt 1974 · S/N 17263111 N4362RBruther Thomas J · Temecula, CABuilt 1974 · S/N 17263113 N4363RSky Walker Flight School LLC · Adrian, MIBuilt 1974 · S/N 17263114 N4365RCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1974 · S/N 17263116 N4366RHyland Mark R · Poland, MEBuilt 1974 · S/N 17263117 N4370RSkar Paul R · Londonderry, NHBuilt 1974 · S/N 17263121 N4377RDallas Aero & Sales LLC · Poplar, MTBuilt 1974 · S/N 17263127 N4379RSlipstream Aviation LLC · Calera, ALBuilt 1974 · S/N 17263129 N4381RDugan James M · North Bend, OHS/N 17263131 N4382RMoranski Joseph F · Budd Lake, NJBuilt 1974 · S/N 17263132 N4384RAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263134 N4385RAnderson Kenneth J · Norman, OKBuilt 1974 · S/N 17263135 N4386RFlying H LLC · Lake Placid, FLBuilt 1974 · S/N 17263136 N4388RSunrise Aviation Inc · Ormond Beach, FLBuilt 1974 · S/N 17263138 N4390RBrown David R · Kent, WABuilt 1974 · S/N 17263140 N4391RCheek Kenneth W · Yadkinville, NCBuilt 1974 · S/N 17263141 N4393RHorizon Dreams LLC · Homer, GABuilt 1974 · S/N 17263143 N4397RBuiqui Aerospace Corp · Kissimmee, FLBuilt 1974 · S/N 17263147 N4398RAlferman Thomas H · Hampton Bays, NYBuilt 1974 · S/N 17263148 N4400RBophades LLC · Fort Pierce, FLBuilt 1974 · S/N 17263150 N4402QSummers Mark A · Alpine, WYBuilt 1973 · S/N 17261697 N4402RAvel Aircraft Inc · West Chicago, ILBuilt 1974 · S/N 17263152 N4403RGorge Aviation Services LLC · Portland, ORS/N 17263153 N4405RBon Homme Flyers Inc · Tyndall, SDBuilt 1974 · S/N 17263155 N4407QSund Manufacturing Co · Newburg, NDS/N 17261698 N4409RRegistration Pending · Albany, ORRegistration pendingBuilt 1974 · S/N 17263158 N4410QAyer Benjamin D · Newport, MEBuilt 1973 · S/N 17261699 N4410RSpane John T · Mount Airy, NCBuilt 1974 · S/N 17263159 N4415RNextgen Flight Academy Inc · Riverside, CABuilt 1974 · S/N 17263163 N4418RTeton Leasing LLC · Pocatello, IDBuilt 1974 · S/N 17263166 N441DLPinion Aviation Inc · Glenbrook, NVBuilt 1976 · S/N 17267391 N441DPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1975 · S/N 17265691 N4420RPeterson Reid E · Minnetonka, MNBuilt 1974 · S/N 17263167 N4422RN4422r LLC · Miami, FLBuilt 1974 · S/N 17263168 N4423QObap · Westchester, ILBuilt 1973 · S/N 17261704 N4427RRedwood Aviation Group LLC · Santa Rosa, CABuilt 1974 · S/N 17263173

Back to Cessna 172M