Wynne, AR
Cancelled registrations · 28
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 = 'AR' AND d.registrant_city = 'WYNNE' 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 = 'AR' AND d.registrant_city = 'WYNNE' 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.
N750ZEMichel Philippe J ZENITH CH750 · S/N 75-8101N725STAmpueda Tosta Allen J SKY HERO - SPY 600 · S/N DJI-MC1000761703N4835VCessna 172RG · S/N 172RG0396N60928Air Tractor AT-502B · S/N 502B-0283N198ASAir Tractor AT-402A · S/N 402A-1053N9431KStinson 108-2 · S/N 108-2431N6780SCessna 150H · S/N 15067580N5647XAero Commander S2R · S/N 1847RN9695Grumman Acft ENG Cor-Schweizer G-164A · S/N 1228N8106KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 567BN3649VCessna 140 · S/N 14920N41SDBell-Versatile 47G · S/N 1156N6112DAir Tractor AT-502B · S/N 502B0279N2292JAyres S2R-T34 · S/N T34-258N4779GWsk-Pzl-Mielec PZL-M-18 · S/N 1Z012-31N406YGrumman G-164 · S/N 216N8163KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 593BN4955XRockwell International S-2R · S/N 2163RN6602QGrumman Acft ENG Cor-Schweizer G-164A · S/N 1688N8375LCessna 172I · S/N 17256575N4861YPiper PA-25-235 · S/N 25-4663N9969WPiper PA-28-140 · S/N 28-23516N84996Champion 7BCM · S/N 7AC-3720N54873Timm N2T-1 · S/N 355N54661Boeing A75N1 · S/N 75-4551N64129Boeing B75N1 · S/N 75-7500N75642Boeing E75 · S/N 75-8577N60611Consolidated Vultee BT-13A · S/N 3565
Back to Wynne, AR