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.

N87449Korzelius Matthew J · Niagara Falls, NYBuilt 1946 · S/N 622 N93318Broer Marc W · Des Moines, IABuilt 1946 · S/N 641 N93320Devries Amy J · Sulphur Bluff, TXBuilt 1946 · S/N 643 N93346Deal Robert E · Hendersonville, TNBuilt 1946 · S/N 669 N93415Brannon Barry Gilmore · Bell, FLBuilt 1946 · S/N 738 N93506Grothe Wayne D · Veradale, WABuilt 1946 · S/N 829 N93511Tabbert Charles · Diamondhead, MSS/N 834 N93514Dalbey Joseph J · Urbandale, IABuilt 1946 · S/N 837 N93542Popio John A · Marysville, OHBuilt 1957 · S/N 865 N93576Larson Daniel M · Fergus Falls, MNS/N 899 N93639Perkins Steven J · Herscher, ILBuilt 1946 · S/N 962 N93661Gonzales David J · Camarillo, CABuilt 1953 · S/N 984 N93705Erickson Jeanne H · Warroad, MNBuilt 1946 · S/N 1028 N93716Central Washington Sport Pilots Inc · Yakima, WABuilt 1946 · S/N 1039 N93771Peppas George D Jr · Fort Wayne, INBuilt 1946 · S/N 1094 N93826Azeredo Ian G · Ringwood, NJBuilt 1946 · S/N 1149 N93841Baker Peters · Clarinda, IABuilt 1946 · S/N 1164 N93853Averett Joseph B · Denham Springs, LAS/N 1176 N93868Simpson Daniel J · Polk City, FLBuilt 1946 · S/N 1191 N93880Ercoupe Aviation LLC · Saint Peters, MOFirst renewal noticeBuilt 1946 · S/N 1203 N93892Lee Justin W · Maud, TXS/N 1215 N93921Amann David P · Wesley Chapel, FLBuilt 1955 · S/N 1244 N93926Brown David M · Aledo, TXBuilt 1946 · S/N 1249 N93966Busch Ronae M · Menoninee, MIBuilt 1946 · S/N 1289 N94082Ward Roy L · Tell City, INBuilt 1946 · S/N 1405 N94085Whale Charles R Jr · Kuna, IDBuilt 1946 · S/N 1408 N94099Tr Pegasus Inc · Glenwood, NJBuilt 1946 · S/N 1422 N94114Sprunger Gary E · Saint Joseph, MIBuilt 1946 · S/N 1437 N94123Croxford Brian · Indianapolis, INBuilt 1946 · S/N 1446 N94160Registration Pending · Waldo, OHRegistration pendingBuilt 1946 · S/N 1483 N94193Washington Buddy K · Ten Sleep, WYBuilt 1946 · S/N 1516 N94195Photakis Gary B · Kirkland, WABuilt 1946 · S/N 1518 N94311Broadwell Eric · Woodstock, GAS/N 1534 N94342Sale Reported · Crystal, MNSale reportedBuilt 1946 · S/N 1565 N94354Hertel Jane V · Granbury, TXBuilt 1946 · S/N 1577 N94357Ratzlaff James P · Newton, KSBuilt 1946 · S/N 1580 N99056Morgan Rodney D · Boiling Springs, PAS/N 1679 N99089Moore Michael W · Tacoma, WABuilt 1946 · S/N 1712 N99101Croft Thomas J · Camdenton, MOBuilt 1946 · S/N 1724 N99129Wischmeyer Matthew R · Hopewell Junction, NYS/N 1752 N99133Schmotzer Donald C · West Columbia, SCBuilt 1946 · S/N 1756 N99267Oswald Merlin W · Herington, KSS/N 1890 N99281Mackie Kevin S · Longview, WAS/N 1904 N99307Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1930 N99369Burdett Jr Robert P · Lilburn, GABuilt 1946 · S/N 1992 N99398Brimmer Johnyjoe · Gillette, WYBuilt 1946 · S/N 2021 N99448Howe Larry G · Florence, ORBuilt 1946 · S/N 2071 N99485Hilton Loye L · Bullhead City, AZBuilt 1946 · S/N 2108 N99573Take Off LLC · Boise, IDBuilt 1946 · S/N 2196 N995PGPratt Mark J · Sikeston, MOBuilt 1946 · S/N 1091

Back to Engineering & Research 415-C