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.

N3795VThomson James W · Narragansett, RIS/N 15216 N3796VMace Wade L · Ottawa, KSBuilt 1949 · S/N 15217 N3799VStogsdill Daniel · Sahuarita, AZS/N 15220 N4242HWebb Greg · Sweetwater, TNBuilt 1949 · S/N 15304 N427LPPeasley Lisa M · Lakeville, MNBuilt 1950 · S/N 15584 N456RWWenman Bradford H · Johnson, KSBuilt 1950 · S/N 15550 N462ADelta Ridge Farms LLC · Oak Grove, LAS/N 15283 N49WMGraupman Gerald A · Chicago, ILBuilt 1949 · S/N 15263 N517WPenell Mark A · Palmetto, FLBuilt 1949 · S/N 15255 N5300CBerg Robert M · Culver, ORBuilt 1950 · S/N 15420 N5302CMiller Roy A · Maquoketa, IAS/N 15422 N5303FSpaulding Kevin P · Mc Bain, MIBuilt 1950 · S/N 15423 N5305CRegistered aircraftBuilt 1950 · S/N 15425 N5311CBudde Bobby M Jr · San Jose, CABuilt 1950 · S/N 15431 N5312CLemanski Joseph S · Grosse Ile, MIBuilt 1950 · S/N 15432 N5313CSlater John · Saint Charles, ILBuilt 1950 · S/N 15433 N5317CLiverett Herb · Rio Linda, CABuilt 1950 · S/N 15437 N5319CDupont Pierre B · Menominee, MIBuilt 1950 · S/N 15439 N5323CManley Eugene M II · Raleigh, NCBuilt 1950 · S/N 15443 N5328CLewis George F Jr · Hampton, CTBuilt 1950 · S/N 15448 N5329CVetterli Gary R · Monroe, WIBuilt 1950 · S/N 15449 N5332CReed Ralph R · San Marcos, CABuilt 1950 · S/N 15452 N5333CWinkler Aircraft Leasing Inc · Brush, COBuilt 1950 · S/N 15453 N5334CSnyder Kenneth C · Lonsdale, MNBuilt 1950 · S/N 15563 N5340CCustis James G · Friday Harbor, WABuilt 1950 · S/N 15460 N5342CPig Aero LLC · Aurora, ILBuilt 1950 · S/N 15565 N5350CJones Terry M · Bells, TNBuilt 1950 · S/N 15573 N5351CLc Aviation Consulting LLC · Montauk, NYBuilt 1950 · S/N 15482 N5352CBohl Howard M · Temecula, CABuilt 1950 · S/N 15483 N5353CStill Martin L · Upper Sandusky, OHBuilt 1950 · S/N 15484 N5355CRothstein Steven R · Punta Gorda, FLBuilt 1950 · S/N 15486 N5356C56 Charlie LLC · Bloomington, INBuilt 1950 · S/N 15487 N5360CJpm Flying Service LLC · Coleman, TXS/N 15491 N5363CAffiliated Equipment Leasing LLC · New Castle, DEBuilt 1950 · S/N 15494 N5364CFischer James E · Lakeville, MNBuilt 1950 · S/N 15495 N5365CKlotz Terrance M · Sparks, NVBuilt 1952 · S/N 15575 N5367CAv8rs LLC · Gig Harbor, WABuilt 1950 · S/N 15498 N5369CLowe David · Sacramento, KYS/N 15502 N5373CJoy Solutions LLC · Wilmington, DES/N 15576 N5374CPaulson Chris M · Eatonville, WABuilt 1950 · S/N 15507 N5376CDynamic Aerospace Inc · Framingham, MABuilt 1950 · S/N 15509 N5380CCoggins Josh · Bonney Lake, WABuilt 1950 · S/N 15513 N5381CBergman James H · Buckley, WABuilt 1950 · S/N 15514 N5383CJenkins David A · Gainesville, FLS/N 15516 N5384CPrice Edsel B · Leesville, SCBuilt 1950 · S/N 15517 N5387CGoral William W · Redlands, CABuilt 1950 · S/N 15520 N5389CRegistration Pending · Niagara, WIRegistration pendingS/N 15522 N5390CGoebel Kendra S · Sarasota, FLBuilt 1950 · S/N 15523 N5392CMcclintock Jesse H · Camarillo, CABuilt 1950 · S/N 15525 N5393CPlane Fun Inc Tr Trustee · Snellville, GABuilt 1950 · S/N 15526

Back to Cessna 140A