Flower Mound, TX
Cancelled registrations · 37
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 = 'FLOWER MOUND' 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 = 'FLOWER MOUND' 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.
N247TDJones Daniel F RV-8 · S/N 80247N490AVBell Helicopter Textron Canada 412EP · S/N 36490N7655BBellanca 14-19-2 · S/N 4006N21XXSchleicher ASW-19 · S/N 19157N7174QAerostar International RX 8 · S/N RX8-3276N9189EAeronca 11AC · S/N 11AC-823N850JCBeech 76 · S/N ME-163N695ZZBlade CHROMA · S/N 2686530169N23764Quad City Challenger CHALLENGER II · S/N CH2-0597-C-1611N750HADJI INSPIRE 1 · S/N W130CH08040905N4986XRockwell International S-2R · S/N 5031RN521CACessna T-310P · S/N 310P0022N1111WHuff HUFFAIRE MONOPLANE · S/N 1N778JAHawker Siddeley BH.125-400A · S/N NA778N6613PPiper PA-24 · S/N 24-1734N6371TRaven Industries S-60A · S/N S60A-3167N756WNCessna U206G · S/N U20604416N5347UCessna U206G · S/N U20605228N62APCessna U206G · S/N U20604252N98XBaker Kevin V VELOCITY RG · S/N DM241N93352Ercoupe 415-D · S/N 675N3106KHead Balloons AX9 118 · S/N 292N8818RDowner BELLANCA 14-19-3 · S/N 4170N728USBoeing 727-214 · S/N 20168N589CStinson 108-3 · S/N 108-3589N478DMAviat A-1A · S/N 1450N988ACCessna 172S · S/N 172S9039N6539PCessna P210N · S/N P21000188N6706JPiper PA-28-140 · S/N 28-24402N367JRReeves John L PULSAR 912-XP · S/N 367N719USBoeing 727-214 · S/N 20163N720USBoeing 727-214 · S/N 20164N721USBoeing 727-214 · S/N 20165N722USBoeing 727-214 · S/N 20166N723USBoeing 727-214 · S/N 20167N729USBoeing 727-214 · S/N 20366N730USBoeing 727-214 · S/N 20367
Back to Flower Mound, TX