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.

N2036NSheehan Dennis P · Addison, ILFirst renewal noticeS/N 12272 N2039NFremont Aviation Inc · Fremont, NEBuilt 1947 · S/N 12275 N2042NRoy David J · Clinton, NYS/N 12278 N2050VAnderson Gordon · Chippewa Falls, WIBuilt 1947 · S/N 14263 N2052NCovington Stephen R · Longview, TXBuilt 1947 · S/N 12288 N2053NKellner Michael · Marengo, ILS/N 12289 N2053VShores Toby L · Newcastle, OKBuilt 1947 · S/N 14266 N2055NPeute Stephen H · Flagler Beach, FLS/N 12291 N2059NDance Bruce B · Carthage, MOS/N 12295 N2061NSale Reported · Stafford, VASale reportedBuilt 1947 · S/N 12297 N2063NMcghee Christopher G · Jay, MEBuilt 1947 · S/N 12299 N2065VChipman Richard M · Capitola, CABuilt 1947 · S/N 14278 N2068NFranks Brian C · Wilton, CABuilt 1947 · S/N 12304 N2070NVekovius Zachery J · Armour, SDBuilt 1947 · S/N 12306 N2073NWinn Jonathan · Wichita Falls, TXBuilt 1947 · S/N 12309 N2081NJerome Jeffrey A · Conneaut Lake, PAS/N 12317 N2082NHoppe Farms Inc · Crookston, MNBuilt 1947 · S/N 12318 N20846Mcclelland James H III · Grove City, PABuilt 1947 · S/N 13468 N2084NMorgan Nick A · Chapel Hill, NCBuilt 1947 · S/N 12320 N2084VButler Richard S · Poplar Grove, ILBuilt 1947 · S/N 14300 N2087VTundra Aviation Inc · Casselton, NDS/N 14317 N2088NWeeks Thomas R · San Diego, CABuilt 1947 · S/N 12324 N2092NSkywagons.Com LLC · Placerville, CABuilt 1947 · S/N 12328 N2092VDavis Bryan C · Winfield, KSBuilt 1947 · S/N 14304 N2093NFevig Gordon O · Ulen, MNBuilt 1947 · S/N 12329 N2094NO'Neill Mark B · Pinckney, MIBuilt 1947 · S/N 12330 N2096NRegistered aircraftS/N 12332 N2096VTetterton Greyson L · Pantego, NCS/N 14306 N209ALawson Dustin M · Three Rivers, MIBuilt 1948 · S/N 14662 N2100NCrane Douglas Gordon · Coquille, ORBuilt 1947 · S/N 12336 N2102NWilliams Reddoch E · Fort Walton Beach, FLS/N 12338 N2111NLongacre John David · Anchorage, AKS/N 12347 N2113NSmith Leo D · Carpenter, WYBuilt 1947 · S/N 12349 N2115NPeterson David W · Poplar Grove, ILBuilt 1947 · S/N 12351 N2120NGalegor Samuel T · Pleasant Hill, MOBuilt 1947 · S/N 12356 N2121NGoran Daniel F · Owasso, OKBuilt 1947 · S/N 12357 N2126NSale Reported · El Mirage, AZSale reportedBuilt 1947 · S/N 12362 N2128NAug Richard J · Glenns Ferry, IDFirst renewal noticeBuilt 1947 · S/N 12364 N2130NBennett David · Apex, NCBuilt 1947 · S/N 12366 N2133NRobles Leejay J · Lake Oswego, ORBuilt 1947 · S/N 12369 N2135NIllogical Aeronautics LLC · Shady Cove, ORS/N 12371 N2141VWiese John C Jr · Palmer, AKS/N 14368 N2143NSuter John R · Jacksonville, NCS/N 12379 N2143VFrederick Albert M · Moultonborough, NHBuilt 1948 · S/N 14370 N2146VLyles Jody A · Lake Arthur, NMS/N 14373 N2147VVanlierop Keith R · Vevay, INBuilt 1948 · S/N 14374 N2149VQuirk Charles L · Lake Charles, LABuilt 1948 · S/N 14378 N2150NMellott Christopher · Tempe, AZBuilt 1947 · S/N 12386 N2150VSmith Dudley E · Arlington, TXBuilt 1948 · S/N 14379 N2151NVoorhis Paul E · Palmer, AKBuilt 1947 · S/N 12387

Back to Cessna 140