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.

N2643XBritten Norman BN-2B-20 · S/N 2109Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1981 · Air Group IncN26740Piper J4A · S/N 4-883Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1940 · Mcclelland Richard PN276RDFairchild F27M · S/N 128Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1969 · Seidle William TrusteeN352FTPiper PA-28-161 · S/N 28-8216211Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1982 · Marti JorgeN39584Kerr Paul S CONDOR III · S/N 83-142-3Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Kerr Paul SN98367Piper PA-28-140 · S/N 28-26192Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1969 · American Contractors Equipment CorpN989PKPiper PA-31-325 · S/N 31-7712010Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1976 · Gardiner GingerN999BAero Commander 500 · S/N 754Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1959 · Pfudpucker Airway IncN333JTPiper PA-31-310 · S/N 31-123Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1967 · Klein International IncN822PCPiper PA-31-310 · S/N 31-7400987Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1974 · T&S EnterprisesN9455YCessna T210N · S/N 21064512Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1981 · Diacsa IncN477UEBritish Aerospace BAE JETSTREAM 3201 · S/N 890Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Ada USA IncN736BUCessna R172K · S/N R1722404Cancelled Nov 25, 2014 · Exported to Paraguay · Built 1977 · Brickell Aviation IncN37673Smith John E WEEDHOPPER JC-24B · S/N 0189Cancelled Nov 21, 2014 · Registration expired, pending cancellation · Smith John EN24941Cessna 152 · S/N 15280461Cancelled Nov 20, 2014 · Exported to Brazil · Built 1977 · Pegasus Aircraft Parts & Systems IncN8619TCessna 182C · S/N 52519Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1960 · Vyfvinkel Frederick J CN87596Republic RC-3 · S/N 165Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Ruzakowski Henry CN875ZCorben Baby Ace 1961 · S/N 61-101Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1962 · Ace Aeromotive IncN8777GAero Commander 500 · S/N 618Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1958 · Alvarez Maria ElenaN8888QDouglas DC-6B · S/N 43562Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1952 · Nighthawk Air Systems IncN310DRPiper PA-31-325 · S/N 31-7912097Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1979 · Palms Air LLCN781ACCessna 182T · S/N 18281316Cancelled Nov 19, 2014 · Exported to Brazil · Built 2004 · Rolim Freight Forward IncN8000RBeech 65-A80 · S/N LD-177Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1964 · G H Enterprises IncN8021QBeech 65-A80 · S/N LD-204Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1965 · Romaguera Oscar AN80249Beech 65-88 · S/N LP-13Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1966 · Associated Heavy EquipmentN8049MCessna 310I · S/N 310I0049Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1964 · Filecci Joseph E DBAN821EDouglas DC-8-51 · S/N 45877Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1966 · International Aircraft EnterprisesN822QBeech 65 · S/N LC-42Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1960 · Phoenix Air EastN836DDouglas DC-7B · S/N 45345Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1958 · Historical Flight Foundation IncN373NEEurocopter Deutschland MBB-BK 117 C-1 · S/N 7507Cancelled Nov 18, 2014 · Exported to Bolivia · Jetvend Aviation LLCN75335Curtiss Wright C-46A · S/N 30428Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1944 · Airlift International IncN7639MCessna 175 · S/N 55939Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1959 · Aquarius Rising Aviation IncN2968Grumman G-73 · S/N J-25Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Amphibian Sales IncN7265MCessna 175 · S/N 55565Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1958 · Mile High Flying ClubN726FLPiper PA-28-140 · S/N 28-7225426Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1972 · Kroneberger Bryan SN7313JPiper PA-28-140 · S/N 28-24662Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1968 · Burton Bill DBAN732PSCessna 210M · S/N 21061671Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1976 · Wallace FredN733TBCessna 172N · S/N 17268526Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1977 · Valderrama German EN7479FHughes 269C · S/N 670607Cancelled Nov 17, 2014 · Registration expired, pending cancellation · L And S Distributors IncN67351Cessna 152 · S/N 15281772Cancelled Nov 14, 2014 · Registration expired, pending cancellation · Built 1978 · American Aviation Ground Svcs IncN610RBBeech G18S · S/N BA-514Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1960 · Alen Manuel JrN6822SAero Commander 680 · S/N 680-328-22Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1956 · Inter Andina Co IncN69907Cessna 421B · S/N 421B0539Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1973 · Ferro Aviation Maintenance Co IncN7183TCessna 172A · S/N 46783Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1959 · Kirschenbaum Robert AN4858MCessna 152 · S/N 15284487Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1980 · L T Aero IncN624ZBeech C-50 · S/N CH-341Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1955 · Parker StevenN6329LAmerican AA-1B · S/N AA1B-0029Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1972 · Trans American Airways IncN63753Piper PA-23-250 · S/N 27-7754087Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Phoenix Express IncN63801Piper PA-23-250 · S/N 27-7754127Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1977 · Phoenix Express IncN640CCPiper PA-23-250 · S/N 27-2544Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1964 · Tittle Victor
Back to Miami, FL