Cleveland, OH
Cancelled registrations · 478
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'OH' AND d.registrant_city = 'CLEVELAND' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'OH' AND d.registrant_city = 'CLEVELAND' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N604FXEmbraer EMB-550 · S/N 55020186N711AUGulfstream Aerospace GVI (G650ER) · S/N 6251N420FLRaytheon 400A · S/N RK-310N657FXGulfstream Aerospace GVI · S/N 6047N467FLRaytheon 400A · S/N RK-468N589KGulfstream Aerospace GV-SP (G550) · S/N 5235N97FXBombardier BD-700-1A10 · S/N 9252N438LXRaytheon 400A · S/N RK202N465FLRaytheon 400A · S/N RK-426N94FXBombardier BD-700-1A10 · S/N 9242N648FXGulfstream Aerospace GVI (G650) · S/N 6146N5043PPiper PA-24 · S/N 24-46N7926HDJI PHANTOM 3 PROFESSION · S/N P78DCJ26061484N456FLRaytheon 400A · S/N RK-365N402FXEmbraer EMB-550 · S/N 55000028N5549MCessna 152 · S/N 15284612N289KCanadair CL-600-2B16 · S/N 5132N941JRBombardier BD-100-1A10 · S/N 20022N401FXEmbraer EMB-550 · S/N 55000027N498LXRaytheon 400A · S/N RK-265N800GVRaytheon 400A · S/N RK-271N400FXEmbraer EMB-550 · S/N 55000025N402FLRaytheon 400A · S/N RK201N60915Noorduyn UC-64 · S/N 345N748UJDJI PHANTOM 3 PROFESSION · S/N P76DCF29016283N70320Piper J3C-65 · S/N 17298N93REMooney M20E · S/N 679N48545Taylorcraft DC-65 · S/N 4299N2056YCessna 172D · S/N 17249556N908FLEmbraer EMB-135BJ · S/N 14500942N32382Rearwin 175 · S/N 1531N712SBoeing 737-2Y5 · S/N 23038N3811HErcoupe 415-CD · S/N 4512N97209Stinson 108-3 · S/N 108209N443CDJI PHANTOM 2 VISION + · S/N PH645301023N52303Mauro Lawrence B HUMMELBIRD · S/N 1N43363Taylorcraft BC12-D · S/N 7022N87725Piper J3C-65 · S/N 15383N8173KStinson 108 · S/N 1081173N8514KStinson 108-2 · S/N 108-1514N64073Fairchild M-62A · S/N FW887N462CTFlight Design CTSW · S/N 06-10-12N9462Great Lakes 2T-1 · S/N 264N11TBButler EAA BIPLANE 1 · S/N 296N1182NCessna T337G · S/N P3370215N605NALearjet 23 · S/N 23-049N2YXHoward Ben O DGA-3 · S/N 67N99512Engineering & Research ERCOUPE 415-C · S/N 2135N99972Engineering & Research 415-C · S/N 2595N52153Fairchild M-62A · S/N T437060
Back to Cleveland, OH