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.

N49CLRaytheon B300 · S/N FL-268Cancelled Jan 26, 2021 · Exported to Mexico · Built 1999 · Arc Aviation LLCN582FLPiper PA-28-140 · S/N 28-7125437Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1971 · Jabour Joshua JohnN4362PHage James LANCAIR 320 · S/N 0001Cancelled Jan 31, 2020 · Second renewal notice · Built 1998 · Williams Glen EN652ZRDJI PHANTOM 2 · S/N BE211510288233Cancelled Sep 6, 2019 · Registration expired, pending cancellation · National Association Of Expert Advisors IncN86MCMichael Crider CYCLONE X8 OCTOCOPTE · S/N 001Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Crider MichaelN773DR3D Robotics SOLO · S/N S111A5701211Cancelled May 6, 2019 · Registration expired, pending cancellation · Eakin MeltonN612BADJI INSPIRE 1 · S/N W13DCC23020663Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Galaxy Uav SystemsN612WKGalaxy Uav Systems PENGUIN · S/N 1001Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Galaxy Uav SystemsN612THGalaxy Uav Systems PENGUIN · S/N 1002Cancelled Mar 8, 2019 · Registration expired, pending cancellation · Galaxy Uav SystemsN249ZDJI S1000 · S/N 7163C26469EABB94D4AD7CD7C019CBCancelled Feb 5, 2019 · Registration expired, pending cancellation · Zvanik Marco FN5904ZDJI PHANTOM 2 · S/N PJ645195263V1.0Cancelled Jan 17, 2019 · Registration expired, pending cancellation · Zvanik Marco FN4407TPiper PA-28R-200 · S/N 28R-7235089Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 1972 · Navar RobertN2851ARans S-4 · S/N 93201Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 2000 · Barajas FabianN758ULCessna R172K · S/N R1723370Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1980 · Morales RobertN62LKLawrence Rex R KOLB FIRE STAR · S/N FS-99-400012Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 2001 · Lawrence Rex RN7140YPiper PA-30 · S/N 30-162Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1963 · Cooper Edward BN4441BBuckeye DM 582 · S/N 3533Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Barajas FabianN939CKDassault FALCON 20 F · S/N 317Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1974 · Alexa Air Charters LLCN1678NHillam Scott L RANS S-9 · S/N 0193117Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1994 · Mcduff Mike AN103MEDestiny XLT 2000 · S/N 1B0108Cancelled May 20, 2015 · Registration expired, pending cancellation · Arias AlejandroN139GSAero Vodochody L39C · S/N 432833Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1984 · Warbird Education FoundationN67376Cessna 152 · S/N 15281792Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1978 · Kit Fun IncN6062WPiper PA-28-140 · S/N 28-20074Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1964 · Etherington Glenn A TrusteeN217MGPoland MIG 17 (LIM-5) · S/N 1C0314Cancelled Aug 27, 2013 · Sale reported, canceledN4984KTemco D-16 · S/N TTN-30Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1949 · Silberman TedN208BFNord 1101 · S/N 154Cancelled May 14, 2013 · Registration expired, pending cancellation · Case Marion HN602JDDooley MODEL DK-1 · S/N 002Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1974 · Dooley John WN88853Boeing A75N1(PT17) · S/N 75-2811Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1941N9255YBoeing A75 · S/N 75-849Cancelled Feb 14, 2013 · Sale reported, canceledN310KWCessna T310R · S/N 310R1327Cancelled Feb 28, 2012 · Exported to Australia · Built 1978 · Jerry Temple Aviation IncN223PACessna 340A · S/N 340A0725Cancelled May 26, 2010 · Exported to Israel · Built 1979 · Jerry Temple Aviation IncN88DBCessna 310R · S/N 310R0274Cancelled Nov 4, 2005 · Exported to Mexico · Built 1975 · Jerry Temple Aviation IncN56962Piper PA-32-260 · S/N 32-7400012Cancelled Jun 13, 2003 · Exported to Mexico · Built 1973 · Flinn Philip RN8686ABeech A35 · S/N D-2096Cancelled Mar 26, 2001 · Greenawalt Jeffrey EN4914CCessna T210N · S/N 21063671Cancelled Nov 18, 1999 · Exported to Portugal · Jerry Temple Aviation IncN75700Consolidated Vultee BT-13 · S/N 6383Cancelled Sep 16, 1952 · Built 1942 · Christie Joe William
Back to Frisco, TX