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.

N2395Van Hoten BENSEN B-8 · S/N 7429VCancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1970 · Saling WilliamN1392GCessna 310R · S/N 310R1217Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1977 · Glass Works IncN421DABoeing 727-232 · S/N 21274Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1977N58CRPiper PA-31-350 · S/N 31-7305033Cancelled Aug 6, 2013 · Exported to Colombia · Lcd Systems IncN633Lockheed 18-56 · S/N 2614Cancelled Aug 6, 2013 · Revoked, canceled · Built 1952 · Vanal IncN6419YPiper PA-23-250 · S/N 27-3703Cancelled Aug 6, 2013 · Revoked, canceled · Van Hise James MN6451ZPiper PA-25 · S/N 25-601Cancelled Aug 6, 2013 · Revoked, canceled · Built 1961 · Kavanagh Mary GN6454PPiper PA-24-250 · S/N 24-1569Cancelled Aug 6, 2013 · Revoked, canceled · Built 1959 · Fife Sam DN6465CConsolidated Vultee PBY-6A · S/N 64104Cancelled Aug 6, 2013 · Revoked, canceled · Aircraft Instrument CorpN64734Cessna 150L · S/N 15072454Cancelled Aug 6, 2013 · Revoked, canceled · General AircraftN64737Cessna 150L · S/N 15073585Cancelled Aug 6, 2013 · Revoked, canceled · General AircraftN14232Piper PA-23-250 · S/N 27-4790Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1972N319ATAerospatiale SA319B ALOUETTE III · S/N 2008Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Built 1973 · Stettmeier Randall LN6137PPiper PA-24-250 · S/N 24-1237Cancelled Aug 5, 2013 · Revoked, canceled · Built 1959 · Aerologics CorpN6259DAero Commander 680 · S/N 680-527-197Cancelled Aug 5, 2013 · Revoked, canceled · Built 1957 · Alfa International IncN6311LAmerican AA-1A · S/N AA1A-0311Cancelled Aug 5, 2013 · Revoked, canceled · Built 1971 · Garner ElvaN6823Boeing 727-223 · S/N 19701Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1968N701CFAeropro CZ EUROFOX LSA · S/N 237 07Cancelled Aug 5, 2013 · Sale reported, canceled · Built 2007N221RMPiper PA-23-250 · S/N 27-7954031Cancelled Aug 1, 2013 · Exported to Panama · Tamiami Aircraft Services CorpN510FACessna 172RG · S/N 172RG0048Cancelled Aug 1, 2013 · Built 1979 · Endeavour Flight Training IncN5246BCessna 152 · S/N 15283815Cancelled Aug 1, 2013 · Exported to Brazil · Built 1979 · Rolim Freight Forward IncN64940Cessna 152 · S/N 15281488Cancelled Aug 1, 2013 · Exported to Brazil · Rolim Freight Forward IncN125GUBoeing 737-2H6 · S/N 23849Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1987N133VCessna 401A · S/N 401A0098Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1969N14018Piper PA-23-250 · S/N 27-4632Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1971 · Farco IncN2493FConvair HC-131A · S/N 52-5783Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1952 · Quo Vadis IncorporatedN28JCPiper J3C-65 · S/N 22945Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1947 · Three Bums Flying Club IncN2980PConsolidated Aeronautics LAKE LA-4-200 · S/N 951Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1979 · Del Sol Luis AN342CCCessna 680 · S/N 680-0342Cancelled Jul 30, 2013 · Exported to Nigeria · Built 2013 · Africair IncN42ACessna 421A · S/N 421A0135Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1970 · Fowler PhillipN4899JBeech 95-C55 · S/N TE-340Cancelled Jul 30, 2013 · Exported to Canada · Built 1967 · Tango Whisky Air LLCN6161MDouglas DC-8F-55 · S/N 45762Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1965N84BLDouglas DC-6B · S/N 43739Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Aerial Transit CompanyN71HCPiper PA-23-250 · S/N 27-3610Cancelled Jul 29, 2013 · Sale reported, canceled · Built 1966N9106SBeech 58TC · S/N TK-5Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1976 · Chillicothe Aviation CompanyN912DAAero Commander 1121B · S/N 147Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1969 · Agro Air Associates IncN81450Cessna 208B · S/N 208B5031Cancelled Jul 25, 2013 · Exported to Kenya · Africair IncN695BBeech A35 · S/N D-1698Cancelled Jul 24, 2013 · Registration expired, pending cancellation · Built 1948 · Corchero Eduardo AN40567Piper PA-23-250 · S/N 27-7405308Cancelled Jul 23, 2013 · Exported to El Salvador · Built 1973 · Aviators II LLCN47950Piper PA-28-181 · S/N 28-7890155Cancelled Jul 23, 2013 · Exported to El Salvador · Built 1977 · Aviators II LLCN7333HPiper J3C-65 · S/N 20593Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1946 · Yoas E JaxonN7451TCessna 172A · S/N 47051Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1959 · Rea Lawrence E JrN475PLAero Commander 500 · S/N 767Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1959 · Suval CorpN501LPitts SPECIAL · S/N L-1Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1968 · Vagner Robert MN550RCPiper PA-31-325 · S/N 31-8212020Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1982 · Carinabelt Business CorpN5758YPiper PA-23-250 · S/N 27-2884Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1965 · Perez JoeN580JCDouglas DC-8-21 · S/N 45594Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1960 · General Air Services IncN7150QCessna 172L · S/N 17260450Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1972 · Charles Branan Co IncN200TADouglas DC3 · S/N 19998Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1946 · Sarmiento Rolando RN2656XBeech H-18 · S/N BA-677Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1964 · American Professional Air Service
Back to Miami, FL