Miami, FL

Cancelled registrations · 5,508

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 = 'MIAMI'
  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.

N5MKBeech 200 · S/N BB-537Cancelled May 12, 2015 · Registration expired, pending cancellation · Built 1979 · Executive Aircraft Of Central America LLCN62561Hawkes Barry E CHALLENGER II · S/N CH2-0292-0826Cancelled May 12, 2015 · Registration expired, pending cancellation · Hawkes Barry EN497AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49735Cancelled May 11, 2015 · Sale reported, canceled · Built 1989N537NBPiper PA-31-310 · S/N 31-90Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1967 · Chyd JefferyN62595Brooks Terrell W BANSHEE II · S/N 267803425Cancelled May 11, 2015 · Registration expired, pending cancellation · Brooks Terrell WN62846Airbus Industrie A300 B2-1C · S/N 10Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1975 · Asc Acquisition Partners Lp DBAN8108NBoeing 727-25 · S/N 18259Cancelled May 11, 2015 · Sale reported, canceled · Built 1964N8461KPiper PA-34-220T · S/N 34-8233025Cancelled May 11, 2015 · Sale reported, canceledN935JHCessna 172N · S/N 17272852Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1979 · Alliance Air IncN218LCNihon YS-11A · S/N 2171Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1991 · Kfs Aviation IncN282WWRockwell International NA-265-60 · S/N 306-134Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1977 · Zimair CorpN3718DCessna 182A · S/N 34418Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1957 · Fuentes Jose RN31434Beech C90A · S/N LJ-1186Cancelled May 7, 2015 · Registration expired, pending cancellation · Built 1988 · Paranapanema International LimitedN91063Cessna 207 · S/N 20700050Cancelled May 7, 2015 · Registration expired, pending cancellation · Built 1969 · Avi Sales IncN2058ECessna 172N · S/N 17271136Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1978 · Queen Air CorporationN289BMFouga CM 170 MAGISTER · S/N MT289Cancelled May 6, 2015 · Registration expired, pending cancellation · International Flight CenterN44854Piper PA-28-161 · S/N 28-7816027Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1977 · Marti JorgeN4559WCameron Balloons US BURGER-65 · S/N 3050Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1993 · Burger King CorpN48075Mcdonnell Douglas DC-9-15 · S/N 45723Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1966 · International Airline Supp Group IncN743USBoeing 727-281 · S/N 20285Cancelled May 6, 2015 · Sale reported, canceled · Built 1971N8391BCessna 172 · S/N 36191Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1957 · Hilton Maurice JN1385PDouglas C-47 · S/N 34371Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1945 · York'S Cargo IncN1606HCameron Balloons US N-77 · S/N 5946Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1994 · Sunrise Community Promotions IncN22JGPiper PA-31-310 · S/N 31-7401235Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1974 · Joes Airplane IncN6469YPiper PA-23-250 · S/N 27-3764Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1967 · Air Charter Network IncN65444Cessna 210N · S/N 21063424Cancelled May 5, 2015 · Registration expired, pending cancellation · First International Finance CorpN8920CPiper PA-32R-300 · S/N 32R-7680143Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1976 · Stevens TerryN211CHBeech 95-B55 (T42A) · S/N TC-2279Cancelled May 4, 2015 · Exported to Venezuela · Built 1980 · Rs Global LLCN25958Cessna 152 · S/N 15280882Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1977 · Tamiami Aircraft Services IncN290RSPiper PA-31T1 · S/N 31T-7904033Cancelled May 4, 2015 · Exported to Venezuela · R&V Aviation Services IncN32601Piper PA-34-200T · S/N 34-7570036Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1974 · National Aviation Services IncN507DCDouglas DC-8-51 · S/N 45855Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1966 · Agro Air Associates IncN57MABeech B90 · S/N LJ-414Cancelled May 4, 2015 · Registration expired, pending cancellation · Thomas Howell Kiewit (USA) IncN62SEPiper PA-23-250 · S/N 27-7654181Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1976 · Interamerican Investments IncN8008DDouglas DC-8-51 · S/N 45252Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1958 · Fba IncN2467EPiper PA-38-112 · S/N 38-78A0471Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1978 · American Aviation Of Florida IncN68KBPiper PA-23-250 · S/N 27-28Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Absolute AirwaysN6990ACessna 172 · S/N 29090Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1956 · S G S Special Services IncN7226LPiper PA-31-310 · S/N 31-748Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1971 · Garcia JorgeN8536ABritten-Norman BN-2A-9 · S/N 841Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1981 · Air Group IncN9892ZCurtiss Wright C-46D · S/N 33376Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1944 · Gonzales FrankN1512KBalloon Works FIREFLY 7-B · S/N F7B-030Cancelled Apr 29, 2015 · Registration expired, pending cancellation · Built 1982 · Shantz Robert WN7064LCessna 337B · S/N 3370670Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Built 1967 · Degani ShlomoN845TADouglas C-118B · S/N 131572Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Atlas Aircraft CorporationN2652BCessna 402C · S/N 402C0345Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Joseph Charles EN963MTOrtiz Jesus R EROS · S/N 001Cancelled Apr 9, 2015 · Exported to Bolivia · Built 2002 · Ortiz Jesus RN2991ACessna 310R · S/N 310R1855Cancelled Apr 8, 2015 · Exported to Brazil · Built 1979 · Evolution Airparts CorpN651VNBritish Aerospace BAE JETSTREAM 3101 · S/N 651Cancelled Mar 19, 2015 · Exported to Venezuela · Jetstream 31-777 CorpN28VBBodifee Victor SEAREY · S/N 1DK069Cancelled Mar 12, 2015 · Third renewal notice · Built 1998 · Vct Aviation IncN804EDouglas DC-8-51 · S/N 45411Cancelled Mar 12, 2015 · Third renewal notice · Built 1959 · International Aircraft Enterprises
Back to Miami, FL