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.

N1840NBybee James W · West Jordan, UTBuilt 1946 · S/N 12084 N1843NMaples Andrew L · Belle, MOBuilt 1946 · S/N 12087 N1843VFrostman Ronald G · Ft Myers, FLBuilt 1947 · S/N 14096 N1844NCorn Dustin M · Muncie, INBuilt 1946 · S/N 12088 N1844VWheelock Jon M · Fairbanks, AKS/N 14102 N1845NLoucks Donald A · Bastrop, TXBuilt 1946 · S/N 12089 N1847NO'Quinn Aaron N · Anchorage, AKS/N 12091 N1849VCooke Patrick E · Wrightsville, PABuilt 1947 · S/N 14114 N1851VKraemer Norma J · Deadwood, SDBuilt 1947 · S/N 14119 N1853NProst Gary E · Stockton, CAS/N 12097 N1853VMid Michigan Aviation LLC · Owosso, MIBuilt 1947 · S/N 14125 N1858NWeeks Addison W · Covina, CABuilt 1946 · S/N 12102 N1866NSpivey Darwyn D · Guntersville, ALS/N 12110 N1867NPasqualino Mark W · Ocala, FLBuilt 1946 · S/N 12111 N1873NBarbee Max C · Wharton, TXBuilt 1946 · S/N 12117 N1874NCuddie Robert R · Marble Falls, TXBuilt 1946 · S/N 12118 N1877NAscolese Michael J · Athol, MABuilt 1946 · S/N 12121 N1883NStrand Stephen E · Pelican Rapids, MNBuilt 1946 · S/N 12127 N1888NMorton William J · Hurst, TXBuilt 1947 · S/N 12132 N1890NVasquez Allison O · San Antonio, TXS/N 12134 N1891NMcmaster James R II · Bath, PABuilt 1947 · S/N 12135 N1894NWarren C Metzger II · Anchorage, AKBuilt 1947 · S/N 12138 N1897NNasw Foundation · Rio Grande, NJBuilt 1947 · S/N 12141 N1901NHowerton Bradley S · Bartlesville, OKBuilt 1947 · S/N 12145 N1906NBourland Alton L · Santa Teresa, NMBuilt 1947 · S/N 12150 N1909NSanders David L · Powell, WYBuilt 1947 · S/N 12153 N1917NLozano Brian · Santa Rosa, CAS/N 12161 N1928NNikkila John C · Surprise, AZBuilt 1947 · S/N 12172 N1935NAscolese Michael J · Athol, MABuilt 1947 · S/N 12175 N1944NNentwick James L Jr · East Liverpool, OHS/N 12184 N1945NCochran Clifford D · Soldotna, AKBuilt 1947 · S/N 12185 N1947VKlenske Joshua Mark · Yucaipa, CAS/N 14239 N1947ZPanzer Jessica DBA · Lincoln, NEBuilt 1947 · S/N 13718 N1951VLinero Jose J · San Juan, PRBuilt 1947 · S/N 14162 N1952VHaraway David D · Tulsa, OKBuilt 1947 · S/N 14163 N1958VHeath Byron R · Scottsdale, AZBuilt 1947 · S/N 14169 N1960VKrasemann Keith W · Chicago, ILBuilt 1947 · S/N 14171 N1972VAbsolute Ceiling Leasing LLC · Stafford, VABuilt 1947 · S/N 14183 N1974VBocek James C · Sheridan, WYBuilt 1947 · S/N 14240 N1979VNixon Andrew S · Davison, MIBuilt 1947 · S/N 14190 N1985VMiller William H Jr · Blue Mound, ILBuilt 1947 · S/N 13994 N1988VMosher Dustin T · Tehachapi, CABuilt 1947 · S/N 14199 N1989VHotchkin Derek J · Atlantic, IAS/N 14200 N1995VKent Thurmon Jr · Millen, GABuilt 1947 · S/N 14206 N1997NNewell John G · Oklahoma City, OKBuilt 1947 · S/N 12233 N2008VRossiter David A · Sioux Falls, SDBuilt 1947 · S/N 14219 N2014VQuinn Timothy L · Tujunga, CABuilt 1947 · S/N 14289 N2016VJenkins Robert W · Fredericktown, OHBuilt 1947 · S/N 14307 N2026NTre Aviation Corp · Wilmington, DEBuilt 1947 · S/N 12262 N20285Hanson Jonathan G · Nome, AKS/N 12897

Back to Cessna 120