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.

N7113GCessna 172K · S/N 17258813Cancelled May 15, 2014 · Exported to Russia · Built 1969 · Ryans Dream IncN1119Cessna 172P · S/N 17275233Cancelled May 13, 2014 · Exported to Colombia · Built 1981 · Lcd Systems IncN85LARaytheon 58 · S/N TH-2100Cancelled May 8, 2014 · Exported to Paraguay · Brickell Aviation IncN55241Cessna 172S · S/N 172S11371Cancelled Apr 15, 2014 · Exported to Ethiopia · Africair IncN55243Cessna 172S · S/N 172S11372Cancelled Apr 15, 2014 · Exported to Ethiopia · Africair IncN5524UCessna 172S · S/N 172S11370Cancelled Apr 15, 2014 · Exported to Ethiopia · Africair IncN199PYAirbus Industrie A300 B4-203 · S/N 199Cancelled Apr 11, 2014 · Pyramid Leasing Three IncN422USBoeing 737-401 · S/N 23989Cancelled Apr 9, 2014 · Exported to Venezuela · Built 1987 · Shell Aerospace Supplies IncN423USBoeing 737-401 · S/N 23990Cancelled Apr 9, 2014 · Exported to Venezuela · Built 1989 · Shell Aerospace Supplies IncN5934FCessna 210G · S/N 21058934Cancelled Mar 25, 2014 · Exported to Paraguay · Built 1967 · Fabricmaster LLCN1551HBeech C90A · S/N LJ-1211Cancelled Mar 24, 2014 · Exported to Paraguay · Built 1989 · Atlantic Aviation Group IncN2166ECessna 172N · S/N 17271175Cancelled Mar 24, 2014 · Exported to Brazil · Built 1978 · Taylor Milton VN499DNMcdonnell Douglas DC-9-83(MD-83) · S/N 49530Cancelled Mar 13, 2014 · Registration pending · Built 1987N123VPCessna 550 · S/N 550-0111Cancelled Mar 12, 2014 · Exported to Panama · Built 1979 · Atlantic Aviation Group IncN312DSPiper PA 46-350P · S/N 4636455Cancelled Mar 12, 2014 · Exported to Brazil · Built 2008 · Rolim Freight Forward IncN4360TPiper PA-32-300 · S/N 32-7240064Cancelled Feb 18, 2014 · Exported to Venezuela · R & V Aviation Services IncN6020SAntonov AN-2 · S/N 1G21514Cancelled Feb 18, 2014 · Exported to Venezuela · Built 1985 · R & V Aviation Services IncN982ASMcdonnell Douglas MD 83 · S/N 53473Cancelled Feb 18, 2014 · Exported to Venezuela · Built 1997 · Air Capital Group LLCN9534ZCessna T206H · S/N T20609111Cancelled Feb 14, 2014 · Exported to France · Africair IncN31255Bellanca 7KCAB · S/N 329-72Cancelled Feb 11, 2014 · Exported to Venezuela · Built 1972 · R & V Aviation Services IncN785NMBell OH-58/206A · S/N 70-15630Cancelled Feb 10, 2014 · Exported to Dominican Republic · Built 1971 · Negarit Air LLCN7052NAntonov AN-2 · S/N 1G20339Cancelled Feb 5, 2014 · Exported to Venezuela · Built 1983 · R & V Aviation Services IncN31088Aerovodochody L-29 DELFIN · S/N 2813Cancelled Jan 22, 2014 · Exported to Canada · Built 1968 · Rocafort Manuel JN52YAYakovlev YAK 52 · S/N 8910111Cancelled Jan 16, 2014 · Exported to Brazil · Built 1989 · Evolution Airparts CorpN81543Cessna 208B · S/N 208B5074Cancelled Jan 14, 2014 · Exported to Kenya · Built 2013 · Africair Aviation Leasing LLCN4634VCessna 172RG · S/N 172RG0344Cancelled Dec 23, 2013 · Exported to Ecuador · Built 1980 · Miami Rent A Plane LLCN4383APiper PA-28-181 · S/N 28-8590019Cancelled Dec 19, 2013 · Exported to Brazil · Built 1984 · Rolim Freight Forward IncN704RRCessna 150M · S/N 15078818Cancelled Dec 16, 2013 · Exported to Brazil · Built 1976 · Santos Jose AmauriN717DHBoeing 727-23 · S/N 19389Cancelled Dec 16, 2013 · Third renewal notice · Built 1966 · Air Trading International LLCN724DHBoeing 727-228 · S/N 19862Cancelled Dec 16, 2013 · Third renewal notice · Built 1969 · Air Trading International LLCN868LLCirrus Design SR20 · S/N 1664Cancelled Dec 16, 2013 · Exported to Brazil · Built 2006 · Rolim Freight Forward IncN8751UCessna 150M · S/N 15077979Cancelled Dec 11, 2013 · Exported to Brazil · Built 1976 · Alj Engines Supply IncN311PBCessna 310R · S/N 310R1396Cancelled Dec 9, 2013 · Second renewal notice · Built 1978 · Migster LLCN56665Consolidated Vultee BT-13A · S/N 7861Cancelled Nov 26, 2013 · Exported to Brazil · Built 1946 · Alj Engines Supply IncN19079Cessna 150L · S/N 15074150Cancelled Nov 22, 2013 · Exported to Bolivia · Built 1972 · Alas Srl CorpN1001ZMccallum Fred F LM-5X · S/N LM-5X-1001Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1990 · Gala Enterprise IncN62576Airbus Industrie A300 B2-1C · S/N 11Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1975 · Asc Acquistion Partners L P DBAN7645UBoeing 727-222 · S/N 20039Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1969 · U Boats Parts IncN7744JPiper PA-32-260 · S/N 32-1148Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1969 · Tamair IncN1804Douglas DC-8-62 · S/N 45896Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1967 · Agro Air Associates IncN128BPBoeing 747-143 · S/N 19729Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1970 · Bpi Aerospace CorpN493BBBeech 58 · S/N TH-1111Cancelled Nov 5, 2013 · Exported to Paraguay · Brickell Aviation IncN524FSBeech 200 · S/N BB-590Cancelled Nov 5, 2013 · Exported to Brazil · Alj Engines Supply IncN9419MCessna 210K · S/N 21059319Cancelled Nov 5, 2013 · Exported to Paraguay · Built 1970 · Brickell Aviation IncN5304YPiper PA-23-250 · S/N 27-2377Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1963 · Jmj Avaiton IncN5725JCessna P206E · S/N P20600625Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1969 · Highwing CorpN9039YPiper PA-31-310 · S/N 31-53Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1967 · Sorevilo Invesment CorpN234QGood Marvin VELOCITY · S/N DMO 82Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1992 · Good Marvin FN704XECessna 150M · S/N 15078949Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1976 · Aquarius Rising Enterprises IncN8144DCessna 208B · S/N 208B5029Cancelled Oct 31, 2013 · Exported to Tanzania · Built 2013 · Africair Inc
Back to Miami, FL