Eaa Aviation Foundation Inc
Registered aircraft · 65
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'EAA AVIATION FOUNDATION INC' OR list_contains(g.other_registrant_names, 'EAA AVIATION FOUNDATION INC') ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'EAA AVIATION FOUNDATION INC' OR list_contains(g.other_registrant_names, 'EAA AVIATION FOUNDATION INC') ORDER BY g.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.
N1114VDehavilland DHC-1 · S/N 154N11609Pitcairn PCA2 · S/N B-27N11MEMonnett MONNETT II · S/N 1N1292Whittman DFA · S/N 7N12930Chester Special RACER · S/N 1N12SXSonex Ltd/Monnett John T JR SONEX · S/N 001N13993Spartan 7W · S/N 2N141SXMonnett John T JR SUB SONEX · S/N 001N1436Rand KR-1 · S/N 01N143BJBarber Paul A VELOCITY ELITE RG · S/N 42651N14JTaylor Titch MARK III · S/N 1N14RVVangrunsven Richard/Diane RV-4 · S/N 1N151NPheasant H-10 · S/N 136N15MGMikoyan MIG-15BIS · S/N 1411N16291Aeronca C-3 · S/N A-668N169SHRutan Richard G LONG-EZ-B · S/N 0169N17372Ryan Aeronautical SCW-145 · S/N 201N17RVVangrunsven RV-3 · S/N 173N18268Wittman W · S/N 5N1ACEaa Sport Biplane HOME BUILT · S/N 3138N2125Birchfield James W ROSEPARAKEET REPLICA · S/N 001N2309NChristensen-Frank CHRISTEN EAGLE I-F · S/N 0001N241Curtiss Wright TRAVEL AIR 4000 · S/N 1N264YElmendorf A - 1 · S/N A-1N26MSMelvill M W/Melvill Sally LONG-EZ · S/N 115N2732MPiper PA-12 · S/N 12-1225N2741HRolf R Hetico RV-8A · S/N 81180N27VVRutan VARIVIGGEN 50-160 · S/N 001N2RYRyson ST-100 · S/N 001N307XZKitty Hawk MULE SPA-BETA · S/N 007N3259Wittman WV · S/N 11N33VKKlapmeier Alan/Klapmeier Dale CIRRUS VK 30 · S/N 005N3451DNorth American F-51D · S/N 44-75007NN3569Fairchild FC-2-W2 · S/N 35N37SWWittman TAILWIND WO · S/N 12N38899Thomas Morse S4C · S/N 38899N3908Pitcairn PA39 · S/N M98N417GMMorrison W Howard BOWERS FLYBABY 1A · S/N 94-1N49750Piper J3C-65 · S/N 8294N500BDBede BD-5 · S/N 1N5084TSolsvig Russel T AIR CAM · S/N AC001N510SCStemme S-10 · S/N 10-51N516MHHester Maxey SPACEWALKER · S/N SW6020BN51GPober Sport P-5 · S/N 105N51NANorth American XP-51 · S/N 41-038N555ADyke Delta JD-2 · S/N 1001N5814Waco ATO · S/N A-4N606PERosnick Ralph HAWK P-6E · S/N 32-260N613LDMark Marino BENOIST TYPE XIV · S/N 43N6667Chance Vought F4U-4 · S/N 9413
Back to Eaa Aviation Foundation Inc