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.

N2975NVan Voast Francis L · Turner, MTBuilt 1947 · S/N 13233 N2977NFarrell Tammy J · Sterling, AKBuilt 1947 · S/N 13235 N2986NChartier Michael W · Las Vegas, NVBuilt 1947 · S/N 13244 N2988NSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 13246 N2990NPaulson Michael J · Fargo, NDBuilt 1947 · S/N 13248 N2FZRiedel Terry D · Erie, COBuilt 1946 · S/N 8341 N3001NWilson Richard W · Independence, ORBuilt 1947 · S/N 13259 N3015NLepley Philip R · Bothell, WABuilt 1947 · S/N 13273 N3018NRuby Mark A · Conway, SCBuilt 1947 · S/N 13276 N3020NShuster David M · Estero, FLBuilt 1947 · S/N 13278 N302SPAppalachian Aviators LLC · Lititz, PABuilt 1948 · S/N 14408 N3043SSpitler John · Laramie, WYBuilt 1947 · S/N 12709 N3047NStagnito Kollin · Frederick, MDBuilt 1947 · S/N 13305 N3049NAyres Henry W Jr · Marshall, VABuilt 1947 · S/N 13307 N3056NDeaton Christopher D · Biloxi, MSS/N 13314 N3060NDischner Charles R · Plattsburg, MOBuilt 1955 · S/N 13318 N3062NFletcher Andrew Christian · Granbury, TXBuilt 1947 · S/N 13320 N3065NSimply Living LLC · Fort Myers, FLBuilt 1947 · S/N 13586 N3073NWiseth Kurt C · Thief River Falls, MNBuilt 1947 · S/N 13331 N3083NMcleod Thomas J · Elba, ALBuilt 1947 · S/N 13341 N3086NDischner Charles R · Plattsburg, MOBuilt 1947 · S/N 13344 N3090NJohnson Scott · Milan, MIBuilt 1947 · S/N 13348 N3094NWarganich William J Jr · Gatlinburg, TNBuilt 1947 · S/N 13352 N3103NDm Aviation Inc · Kissimmee, FLBuilt 1947 · S/N 13361 N3111NGavagan Harold R · Chandler, AZBuilt 1947 · S/N 13369 N3115NYork Ersell Shane · Ramseur, NCS/N 13373 N3131NJerrell Lawrence B · Pittsgrove, NJBuilt 1947 · S/N 13389 N3133NRice Gary W · San Antonio, TXBuilt 1947 · S/N 13391 N3137NLuana John L · Deford, MIBuilt 1947 · S/N 13395 N3142NMcdonald Collin D · Carthage, TNS/N 13400 N3148NGoerger Allan E · Barney, NDBuilt 1947 · S/N 13406 N314JMJ B Flying Club Inc · Weymouth, MABuilt 1947 · S/N 12243 N3150NPutnam Michael C · Topeka, KSBuilt 1947 · S/N 13408 N3158NAlbrecht Romaine C · Ohio, ILBuilt 1947 · S/N 13416 N3168NPealer Raymond L III · Elkins, WVS/N 13426 N3170NGarver James L · Scappoose, ORBuilt 1947 · S/N 13428 N3176NDomeier Paul A · San Jose, CABuilt 1947 · S/N 13434 N3184NSale Reported · Wichita, KSSale reportedS/N 13442 N3190NRieser Ryan M · Portland, ORBuilt 1947 · S/N 13448 N3194NSale Reported · Sacramento, CASale reportedBuilt 1947 · S/N 13452 N3195NLimpert Theodore H · Syracuse, NYBuilt 1946 · S/N 11007 N31FLloyd Land Plane II LLC · Brighton, COBuilt 1946 · S/N 8508 N3342GWhitley Darrell L · Georgetown, TXBuilt 1959 · S/N 10165 N33UEstep Justin E · Turkey Creek, KYBuilt 1946 · S/N 11032 N347CRHirsch Randall L · Mc Donald, TNBuilt 1946 · S/N 9635 N3502VFountain Trevin W · Junction City, ORBuilt 1948 · S/N 14771 N3509VLaakso David · Gaston, ORBuilt 1948 · S/N 14778 N3514VPlane Fun Inc Tr Trustee · Snellville, GAS/N 14819 N3516VCoulter Ryan C · Portland, ORBuilt 1948 · S/N 14785 N3521VAlburitel Aloisio A · Elkhart, INBuilt 1948 · S/N 14790

Back to Cessna 140