OpenAirDocs.org
Hialeah, FL

Cancelled registrations · 261

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 = 'FL' AND d.registrant_city = 'HIALEAH'
  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.

N2534NPiper PA-38-112 · S/N 38-79A0903Cancelled Oct 24, 2007 · Triennial form not returned · Built 1979 · Pumarol AngelN74KTAerospatiale AS350B · S/N 1928Cancelled Apr 27, 2007 · Exported to Dominican Republic · Built 1986 · Redhawk Air LLCN7151TCessna 172 · S/N 46751Cancelled Oct 11, 2006 · Triennial form not returned · Built 1959 · Leyva Gustavo AN901DFCessna A185F · S/N 18503991Cancelled May 10, 2006 · Exported to Canada · Built 1980 · Fox Electric Enterprises IncN3011HPiper PA-44-180 · S/N 44-7995194Cancelled Apr 17, 2006 · Exported to Panama · Built 1978 · Skyline Enterprises CorpN7554XCessna 172B · S/N 17248054Cancelled Jan 30, 2006 · Triennial form not returned · Built 1960 · Lopez RichardN6127UCessna T210R · S/N 21064907Cancelled Nov 7, 2005 · Exported to Venezuela · Skyline Enterprises CorpN38SUBeech 1900C · S/N UC-38Cancelled May 3, 2005 · Exported to Colombia · Built 1988 · Skyline EnterprisesN6126XAero Commander 560-F · S/N 560F-993-7Cancelled Aug 18, 2004 · Exported to Venezuela · Built 1961 · Rg International Aircraft CorpN198BCBeech 65-A90 · S/N LJ-147Cancelled Feb 24, 2004 · Exported to Venezuela · Built 1966 · Rg International Aircraft CorpN86QBeech 200 · S/N BB300Cancelled Feb 11, 2004 · Exported to Panama · Built 1977 · Rg International Aircraft CorpN90806Beech 200 · S/N BB-33Cancelled Feb 3, 2004 · Exported to Panama · Built 1975 · Rg International Aircraft CorpN901FAPiper PA-31-350 · S/N 31-7552041Cancelled Aug 14, 2003 · Exported to Canada · Built 1975 · Fox Aviation International IncN339VHRobinson Helicopter R22 MARINER · S/N 2305MCancelled Jul 31, 2003 · Exported to Mexico · Built 1993 · Florida Jet Support IncN100FEBeagle B.206 SERIES 2 · S/N 032Cancelled Feb 11, 2003 · Triennial form not returned · Built 1966 · Hall Edward EN42086Mcdonnell Douglas DC-8-62 · S/N 46132Cancelled Sep 26, 2002 · Exported to Peru · Built 1970 · International Air Leases Of Pr IncN119SWBoeing 737-2N7 · S/N 21226Cancelled Jun 13, 2002 · Exported to Indonesia · Bbc Aircraft LLCN137AAMcdonnell-Douglas DC-10-30 · S/N 47847Cancelled May 16, 2002 · Sale reported · Built 1973N144AAMcdonnell-Douglas DC-10-30 · S/N 47848Cancelled May 16, 2002 · Sale reported · Built 1974N41840Douglas DC-6B · S/N 43525Cancelled Feb 20, 2002 · Triennial form not returned · Built 1952 · Banderas J FernandoN9823WPiper PA-28-140 · S/N 28-23325Cancelled Jan 9, 2002 · Triennial form not returned · Built 1967 · Clero Enterprises IncN132SWBoeing 737-200 · S/N 21227Cancelled Aug 2, 2001 · Exported to Indonesia · Bbc Aircraft LLCN3044XCessna 150F · S/N 15064444Cancelled Jan 30, 2001 · Triennial form not returned · Clero Jorge JN2818WBoeing 727-247 · S/N 20874Cancelled Aug 28, 2000 · Exported to Brazil · Ial Aircraft Holding IncN935PGGoral Paul VELOCITY RG · S/N DM0167Cancelled Feb 23, 2000 · Triennial form not returned · Coral PaulN4948HCessna 152 · S/N 15284041Cancelled Jan 7, 2000 · Exported to Spain · Alen Sergio RN5642GCessna 150K · S/N 15071142Cancelled Jul 6, 1999 · Exported to Chile · Guell Julio AN778JWCessna 421B · S/N 421B0577Cancelled Apr 21, 1999 · Exported to Turks and Caicos Islands · Chan Jon Chu Guillaume HN91392Boeing 727-21 · S/N 18997Cancelled Feb 4, 1999 · Triennial form not returned · Air Taxi International IncN11412Boeing 727-100 · S/N 18874Cancelled Jan 19, 1999 · Triennial form not returned · Air Taxi International IncN11415Boeing 727-51 · S/N 19122Cancelled Jan 19, 1999 · Triennial form not returned · Air Taxi International IncN737RDBoeing 737-291 · S/N 20365Cancelled Aug 6, 1998 · Ial Aircraft Holding Inc TrusteeN313EALockheed L-1011-385-1 · S/N 1020Cancelled May 12, 1998 · Triennial form not returned · Ial Aircraft Holding IncN6658YBoeing 737-248 · S/N 20221Cancelled Nov 26, 1996 · Exported to Chile · Ial Aircraft Holding IncN142PMFokker F27 · S/N 10122Cancelled Aug 1, 1996 · Exported to Gambia · Chon Dal IncN143PMFokker F.27MK 100 · S/N 10109Cancelled Aug 1, 1996 · Exported to Gambia · Chon Dal IncN144PMFokker F.27MK 100 · S/N 10107Cancelled Aug 1, 1996 · Exported to Gambia · Chon Dal IncN141PMFokker F.27MK 100 · S/N 10114Cancelled Apr 4, 1996 · Exported to Peru · Chon Dal IncorporatedN379PABoeing 727-2B7 · S/N 20302Cancelled Mar 26, 1996 · Triennial form not returned · Ial Aircraft Holding IncN40482Boeing 727-22 · S/N 18330Cancelled Jan 5, 1996 · Exported to Nigeria · Aerospace International Group IncN67AFBoeing 737-222 · S/N 19554Cancelled Nov 28, 1995 · Exported to Peru · Ial 361 IncN2439BPiper PA-38-112 · S/N 3879A0062Cancelled Sep 7, 1995 · Triennial form not returned · Hardisson JohnN8833EBoeing 727-225 · S/N 20152Cancelled Jul 21, 1995 · Exported to Canada · Interair Leases IncN9119BCessna 172 · S/N 36719Cancelled Jul 13, 1995 · Triennial form not returned · Sigler JosephN145PMFokker F.27MK 100 · S/N 10116Cancelled May 19, 1995 · Exported to Venezuela · Chon Dal IncorporatedN325ASBoeing 727-247 · S/N 20267Cancelled Apr 26, 1995 · International Air Leases IncN326ASBoeing 727-247 · S/N 20268Cancelled Apr 10, 1995 · Exported to Mexico · Interair Leases IncN2778WMooney M20C · S/N 3359Cancelled Dec 21, 1994 · Triennial form not returned · Feijoo AntonioN64AFBoeing 737-222 · S/N 19549Cancelled Sep 26, 1994 · Ial Aircraft Holding IncN466DMCessna 150J · S/N 15069365Cancelled Jul 11, 1994 · Exported to Dominican Republic · Mccutcheon Wesley R
Back to Hialeah, FL