Skip to content

Registered aircraft · 857

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

N4387QCrose Merrill L · Sibley, MOBuilt 1971 · S/N 17260287 N4389QMellinger Jason C · North Pole, AKS/N 17260289 N4390QFlying Mermaid LLC · Aiea, HIBuilt 1971 · S/N 17260290 N4391QSpringville Flying Club · Spanish Fork, UTBuilt 1971 · S/N 17260291 N4392QRose Denver W · Eubank, KYBuilt 1971 · S/N 17260292 N4393QJkj Aviation LLC · Wilmington, NCBuilt 1971 · S/N 17260293 N4394QAircraft Resource Center Inc · Lakeville, MNBuilt 1971 · S/N 17260294 N4396QBennett Barry J · Owasso, OKBuilt 1971 · S/N 17260296 N4397QWingsleasing LLC · Wichita, KSS/N 17260297 N4399QHoefly Christopher · Belleview, FLS/N 17260299 N46696Moses Aviation Services LLC · Uvalde, TXBuilt 1971 · S/N 17259722 N48JKKeahey Britt · Saint Joseph, LABuilt 1972 · S/N 17260693 N4EBDaro Norman E · Cody, WYBuilt 1972 · S/N 17260518 N500BSCentral Aircraft Sales And Leasing LLC · Columbia, MOBuilt 1971 · S/N 17260303 N50772Donnelly Jennifer A · Hackettstown, NJBuilt 1971 · S/N 17259947 N5081UKiloecho Aeronautics LLC · Tucson, AZBuilt 1971 · S/N 17259673 N521DMAllison James R · Middlefield, OHBuilt 1972 · S/N 17260567 N529TDJohnson Timothy Dean · Walton, KYBuilt 1972 · S/N 17260741 N5500GCummings Terence J · Morgan Hill, CABuilt 1971 · S/N 17260300 N5947NGmm Records · Big Pine Key, FLBuilt 1972 · S/N 17260597 N595KHarvey Air LLC · Doylestown, PABuilt 1972 · S/N 17260401 N59PGStone Aviation Holdings LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260347 N59VLKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259905 N5PTMunson George R · Westhampton, MABuilt 1972 · S/N 17260628 N5RWToms Ronald C · Lena, LABuilt 1970 · S/N 17259649 N620GWBoyer Skip P · Oak Harbor, WABuilt 1972 · S/N 17260486 N622EHaggerty Russell P · Bethpage, NYBuilt 1971 · S/N 17260059 N628RBBrown Michael C · Erie, KSBuilt 1972 · S/N 17260622 N63GOneil Liam Trustee · Vashon, WABuilt 1972 · S/N 17260616 N660TAReinhardt Anthony C · Duchesne, UTBuilt 1970 · S/N 17259612 N6644MSierra Lima Aviation LLC · Riverton, UTBuilt 1972 · S/N 17260503 N666JVWalter Jack N · Meadville, PABuilt 1972 · S/N 17260737 N6HNTalbott Philip A · Galena, OHBuilt 1971 · S/N 172-60326 N7005QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1971 · S/N 17260305 N7006QToney Edward L · Hampton, GABuilt 1971 · S/N 17260306 N7009QJoiner Legacy Enterprises LLC · Joliet, MTS/N 17260309 N7010QMosman Matthew J · Nezperce, IDS/N 17260310 N7013QVeil Casey J · Jamestown, NDBuilt 1971 · S/N 17260313 N7017QClair Michael A · Omaha, TXFirst renewal noticeBuilt 1971 · S/N 17260317 N7018QStockett & Assoc Ltd · Hattiesburg, MSBuilt 1971 · S/N 17260318 N7019QYenser Thomas A · Kutztown, PABuilt 1971 · S/N 17260319 N7020QAufderheide Flying Service Inc · De Witt, ARBuilt 1971 · S/N 17260320 N7022QChant Savanah B · Baggs, WYBuilt 1971 · S/N 17260322 N7024QWells Nathan S · Scotia, NEBuilt 1971 · S/N 17260324 N7027QAero B Flying Service · Richards, MOBuilt 1971 · S/N 17260327 N7028QBurns Michael S · Coplay, PABuilt 1971 · S/N 17260328 N7034QTesch David P · Pardeeville, WIBuilt 1971 · S/N 17260334 N7035QEarly Bird Aviation LLC · Phoenix, AZBuilt 1971 · S/N 17260335 N7037QJohnson Joe N · Smithville, TNBuilt 1971 · S/N 17260337 N7038QSchenone William M · Mattituck, NYBuilt 1971 · S/N 17260338

Back to Cessna 172L