Skip to content

Registered aircraft · 1,605

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 ('2071602', '2071603')
  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 ('2071602', '2071603')
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.

N1895VMontgomery Larry G · Seymour, INFirst renewal noticeBuilt 1947 · S/N 14085 N1903VCovelli Rene A · Cherry Hill, NJBuilt 1947 · S/N 14094 N1907VChristopher Russell L · Leona Valley, CABuilt 1947 · S/N 14099 N1910VBommarito Sterling J · Bend, ORS/N 14103 N1912VWatson Bryan · Kent, WABuilt 1947 · S/N 14105 N1916VSuter William A · Bluffton, OHBuilt 1947 · S/N 14110 N1917VJustice Thomas J · Wilmington, NCBuilt 1947 · S/N 14111 N1920VTruluck Charles Harry III · North Fort Myers, FLBuilt 1947 · S/N 14116 N1925VNewell Robert J Jr · Belleville, MIBuilt 1947 · S/N 14123 N1926VVeenstra Timothy S · Wasilla, AKBuilt 1947 · S/N 14124 N1927VBoydston Terry · Whitewater, WIBuilt 1947 · S/N 14127 N1928VSchubert Christopher P · Canandaigua, NYBuilt 1947 · S/N 14128 N1938VBarnett Jeffrey S · Clayton, INBuilt 1947 · S/N 14142 N1939VWheadon William J · Napa, CABuilt 1947 · S/N 14145 N1940VGregg Delvin K · Durango, COS/N 14146 N1945VKellar John C · Runaway Bay, TXBuilt 1947 · S/N 14153 N1948VBryant Mark A · Bennett, COBuilt 1947 · S/N 14159 N1949VCrook Stacy Y · Anchorage, AKBuilt 1947 · S/N 14160 N1955NRollins Brian D · Smithville, MSS/N 12191 N1956N1812j Blue LLC · Akron, OHBuilt 1947 · S/N 12192 N1961NMarshall Charles · Fair Grove, MOBuilt 1947 · S/N 12197 N1962NPowell Kenneth W · Ann Arbor, MIBuilt 1947 · S/N 12198 N1962VMorris Gray S · Chugiak, AKBuilt 1947 · S/N 14173 N1965NWixon Charles · Milton, WIS/N 12201 N1969VSabala Michal · San Jose, CABuilt 1947 · S/N 14180 N1976VWilliams Thomas E · Philip, SDBuilt 1947 · S/N 14187 N1977NKeith Kaston H · El Paso, ILBuilt 1947 · S/N 12213 N1984NStuart Steven A · Lititz, PABuilt 1947 · S/N 12220 N1988NMckinney Derrill L · Rio Linda, CABuilt 1947 · S/N 12224 N1989NAeschliman Arlie W · Tribune, KSBuilt 1947 · S/N 12225 N1991VMussman Craig · Grant Park, ILBuilt 1947 · S/N 14202 N1995NAlabama Aircraft Management LLC · Valley Head, ALBuilt 1947 · S/N 12231 N1998NHarris Bill J · Evergreen, COS/N 12234 N1999VWeinreich Mark W · River Falls, WIBuilt 1947 · S/N 14210 N2002NPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N 12238 N2004NKershaw Gloria D · East Tawas, MIBuilt 1947 · S/N 12240 N2005NMoore Michael T · Liberty Lake, WABuilt 1947 · S/N 12241 N2006NBreeding Jarrard L · Sharpsburg, GABuilt 1947 · S/N 12242 N2010NMccoy Michael David · Mentor, OHBuilt 1947 · S/N 12246 N2011NSutton Jesse K · Hutchinson, KSBuilt 1947 · S/N 12247 N2012VClare Ross W · Sodus, MIBuilt 1947 · S/N 14288 N2018NNixon David W · Portland, ORBuilt 1947 · S/N 12254 N201KWalker Patrick R · Germantown, MDBuilt 1946 · S/N 9397 N2020NHair Cory A · Collinsville, OKBuilt 1947 · S/N 12256 N2020VHunter Hallock · Waynesville, NCS/N 14292 N2024NCrow Edward N · Silverdale, WABuilt 1947 · S/N 12260 N2026VSzura Jeffrey S · Peoria, AZBuilt 1947 · S/N 14297 N2029VSttm Texas LLC · Spring Branch, TXBuilt 1947 · S/N 14242 N2030VGleiter Jerilee A · Grants Pass, ORBuilt 1947 · S/N 14243 N2035VReall George D · Castle Rock, COBuilt 1947 · S/N 14248

Back to Cessna 140