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.

N9619ADanziger George E · Florence, MABuilt 1949 · S/N 15340 N9623ASun 'N Fun Fly-In Inc · Lakeland, FLFirst renewal noticeBuilt 1949 · S/N 15344 N9624ASnead John S DBA · Crescent City, FLBuilt 1950 · S/N 15345 N9626AWebie Matthew W · Madison, ALBuilt 1949 · S/N 15347 N9629AWinover Orville J Jr · Tyler, TXBuilt 1950 · S/N 15350 N9632AHiter Henry P Jr · Merigold, MSBuilt 1949 · S/N 15353 N9633ASmith Herschell C III · Panama City, FLBuilt 1949 · S/N 15354 N9637AMutz Paul J · Rocklin, CABuilt 1949 · S/N 15358 N9639APhyfe Andrew L · Cape Coral, FLBuilt 1950 · S/N 15360 N9641AIsler Jerry L · Donalsonville, GABuilt 1949 · S/N 15362 N9643AMaples Jeffery · Wilmington, DES/N 15364 N9644ASchindler Patrick E · West Valley City, UTBuilt 1950 · S/N 15478 N9647ASilver Minnow LLC · Farmington, MNBuilt 1950 · S/N 15480 N9649APuls Kurt V · Valparaiso, INBuilt 1949 · S/N 15370 N9650AGraber Kirby D · Brooksville, MSBuilt 1949 · S/N 15371 N9651AMarty Air LLC · Vero Beach, FLBuilt 1950 · S/N 15481 N9654ARegistered aircraftBuilt 1950 · S/N 15375 N9656AKriley Kevin · Smith Center, KSBuilt 1950 · S/N 15377 N9658AMouser Jay F · Goldendale, WABuilt 1950 · S/N 15379 N9660AYates Michael H · Darlington, MDBuilt 1950 · S/N 15381 N9661AEndsley Larry R · Waynesboro, VABuilt 1950 · S/N 15561 N9667ALight For Living Inc · Harvest, ALBuilt 1950 · S/N 15388 N9669ADella David Dan · Vacaville, CABuilt 1950 · S/N 15390 N9672AJohnstone Deborah L · Edmonds, WABuilt 1950 · S/N 15393 N9673AGiesbrecht Shane R · Grand View, IDS/N 15394 N9674AKubitschek William J · Mansfield, MOS/N 15395 N9681AKablau Frank · Elroy, WIBuilt 1950 · S/N 15562 N9682APenfield George R · Shreveport, LABuilt 1950 · S/N 15403 N9683ARogers Wallace B · Salem, ORS/N 15404 N9687AHolbrook James A · Burnet, TXBuilt 1950 · S/N 15408 N9688ASmith Herschel C III · Panama City, FLBuilt 1952 · S/N 15409 N9691ABernette Allan E · Wisconsin Rapids, WIBuilt 1950 · S/N 15412 N9694AOgilvie Adam P · Loveland, COBuilt 1950 · S/N 15415 N996CAClassic Aircraft Investments LLC · Tega Cay, SCBuilt 1949 · S/N 15235

Back to Cessna 140A