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.

N372VKShield Ai V-BAT · S/N VB-100270Cancelled Aug 7, 2025 · Sheild Ai IncN372XSShield Ai V-BAT · S/N VB-100269Cancelled Aug 7, 2025 · Shield Ai IncN372YFShield Ai V-BAT · S/N VB-100268Cancelled Aug 7, 2025 · Shield Ai IncN372ZGShield Ai V-BAT · S/N VB-100267Cancelled Aug 7, 2025 · Shield Ai IncN373ADShield Ai V-BAT · S/N VB-100264Cancelled Aug 7, 2025 · Shield Ai IncN373CRShield Ai V-BAT · S/N VB-100263Cancelled Aug 7, 2025 · Shield Ai IncN373DWShield Ai V-BAT · S/N VB-100262Cancelled Aug 7, 2025 · Shield Ai IncN373NFShield Ai V-BAT · S/N VB-100261Cancelled Aug 7, 2025 · Shield Ai IncN929QMMartin Uav V-BAT · S/N VBP-100029Cancelled Aug 7, 2025 · Shield Ai IncN930JEMartin Uav V-BAT · S/N VBP-200001Cancelled Aug 7, 2025 · Shield Ai IncN227XSShield Ai V-BAT · S/N VB-100180Cancelled Mar 11, 2025 · Shield Ai IncN852DCShield Ai V-BAT · S/N VB-200013Cancelled Mar 11, 2025 · Shield Ai IncN848DCShield Ai V-BAT · S/N VB-200009Cancelled Feb 6, 2025 · Shield Ai IncN930HTMartin Uav V-BAT · S/N VBP-200002Cancelled Feb 6, 2025 · Shield Ai IncN849DCShield Ai V-BAT · S/N VB-200010Cancelled Jan 8, 2025 · Shield Ai IncN227PVShield Ai V-BAT · S/N VB-100185Cancelled Jan 7, 2025 · Shield Ai IncN9291MMartin Uav V-BAT · S/N VBP-200004Cancelled Oct 31, 2024 · Shield Ai IncN9293MMartin Uav V-BAT · S/N VBP-200005Cancelled Oct 31, 2024 · Shield Al IncN929ZRMartin Uav V-BAT · S/N VBP-200006Cancelled Oct 31, 2024 · Shield Ai IncN287CFShield Ai V-BAT · S/N VB-100221Cancelled Sep 26, 2024 · Shield Ai IncN37DCShield Ai V-BAT · S/N VB-100174Cancelled Sep 26, 2024 · Shield Ai IncN888BALearjet 45 · S/N 451Cancelled Sep 3, 2024 · Exported to Mexico · Built 2012 · Arc Aviation LLCN1161WShield Ai V-BAT · S/N VB-100107Cancelled Jul 19, 2024 · Shield Ai IncN228AAShield Ai V-BAT · S/N VB-100182Cancelled Jul 19, 2024 · Shield Ai IncN778MVMartin Uav V-BAT · S/N VBP-036Cancelled Jul 16, 2024 · Sale reportedN779MVMartin Uav V-BAT · S/N VBP-047Cancelled Jul 16, 2024 · Sale reported · Built 2020N922KYMartin Uav V-BAT · S/N VBP-019Cancelled Jul 16, 2024 · Sale reportedN930ZMMartin Uav V-BAT · S/N VBP-44Cancelled Jul 16, 2024 · Sale reportedN2264VShield Ai V-BAT · S/N VB-100173Cancelled Jun 14, 2024 · Shield Ai IncN1155AShield Ai V-BAT · S/N VB-100101Cancelled Jun 5, 2024 · Shield Ai IncN2073UShield Ai V-BAT · S/N VB-100149Cancelled Jun 5, 2024 · Shield Ai IncN116MTShield Ai V-BAT · S/N VB-100105Cancelled May 31, 2024 · Shield Ai IncN1180DShield Ai V-BAT · S/N VB-100120Cancelled May 31, 2024 · Shield Ai IncN118HSShield Ai V-BAT · S/N VB-100119Cancelled May 31, 2024 · Shield Ai IncN2268VShield Ai V-BAT · S/N VB-100172Cancelled May 31, 2024 · Sheild Ai IncN929WJMartin Uav V-BAT · S/N VBP-100023Cancelled May 31, 2024 · Built 2022 · Martin Uav LLCN949PKMartin Uav V-BAT · S/N VBP-100051Cancelled May 31, 2024 · Martin Uav LLCN974NMMartin Uav V-BAT · S/N VB-100081Cancelled May 31, 2024 · Martin Uav LLCN974SVMartin Uav V-BAT · S/N VB-100099Cancelled May 31, 2024 · Martin Uav LLCN204SUShield Ai V-BAT · S/N VB-100159Cancelled Feb 21, 2024 · Sheild Ai IncN2042DShield Ai V-BAT · S/N VB-100153Cancelled Feb 19, 2024 · Shield Ai IncN774MVMartin Uav V-BAT · S/N VBP-009Cancelled Feb 19, 2024 · Built 2018 · Martin Uav LLCN910SMMartin Uav V-BAT · S/N VBP-100013Cancelled Feb 19, 2024 · Built 2022 · Sheild Ai IncN922GFMartin Uav V-BAT · S/N VBP-100011Cancelled Feb 19, 2024 · Martin Uav LLCN931RMMartin Uav V-BAT · S/N VBP-100026Cancelled Feb 19, 2024 · Built 2022 · Martin Uav LLCN951LMMartin Uav V-BAT · S/N VB-100066Cancelled Nov 4, 2023 · Martin Uav LLCN6797LCessna 421C · S/N 421C1050Cancelled Sep 5, 2023 · Regional Aviation LLCN77UV3D Robotics SOLO · S/N S111A5500871Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Crider MichaelN43031Aerospatiale AS350B · S/N 1437Cancelled Apr 2, 2022 · Registration expired, pending cancellation · 2008r44llcN60181Lindstrand Balloons 180A · S/N 5135Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 2000 · Broker William
Back to Frisco, TX