Experimental Aircraft Association Inc
Registered aircraft · 28
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 = 'EXPERIMENTAL AIRCRAFT ASSOCIATION INC' OR list_contains(g.other_registrant_names, 'EXPERIMENTAL AIRCRAFT ASSOCIATION 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 = 'EXPERIMENTAL AIRCRAFT ASSOCIATION INC' OR list_contains(g.other_registrant_names, 'EXPERIMENTAL AIRCRAFT ASSOCIATION 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.
N10VNorth American B-25H · S/N 98-21433N1271UCessna 172M · S/N 17266966N134TXBeech T-34A · S/N G-113N140WWExperimental Aircraft Assn CRUZER CH 750 · S/N C75-10050N150HVCessna 150G · S/N 15066657N157DCNorth American T-6G · S/N 49-3141N184RSCessna 162 · S/N 16200077N1933JBrugioni Mario CUBY · S/N 303N20953Waco ARE · S/N 5080N211Eaa Air Museum Foundation SPIRIT OF ST. LOUIS · S/N 2N231YEEaa Aviation Foundation GLASTAR 3 · S/N 5192N232YEEaa Aviation Foundation GLASTAR · S/N 5265N275PAVans RV-12IS · S/N 12161N3311SCessna 210J · S/N 21059111N4028Swallow SWALLOW · S/N 899N40LFCessna 162 · S/N 16200302N5017NBoeing B-17G · S/N 44-85740N51986Cessna 162 · S/N 16200004N5198YCessna 162 · S/N 16200003N6063TCessna 150D · S/N 15060763N648HCurtiss Wright TRAVEL AIR E-4000 · S/N 1224N6YEEaa Aviation Foundation RV-6A · S/N 2557N830SHVans RV-12IS · S/N 12083N840North American P-64 · S/N 68-3061N8407Ford 4-AT-E · S/N 69N840SHVans RV-12IS · S/N 12087N8413DBell 47G-5A · S/N 25091N95WPitcairn PA-7 · S/N 147
Back to Experimental Aircraft Association Inc