Cleveland, OH
Registered aircraft · 391
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 = 'CLEVELAND' 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 = 'CLEVELAND' 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.
N100FXGulfstream Aerospace GVIII-G700 · S/N 87041N101FXGulfstream Aerospace GVIII-G700 · S/N 87054N102FXGulfstream Aerospace GVIII-G700 · S/N 87007N103FXGulfstream Aerospace GVIII-G700 · S/N 87039N115AVCirrus Design SR20 · S/N 9250N136ZCGulfstream Aerospace GVIII-G700 · S/N 87019N156PHBombardier BD-100-1A10 · S/N 20696N158PHBombardier BD-100-1A10 · S/N 20721N172FXCessna 172N · S/N 17271381N1836LBeech A36 · S/N E-1111N190XTBeech C90A · S/N LJ-1066N200FXGulfstream Aerospace GVII-G500 · S/N 72136N205AGBeech 58 · S/N TH-516N220FXBombardier BD-100-1A10 · S/N 21075N221FXBombardier BD-100-1A10 · S/N 21080N222FXBombardier BD-100-1A10 · S/N 21101N223FXBombardier BD-100-1A10 · S/N 21102N224FXBombardier BD-100-1A10 · S/N 21118N224LWCirrus Design SR22T · S/N 0293N225FXBombardier BD-100-1A10 · S/N 21119N226FXBombardier BD-100-1A10 · S/N 21131N227FXBombardier BD-100-1A10 · S/N 21134N233FXEmbraer Executive EMB-505 · S/N 50500938N234FXEmbraer Executive EMB-505 · S/N 50500949N2354XCessna 182H · S/N 18256254N235FXEmbraer Executive EMB-505 · S/N 50500972N260LFLearjet 31A · S/N 231N261FXEmbraer S A EMB-545 · S/N 55010166N261MHEurocopter Deutschland MBB-BK 117 C-2 · S/N 9250N262FXEmbraer S A EMB-545 · S/N 55010171N262MHEurocopter Deutschland MBB-BK 117 C-2 · S/N 9278N263FXEmbraer S A EMB-545 · S/N 55010175N263MHEurocopter Deutschland MBB-BK 117 C-2 · S/N 9311N2641WMooney M20C · S/N 3303N264FXEmbraer S A EMB-545 · S/N 55010172N265FXEmbraer S A EMB-545 · S/N 55010178N267FXEmbraer S A EMB-545 · S/N 55010185N268FXEmbraer S A EMB-545 · S/N 55010189N269FXEmbraer S A EMB-545 · S/N 55010183N270FXEmbraer S A EMB-545 · S/N 55010194N272FXEmbraer S A EMB-545 · S/N 55010196N273FXEmbraer S A EMB-545 · S/N 55010197N274FXEmbraer S A EMB-545 · S/N 55010208N275FXEmbraer S A EMB-545 · S/N 55010210N279FXEmbraer S A EMB-545 · S/N 55010213N281FXEmbraer S A EMB-545 · S/N 55010214N282FXEmbraer S A EMB-545 · S/N 55010217N283FXEmbraer S A EMB-545 · S/N 55010218N301FXEmbraer Executive EMB-505 · S/N 50500838N302FXEmbraer Executive EMB-505 · S/N 50500839
Back to Cleveland, OH