The Woodlands, TX
Cancelled registrations · 26
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 = 'THE WOODLANDS' 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 = 'THE WOODLANDS' 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.
N24LJGates Lear Jet 24E · S/N 345N240HLAir Tractor AT-602 · S/N 602-1331N605GSCostruzioni Aeronautiche Tecna P2010 · S/N 129/USN522BACessna 421B · S/N 421B0555N6654JPiper PA-28-180 · S/N 28-5138N4132HRobinson Helicopter R44 · S/N 2403N320DMDJI INSPIRE 1 · S/N W13DCF19040347N7937GCessna 172L · S/N 17259637N43439Piper PA-28-151 · S/N 28-7415540N19440Monocoupe 90A · S/N A790N693VWHobbico FLYZONE CALYPSO · S/N 20062N355DSDiamond Aircraft Ind DA 40 · S/N 40.1083N233BWWills Chris A HURRICANE II · S/N 0115-2N841TADouglas DC-6B · S/N 44891N4243AAvions Mudry ET Cie CAP 10B · S/N EPC-164N29TWWilson Theodore Taylor CHALLENGER II · S/N CH20987B0272N3688DCessna 310 · S/N 35388N732TGCessna T210M · S/N 21061757N71979Luscombe 8A · S/N 3406N51593Maule M-5-210C · S/N 6035CN7681HRobinson Helicopter R22 BETA · S/N 3852N2430SCessna T210L · S/N 21061279N3409XMooney M20F · S/N 670031N4834NCessna 182Q · S/N 18267404N5238HCessna 152 · S/N 15284071N75087Navion L-17C · S/N NAV4965
Back to The Woodlands, TX