Cleveland, OH
Cancelled registrations · 480
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.
N2448WSchweizer SGS 2-33 · S/N 14N6529LGrumman American Avn. AA-1B · S/N AA1B-0329N7166LAmerican AA-5 · S/N AA5-0466N6504LAmerican AA-1B · S/N AA1B-0304N8900LAmerican AA-1B · S/N AA1B-0300N9993LGrumman American Avn. AA-1B · S/N AA1B-0293N7116LAmerican AA-5 · S/N AA5-0416N7101LGrumman American Avn. AA-5 · S/N AA5-0401N6065LGrumman American Avn. AA-5 · S/N AA5-0165N9929LGrumman American Avn. AA-1B · S/N AA1B-0229N501BDBede BD-5 · S/N 2N5821LAmerican AA-5 · S/N AA5-0221N9696LGrumman American Avn. AA-1B · S/N AA1B-0196N69591Cessna 310Q · S/N 310Q0806N74999Piper PA-31-350 · S/N 31-7405401N5428LAmerican AA-5 · S/N AA5-0328N9608LGrumman American Avn. AA-1B · S/N AA1B-0108N40233Piper PA-23-250 · S/N 27-7305033N5698ECessna 150 · S/N 17198N5436LAmerican AA-5 · S/N AA5-0336N5422LAmerican AA-5 · S/N AA5-0322N9512LAmerican AA-5 · S/N AA5-0249N6616YPiper PA-23-250 · S/N 27-3922N7491LPiper PA-31 · S/N 31-7300915N5836LAmerican AA-5 · S/N AA5-0236N5990LAmerican AA-5 · S/N AA5-0239N6151LGrumman American Avn. AA-5 · S/N AA5-0241N7359LAmerican AA-1B · S/N AA1B-0059N7372LGrumman American Avn. AA-5 · S/N AA5-0272N9635LAmerican AA-1B · S/N AA1B-0135N9637LGrumman American Avn. AA-1B · S/N AA1B-0137N6374LAmerican AA-5 · S/N AA5-0244N14390Piper PA-23-250 · S/N 27-7304986N6099LAmerican AA-5 · S/N AA5-0258N9543FHughes 269B · S/N 1280403N14279Piper PA-23-250 · S/N 27-4841N6885YPiper PA-23-250 · S/N 27-4235N6422LAmerican AA-1A · S/N AA1A-0422N6323FCessna 337A · S/N 337-0323N8680CPiper PA-22-135 · S/N 22-1340N6335RPiper PA-28-140 · S/N 28-21504N5633LAmerican AA-1 · S/N AA1-0033N6318LAmerican AA-1A · S/N AA1A-0318N6319LAmerican AA-1A · S/N AA1A-0319N707CAAero Commander 500-B · S/N 500B-1143-79N6914SCessna 150H · S/N 15067614N5425CCessna 170B · S/N 19459N9389LAmerican AA-1A · S/N AA1A-0089N9345LAmerican AA-1A · S/N 045N34398Meyers Industries 200A · S/N 255
Back to Cleveland, OH