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.

N99188Wallin Joshua M · Moreno Valley, CAS/N 1811 N99189Young Jason C · Little River, KSBuilt 1946 · S/N 1812 N99190Pitts Steven L · Anacortes, WABuilt 1946 · S/N 1813 N99198Perry Gregory C · Maurice, LABuilt 1946 · S/N 1821 N99200Airmotive Service LLC · Brigham City, UTBuilt 1946 · S/N 1823 N99201Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1824 N99215Stasny James M · Jacksonville, FLBuilt 1946 · S/N 1838 N99216Prentice Robert D · Ripon, WIBuilt 1946 · S/N 1839 N99226Mcclellan Fred · Grand Blanc, MIBuilt 1946 · S/N 1849 N99228Ching Radford G · Elsie, MIBuilt 1946 · S/N 1851 N99231Stone Charles N · Chetopa, KSBuilt 1946 · S/N 1854 N99233Advanced Airplanes Associates Inc · Keller, TXBuilt 1946 · S/N 1856 N99235Wido Mark C · Plainfield, ILBuilt 1946 · S/N 1858 N99238Urash Richard M · Americus, GABuilt 1946 · S/N 1861 N99244Strutzenberg Kent R · Manson, IAS/N 1867 N99251Jefson Scott A · Shelbyville, ILBuilt 1946 · S/N 1874 N99264Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1887 N99274Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1946 · S/N 1897 N99280Eastern Stearman Inc Trustee · Leesburg, VAS/N 1903 N99287Sweet Pea Flying Club LLC · State Center, IABuilt 1946 · S/N 1910 N99297Baird Mark A · Alameda, CABuilt 1946 · S/N 1920 N99309Sheridan Joshua M · Janesville, WIBuilt 1946 · S/N 1932 N99310Miller Larry W · Lexington, KYBuilt 1946 · S/N 1933 N99317Madre Charles P · Hertford, NCBuilt 1946 · S/N 1940 N99322Bost Kenneth A · Rockwell, NCBuilt 1946 · S/N 1945 N99325Registration Pending · Morrisville, PARegistration pendingBuilt 1946 · S/N 1948 N99326Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1949 N99327Bierck Gregory R · Lafayette, INBuilt 1946 · S/N 1950 N99334Ferster William J · Berlin, MDBuilt 1946 · S/N 1957 N99335Mohler Bruce A · Peru, INBuilt 1946 · S/N 1958 N99337Yocom Jason D · Cocoa, FLS/N 1960 N99340Middelkamp Rick D · Platte City, MOBuilt 1946 · S/N 1963 N99353Aeroplanes Over Idaho · Caldwell, IDS/N 1976 N99367Brown Paul M · Batson, TXBuilt 1946 · S/N 1990 N99372Bevard David · Skiatook, OKBuilt 1946 · S/N 1995 N99388Holcomb Gary G · Palestine, TXBuilt 1946 · S/N 2011 N99391Wood Robert · Trezevant, TNBuilt 1946 · S/N 2014 N99402Sidusky Judy A · Queensbury, NYBuilt 1946 · S/N 2025 N99405Rathe Don A · Fort Mohave, AZS/N 2028 N99406Bahm Martin P · Edmond, OKBuilt 1946 · S/N 2029 N99407Brown Doyle E · Jonesboro, ARFirst renewal noticeS/N 2030 N99411Wido Mark · Plainfield, ILBuilt 1946 · S/N 2034 N99432Sullivan Patrick Joseph · East Hampton, NYS/N 2055 N99433Louden Andrew R · Corvallis, ORS/N 2056 N99458Muldoon Kevin M · Berlin, MDBuilt 1946 · S/N 2081 N99463Myers Kenneth O · Niskayuna, NYBuilt 1946 · S/N 2086 N99466Kenny Edward P · Montauk, NYS/N 2089 N99488Murphy Peter S · Indianapolis, INS/N 2111 N99495Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 2118 N99506High Plains Flying LLC · Burlington, COS/N 2129

Back to Ercoupe 415-C