Marion, IN
Registered aircraft · 50
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
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_state = 'IN' AND g.registrant_city = 'MARION' 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_state = 'IN' AND g.registrant_city = 'MARION' 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.
N129GFCostruzioni Aeronautiche Tecna P2008 · S/N 126N1414Piper J3C-65 · S/N 16604N1464HAeronca 15AC · S/N 15AC-534N152MLCessna 150J · S/N 15070431N1548HCessna 177RG · S/N 177RG0722N221JTTextron T206H · S/N T20609520N2630BDJI AGRAS T30 · S/N 527BK9P001004QN2630MCessna 172N · S/N 17271166N263ZJDJI AGRAS T30 · S/N 527BK9S001003FN26409Stinson 10 · S/N 7600N283DAXag P150 · S/N 186324P18223502D66F6Sale reportedN28YNSchleicher ASW-28 · S/N 28037N300EEEmbraer Executive EMB-505 · S/N 50500537N328MRaytheon 58 · S/N TH-1992N3469EAeronca 11AC · S/N 11AC-1764N3513CBuckeye Industries DREAM MACHINE · S/N 4929N3644EAeronca 11AC · S/N 11AC-1834N377KMCostruzioni Aeronautiche Tecna ASTORE · S/N 060N39634Aeronca 11AC · S/N 11AC-2N4003EAeronca 11BC · S/N 11BC91N459DCDJI AGRAS T30 · S/N 527BK8C00100D8N48353Drews B-1A · S/N 18362N49696Cessna 152 · S/N 15283496N515DSCessna T206H · S/N T20608179N529Ostroth D David VELOCITY FG · S/N DMO346N6214SCessna 150G · S/N 15067014N669SCRobinson Helicopter R44 II · S/N 11316N7056KBuckeye DREAM MACHINE · S/N 6019N710USCessna 414 · S/N 414-0083N721JKKitz John RV-4 · S/N 164N7249JPiper PA-28-140 · S/N 28-24591N72792Naval Aircraft Factory N3N-3 · S/N 2792N731MQCessna P210N · S/N P21000496N74243Grumman American Avn. AA-5B · S/N AA5B-0172N74AGCirrus Design SR22 · S/N 0428N770TTCompagnie Daher TBM 700 · S/N 1640N7987UCessna 172F · S/N 17251987N800TEEclipse EA500 · S/N 000021N806SPCessna 172S · S/N 172S8110N81219Fields Ralph BENSEN B8M · S/N 777RFN852JJDJI AGRAS T100 · S/N 1581F8ZLC25AH0029SW3N85834Aeronca 11AC · S/N 11AC-245N86343Aeronca 11AC · S/N 11AC-151N87HMMcdaniel Hardey I JR QUICKIE · S/N 522N89395Cessna 140 · S/N 8427N91AWNorth American T-28B · S/N 138356N9373EAeronca 11AC · S/N 11AC-1011N938WBDJI AGRAS T30 · S/N 3U5BJ6G00100FMN938XBDJI AGRAS T30 · S/N 3U5BJ5H001001RN9593SChampion 7ECA · S/N 35
Back to Marion, IN