Skip to content

Registered aircraft · 624

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 ('0420322')
  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 ('0420322')
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.

N93869Jacobsen Ian M · Lincoln City, ORBuilt 1946 · S/N 1192 N93883Schmidt John P · Lafayette, INBuilt 1946 · S/N 1206 N93886Dalsco Inc · Dover, DES/N 1209 N93888Andrews Kenneth G · Kuna, IDFirst renewal noticeBuilt 1946 · S/N 1211 N93889Mcgrath John P · Concord, NHBuilt 1946 · S/N 1212 N93896Lambert Joe B · Brainerd, MNS/N 1219 N93902Carlson Bruce D · Umatilla, ORBuilt 1946 · S/N 1225 N93905Siska James Joseph · Plain City, OHBuilt 1946 · S/N 1228 N93915Lee Justin W · Maud, TXBuilt 1946 · S/N 1238 N93930Dubbert Roger D · Mexico, MOBuilt 1946 · S/N 1253 N93950Fust Irwin H · Anderson, CABuilt 1946 · S/N 1273 N93955Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1278 N93960Smith Roy V · Trimble, TNBuilt 1946 · S/N 1283 N93963Bug Smashers LLC · Winfield, KSBuilt 1946 · S/N 1286 N93968Flying Wrenches · Buhl, IDS/N 1291 N93977Hardin Melissa K · Terrell, TXBuilt 1946 · S/N 1300 N93978Coleman Stanley · Lefors, TXS/N 1301 N93984Arsenault William R · Rehoboth, MABuilt 1946 · S/N 1307 N93994Pound John · Tucson, AZBuilt 1946 · S/N 1317 N93997Registration Pending · Maud, TXRegistration pendingBuilt 1946 · S/N 1320 N94003Boggs Marty N · Thomasville, NCBuilt 1946 · S/N 1326 N94004Fremont Aviation · Fremont, NEBuilt 1946 · S/N 1327 N94007Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1330 N94008Buck Jon R · Sykesville, MDBuilt 1946 · S/N 1331 N94012Mcglashan Richard L · Round Rock, TXS/N 1335 N94020Lee Justin W · Maud, TXBuilt 1946 · S/N 1343 N94026Dinucci Gino · Clearwater, FLBuilt 1946 · S/N 1349 N94036Tlc Olson Construction LLC · Huron, SDBuilt 1946 · S/N 1359 N94040Magnolia Aviation Solutions LLC · Sheridan, WYBuilt 1946 · S/N 1363 N94041Robinson Randall L · Crawfordville, FLBuilt 1946 · S/N 1364 N94043Moco Aviation LLC · Moultonborough, NHBuilt 1946 · S/N 1366 N94045Stoelt William L · Lynden, WABuilt 1946 · S/N 1368 N94047Marsteller Michael A · Lugoff, SCBuilt 1946 · S/N 1370 N94060Reedsburg Aviation LLC · Reedsburg, WIS/N 1383 N94065Burr Allen H · Oak Island, NCBuilt 1946 · S/N 1388 N94068Robertson Malcolm E · El Dorado Springs, MOBuilt 1946 · S/N 1391 N94084Migliore Richard · Albuquerque, NMS/N 1407 N94087Registration Pending · Anderson, CARegistration pendingBuilt 1946 · S/N 1410 N94088Johnson David R · Wichita, KSBuilt 1946 · S/N 1411 N94093Muchow Charles R · Brookshire, TXBuilt 1946 · S/N 1416 N94096Still John D · Greenwood, SCBuilt 1946 · S/N 1419 N94106Glenn Larry W · Bunn, NCBuilt 1946 · S/N 1429 N94109Mccready Kevin · Gettysburg, PAS/N 1432 N94113Archer Samuel E Trustee · Independence, ORS/N 1436 N94115Hurt Paul G · Supply, NCBuilt 1946 · S/N 1438 N94116Bentson Lisa F · Las Vegas, NMBuilt 1946 · S/N 1439 N94117Burquest Donald A · New Braunfels, TXBuilt 1946 · S/N 1440 N94127Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1450 N94129Westall Melina Joan · Anchorage, AKBuilt 1946 · S/N 1452 N94131Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1454

Back to Ercoupe 415-C