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.

N89156Bornheber Ralf · Novi Marof-DraskovS/N 8168 N89157Lombardi Jack D · Bronx, NYBuilt 1946 · S/N 8169 N89168Hendrix Walter A · Monroe, GABuilt 1946 · S/N 8182 N89170Mowery Charles C · Tioga, WVBuilt 1946 · S/N 8184 N89171Kruzdlo Alan · Calhoun, GABuilt 1946 · S/N 8185 N89173Cooper Matthew · Fairbanks, AKBuilt 1946 · S/N 8187 N89189Barchik Edward C · Huntington Mills, PABuilt 1946 · S/N 8203 N89191Simmons Steven E · Kinston, ALBuilt 1946 · S/N 8205 N89194Haley Lee · Ahwahnee, CABuilt 1946 · S/N 8208 N89198Riggin Flight Service Inc · Madison, SDBuilt 1946 · S/N 8218 N89200Nostalgair Sky Adventures Inc · Vero Beach, FLBuilt 1946 · S/N 8220 N89201Hangar Ak LLC · Sterling, AKS/N 8221 N89202Kinney James R · Vermillion, SDBuilt 1946 · S/N 8222 N89205Neal Kyle · Midlothian, TXBuilt 1946 · S/N 8225 N89209Vander Veen William A · Dyer, INBuilt 1946 · S/N 8229 N89211Capece Richard N · Leonardtown, MDBuilt 1946 · S/N 8231 N89213Iler Elden · Van Nuys, CAS/N 8233 N89217Reddeck Thomas J III · Gold Hill, NCBuilt 1946 · S/N 8237 N89221Smith Fane S · Newport Beach, CABuilt 1946 · S/N 8241 N89222Johnson Lucas · Pleasant Lake, MIBuilt 1946 · S/N 8242 N89227Koontz Rodney A · Lexington, NCBuilt 1946 · S/N 8247 N89233Sale Reported · Homer, AKSale reportedBuilt 1946 · S/N 8253 N89235Meuse Cade · Dallas, TXBuilt 1946 · S/N 8255 N89241Jackson Barry P · Paragould, ARBuilt 1946 · S/N 8261 N89244Daman Vickie L · Kasilof, AKBuilt 1946 · S/N 8264 N89249Halloran Donal Warren · Marshfield, WIBuilt 1946 · S/N 8269 N89250Lamb Colter L · Portales, NMBuilt 1946 · S/N 8270 N89252Warren Joy A · White Lake, MIBuilt 1946 · S/N 8272 N89256Liby Darren L · Hutchinson, KSBuilt 1946 · S/N 8280 N89257Mix Timothy R · Hubbard, ORS/N 8281 N89262Gosshawk Unlimited Inc · Casa Grande, AZBuilt 1946 · S/N 8286 N89264Clydes Best LLC · Willow Springs, ILBuilt 1946 · S/N 8288 N89265Snyder Glenn N · Richardson, TXBuilt 1946 · S/N 8289 N89270Hamer Marinus P · Livonia, NYBuilt 1946 · S/N 8294 N89274Doran Jeffrey T · Westerville, OHBuilt 1946 · S/N 8300 N89276Wikstrom Keith A · Fort Ripley, MNS/N 8302 N89278Weaver Samuel D · Upper Sandusky, OHS/N 8304 N89284Wheaton Eric J · Gig Harbor, WABuilt 1946 · S/N 8310 N89290Faulkner Jeannine P · Bethel, AKBuilt 1946 · S/N 8316 N89292Durham Allen W · Shallowater, TXBuilt 1946 · S/N 8318 N89293Port Townsend Aero Museum · Port Townsend, WABuilt 1946 · S/N 8319 N89295Turner Robert Lamar · Baxley, GABuilt 1946 · S/N 8321 N89297Just Plane Flying LLC · Fort Collins, COS/N 8323 N89303Barry Raymond C · Commerce Twp, MIBuilt 1946 · S/N 8331 N89306Windsock Capital LLC · Bertram, TXBuilt 1946 · S/N 8334 N89307Evan Earl J · Oglethorpe, GABuilt 1946 · S/N 8335 N89309Bolton Derwin B · Jacksonville, TXS/N 8337 N89316Swenson Leslie L · Evansville, WIBuilt 1946 · S/N 8344 N89320Qualitair LLC · MichelstadtS/N 8348 N89322Hamilton Donis B · Paragould, ARBuilt 1946 · S/N 8350

Back to Cessna 140