Toledo, OH
Registered aircraft · 55
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 = 'TOLEDO' 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 = 'TOLEDO' 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.
N1024HPiper PA-28-151 · S/N 28-7715302N1100WDJI MAVIC AIR 2S · S/N 3YTBJ94003015QN112HGBeech C90 · S/N LJ529N1200YCessna 150B · S/N 15059600N120BCCessna P210N · S/N P21000404N12525Cessna 172M · S/N 17262040N127AKAviat A-1B · S/N 2059N1458NPiper J3C-65 · S/N 22996N1827PPiper PA-22-150 · S/N 22-2607N195AJPiper PA-32R-301 · S/N 3213096N1MWCessna 525B · S/N 525B0351N2014Cessna 180J · S/N 18052338N213TCCastlebary Tom GLASAIR · S/N 213N2197BLuscombe 8A · S/N 6624Registration pendingN251NGPilatus PC-12/47E · S/N 1251N2830RCessna 182K · S/N 18258430N328LPJ Cresswell SPORTSMAN AMPH VJ22 · S/N WJBC-1-1-67N338NPiper PA-60-602P · S/N 60-8365008N34PLCessna T206H · S/N T20608403N36WHExtra Flugzeugproduktions-Und EA 300/LT · S/N LT002N3829RCessna 172H · S/N 17255329N4034JCessna 150G · S/N 15065334N419AKPiper PA-18 · S/N 18-1067N4482JPiper PA-28-140 · S/N 28-22899N4502ZPiper PA-22-108 · S/N 22-8002N45PVGrumman G-44 · S/N 1380N46529Cessna 172K · S/N 17257329N47578Piper PA-28-161 · S/N 28-7816100N494SRCirrus Design SR22 · S/N 2263N524BHHoot Brian D GLASAIR SUPER IIS TD · S/N 2280N551BHHoot Brian D EAGLE R&D LTD CO · S/N 6-31N555TQSocata TBM 700 · S/N 555N656SSwann Gary F GLASAIR SUPER II RG · S/N 2255N66EWDassault-Breguet MYSTERE FALCON 200 · S/N 492N69RHCessna 401A · S/N 401A-0122N72USCessna 182S · S/N 18280936N7603JPiper PA-28R-180 · S/N 28R-30995N78LFAgustawestland Philadelphia AW119MKII · S/N 14963N811HGEmbraer Executive EMB-505 · S/N 50500646N827VBeech A36 · S/N E907N834AFLearjet 31A · S/N 225N8559Schempp-Hirth STANDARD CIRRUS · S/N 70N863PJBeechcraft G36 · S/N E-4042N86605Bellanca 7GCAA · S/N 288-74N86GTBalloon Works FIREFLY 7 · S/N F7-276N8848PPiper PA-24-260 · S/N 24-4303N8942DPiper PA-22-160 · S/N 22-6100First renewal noticeN90HACessna 172N · S/N 17272658N9194JPiper PA-28-180 · S/N 28-3262N91SVAgusta A109E · S/N 11627
Back to Toledo, OH