Youngstown, OH
Registered aircraft · 26
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 = 'YOUNGSTOWN' 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 = 'YOUNGSTOWN' 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.
N11MBCessna 172N · S/N 17272769N1EDIai GULFSTREAM G150 · S/N 324N225FTRobinson Helicopter R22 BETA · S/N 3231N2599RPiper PA-28-180 · S/N 28-5656N277RSRaytheon HAWKER 800XP · S/N 258693N3336EAeronca 7AC · S/N 7AC-6786N3964LCessna 172G · S/N 17254133N398SSinclair Pete LANCAIR ES · S/N ESP 212-12N4169QCessna 310N · S/N 310N-0069N456BBeech 35 · S/N D-1473Non-citizen corporation, flight hours not reportedN46FTSam K Serrino SHORT II · S/N 002N5412RCessna 172F · S/N 17252953N5541TCessna 172E · S/N 17251441N5688TEnstrom F-28C · S/N 480-2N65054Noga Gwain J FP-202 · S/N 7GRIZ202CUBN6505XNoga Gwain J MINI-MAX 1600 · S/N 371600SN309N6506KNoga Gwain J HI-MAX 1700 · S/N HMSNMKY5607N6560MCessna 182P · S/N 18263754N705CGCessna TR182 · S/N R18200801N8050LCessna 172H · S/N 17256250N844BEBeech A36 · S/N E2199N866RSFlight Design CTLS · S/N F-10-06-02N91718Cessna 182M · S/N 18259882N9353YCessna T210N · S/N 21064482N9420UCessna 150M · S/N 15078368N9732JPiper PA-28-180 · S/N 28-3925
Back to Youngstown, OH