Skip to content

Registered aircraft · 3,138

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

N172UFR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273703 N172WAHandrop Ronald S · Bonita, CABuilt 1979 · S/N 17273507 N172WBTumbleweed Leasing Company Inc · Salt Lake City, UTBuilt 1978 · S/N 17270907 N172WNLegends Air Center LLC · Bentonville, ARBuilt 1978 · S/N 17270565 N172YHWild River Flying Club · Saint Croix Falls, WIBuilt 1979 · S/N 17271130 N173BADunlap Jolene · Peoria, ILBuilt 1979 · S/N 17272370 N173SKS Kamat Inc · Lexington, KYS/N 17272108 N174HAKlin Trin Collectibles LLC · Downers Grove, ILS/N 17272235 N176ERSkywarrior Flight Training LLC · Pensacola, FLS/N 17269507 N17SMN17sm LLC · Coral Springs, FLS/N 17272967 N180NYN180ny LLC · Wainscott, NYBuilt 1978 · S/N 17271141 N183SPIndian River Flying Club Inc · Rockledge, FLBuilt 1977 · S/N 172-68675 N186FMJett Aviation LLC · Clovis, NMFirst renewal noticeBuilt 1977 · S/N 17269339 N1900UBismarck Aero Center · Bismarck, NDBuilt 1979 · S/N 17273162 N1919FUsda Forest Service Fepp · Columbia, SCBuilt 1979 · S/N 17273011 N191ARJack Dixon Inc · Haiku, HIBuilt 1977 · S/N 17270069 N1920FChristensen Dean G · Elk Grove, CABuilt 1979 · S/N 17273012 N1921FState Of Iowa · Iowa City, IABuilt 1979 · S/N 17273013 N1923FAtlanta Air Academy LLC · Kennesaw, GABuilt 1980 · S/N 17273015 N1926FUnited Flying Club Inc · Belmont, CABuilt 1979 · S/N 17273017 N1927FSanders Herman G · Baldwyn, MSBuilt 1979 · S/N 17273018 N1928FJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17273019 N192ARDj Whelan Corp · Sag Harbor, NYBuilt 1978 · S/N 17272016 N1933FVidal Aviation LLC · Gaithersburg, MDBuilt 1979 · S/N 17273023 N1936FCheek David H · Garland, TXBuilt 1979 · S/N 17273026 N1937FA2 Flight Leasing LLC · Castro Valley, CABuilt 1979 · S/N 17273027 N1940FAmerican Asset Leasing LLC · Livermore, CAS/N 17273030 N1945FLake Elmo Aero LLC · Lake Elmo, MNBuilt 1979 · S/N 17273035 N1947FMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17273037 N1948FKdrd Holdings LLC · Texas City, TXBuilt 1979 · S/N 17273038 N194ARTarpley Richard · Cleveland, GABuilt 1978 · S/N 17272029 N1950FAce Of Spades Aviation LLC · Las Vegas, NVS/N 17273040 N1956FPenzo Michael A · Stafford, VABuilt 1979 · S/N 17273046 N1957Registered aircraftBuilt 1977 · S/N 17269009 N1957FSteward Ashtyn L · Weatherford, TXBuilt 1979 · S/N 17273047 N1960FCornerstone Financial Enterprises LLC · Mesquite, NVBuilt 1979 · S/N 17273050 N1961FRemove B4 Flight LLC · Joplin, MOBuilt 1979 · S/N 17273051 N1964FLombardo Russell S · Fostoria, MIBuilt 1979 · S/N 17273053 N1966FD & S Aviation LLC · Spring, TXBuilt 1980 · S/N 17273578 N1968FMedia Stew LLC · Carson City, NVBuilt 1979 · S/N 17273057 N1969EC M & T Aero Inc · Cedar Rapids, IABuilt 1978 · S/N 17271105 N196ARHeihn Daniel M · Soldotna, AKBuilt 1978 · S/N 17272023 N1971FButterfly Aviation Inc · Goodland, KSBuilt 1979 · S/N 17273059 N1972EMartin George C · Charleston, WVS/N 17271106 N1973FRuiz Naile C · Davie, FLBuilt 1979 · S/N 17273061 N1974FBusler Bradley R · Nacogdoches, TXBuilt 1979 · S/N 17273062 N1975FWard Gary T · Cincinnati, OHBuilt 1979 · S/N 17273063 N1976FRaritan Valley Flying School · Princeton, NJBuilt 1979 · S/N 17273064 N1977FJeffery & Weiss Holdings LLC · Long Beach, CABuilt 1979 · S/N 17273065 N1977SRiley James E · Sparks, NVBuilt 1976 · S/N 172-67687

Back to Cessna 172N