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.

N76769Clark Dennis L · Ozona, TXBuilt 1946 · S/N 11201 N76771Somd Seaplanes LLC · Lexington Park, MDS/N 11203 N76776Forman Ronald M · Puyallup, WABuilt 1946 · S/N 11208 N76777Warner Aric D · Rosamond, CAS/N 11209 N76780Croxton Adam H · Du Quoin, ILBuilt 1946 · S/N 11212 N76785Henning Nancy E · Hardinsburg, KYBuilt 1946 · S/N 11217 N76791Suburban Aircraft Leasing And Sales LLC · Sylvania, OHBuilt 1946 · S/N 11223 N76795Tumbleson Shelly L · San Antonio, TXBuilt 1946 · S/N 11227 N76813Ruysenaars Nick H Jr · Port Neches, TXBuilt 1946 · S/N 11245 N76829Shupe Martin A · Granbury, TXBuilt 1946 · S/N 11261 N76832Skyhawk Archaeology LLC · Livingston Manor, NYBuilt 1946 · S/N 11264 N76836Kempf Ian J · Havana, ILBuilt 1946 · S/N 11268 N76841Hebert Bernard J · Richmond, VABuilt 1946 · S/N 11275 N76843Petro Harold J · Des Moines, IABuilt 1946 · S/N 11277 N76847Sharkey John P · Saint Charles, MOBuilt 1946 · S/N 11281 N76850Rawls Steve · Fernandina Beach, FLBuilt 1946 · S/N 11284 N76861Kaufman Rodney G · Silverton, ORBuilt 1946 · S/N 11295 N76865Eagles Wings Inc · San Angelo, TXBuilt 1946 · S/N 11299 N76867Prato Joseph H · Livonia, NYBuilt 1946 · S/N 11301 N76871Gaipa Tim · Saint Joseph, MIBuilt 1946 · S/N 11305 N76874Olsen Jerry K · Rosamond, CABuilt 1946 · S/N 11308 N76875Richard Brady K · Farmers Branch, TXBuilt 1946 · S/N 11309 N76882Williams Jason R · Troy, OHBuilt 1946 · S/N 11316 N76883Cox Keith L · Griffin, GAS/N 11317 N76885Delta Ridge Farms LLC · Oak Grove, LAS/N 11319 N76887Victor Whiskey Aviation LLC · Spring Branch, TXBuilt 1946 · S/N 11321 N76893Wright Joseph G · Medicine Lodge, KSBuilt 1946 · S/N 11327 N76894Sislo James W · Wausau, WIBuilt 1946 · S/N 11328 N76901Dawsonfens 140 LLC · Pearland, TXBuilt 1946 · S/N 11343 N76903Jones David L · Powderly, TXBuilt 1946 · S/N 11345 N76905Guidice Donald C · Chugwater, WYBuilt 1946 · S/N 11347 N76915M R G 2 LLC · Galesburg, ILBuilt 1946 · S/N 11357 N76918Mccoy Kevin P · Big Pine Key, FLBuilt 1954 · S/N 11360 N76925Hamman Baron L · Dallas, TXBuilt 1946 · S/N 11367 N76926Rachael Earl · Keene, NHBuilt 1946 · S/N 11368 N76930Osowski Wes · Kodiak, AKBuilt 1946 · S/N 11372 N76933Almaguer Carlos · Mcallen, TXBuilt 1946 · S/N 11375 N76937Thaxton Douglas C · Chandler, AZS/N 11379 N76939Beech O Sphere LLC · Casper, WYS/N 11381 N76942Hawkins Brennan J · Superior, WIS/N 11384 N76946Mayton Travis W · Decatur, TNBuilt 1946 · S/N 11388 N76950Beare Michael · Camano Island, WABuilt 1946 · S/N 11396 N76951Wallace Carey · Knoxville, TNBuilt 1946 · S/N 11397 N76954Nemmers Joseph P · Trent, SDBuilt 1946 · S/N 11400 N76955Pell Daniel · Naperville, ILBuilt 1946 · S/N 11401 N76962Burwell Daniel G · Spanaway, WABuilt 1946 · S/N 11408 N76967Johnson Gary D · Trinidad, CAS/N 11413 N76974Ansorge Inc · Elk Grove, CAS/N 11420 N76975Day Samuel · Topeka, KSBuilt 1946 · S/N 11421 N76977Lapointe Teagan · Gig Harbor, WABuilt 1946 · S/N 11423

Back to Cessna 140