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.

N121VVBowers Airplanes LLC · Chesterfield, VABuilt 1946 · S/N 3440 N2149HGovin James M · Ball Ground, GABuilt 1946 · S/N 2772 N2166HCrone Janice C · Frederick, MDBuilt 1946 · S/N 2789 N2203HKhanna Varun · Kent, WABuilt 1946 · S/N 2826 N2212HDenault Christopher A · Union Hill, ILBuilt 1946 · S/N 2835 N2247HGerdes Brian K · Los Alamitos, CABuilt 1946 · S/N 2870 N2302HEnigma Aircraft LLC · Benton Harbor, MIBuilt 1946 · S/N 2927 N2327HDelaware Aviation Museum Foundation · Georgetown, DEBuilt 1946 · S/N 2952 N2338HSmith William Alan Charles · Davenport, IABuilt 1946 · S/N 2963 N2354HGriffin Lea Edward · Beaufort, NCBuilt 1946 · S/N 2979 N2389H1941 Historical Aircraft Group Museum · Geneseo, NYBuilt 1946 · S/N 3014 N2394HIngelse David A · Rockford, ILS/N 3019 N2485HMcnutt Richard K · De Pere, WIBuilt 1946 · S/N 3110 N2523HShadd James A · Lancaster, OHBuilt 1946 · S/N 3148 N2539HFortune Conversions Corp · Cave Creek, AZBuilt 1946 · S/N 3164 N2602HWilson Rutledge P III · Marietta, GABuilt 1946 · S/N 3227 N2681HFrazier Jesse O · Barnwell, SCBuilt 1946 · S/N 3306 N26RRightfooted Foundation International · Tucson, AZBuilt 1946 · S/N 3153 N2735HMorris Robert L · Ulm, MTBuilt 1946 · S/N 3360 N2756HSoper Steven E · Rathdrum, IDS/N 3381 N2779JGregory Vernon L · Swansea, SCS/N 976 N2784HHudson Jason M · Toccoa, GABuilt 1946 · S/N 3409 N2795HScholten Dirk J · Ames, IABuilt 1946 · S/N 3420 N2797HWinters David D · Clarksville, TNBuilt 1946 · S/N 3422 N2806HKass John P · Apple Valley, MNBuilt 1946 · S/N 3431 N2872HBevelhymer Paul A · Grass Valley, CABuilt 1946 · S/N 3497 N2875HBoley Richard J · Hayward, WIBuilt 1946 · S/N 3500 N2879HSmith Harry L · Leesburg, FLBuilt 1946 · S/N 3504 N28921Newbury II Dennis M · Brea, CABuilt 1940 · S/N 16 N28928Tate Isaac · Yucaipa, CABuilt 1940 · S/N 23 N28932Williams Elden G · Redding, CAS/N 27 N28944Knox Raymond F · Clarksville, TNS/N 3394 N2902HFerguson Donald · Creston, OHBuilt 1946 · S/N 3527 N2920HBushby David R · Barnesville, GABuilt 1946 · S/N 3545 N2939HDecker John M · Camano Island, WABuilt 1946 · S/N 3564 N2960HBennett Steven · La Fayette, GABuilt 1946 · S/N 3585 N2966EThompson Don Edward · Long Beach, CAS/N 2876 N2969HCaswell Michael W · Rogersville, TNBuilt 1946 · S/N 3594 N299DCGardiner Thomas A · Elizabeth City, NCBuilt 1946 · S/N 1250 N3003HAnderas Per R · Green Bay, WIBuilt 1946 · S/N 3628 N3005HCulver Jacob S · Elgin, ORBuilt 1946 · S/N 3630 N3008HAtkinson Marlyn R · Excelsior Springs, MOBuilt 1946 · S/N 3633 N3027HHeilmann Charles E · Millwood, WVBuilt 1946 · S/N 3652 N3034HBagge John A · Independence, IABuilt 1946 · S/N 3659 N3043HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3668 N3097HFleischhauer Martin W · Tucson, AZBuilt 1946 · S/N 3722 N3105HSzymanski Richard Jr · Long Valley, NJS/N 3730 N3130HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3755 N3152HMay John D · Ward, ARBuilt 1946 · S/N 3777 N3174HSchaffer Richard C · Sparta, WIBuilt 1946 · S/N 3799

Back to Engineering & Research 415-C