Grand Prairie, TX
Cancelled registrations · 637
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 = 'GRAND PRAIRIE' 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 = 'GRAND PRAIRIE' 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.
N457JDEurocopter Deutschland MBB-BK 117 C-2 · S/N 9134N236AHAirbus Helicopters MBB-BK117 D-3 · S/N 21407N149CFBeech C90 · S/N LJ-925N566AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9256N146AHAirbus Helicopters AS350B3 · S/N 9707N107AHAirbus Helicopters AS 350B3 · S/N 9695N453VEurocopter EC120B · S/N 1658N131AHAirbus Helicopters AS350B3 · S/N 9476N248AHAirbus Helicopters MBB-BK117 D-3 · S/N 21148N205AHAirbus Helicopters MBB-BK117 D-3 · S/N 21126N187AHAirbus Helicopters MBB-BK117 D-3 · S/N 21109N204AHAirbus Helicopters MBB-BK117 D-3 · S/N 21113N206AHAirbus Helicopters MBB-BK117 D-3 · S/N 21134N177AHAirbus Helicopters MBB-BK117 D-3 · S/N 21078N227AWSoaring Concepts SKY TREK · S/N A058SCIN136AHAirbus Helicopters MBB-BK117 D-3 · S/N 21098N163AHAirbus Helicopters MBB-BK117 D-3 · S/N 21068N133AHAirbus Helicopters MBB-BK117 D-3 · S/N 21094N105AHAirbus Helicopters MBB-BK117 D-3 · S/N 21044N161AHAirbus Helicopters MBB-BK117 D-3 · S/N 21058N162AHAirbus Helicopters MBB-BK117 D-3 · S/N 21063N184AHAirbus Helicopters MBB-BK117 D-3 · S/N 21087N94758Ercoupe 415-E · S/N 4869N178CBEurocopter EC120B · S/N 1409N156AHAirbus Helicopters MBB-BK117 D-3 · S/N 21100N194CBEurocopter EC120B · S/N 1443N371HSEurocopter EC120B · S/N 1471N3926AEurocopter EC120B · S/N 1598N320FCessna 320D · S/N 320D0020N126AHAirbus Helicopters MBB-BK117 D-3 · S/N 21054N378HSEurocopter EC120B · S/N 1566N241CBEurocopter EC120B · S/N 1459N376HSEurocopter EC120B · S/N 1559N9059ZAerostar International RX 8 · S/N S57A-3142N542AHAirbus Helicopters AS 350B3 · S/N 8643N114AHAirbus Helicopters MBB-BK 117 C-2 · S/N 9857N110AHAirbus Helicopters MBB-BK 117 C-2 · S/N 9856N117AHAirbus Helicopters Deutschland EC135 P3 · S/N 2103N135HXAirbus Helicopters Deutschland EC135 P3 · S/N 2080N499AHAirbus Helicopters Deutschland EC135 P3 · S/N 2068N911DGAirbus Helicopters AS350B3 · S/N 8895N564AHAirbus Helicopters AS 350B3 · S/N 8674N604AHAirbus Helicopters MBB-BK 117 C-2 · S/N 9845N605AHAirbus Helicopters MBB-BK 117 C-2 · S/N 9846N611AHAirbus Helicopters MBB-BK 117 C-2 · S/N 9848N622AHAirbus Helicopters MBB-BK 117 C-2 · S/N 9851N637AHAirbus Helicopters AS350B3 · S/N 8818N612AHAirbus Helicopters MBB-BK 117 C-2 · S/N 9849N585AHAirbus Helicopters AS 350B3 · S/N 8727N15714Piper PA-28-140 · S/N 28-7325143
Back to Grand Prairie, TX