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.

N264BCPiper PA46-500TP · S/N 4697518Cancelled Jul 3, 2017 · Exported to Brazil · Built 2013 · Rolim Freight Forward IncN197ALBoeing 737-2E1 · S/N 20300Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1993 · Nortek Repair Center IncN4733BCessna 152 · S/N 15283605Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1979 · Riggs Charles AN61139Cessna 150J · S/N 15070830Cancelled Jun 21, 2017 · Exported to Argentina · Built 1969 · Malnati MartinN4083SBell 412 · S/N 33028Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1981 · Miami International Machinery & Equipment CoN971JXBritish Aerospace BAE JETSTREAM 3201 · S/N 971Cancelled Jun 19, 2017 · Registration expired, pending cancellation · International Aircraft Systems IncN7644UBoeing 727-222 · S/N 20038Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1969 · U Boats Parts IncN13820Piper PA-23-250 · S/N 27-4465Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1969 · Cogburn Roy EN3802QCessna 172L · S/N 17259902Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1971 · Garcia MiguelN813HABoeing 737-300 · S/N 27285Cancelled Jun 14, 2017 · Exported to Venezuela · High Air Power LLCN57KCPiper PA-31T2 · S/N 31T-8166076Cancelled Jun 13, 2017 · Exported to Brazil · Built 1983 · Rolim Freight Forward IncN39288Reims CESSNA FT337GP · S/N P0001Cancelled Jun 12, 2017 · Exported to Russia · Rolland Richard FN2685WDouglas DAKOTA 4 · S/N 16262/33010Cancelled Jun 8, 2017 · Registration expired, pending cancellation · International Airline Support GroupN20253Textron 172S · S/N 172S12018Cancelled May 31, 2017 · Exported to Uganda · Built 2017 · Africair IncN20271Textron 172S · S/N 172S12019Cancelled May 31, 2017 · Exported to Uganda · Built 2017 · Africair IncN2203YFirefly Balloons FIREFLY 9 · S/N F9-2004Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 2005 · Mackie Thomas SN511PEBoeing 727-232 · S/N 20634Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1973 · U Boats Parts IncN206ZTBell 206B · S/N 2906Cancelled May 25, 2017 · Exported to Dominican Republic · Built 1980 · Ruchi CorpN16519Piper PA-32-260 · S/N 32-7300029Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1973 · Millennium Import & Export IncN94939Cessna 152 · S/N 15285817Cancelled May 23, 2017 · Exported to Czech Republic · Built 1983 · Silver Express Co DBAN50918Cessna 150J · S/N 15069641Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1968 · Kirk Enterprise IncN183WAAeronca 7AC · S/N 7AC-4741Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1946 · Schofield Mark HN2510RSwearingen SA226TC · S/N TC292Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1979 · Coromias Jorge ArayaN265USBoeing 727-251 · S/N 19984Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1969 · Intl Airline Support Group IncN729AABoeing 727-227 · S/N 20736Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1973 · Aerospace Finance LLCN630NHBell Helicopter Textron Canada 407 · S/N 54661Cancelled May 9, 2017 · Exported to Kenya · Africair IncN40212Piper PA-23-250 · S/N 27-7305010Cancelled May 8, 2017 · Rosario Luis DelN2052UTextron 560XL · S/N 560-6230Cancelled Apr 24, 2017 · Exported to Algeria · Africair IncN128NKDouglas DC-9-21 · S/N 47307Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1969 · Amtec Jet IncN1803Mcdonnell Douglas DC-8-62 · S/N 45895Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1967 · Agro Air Associates IncN4935CMcdonnell Douglas DC-8-63 · S/N 45931Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1968 · Agro Air Associates IncN816BEBeech 1900C · S/N UB57Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1986 · Aero Consulting CorpN893AFDouglas DC-8-52 · S/N 45619Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1961 · International Airline Support GroupN105HDRockwell International NA-265-80 · S/N 38039Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1976 · Sunrise Air IncN426FBDouglas DC-8F-54 · S/N 45667Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1963 · Miami Leasing IncN5819XCessna 310F · S/N 310-0119Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1961 · K Patel IncN616SEDouglas DC-6A · S/N 44070Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1953 · Nighthawk Air Systems IncN211NWMcdonnell-Douglas DC-10-30 · S/N 46868Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1974 · Picl Aviation IV LLCN3669FEurocopter AS 350 B2 · S/N 1495Cancelled Apr 4, 2017 · Exported to Colombia · Built 1981 · Angel Emiliano TrusteeN505FBDouglas DC-8-51 · S/N 45410Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Miami Leasing IncN5323PCessna 152 · S/N 15284914Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1981 · Husta Aviation IncN55FBDouglas DC-8F-55 · S/N 45678Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1965 · Miami Leasing IncN7285GCessna 172K · S/N 17258985Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1970 · Edwards Marianne RankinN7806MFairchild FH-227 · S/N 515Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1966 · International Group Distributors IncN8704SCessna 150F · S/N 15062004Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Gettinger Jason VN952VVMcdonnell Douglas DC-9-21 · S/N 47303Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Amtec Jet IncN323SPCessna 411 · S/N 411-0238Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1966 · Atlantic Aviation & Marine International Svcs CorpN722MPPinedo Marcos AVENTURA HP · S/N APHP0011Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1999 · Pinedo Marcos FN5450YPiper PA-23-250 · S/N 27-2532Cancelled Mar 23, 2017 · Exported to Venezuela · Built 1964 · Lima-Bravo Group CorpN1808EDouglas DC-8-62 · S/N 46105Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1969 · Agro Air Associates Inc
Back to Miami, FL