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.

N76112Fanslau Nathaniel R · Williamstown, NJBuilt 1946 · S/N 10509 N76114Tundra Aviation Inc · Casselton, NDBuilt 1946 · S/N 10511 N76120Sale Reported · Kalispell, MTSale reportedBuilt 1946 · S/N 10517 N76122Norbury Investments LLC · Boonville, MOBuilt 1946 · S/N 10519 N76123Creative Strategies Inc · Lucasville, OHBuilt 1946 · S/N 10520 N76128Ferguson Donald R · Billings, MTBuilt 1946 · S/N 10525 N76132Simonis Tadas · Toms River, NJBuilt 1946 · S/N 10529 N76136Brown Michael E · Anchorage, AKBuilt 1946 · S/N 10533 N76140Fun With Physics LLC · Ocala, FLBuilt 1947 · S/N 13265 N76146Larmon Larry · Valparaiso, INBuilt 1946 · S/N 10543 N76148Chase 13 LLC · Wilmington, DES/N 10545 N76154Bayou Flight LLC · Parker, COBuilt 1946 · S/N 10551 N76155Beaver Valley Aircraft Maintenance LLC · New Carlisle, OHBuilt 1946 · S/N 10552 N76163Loncarevic Andrew M · Blue Ridge, GABuilt 1946 · S/N 10560 N76171Delta Ridge Farms LLC · Oak Grove, LAS/N 10568 N76174Hinshaw Eric Carl · Lake Wales, FLBuilt 1946 · S/N 10571 N76179Grismer Jeff Trustee · Hemet, CABuilt 1946 · S/N 10576 N76180Moehn Dennis H · Oshkosh, WIBuilt 1946 · S/N 10577 N76186Wells Kris G · Barron, WIBuilt 1946 · S/N 10583 N76190Thomson Bruce M · Albuquerque, NMBuilt 1946 · S/N 10587 N76206Registered aircraftBuilt 1946 · S/N 10609 N76208Robinson Michael F · Granbury, TXBuilt 1946 · S/N 10611 N76209Beard Garrett T · Pelahatchie, MSBuilt 1946 · S/N 10612 N76212Marburg Loren C · Indianapolis, INBuilt 1946 · S/N 10615 N76213Lucy Donald E · Newbury Park, CABuilt 1946 · S/N 10616 N76218Hall Charles M · Lubbock, TXBuilt 1946 · S/N 10621 N76220Thomas Erik P · Little Compton, RIBuilt 1955 · S/N 10623 N76225Lonza Frank R · Crescent City, FLBuilt 1954 · S/N 10628 N76232Mischock Andrew J · Waukesha, WIS/N 10635 N76234Sprockett Jill L · Punta Gorda, FLBuilt 1946 · S/N 10637 N76240Stick And Rudder Aero LLC · Millwood, WABuilt 1946 · S/N 10643 N76244Elliott Russell P · Greencastle, INBuilt 1946 · S/N 10649 N76256Groeneveld John · Maryland Heights, MOBuilt 1946 · S/N 10661 N76258Lee Li · West Covina, CAS/N 10663 N76267Reece Andy · Marysville, WAS/N 10675 N76275King Adam J · Kalamazoo, MIBuilt 1946 · S/N 10683 N76277Hauser Linda L · Ulysses, KSBuilt 1946 · S/N 10685 N76286Baggot John P · Shiocton, WIS/N 10700 N76289Barrett Michael S · Bigfork, MTBuilt 1946 · S/N 10703 N76290Witt Autry A · Fort Worth, TXBuilt 1946 · S/N 10704 N76291Sheban George J · Dallas, TXBuilt 1946 · S/N 10705 N76293Koester David P · Newport, ORBuilt 1946 · S/N 10707 N76295Bassett Joseph T · Lovell, WYBuilt 1946 · S/N 10709 N76303Lewis Nicholas · Stony Creek, VABuilt 1946 · S/N 10717 N76310Poe David W · Crystal Lake, ILBuilt 1946 · S/N 10724 N76314Downey Gerard P · Boise, IDBuilt 1946 · S/N 10728 N76326Reiner William P · Anchorage, AKBuilt 1946 · S/N 10740 N76336Bostani Majo · Philadelphia, PABuilt 1946 · S/N 10753 N76340Monce Michael S · Granite City, ILBuilt 1946 · S/N 10757 N76344Jeffers Kyle A · New Carlisle, OHBuilt 1946 · S/N 10761

Back to Cessna 140