Marietta, OH
Registered aircraft · 30
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 = 'OH' AND g.registrant_city = 'MARIETTA' 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 = 'OH' AND g.registrant_city = 'MARIETTA' 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.
N122MTCirrus Design SR22T · S/N 1856N1297GCessna 310R · S/N 310R0003N1305QCessna 150L · S/N 15072605N153DDDennis Lyle Dye KOLB FIRESTAR II · S/N FS15-4-00099N1576NPiper J3C-65 · S/N 23108N173CCTaylorcraft DCO-65 · S/N 5793N1808XCessna 182H · S/N 18255908N193PPCessna 525A · S/N 525A0192N206CSBell 206B · S/N 4068N224DPBeech A36 · S/N E-2599N239DMAero Vodochody L39C · S/N 031818N2853SPiper PA-28RT-201 · S/N 28R-7918177N3136ZPiper PA-22-160 · S/N 22-7080N3403PPiper PA-23-160 · S/N 23-1367N3761TPiper PA-28R-180 · S/N 28R-30070N4050JAlon A2 · S/N A101N421TBSocata TB21 · S/N 2081N477JAPhilip B Shiflett ESCAPADE · S/N JA477-12-15N60046Commander 114-B · S/N 14546N601BBSmith AEROSTAR 601P · S/N 61P-0431-159N676ECCastle Joseph E GLASAIR II-SRG · S/N 2163N67WTCessna 182M · S/N 18259488N6962PPiper PA-24-250 · S/N 24-2100N76427Cessna 140 · S/N 10853N78911Mooney M20C · S/N 1940N83544Aeronca 7AC · S/N 7AC-2220N839LGRobert William Carr AVID FLYER COMMUTER · S/N 1001N91284Piper PA-34-200T · S/N 347970111N9144TPiper PA-28-181 · S/N 28-8690029N9169RDye Rodney D BEDE 4 · S/N D0101
Back to Marietta, OH