Skip to content

Registered aircraft · 660

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

N1741VCollins E Randolph · Clemson, SCFirst renewal noticeBuilt 1947 · S/N 13926 N1745VReinholtz Edward J · Glasford, ILBuilt 1947 · S/N 13930 N1746NSmith Courtney E · Phoenix, AZBuilt 1946 · S/N 11990 N1748NTengesdal Kenneth L · Maxbass, NDBuilt 1946 · S/N 11992 N1751NTynes Edward R · Round Rock, TXBuilt 1946 · S/N 11995 N1751VScott William G · Lebanon, ORBuilt 1947 · S/N 13936 N1754NMorrison Rodney R · Hot Springs, ARBuilt 1946 · S/N 11998 N1755VMcclean James · Springfield, MOBuilt 1947 · S/N 13940 N1757VMollohan Timothy J · Otis, COBuilt 1947 · S/N 14138 N1758NMclaughlin James L · Centerburg, OHS/N 12002 N1761NNewcomer Ryan D · Monroe, GABuilt 1946 · S/N 12005 N1761VMoyer Michael R · Elkton, MDBuilt 1947 · S/N 13946 N1766NStevens William · Nassau Bay, TXBuilt 1946 · S/N 12010 N1767VHanson Jonathan G · Nome, AKS/N 14151 N1770NWirth Curtis L · New Raymer, COBuilt 1946 · S/N 12014 N1771NRohsner Thomas A · Nacogdoches, TXBuilt 1946 · S/N 12015 N1773NRhoades William P · Northfield, MNBuilt 1946 · S/N 12017 N1773VGilbert Mary L · Memphis, NYS/N 13958 N1775NPritchard Joshua E · Andover, KSBuilt 1946 · S/N 12019 N1783VMark Uhlman Dpe LLC · Perry, OKBuilt 1947 · S/N 13968 N1786NLivingston Lyle R · Chico, CABuilt 1946 · S/N 12030 N1791NKieser Jason P · Bloomington, ILBuilt 1946 · S/N 12035 N1793NDaigh Eric B · Ketchum, IDS/N 12027 N1794NRedsun Oren D · Fairfield, CABuilt 1946 · S/N 12038 N1795NBeckham Joseph D · New Waverly, TXBuilt 1946 · S/N 12039 N1797NStrebel David P · Oroville, CABuilt 1946 · S/N 12041 N1797VValle Perez Kevin · Castroville, TXBuilt 1947 · S/N 13982 N1798NHissam Joshua K · Pasco, WAS/N 12042 N1803VAnderson Michael J · Carmichael, CABuilt 1947 · S/N 13988 N1805NThompson Randy L · Anderson, CABuilt 1946 · S/N 12049 N1807VBushre David N · Janesville, WIBuilt 1947 · S/N 13992 N1810NMetzler Darwin H · Manheim, PABuilt 1946 · S/N 12054 N1812NRutherford Kevin · Sheridan, ARBuilt 1946 · S/N 12056 N1813VCodingflyboy LLC · Hayward, CAS/N 13998 N1817VHarper James J · Miller, MOBuilt 1947 · S/N 14002 N1818NFirth Thomas H IV · Sonora, CABuilt 1946 · S/N 12062 N1819NPower Terry Edward · Council, IDBuilt 1946 · S/N 12063 N1819VSparebanc LLC · Appleton, MNBuilt 1947 · S/N 14004 N1823NMoehn Dennis H · Oshkosh, WIS/N 12067 N1823VWeller Oscar R · Sun City, AZBuilt 1947 · S/N 14150 N1826NHenry Dean R · Gilroy, CABuilt 1946 · S/N 12070 N1827NBrooks Adam Jacob Robert · Granada Hills, CABuilt 1946 · S/N 12071 N1827VAgate Mark A · Phoenix, AZBuilt 1947 · S/N 14045 N1829NEvans Earl J · Oglethorpe, GABuilt 1948 · S/N 12073 N1829VJacob Mark K · East Lansing, MIBuilt 1947 · S/N 14047 N1834NBernard Elswick Theodore · Fernley, NVBuilt 1946 · S/N 12078 N1835VHauser Linda L · Ulysses, KSBuilt 1947 · S/N 14074 N1836NMulligan Kevin S · Port Alexander, AKBuilt 1946 · S/N 12080 N1838NMutual Flyers Inc · Columbus, NEBuilt 1946 · S/N 12082 N1839VEdwards Christopher V · Seattle, WAS/N 14084

Back to Cessna 120