Elk Grove Village, IL
Cancelled registrations · 21
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 = 'ELK GROVE VILLAGE' 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 = 'ELK GROVE VILLAGE' 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.
N3838JScrabeck Jerald TITAN BEMMER · S/N 001N611ARBoeing 747-128 · S/N 19749N6088XMooney M20A · S/N 1684N3632GWarwick TINY CHAMP M-I · S/N 1960N92TBBolger Terence A BUCCANEER II · S/N B2BK048N108UABoeing 747-422 · S/N 26903N1855UMcdonnell-Douglas DC-10-30 · S/N 47837N610ARBoeing 747-128 · S/N 20800N200AUBoeing 737-201 · S/N 19418N601ARBoeing 727-228 · S/N 19865N602ARBoeing 727-228 · S/N 20075N78020Boeing 747-243B · S/N 19731N210DSBoeing 720-047B · S/N 18167N1910HSeverson Aeroplane I · S/N 1N17207Boeing 720-024B · S/N 19002N57201Boeing 720-024B · S/N 18416N57205Boeing 720-024B · S/N 18587N62119Boeing 727-30 · S/N 18934N4005NMooney M20F · S/N 680158N2315Spinner B-8M · S/N 1N7668PPiper PA-24 · S/N 24-2881
Back to Elk Grove Village, IL