Staunton, IL
Cancelled registrations · 199
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 = 'STAUNTON' 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 = 'STAUNTON' 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.
N40799Piper PA-28-180 · S/N 28-7405067N6117KCessna 150M · S/N 15077534N6340ZPiper PA-25 · S/N 25-523N6844FCessna 150F · S/N 15063444N8296FCessna 150F · S/N 15064396N2501LCessna 172H · S/N 17255701N246LBeech 95-B55 (T42A) · S/N TC-502N2059QCessna 177RG · S/N 177RG0459N757LDCessna 152 · S/N 15279817N1140FCessna 172G · S/N 17254735N1290UCessna 172M · S/N 17266984N7682KPiper PA-20 · S/N 20-504N3005LCessna 310J · S/N 310J0005N43102Cessna 172H · S/N 17255566N105ASocata TB 10 · S/N 590N9372RCessna A188B · S/N 18802263TN24LHCessna TR182 · S/N R18200769N4045VCessna 150M · S/N 15076683N4307UCessna 152 · S/N 15283725N4189QPiper PA-28-161 · S/N 28-7716172N4957VCessna 172RG · S/N 172RG0426N5290KCessna 172P · S/N 17274047N43844Piper PA-28-181 · S/N 28-7890029N70397Cessna 172M · S/N 17267213N4253SPiper PA-22-135 · S/N 22-728N2653VCessna 170 · S/N 18163N4877VCessna T303 · S/N T30300282N9795LBeech C23 · S/N M-1400N4309DCessna 152 · S/N 15284928N6294JPiper PA-28-151 · S/N 28-7615358N6783TCessna 310D · S/N 39083N731RDCessna A188B · S/N 18803088TN40991Piper PA-28-151 · S/N 28-7415128N6240ZPiper PA-25 · S/N 25-291N4735DCessna 182A · S/N 34835N49856Cessna 152 · S/N 15281361N5002FPiper PA-32R-300 · S/N 32R-7780001N45072Cessna 150M · S/N 15076723N3055ZPiper PA-22-160 · S/N 22-7010N3140QCessna 182K · S/N 18258140N33JECessna 310B · S/N 35555N2647QCessna 182K · S/N 18257847N24724Cessna 152 · S/N 15280340N2339UCessna 172D · S/N 17249939N2315UCessna 172D · S/N 17249915N266ERPiper PA-44-180 · S/N 44-8195012N5343KCessna 172P · S/N 17274073N5685RCessna 172F · S/N 17253327N923QBeech 65-80 · S/N LD-123N25919Cessna 152 · S/N 15280858
Back to Staunton, IL