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.

N89323Oliphant Mitchell Scott · Lakin, KSBuilt 1946 · S/N 8351 N89328Schlotte Randy V · River Falls, WIBuilt 1946 · S/N 8356 N89334Overson Christopher J · La Mesa, CABuilt 1946 · S/N 8362 N89338Macdowell John E · Kent, WABuilt 1946 · S/N 8366 N89341Weierbach Ryan P · Stuart, FLBuilt 1946 · S/N 8369 N89343Grosdidier Brent J · Eudora, KSBuilt 1946 · S/N 8371 N89344Mehrhoff Stanley · Prairie Home, MOS/N 8372 N89347Shinn Norman J · Ashland, ORBuilt 1946 · S/N 8375 N89348Schreiner David J · San Antonio, TXS/N 8376 N89351Beebe Michael W · Rangeley, MES/N 8379 N89352Ritter Tamara G · Bethel, PABuilt 1946 · S/N 8380 N89360Schiller Gottfried · Howell, MIBuilt 1946 · S/N 8392 N89368Staples Norman J · Sussex, WIBuilt 1946 · S/N 8400 N89378Blais Kevin · West Burke, VTBuilt 1946 · S/N 8410 N89380Naples Guy M · Delaware, OHBuilt 1946 · S/N 8412 N89384Gast Eldon B · Garner, IABuilt 1946 · S/N 8416 N89385Mills Marc S · Huntley, ILBuilt 1946 · S/N 8417 N89389Wright Michael · Houston, PAS/N 8421 N89392Story John D · Harrah, OKBuilt 1946 · S/N 8424 N89395Scher Eric J · Marion, INS/N 8427 N89398Pyziak William L · Manhattan, ILBuilt 1946 · S/N 8430 N89399Registration Pending · Goshen, INRegistration pendingBuilt 1946 · S/N 8431 N89400Johnson Ned T · Maplewood, MNBuilt 1946 · S/N 8432 N89402Miller Mark A · Vickery, OHBuilt 1946 · S/N 8434 N89407Peachey Samuel R · Belleville, PABuilt 1946 · S/N 8439 N89411Registration Pending · Chandler, AZRegistration pendingBuilt 1946 · S/N 8443 N89416Wright Douglas J · Greenwood, INBuilt 1946 · S/N 8448 N89426Givens Brian D · Rockwood, TNBuilt 1946 · S/N 8458 N89435Lucas Caleb D · Rock Port, MOBuilt 1946 · S/N 8467 N89447Mariette Brian K · Santa Rosa, CABuilt 1946 · S/N 8479 N89450Applegate Ronald E · Rosamond, CABuilt 1946 · S/N 8482 N89454England Max W · Doniphan, NEFirst renewal noticeS/N 8486 N89457Wansack Mark P · West Middlesex, PAFirst renewal noticeS/N 8489 N89458Diel Mark A · Walnut Creek, CABuilt 1946 · S/N 8490 N89463Honore Enterprise LLC · Allegan, MIBuilt 1946 · S/N 8495 N89466Stopa Gregg · Middletown, NYBuilt 1946 · S/N 8498 N89467Rea Family Investments LLC · Colorado Springs, COBuilt 1946 · S/N 8499 N89471Gingerich Dylan M · Mountain Home, IDBuilt 1946 · S/N 8503 N89473Gray Billy D · Vaughn, MTBuilt 1946 · S/N 8504 N89476Lacharite Joseph N · Warren, MABuilt 1946 · S/N 8507 N89479Shannahan Erwin E · Sunnyvale, CABuilt 1946 · S/N 8510 N89480Stoddard Levi Van · Rocky Ford, COBuilt 1946 · S/N 8511 N89484Gsp Aviation LLC · Wichita, KSBuilt 1946 · S/N 8516 N89485Halley Douglas H · Shelton, CTS/N 8517 N89488Moeder Denis J · Ocala, FLBuilt 1946 · S/N 8520 N89492Pilot Farm LLC · Grant, NEBuilt 1946 · S/N 8524 N89493Craig Larry D · Enon Valley, PAS/N 8525 N89495Carson Leonard H · Chesapeake, VABuilt 1946 · S/N 8527 N89504Hutto Glen A · Orangeburg, SCBuilt 1946 · S/N 8540 N89511Krenzke Stephen E · Fairbanks, AKBuilt 1946 · S/N 8547

Back to Cessna 140