S.O.C.A.T.A. RALLYE 235E
Registered aircraft · 16
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 ('8400135')
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 ('8400135')
ORDER BY n_numberRun 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.
N14EE14ee Corp · Cranberry Township, PAN235GTBrown Rodney · Foxworth, MSN266DHurricane Mesa Aviation LLC · Hurricane, UTN301RAHagedorn Hans J · Spring, TXN305Keene Keith L · Crosby, TXN306RACoen Peter G · Newport News, VAN312RACross Country Soaring Inc · Lonsdale, MNN322RAEuroamerican Development Group Inc · New York City, NYN323RAStack Timothy A · Cataula, GAN326RAGolden Pegasus LLC · Hughson, CAN338RATeufel Kirsi Katariina · Ontario, ORN341RAYang Chi · Lafayette, CON342RAHeartland Aviation LLC · Harrisonville, MON343RABrown Ronald B · Virginia Beach, VAN346RAThompson Christopher C · Hillsboro, WIN418JTDavies Lloyd G · Orofino, ID
Back to S.O.C.A.T.A. RALLYE 235E