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.

N931FTBoeing 727-23 · S/N 19390Cancelled Jun 24, 1994 · Exported to São Tomé and Príncipe · Ial Aircraft Holding IncN408BNBoeing 727-291 · S/N 19993Cancelled May 12, 1994 · Ial Aircraft Holding IncN931EADouglas DC-9-14 · S/N 45698Cancelled Apr 26, 1994 · Exported to Mexico · International Air Leases IncN727CDBoeing 727-22 · S/N 18849Cancelled Dec 30, 1993 · Exported to Honduras · Ial Aircraft Holding IncN2976HEngineering & Research ERCOUPE 415-C · S/N 3601Cancelled Aug 2, 1993 · Triennial form not returned · Leyva Gustavo AN38641Douglas DC-9-14 · S/N 47060Cancelled Jul 20, 1993 · Exported to Mexico · International Air Leases IncN7588JPiper PA-28R-180 · S/N 28R30982Cancelled Apr 30, 1993 · Triennial form not returned · Straight ArrowN933FTBoeing 727-23 · S/N 19182Cancelled Mar 24, 1993 · Exported to Honduras · Ial Aircraft Holding IncN459ACBoeing 737-222 · S/N 19072Cancelled Mar 12, 1993 · Exported to Peru · A L Aircraft 2 CorpN4617Boeing 727-35 · S/N 18845Cancelled Mar 12, 1993 · Exported to Peru · Ial Air IncN8090PBoeing 707-351C · S/N 18921Cancelled Mar 12, 1993 · Exported to Peru · African Aircraft CorporationN8090QBoeing 707-351C · S/N 19434Cancelled Mar 12, 1993 · Exported to Peru · African Aircraft CorporationN23TJLearjet 23 · S/N 033Cancelled Jan 20, 1993 · Thrust-Tech AviationN88SHHacha-Stanley SH-3 STOL · S/N SH2Cancelled Dec 29, 1992 · Triennial form not returned · Hacha StanleyN111MMPiper PA-31-325 · S/N 317512011Cancelled Dec 24, 1992 · Exported to Costa RicaN791PABoeing 707-321C · S/N 18715Cancelled Jan 15, 1992 · Exported to Sudan · International Air Leases IncN5619YPiper PA-23-250 · S/N 27-2728Cancelled Aug 24, 1989 · Holmes Henry E DBAN3203NBell 206L-3 · S/N 51211Cancelled Jun 19, 1987 · Exported to Colombia · Rolanco Trading CoN757VCCessna 152 · S/N 15280029Cancelled Apr 20, 1984 · Exported to Dominican Republic · Airlines CorpN5184CCessna T310R · S/N 310R1512Cancelled Oct 12, 1983 · Exported to Peru · Diesel Machinery Service IncN757TYCessna 152 · S/N 15280002Cancelled Oct 6, 1982 · Revoked, pending cancellation · Built 1977 · Aviation Financial Services IncN81909Cessna U206 · S/N U206-0761Cancelled Sep 24, 1982 · Herring W JohnN69039Cessna 152 · S/N 15282454Cancelled Aug 23, 1982 · Avation Financial Services IncN757MLCessna 152 · S/N 15279848Cancelled Mar 26, 1982 · Aviation Financial Services IncN757SFCessna 152 · S/N 15279962Cancelled Mar 26, 1982 · Aviation Financial Services IncN738VFCessna 172N · S/N 17270266Cancelled Mar 2, 1982 · Aviation Financial Services IncN9905RBeech B95 · S/N TD-360Cancelled Jan 14, 1982 · Administratively canceled · Sullivan George WN244GConvair 240-23 · S/N 177Cancelled May 6, 1981 · Exported to Dominican Republic · Built 1950 · Latin American Aviation Exports IncN62378Hiller UH-12D · S/N 1118Cancelled Sep 11, 1979 · Hill Copters IncN24287Cessna 152 · S/N 15280195Cancelled May 4, 1979 · Aviation Financial Services IncN1069UPiper PA-34-200 · S/N 34-7250060Cancelled Mar 23, 1979 · Exported to Bolivia · Built 1971 · B & R Flying Inc/ C/O Harold JohnsN498DMBeech C-45H · S/N AF696Cancelled Jan 29, 1979 · Guell Julio AlfonsoN2258FCessna 310L · S/N 310-0058Cancelled Dec 6, 1978 · Exported to Costa Rica · Latin American Aviation ExportN3101HErcoupe 415-C · S/N 3726Cancelled Oct 31, 1977 · Built 1946 · Tucker Jack RN5571UPiper PA-28-140 · S/N 2826300Cancelled Aug 21, 1975 · Taylor Clarence EN1132VConsolidated Vultee L-13A · S/N 47-390Cancelled Feb 19, 1975 · Exported to United Kingdom · Built 1961 · Murphy Harold EN70161Cessna A188B · S/N 18801854TCancelled Jan 24, 1975 · Exported to Chile · H R Intl Purchasing AgenciesN5875MCessna 310P · S/N 310P0175Cancelled Nov 6, 1974 · Mctyre J WillisN2045EAeronca 7AC · S/N 7AC-5615Cancelled Jul 22, 1974 · Skinner Andrew & Jean SkinnerN53145Cessna A188B · S/N 18801646TCancelled Jun 26, 1974 · Exported to Chile · H R International Purchasing AgenciesN2763Flug & Fahrzeugwerke DIAMANT 16.5 · S/N 063Cancelled Mar 13, 1974 · Exported to Canada · Marin JoseN43BBPiper PA-23-160 · S/N 23-1437Cancelled Oct 1, 1973 · Empress Trading Co IncN6732UAerostar Acft Corp Of Texas M20C · S/N 2464Cancelled Sep 14, 1973 · Exported to Dominican Republic · Aircraft Marketing IncN70815Cessna U206F · S/N U20602098Cancelled Jul 17, 1973 · Exported to Paraguay · New World Equipment And Supply CorpN5135XChampion 7KCAB · S/N 172Cancelled Jun 25, 1973 · Scotton Rodney WN8135Soucy DRAG-N-FLY · S/N 1Cancelled Feb 29, 1972 · Built 1969 · Soucy GerryN6984ZPiper PA-25-235 · S/N 25-2732Cancelled Feb 11, 1972 · Exported to Chile · H R International Purchasing AgenciesN20276Piper J-3 · S/N 2076Cancelled Dec 16, 1971 · Built 1938 · Martins Maurice FN49917Laister-Kauffman LK-10A · S/N 109Cancelled Dec 7, 1971 · Built 1943 · Bennett M TN2074ACurtiss Wright C-46A · S/N 42-96671Cancelled Nov 22, 1971 · Inter South Inc
Back to Hialeah, FL