Skip to content

Registered aircraft · 234

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 ('2071604')
  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 ('2071604')
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.

N10534Shergi Nikolai W · Franklin, INS/N 15697 N1103DOber John A · Candor, NYBuilt 1950 · S/N 15663 N1104DRymill Mark R · Belmont, CABuilt 1950 · S/N 15664 N1105DGilman Larry E · Reno, NVBuilt 1950 · S/N 15665 N1106DMurdock Mark F · Ketchikan, AKBuilt 1950 · S/N 15666 N1108DReddout Terry L Trustee · Wichita, KSS/N 15668 N1109DMcqueen Alan G · Cocoa, FLBuilt 1950 · S/N 15669 N1112DMurray Russell J · Fresno, CAS/N 15676 N1116DOxman Warren L · Rhome, TXS/N 15680 N1119DChumble Ameya A · Duluth, MNBuilt 1951 · S/N 15683 N1121DVancuren Mary Ann · Owasso, OKBuilt 1950 · S/N 15685 N1122DBeech O Sphere LLC · Casper, WYS/N 15686 N1125DStarr Eric M · Queen Creek, AZBuilt 1951 · S/N 15689 N1126DHynds Michelle S · Addison, TXBuilt 1951 · S/N 15675 N1129DKogl John L · Valparaiso, INBuilt 1951 · S/N 15692 N1133DBohl Howard M · Temecula, CABuilt 1951 · S/N 15696 N1135DRodriguez Daniel Royo · Hagerstown, MDBuilt 1951 · S/N 15698 N1136DWatson Frank H · Central Point, ORBuilt 1951 · S/N 15699 N1139DOborny Alan R · Choteau, MTBuilt 1951 · S/N 15702 N1141DKilo Mushroom Aeronautics Inc · Renton, WABuilt 1951 · S/N 15704 N1142DSale Reported · Fayetteville, WVSale reportedBuilt 1951 · S/N 15705 N1143DSwanland Robert C · San Jose, CABuilt 1951 · S/N 15706 N1148DBohl Howard M · Temecula, CABuilt 1951 · S/N 15711 N1150DFlight Time Pathways · Forest Lake, MNBuilt 1951 · S/N 15713 N1151DWelborn Mark G · Boonville, NCBuilt 1951 · S/N 15714 N1153DCarbonaro Joseph J Jr · Lexington Park, MDBuilt 1951 · S/N 15716 N1161DJefferies Stanley J · Coos Bay, ORS/N 15724 N13BBGoodwin William W · Pleasureville, KYBuilt 1949 · S/N 15234 N140ABWiliams Steve C · Elgin, SCS/N 15703 N140CFBowser Brett A · Murfreesboro, TNBuilt 1949 · S/N 15369 N140LAAllen Lynn A II · Waxahachie, TXBuilt 1949 · S/N 15338 N140LMLambson Roger S · Saint Ignatius, MTBuilt 1950 · S/N 15588 N140MQWasem John S · Nome, AKS/N 15505 N140NTFlight International Inc Trustee · Dover, DES/N 15396 N140PDCoulouris George L · Washington, DCBuilt 1950 · S/N 15414 N191EBitikofer Brent E · Kansas City, KSBuilt 1950 · S/N 15564 N1949AReneau Tom · Midland, TXBuilt 1949 · S/N 15240 N1950ABuchanan Noreen E · Meridian, IDS/N 15637 N2384NHirzel William J · Walbridge, OHBuilt 1947 · S/N 12633 N251CMetsger Cecil P · Haughton, LABuilt 1951 · S/N 15707 N28355Hayton James B · Sedro Woolley, WABuilt 1950 · S/N 15579 N2837DZielinski John · Queen Creek, AZBuilt 1949 · S/N 15346 N299TDBrueggen Erin J · Cashton, WIBuilt 1950 · S/N 15596 N3779V212 Investments Of Montana LLC · Owasso, OKBuilt 1949 · S/N 15200 N3781VHammitt Thomas K · Walnut Creek, CABuilt 1949 · S/N 15202 N3782VRevlett Austin W · Sacramento, KYBuilt 1949 · S/N 15203 N3788VGraves Kenneth D · La Crosse, WIBuilt 1949 · S/N 15209 N3791VTapia Samuel R · Barstow, CAS/N 15212 N3792VBrown David L · Boyertown, PABuilt 1949 · S/N 15213 N3794VGuynn James H · Arlington, VABuilt 1949 · S/N 15215

Back to Cessna 140A