Wichita Falls, TX
Cancelled registrations · 138
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 = 'TX' AND d.registrant_city = 'WICHITA FALLS' 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 = 'TX' AND d.registrant_city = 'WICHITA FALLS' 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.
N312EBRobinson Helicopter R44 II · S/N 14774N8031LCessna 172H · S/N 17256231N2916CCessna 180 · S/N 30816N41869Piper PA-28-151 · S/N 28-7415342N6681VBellanca 17-30 · S/N 30019N69YXJuergen Voll WAIEX-B · S/N WXB0017N4554DBeech G35 · S/N D-4702N4216DBeech G35 · S/N D-4414N2918HErcoupe 415-C · S/N 3543N365JGGeorge James W JR CHALLENGER II SPEC · S/N CH21088CW0365N190MMCurtis Moldenhauer LANCAIR IVP · S/N CM4N6257VBeech V35 · S/N D-8587N2522VPiper PA-31T · S/N 31T-8020078N81WEPiper PA-31T · S/N 31T-7920060N2440RCessna 182G · S/N 18255540N2649MJensen William A BJ1982 · S/N 001N449FPPowrachute PEGASUS · S/N A490PEGN247HCDJI PHANTOM 2 · S/N PH646051598N8400DPiper PA-22-160 · S/N 22-5653N899CCCartercopters 002 · S/N 001N5364SCessna 337A · S/N 337-0464N4348VPowrachute PEGASUS · S/N A-243 PEGN2525SCurtiss-Peek JN4D · S/N 1917N880SASab VULCAN C-100FG · S/N C22N571SBAmerican Champion 7GCBC · S/N 1412-2006N3320UCessna 182F · S/N 18254720N2535HSchweizer SGS 1-35 · S/N 53N3502YPowerchute PC 2000 · S/N A39POWN8935DPiper PA-22-160 · S/N 22-6093N339LCPowrachute PEGASUS · S/N A458PEGN6555UMooney M20C · S/N 2338N10397Mini John MINI BENSON GYRO PLA · S/N JM-001N3906JDouglas SUPER R4D-8 · S/N 43344N3874QCessna 172L · S/N 17259974N91VSSpies Somarna CHALLENGER II · S/N CH2-0298-1719N92WFChurch Niley M PULSAR · S/N 163N89445Cessna 140 · S/N 8477N7082YJames Gregory W LONG EZ · S/N 0001N35241Powrachute PEGASUS · S/N A204PEGN1472VDehavilland DH104 DOVE 6A · S/N 04302N32221MC Ginty Arthur M RAND ROBINSON KR-1 · S/N 5470N84996Moulton Ronald L BENSEN B-8M · S/N 1RTN84103Cessna 172K · S/N 17258333N5497QCessna 150L · S/N 15073397N26EPProphet VARIEZE · S/N 483N27269Fine-Smith STITS SA3A · S/N SF-1N5590ECessna 150 · S/N 17090N4818RCessna A188B · S/N 18802338N39491Stinson 10A · S/N 8191N23081Cessna 150H · S/N 15068716
Back to Wichita Falls, TX