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.

N4FXCessna P337H · S/N P3370309Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1978 · Ortis CarlosN3891WPiper PA-32-260 · S/N 32-837Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1966 · Lynn William HN399MMaugeri OSPREY 1 · S/N 44JMCancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1977 · Maugeri Joseph WN45821Convair 240 · S/N 194Cancelled Nov 14, 2012 · Sale reported, canceledN9556CConsolidated Vultee PBY-6A · S/N 46643Cancelled Nov 14, 2012 · Revoked, canceled · Aircraft Instrument CorpN383MDouglas DC-7C · S/N 45189Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Built 1945 · Modern Air TrasportN84110Champion AERONCA 7AC · S/N 7AC-2798Cancelled Nov 13, 2012 · Sale reported, pending cancellation · Built 1946N842TADouglas DC-6B · S/N 43545Cancelled Nov 13, 2012 · Sale reported, pending cancellationN9577TPiper PA-38-112 · S/N 38-78A0136Cancelled Nov 13, 2012 · Registration pending, canceled · Built 1978N20194Cessna 208B · S/N 208B2372Cancelled Nov 9, 2012 · Exported to Kenya · Built 2012 · Africair IncN374RDFairchild FH-227 · S/N 504Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 1966 · Seidle William D TrusteeN8114NBoeing 727-25 · S/N 18265Cancelled Nov 9, 2012 · Sale reported, pending cancellation · Built 1964N999GDCessna 320E · S/N 320E-0102Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 1967 · Seda SantiagoN81861Cessna 340 · S/N 3400346Cancelled Nov 8, 2012 · Exported to Honduras · Machote-Cody Aviation IncN417DABoeing 727-232 · S/N 21259Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1976N419DABoeing 727-232 · S/N 21272Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1977N3314LDouglas DC-9-14 · S/N 45709Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1966 · International Airline Suppt Grp IncN331SMCessna 310I · S/N 310I0048Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1964 · Mojave Air IncN4394YConvair C-131B · S/N 53-7788Cancelled Oct 24, 2012 · Third renewal notice · Air Freight International IncN4395WConvair C-131D · S/N 54-2818Cancelled Oct 24, 2012 · Third renewal notice · Air Freight International IncN94SPCessna 172N · S/N 17268122Cancelled Oct 24, 2012 · Exported to Brazil · Built 1976 · Robinson Air Crane IncN79076Cessna 182P · S/N 18261791Cancelled Oct 23, 2012 · Sale reported, pending cancellation · Built 1973N29HCVisionair International F2B BRISTOL REPLICA · S/N 1Cancelled Oct 19, 2012 · Registration expired, pending cancellation · Built 1979 · Visionair International IncN74JFPiper PA-E23-250 · S/N 27-4787Cancelled Oct 19, 2012 · Sale reported, pending cancellation · Built 1972N75WSDouglas DC3C · S/N 33564Cancelled Oct 19, 2012 · Sale reported, pending cancellation · Built 1945N2778Beech A65 · S/N LC-286Cancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 1968 · Ramirez JuanaN286Douglas DC-7C · S/N 45205Cancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 1957 · Modern Air Transport IncN81550Interavia I-3 · S/N 209Cancelled Oct 18, 2012 · Exported to Canada · Mantilla HugoN711WRPiper PA-28-161 · S/N 28-7816121Cancelled Oct 17, 2012 · Exported to Brazil · Built 1977 · Rolim Freight Forward IncN755DHBoeing 727-225 · S/N 21857Cancelled Oct 17, 2012 · Exported to Panama · Built 1979 · C&G Engines CorpN2048JSemco Balloon CHALLENGER · S/N SEM179Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1977 · Evain Michael GN2214ZCessna 411 · S/N 411-0231Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1966 · Martinez PedroN18CKBeech D18S · S/N A-32Cancelled Oct 15, 2012 · Registration expired, pending cancellation · Built 1945 · Knight Aircraft CorpN6889SAero Commander 680 · S/N 680-415-90Cancelled Oct 15, 2012 · Sale reported, pending cancellation · Built 1956N10926Hughes 269C · S/N 400913Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1980 · Carib Aviation IncN1431PPiper PA-23 · S/N 23-487Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1956 · Portable Welding Svc IncN144GTConvair T-29B · S/N 51-5144Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Mbm Aircraft Leasing And Sales IncN14PRPiper PA-23-160 · S/N 23-1765Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1959 · Underwood DaryleN97TTCessna 404 · S/N 404-0013Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1977 · S E P T CoporationN3587DPiper PA-31-350 · S/N 31-8052119Cancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1980 · Jf Aviation CorporationN3599BBeech B50 · S/N CH-71Cancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1954 · Benavides Pedro J JrN3634CCessna 180 · S/N 31132Cancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1954 · Ferro Aviation Maintainance Co IncN3660XAero Commander S2R · S/N 1889RCancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1974 · Alj Engines Supply IncN6349HCessna T207A · S/N 20700490Cancelled Oct 9, 2012 · Sale reported, pending cancellation · Built 1978N6262YPiper PA-23-250 · S/N 27-3503Cancelled Oct 4, 2012 · Sale reported, pending cancellation · Built 1966N2782SDouglas DC3 · S/N 4148Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Aircraft Holdings IncN332DGrumman G-21 · S/N 1109Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Worldwide Aviation Distributors IncN333GBeech 65-90 · S/N LJ-101Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1966 · Bramco Aircraft LeasingN402DABoeing 727-232 · S/N 21146Cancelled Oct 3, 2012 · Sale reported, canceled · Built 1975N32410Piper PA-28-151 · S/N 28-7515150Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1974 · On Eagles Wings
Back to Miami, FL