Belleville, IL
Cancelled registrations · 67
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 = 'IL' AND d.registrant_city = 'BELLEVILLE' 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 = 'IL' AND d.registrant_city = 'BELLEVILLE' 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.
N6503LGrumman American Avn. AA-1B · S/N AA1B-0303N56163Piper PA-28R-200 · S/N 28R-7335371N9346XCessna 182E · S/N 18253746N22473Cessna 150H · S/N 15068304N2609KLuscombe 8E · S/N 5336N45848Silvaire LUSCOMBE 8C · S/N 2375N57961Noorduyn UC-64A · S/N 838N64267Aeronca 0-58B · S/N C3252TAN63617Fairchild M-62C(PT-23A) · S/N 333-HON48179Boeing A75N1 · S/N 75-1018N48184Boeing A75N1 · S/N 75-1046N48189Boeing A75N1 · S/N 75-1132N22110Aeronca 50-C · S/N C-2168N48278Taylorcraft DCO-65 · S/N L-5395N38324Piper J3F-65 · S/N 6932N546NJohnson-Heath MODEL A · S/N 1N899Standard J-1 · S/N PA27
Back to Belleville, IL