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.

N676AAMcdonald Donald C Trustee · Owatonna, MNS/N 3069 N72EToronidis Joannis · Ronkonkoma, NYBuilt 1946 · S/N 2918 N72PPEd Stapleton Lawyer Pllc · Brownsville, TXS/N 2051 N77ZGorman John C · St Augustine, FLS/N 497 N789JJFallon Jeffrey C · Berlin, MABuilt 1946 · S/N 1541 N799TXCowden Timothy L · Escondido, CABuilt 1946 · S/N 670 N846MDSimons Barbara A · Enderlin, NDBuilt 1946 · S/N 3254 N86962Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 135 N86965Mcguckian Michael P · Colorado Springs, COS/N 138 N86972Parnell Jeffrey R · Garrison, MOBuilt 1945 · S/N 145 N86978Yoder Aaron W · Belvidere, TNBuilt 1945 · S/N 151 N86982Forseth David E · Arena, WIBuilt 1945 · S/N 155 N86984Walts Robert · Moraga, CABuilt 1945 · S/N 157 N86996Gregory Vernon L · Swansea, SCBuilt 1945 · S/N 169 N87014Cohen David M · Gaithersburg, MDS/N 187 N87034Prescott Paul H · North Augusta, SCBuilt 1945 · S/N 207 N87037Drake Paul A · Eagar, AZBuilt 1945 · S/N 210 N87040Burr Walter E · Tecumseh, MIBuilt 1945 · S/N 213 N87042Gregory Vernon L · Swansea, SCBuilt 1945 · S/N 215 N87046Young Eagles Flying Club LLC · Lady Lake, FLS/N 219 N87051Strong Neil E · Pittsburg, TXBuilt 1946 · S/N 224 N87071Cortes-Batista Eliacim · Arlington, TXBuilt 1946 · S/N 244 N87072Galloway George G · Fort Worth, TXBuilt 1946 · S/N 245 N87074Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 247 N87077Dombrowski Christopher · Livermore, CABuilt 1946 · S/N 250 N87080Schoenfelder James N · Huron, SDS/N 253 N87085Pyle Dana C · Naples, FLBuilt 1946 · S/N 258 N87086Bernard Kate L · Neenah, WIBuilt 1946 · S/N 259 N87091Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 264 N87096Wright Ronald E · Overland, MOBuilt 1946 · S/N 269 N870DFHall William R · Franklin, NCBuilt 1946 · S/N 870 N87101Courser Jacob A · West Hartford, CTBuilt 1946 · S/N 274 N87103Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 276 N87133Todd W Wish · Sellersville, PABuilt 1946 · S/N 306 N87155Purnell James I · Manassas, VAFirst renewal noticeBuilt 1946 · S/N 328 N87162Evans Orville J · New Philadelphia, OHBuilt 1946 · S/N 335 N87170Withrow Thomas E · Lewisburg, WVS/N 343 N87171Toth Richard J · Windber, PABuilt 1946 · S/N 344 N87187Fountain Robert A · Suitland, MDBuilt 1946 · S/N 360 N87197Craparo John S · Georgetown, TXS/N 370 N87201Yurasich Tom J · Sedalia, MOBuilt 1946 · S/N 374 N87215Orr Leroy A · Tonasket, WAS/N 388 N87223Ballew James W · Collinsville, OKBuilt 1946 · S/N 396 N87231Bayne William R · Kaufman, TXFirst renewal noticeS/N 404 N87248Biggs William E · Temple, TXBuilt 1946 · S/N 421 N87264Homic Michael J · Edmond, OKBuilt 1946 · S/N 437 N87267Collins Dennis L · Richland, WABuilt 1946 · S/N 440 N87277Webb Patrick S · Chuckey, TNBuilt 1946 · S/N 450 N87283Hornby Larry E · Helena, MTBuilt 1946 · S/N 456 N87296Brigitte Krivan Iris · Port Saint Lucie, FLBuilt 1946 · S/N 469

Back to Ercoupe 415-C