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.

N9412AKrause Victor A · Geneva, ILBuilt 1949 · S/N 15233 N9415AMiller Gerald R · Sevierville, TNFirst renewal noticeBuilt 1949 · S/N 15236 N9418ARamsey Matthew A · Hermosa, SDBuilt 1949 · S/N 15239 N9421AWillie Brett A · Decorah, IABuilt 1949 · S/N 15242 N9423ADyer Shane E · White Hills, AZBuilt 1949 · S/N 15244 N9425AZimmerman Scott Andrew · Palmdale, CABuilt 1949 · S/N 15246 N9428AHoyt Richard A · Webster Groves, MOBuilt 1949 · S/N 15249 N9429ARegistration Pending · Chicago, ILRegistration pendingBuilt 1950 · S/N 15461 N9430AWalker Neiman J · Denton, TXBuilt 1949 · S/N 15251 N9431ADelta Ridge Farms LLC · Oak Grove, LABuilt 1949 · S/N 15252 N9433ABohl Howard M · Temecula, CABuilt 1949 · S/N 15254 N9435ARoberts Ralph Russell · Seaman, OHBuilt 1949 · S/N 15256 N9436APyeatt David W · Palm Beach Gardens, FLBuilt 1950 · S/N 15462 N9438ACorder Charles W · Fairfield, OHBuilt 1949 · S/N 15259 N9439AFullerton Paul S · Saint Ignace, MIBuilt 1949 · S/N 15260 N9441AKing Beth A · Louisville, KYBuilt 1949 · S/N 15262 N9445AAlsup Alan D · Gainesville, TXBuilt 1949 · S/N 15266 N9448AOlson Ben A · Gig Harbor, WABuilt 1949 · S/N 15269 N9449ASiglin Sybil Joann · Pleasanton, CABuilt 1949 · S/N 15270 N9451APiantanida Raymond G · Florahome, FLBuilt 1953 · S/N 15463 N9454AZembinski Robert A · Brookfield, WIBuilt 1949 · S/N 15275 N9455AMartin Michael A · Hampshire, ILBuilt 1950 · S/N 15557 N9465AMorris Mark A · Westlake, TXBuilt 1949 · S/N 15286 N9466AThomas Lynnet M · Stevensville, MTBuilt 1949 · S/N 15287 N9467AKourtis Vintage Aviation LLC · Owasso, OKBuilt 1950 · S/N 15469 N9469ABohl Howard M · Temecula, CABuilt 1949 · S/N 15290 N9471ABlock Elliot M · Encinitas, CAS/N 15292 N9476AFoust Kal E · Lenox, MIBuilt 1950 · S/N 15471 N9477ATriesenberg Stephanie · Grand Rapids, MIBuilt 1949 · S/N 15298 N9481AScholl Jonathan W · Mckinney, TXBuilt 1949 · S/N 15302 N9484ABrown Glen S · Aberdeen, MSBuilt 1949 · S/N 15305 N9485ABeam David M · Sabina, OHBuilt 1949 · S/N 15306 N9486ASimonson David C · Iron River, WIS/N 15558 N9487AMccown Bill · Dripping Springs, TXBuilt 1949 · S/N 15308 N9488ARadke Harlow · Hastings, MNBuilt 1949 · S/N 15309 N9489ASmith Paul H · Byron, GAS/N 15310 N9491AWonder Aviation LLC · Nashville, TNBuilt 1950 · S/N 15559 N9493ABrooks Charles W Jr · Hesperia, CABuilt 1949 · S/N 15314 N9494ASmiley Neil G · Clover, VABuilt 1950 · S/N 15475 N9496APrice Robert M · Seattle, WAS/N 15317 N9498AEvans Earl J · Oglethorpe, GABuilt 1949 · S/N 15319 N9499AGourdin Gordon O · Sheridan, ORS/N 15320 N95LHubbert Stephen A · Newcastle, OKS/N 15383 N9600ABooth Donald V · Denison, TXBuilt 1949 · S/N 15321 N9602AGutkowski Robert L · Arlington, TXBuilt 1949 · S/N 15323 N9605ADavis Rickard J · Los Lunas, NMBuilt 1949 · S/N 15326 N9607AAdams Teresa M Trustee · Granbury, TXBuilt 1949 · S/N 15328 N9610AJackson William P · Littlerock, CAS/N 15331 N9612AKm Aero Inc · Kalispell, MTBuilt 1949 · S/N 15333 N9615ADay Michael J · Fort Wayne, INBuilt 1949 · S/N 15336

Back to Cessna 140A