Skip to content

Engineering & Research 415-C

Registered aircraft · 160

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

N3210HDixon James L · Eastland, TXBuilt 1946 · S/N 3835 N3227HOrtland Richard J · Franklin, MIBuilt 1946 · S/N 3852 N3233HCourson Keith A · Boise, IDBuilt 1946 · S/N 3858 N3254BBeek Dudley E · Miami, FLBuilt 1946 · S/N 1018 N3276HRoush Jeremy P · West Terre Haute, INBuilt 1946 · S/N 3901 N3345HWhitaker David E · Canton, OHBuilt 1946 · S/N 3970 N3439HDream Flight Aviation LLC · Frederick, MDBuilt 1946 · S/N 4064 N3443HPereira Ronaldo · Bridgewater, MABuilt 1947 · S/N 4068 N3461HJones Jeffrey W · San Antonio, TXBuilt 1946 · S/N 4086 N3477HSprott Robert L · Perkins, OKBuilt 1946 · S/N 4102 N37129Eaa Chapter 1590 Inc · Morrilton, ARBuilt 1941 · S/N 96 N3714HMcnew Brooks C · Stevensville, MDBuilt 1946 · S/N 4339 N415AShemwell Carl R · Clinton, MIBuilt 1946 · S/N 321 N415FWMiller Frank · Statesboro, GABuilt 1946 · S/N 315 N4500MBaty Russell L · Sheridan, MTBuilt 1946 · S/N 3708 N49GBloemker Edward L · Fremont, NEBuilt 1946 · S/N 426 N6204YHinnen Michael L · Toronto, KSBuilt 1946 · S/N 3771 N65KPoland Linda J · Tawas City, MIBuilt 1946 · S/N 2493 N66KSchaetzl Richard · Albuquerque, NMBuilt 1946 · S/N 1790 N67MReno Bill · Casa Grande, AZBuilt 1946 · S/N 339 N703VVBowers Airplanes LLC · Chesterfield, VABuilt 1946 · S/N 3230 N71HMcdowell Donald L · Geneva, OHBuilt 1946 · S/N 1092 N744WHHampton Warren D · Sparks, NVS/N 3923 N86994Poliak Mark A Trustee · Carmel, INS/N 167 N87003Laws Richard B · Apache Junction, AZBuilt 1945 · S/N 176 N87016Henschel Warren · Kingwood, TXBuilt 1945 · S/N 189 N87022Silva Brent F · Lake Hughes, CABuilt 1945 · S/N 195 N87024Perry Larry G · Andover, KSFirst renewal noticeS/N 197 N87030Long Robert D · Kinston, NCBuilt 1945 · S/N 203 N87055Beste Robert K · Sauk Centre, MNBuilt 1946 · S/N 228 N87093Wheeler Russell E · Roxbury, CTS/N 266 N87100Mcnew Stephen J · Brookville, OHBuilt 1946 · S/N 273 N87115Priesmeyer Arthur J · El Campo, TXBuilt 1946 · S/N 288 N87121Clark Charles A · Fitzgerald, GABuilt 1946 · S/N 294 N87161Carlberg Brad S · Hoodsport, WABuilt 1946 · S/N 334 N87198Rogers Samuel · Le Roy, KSBuilt 1946 · S/N 371 N87206Colangione Anthony P · Troy, NYBuilt 1946 · S/N 379 N87213Meyer Theodore J · Conway Springs, KSBuilt 1946 · S/N 386 N87281Faulds Chad A · Mount Pleasant, WIBuilt 1946 · S/N 454 N87286Eaa Chapter 1590 Inc · Morrilton, ARBuilt 1946 · S/N 459 N87289Hamlin Timothy S · Bunker Hill, KSS/N 462 N87321Wiger Theodore L · Falcon Heights, MNS/N 494 N87326Dixon Richard L · Owensboro, KYBuilt 1946 · S/N 499 N87336Abreu David A · Del Rio, TXBuilt 1946 · S/N 509 N87340Eleazer Robert W III · Merritt Island, FLBuilt 1946 · S/N 513 N87354Boehlke Kevin P · New Baltimore, NYBuilt 1946 · S/N 527 N87361Winter Jack W · Custer, SDS/N 534 N87362Dunbar Wilbur R · Brick, NJBuilt 1946 · S/N 535 N87431Hoffman Merle W · Juniata, NEBuilt 1946 · S/N 604 N87440Billings Christopher P · Seffner, FLBuilt 1946 · S/N 613

Back to Engineering & Research 415-C