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.

N4002NRiggin Flight Service Inc · Madison, SDS/N 13460 N4006NRafford Mark D · Ashland, MEBuilt 1947 · S/N 13464 N4012NIrwin Richard C · Bedias, TXBuilt 1947 · S/N 13470 N4014NHoffman Conrad D · Madison, SDBuilt 1947 · S/N 13472 N4018NHunsberger Robert E · Ramona, CABuilt 1947 · S/N 13476 N4022NHazelton Carl R · Aransas Pass, TXBuilt 1947 · S/N 13480 N4028NOast Thomas H · Sedan, KSBuilt 1947 · S/N 13621 N4032NHoward Nancy Jo · Elmore, OKBuilt 1947 · S/N 13490 N4039NAdams Scott T · Phillips, MEBuilt 1947 · S/N 13497 N4046NLarrick Christopher J · Rhome, TXBuilt 1947 · S/N 13504 N4048NMaas Timothy S · Elbert, COBuilt 1947 · S/N 13506 N4052NFrank Pfeifer & Son LLC · Bristow, NES/N 13871 N4056NParinger Glenn R · Nashotah, WIBuilt 1947 · S/N 13514 N4062NOrr Allan · Hendersonville, TNBuilt 1947 · S/N 13520 N4064NJulian Stan T · Holt, FLBuilt 1947 · S/N 13512 N4070NJorgensen Richard A · Wisconsin Rapids, WIBuilt 1947 · S/N 13528 N4072NFuhrman Ronald A · Fargo, NDS/N 13530 N4074NHall Michael Jacob · Baxter, MNS/N 13532 N4078NAlexander Robert B · Brooksville, FLBuilt 1947 · S/N 13536 N4080NStartin Chad E · Lacrosse, WABuilt 1947 · S/N 13538 N4082NCook Steven C · Hewitt, TXBuilt 1947 · S/N 13540 N4084NBoike Andrew W · Federal Way, WABuilt 1947 · S/N 13542 N4086NLagno Frederick F · Queenstown, MDBuilt 1947 · S/N 13544 N4088N4088n LLC · Springfield, VABuilt 1947 · S/N 13546 N4102NWalden Taylor G · Pueblo, COBuilt 1947 · S/N 13560 N4104NQualitair LLC · MichelstadtBuilt 1947 · S/N 13562 N4112NLittfin Todd D · Eleva, WIBuilt 1947 · S/N 14025 N4114NFoster James W · Rapid River, MIBuilt 1947 · S/N 13572 N4116NUnruh Adrian R · Bellevue, WAS/N 13574 N4122NSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1947 · S/N 13580 N4131NKrupovage Dan C · Alamogordo, NMBuilt 1947 · S/N 13594 N4135NPaige Richard C Jr · Ukiah, CABuilt 1947 · S/N 13598 N4139NConnecticut Valley Aviation · East Longmeadow, MABuilt 1947 · S/N 13602 N4149NJones Eugene E · Saint Johns, MIBuilt 1947 · S/N 13612 N4151NRegistered aircraftBuilt 1947 · S/N 13873 N4153NAljanabi Mohammed Khalid · Herndon, VABuilt 1947 · S/N 13875 N4155NMacvey Troy R · Milan, INBuilt 1947 · S/N 13626 N4158NPerkins Howard D Jr · Sapulpa, OKS/N 13629 N4159NBergwall Douglas H · San Mateo, CAFirst renewal noticeBuilt 1947 · S/N 13630 N4163NOrland William B · Santee, CABuilt 1947 · S/N 13634 N4169NNascimento Robert J · Turlock, CABuilt 1947 · S/N 13640 N4179NGauntt Stephen R · Kennewick, WAS/N 13650 N4185NNew Daniel A · Deming, WABuilt 1947 · S/N 13656 N4188NBascom Richard J Trustee · Elkhart, IABuilt 1947 · S/N 13659 N4198NCohen Marc A · Mason, WIBuilt 1947 · S/N 13669 N419GBTorello Michael S · Port Huron, MIBuilt 1946 · S/N 11665 N4203NHansen Loren E · Des Moines, WABuilt 1947 · S/N 14029 N4205NRutherford Thom J · Burchwood, WIS/N 13676 N4209NVan Dyke Stewart D · Carmel, INBuilt 1947 · S/N 13680 N4213NNichols Tom · Anamosa, IABuilt 1948 · S/N 13684

Back to Cessna 140