Plano, TX
Cancelled registrations · 206
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 = 'PLANO' 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 = 'PLANO' 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.
N1568JPiper PA-28-140 · S/N 28-23973N39SBStephen Michael Bowen 700MM QUADCOPTER · S/N 39N6030LAmerican AA-5 · S/N AA5-0130N223BGDassault FALCON 20 F · S/N 250N63106Piper J3C-65 · S/N 16159N8672CPiper PA-18A-135 · S/N 18-2818N9983Grumman Acft ENG Cor-Schweizer G-164A · S/N 1379N117PNBlade 350 QX3 · S/N 3428468302N589ZMDJI PHANTOM 3 PROFESSION · S/N P76DCH03016549N4017QWhitesell Paul VIKING · S/N 3878566N1997DBeech C35 · S/N D-3260N470PWBeech C35 · S/N D-2692N7342BBeech E35 · S/N D-3805N95240Taylorcraft BC12-D · S/N 9640N21PWBalloonport Of Texas VEGAS 634 · S/N 634-01N61161Infinity INFINITY 582 · S/N IPP2 064N169PADiamond Aircraft Ind DA20-C1 · S/N C0270N451BBAircraft Mfg & Dvlpmt CH601XLI SLSA · S/N 601-051SN6535RBeech C23 · S/N M-1578N91NSCameron Balloons US V-90 · S/N 5650N843ASBombardier CL-600-2B19 · S/N 7310N600MKBeechcraft-Hawker BH-125-600A · S/N 256004N52788Cessna 172P · S/N 17274606N1392VDonald A D SONERAI II · S/N 237-1N2400MElliott Franklin B MONNETT MONI · S/N 099N417DCessna R172K · S/N R1723303N33NSBeech 58 · S/N TH-1340N449KABoeing 737-3Y0 · S/N 24256N369PTCessna T210L · S/N 21061150N531MHCessna 401A · S/N 401A0097N41975Raven S55A · S/N S55A-949N6914RCessna T210H · S/N T210-0314N5081TBeech 19A · S/N MB-338N550PSCzech Sport PIPER SPORT · S/N P1001060N2984LCameron Balloons US 0-105 · S/N 5152N6379RPiper PA-28-140 · S/N 28-21553N60623Cessna 150J · S/N 15070455N493SABoeing 737-4Q3 · S/N 29487N5369TPiper PA-28R-200 · S/N 28R-7235227N1206CPiper PA-22-135 · S/N 22-1012N5981QMooney M20C · S/N 3209N263JBBurpee Gerald M BIRDMAN TL-1A · S/N 263N2MCCapehart VOLKSPLANE WE-1 · S/N CA1N1581VCessna 172M · S/N 17263678N8084GNorth American T-6G · S/N 49-3437N674NNorth American AT-6C · S/N 88-14362N48LTTurner Lisa P TWINSTAR MK-III · S/N MT-99-3-00009N40160Iar Sa Brasov IAR 823 · S/N 40N89551Cessna 152 · S/N 15282782N20400Cameron Balloons V-77 · S/N 5393
Back to Plano, TX