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.

N5394CWillie Gary D · Elkader, IABuilt 1950 · S/N 15527 N5396CSmith Richard E · Olympia, WABuilt 1950 · S/N 15529 N5397CFontana Andrew W · Lake City, MIBuilt 1950 · S/N 15530 N5398CRed Rose Flying Club · Spring City, TNBuilt 1950 · S/N 15531 N5399CPoling Micah D · Gaston, ORS/N 15532 N55PLTyriver Katherine R · Orlando, FLBuilt 1958 · S/N 15528 N5603CBoulette Harris · School Craft, MIBuilt 1950 · S/N 15536 N5606CCollins Florence D Miki · Lake Minchumina, AKFirst renewal noticeBuilt 1950 · S/N 15539 N5608CGustafson Kurt E · Winchester, VABuilt 1950 · S/N 15541 N5613CHolliday Mark E · Lake Elmo, MNBuilt 1950 · S/N 15546 N5618CParis Doug A · Ventura, CAS/N 15551 N5619CDunaire LLC · Mechanicsburg, PAS/N 15622 N5621CDawkins Terry · Defuniak Springs, FLBuilt 1950 · S/N 15554 N5622CBoyett Aviation LLC · Cumby, TXS/N 15555 N5628CEllis George T · Mt Chase, MEBuilt 1950 · S/N 15608 N5629CSchultz Philip W · Lancaster, CABuilt 1950 · S/N 15582 N5630CMallamo John · Shell Knob, MOBuilt 1950 · S/N 15583 N5633CWinkler William P · Granbury, TXBuilt 1950 · S/N 15586 N5639CSpruill William F · Wyoming, DES/N 15592 N5644CRegistered aircraftBuilt 1950 · S/N 15598 N5646CBivens Jason D · Duncan, OKBuilt 1950 · S/N 15600 N5649CRon Alexander Youth Aviation Program · Williamson, GABuilt 1950 · S/N 15603 N5650CMorris Kenneth E · Poplar Grove, ILBuilt 1950 · S/N 15604 N5654CGelardo Matthew L · Cardiff By The Sea, CAS/N 15610 N5656CScully Michael J · San Carlos, CAS/N 15612 N5665CWilson Thomas S · Fallbrook, CABuilt 1950 · S/N 15621 N5667CClassic Aviation Inc · Pella, IABuilt 1950 · S/N 15623 N5668CMatthews Victor M · Comstock Park, MIBuilt 1950 · S/N 15624 N5669CMorris Kenneth E · Poplar Grove, ILBuilt 1950 · S/N 15625 N5671CBredin William B · Anchorage, AKS/N 15627 N5673CBuzbee Nancy C · Mineral Wells, TXS/N 15629 N5676CStearman John T · Collinsville, OKBuilt 1950 · S/N 15632 N5683CBaker Mark A · Orangeville, ILBuilt 1952 · S/N 15639 N5691CDalton Bart · Owasso, OKBuilt 1950 · S/N 15647 N5693CBarnes Sammy Dean · Taylorsville, NCBuilt 1950 · S/N 15653 N5694CWilliams Miriam Evans · Fort Walton Beach, FLS/N 15654 N570HBBohl Howard M · Temecula, CAS/N 15384 N62299Blanton Robin Anthony · Vero Beach, FLBuilt 1950 · S/N 15638 N7818BRitenour John C · Knoxville, TNS/N 15617 N80HHoward Roland Dean · San Antonio, TXS/N 15387 N81HRonnau Thomas F · Kansas City, KSBuilt 1950 · S/N 15602 N88WTFlying L Aircraft Inc · Fort Denaud, FLBuilt 1950 · S/N 15438 N9401ASwinney Vincent F · Waldport, ORS/N 15222 N9403AJ & K Flying LLC · Marengo, OHS/N 15224 N9404AMorrison Mark C · Marfa, TXBuilt 1949 · S/N 15225 N9405ACronin John W Jr · Denver, COBuilt 1949 · S/N 15226 N9406AStowell Colt M · Homedale, IDBuilt 1949 · S/N 15227 N9408ADill Steven S · Hesperia, CAS/N 15229 N9410AAllen Dennis R · San Mateo, CABuilt 1949 · S/N 15231 N9411ARenkenberger James H · Saint Joe, INBuilt 1949 · S/N 15232

Back to Cessna 140A