Marion, TX
Registered aircraft · 49
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 = 'TX' 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 = 'TX' 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.
N120XCessna 120 · S/N 14345N1233EAeronca 7CCM · S/N 7AC-4791N15558Piper PA-18-135 · S/N 18-3876N169XManske David FIRE BOLT · S/N 001N1758VCessna 172M · S/N 17263740N17973Schweizer SGS 1-34 · S/N 73Sale reportedN18591Cessna C-37 · S/N 376N226VPDJI AGRAS T40 · S/N 64TBL4A002006EN2319FCessna 210E · S/N 21058519N24231Aeronca 65-LA · S/N L-6979N2558UCessna 172D · S/N 17250158N300JLBeech A23-19 · S/N MB-134N3326CBeech E35 · S/N D-3992N3684KPiper J3C-65 · S/N 22375N3845RCessna 172H · S/N 17255341N3849HEngineering & Research ERCOUPE 415-CD · S/N 4550N38908Piper PA-32R-300 · S/N 32R-7780487N3NEPatton Ronald V RV-4 · S/N 2AP305N4054JMosel Francis A FH-82 · S/N 802N4070EAeronca 11AC · S/N 11BC-158N4111FCessna 172 · S/N 46011N416TBeech 35-A33 · S/N CD-282N4436BCessna 170 · S/N 26780N4727GCessna 172N · S/N 17273332N5348PPiper PA-24-250 · S/N 24-395N5553NHoward DGA-15P · S/N 978N5588ECessna 150 · S/N 17088N5646NMaule M-5-210TC · S/N 9010CN5GNNelson RV-3 · S/N XX5N601CXMulloy Charles ZODIAC 601XL · S/N 6-4842Registration pendingN628JCCessna 172M · S/N 17262911N64220Cessna 172M · S/N 17265099N656RVDavid D Weise VANS RV-6 · S/N 60511N7008TCessna 172 · S/N 46608N7119BPiper PA-22-150 · S/N 22-4336N71880Cessna 182M · S/N 18259790N732TYCessna T210M · S/N 21061772N74081Bell 47D1 · S/N 216N76673Cessna 140 · S/N 11113N790SHRobinson Helicopter R22 · S/N 3636N7938GCessna 172L · S/N 17259638N8290BCessna 172 · S/N 36090N84427Aeronca 7AC · S/N 7AC-3124N84921Aeronca 7AC · S/N 7AC-3643N85856Aeronca 11AC · S/N 11AC-259N8863BCessna 172 · S/N 36563N8885JPiper PA-28-180 · S/N 28-2859N9457XCessna 210A · S/N 21057757N95839Taylorcraft BC12-D · S/N 8139
Back to Marion, TX