Frisco, TX
Cancelled registrations · 186
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 = 'FRISCO' 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 = 'FRISCO' 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.
N49CLRaytheon B300 · S/N FL-268N582FLPiper PA-28-140 · S/N 28-7125437N4362PHage James LANCAIR 320 · S/N 0001N652ZRDJI PHANTOM 2 · S/N BE211510288233N86MCMichael Crider CYCLONE X8 OCTOCOPTE · S/N 001N773DR3D Robotics SOLO · S/N S111A5701211N612BADJI INSPIRE 1 · S/N W13DCC23020663N612WKGalaxy Uav Systems PENGUIN · S/N 1001N612THGalaxy Uav Systems PENGUIN · S/N 1002N249ZDJI S1000 · S/N 7163C26469EABB94D4AD7CD7C019CBN5904ZDJI PHANTOM 2 · S/N PJ645195263V1.0N4407TPiper PA-28R-200 · S/N 28R-7235089N2851ARans S-4 · S/N 93201N758ULCessna R172K · S/N R1723370N62LKLawrence Rex R KOLB FIRE STAR · S/N FS-99-400012N7140YPiper PA-30 · S/N 30-162N4441BBuckeye DM 582 · S/N 3533N939CKDassault FALCON 20 F · S/N 317N1678NHillam Scott L RANS S-9 · S/N 0193117N103MEDestiny XLT 2000 · S/N 1B0108N139GSAero Vodochody L39C · S/N 432833N67376Cessna 152 · S/N 15281792N6062WPiper PA-28-140 · S/N 28-20074N217MGPoland MIG 17 (LIM-5) · S/N 1C0314N4984KTemco D-16 · S/N TTN-30N208BFNord 1101 · S/N 154N602JDDooley MODEL DK-1 · S/N 002N88853Boeing A75N1(PT17) · S/N 75-2811N9255YBoeing A75 · S/N 75-849N310KWCessna T310R · S/N 310R1327N223PACessna 340A · S/N 340A0725N88DBCessna 310R · S/N 310R0274N56962Piper PA-32-260 · S/N 32-7400012N8686ABeech A35 · S/N D-2096N4914CCessna T210N · S/N 21063671N75700Consolidated Vultee BT-13 · S/N 6383
Back to Frisco, TX