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.

N3309LDouglas DC-9-14 · S/N 45704Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1966 · International Airline Support GroupN59367Bell UH-1B · S/N 229Cancelled Sep 28, 2012 · Sale reported, pending cancellationN600GSConvair 340 · S/N 113Cancelled Sep 28, 2012 · Sale reported, pending cancellation · Built 1953N400DABoeing 727-232 · S/N 21144Cancelled Sep 27, 2012 · Sale reported, canceled · Built 1975N4BLBeech 65-B80 · S/N LD-273Cancelled Sep 27, 2012 · Sale reported, canceled · Built 1966N2906RCessna 310G · S/N 310G0106Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1962 · Delgado Alberto BN5608DBeech E18S · S/N BA-314Cancelled Sep 24, 2012 · Sale reported, pending cancellation · Built 1957N28HWEnstrom F-28A · S/N 111Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1972 · Riverside Leasing Service IncN3924BAshurst Ka ES W KR-2 · S/N ASHURST 1Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Ashurst James WN550USPiper PA-23-250 · S/N 27-4212Cancelled Sep 21, 2012 · Sale reported, pending cancellation · Built 1969N223FBDouglas DC-8-52 · S/N 45985Cancelled Sep 20, 2012 · Revoked, canceled · Built 1968 · Fb Air IncN37511Switzer BENSEN B-8KSB · S/N SB001Cancelled Sep 20, 2012 · Sale reported, canceled · Built 1975N5209YPiper PA-23-250 · S/N 27-2257Cancelled Sep 20, 2012 · Revoked, canceled · Built 1962 · Sleepy Hallow IncN612GCMcdonnell Douglas DC-10-30F · S/N 47840Cancelled Sep 20, 2012 · Exported to Venezuela · Built 1980 · Iag Ventures 1 LLCN9204QCessna 172R · S/N 17281611Cancelled Sep 19, 2012 · Exported to Angola · Built 2012 · Africair IncN9205QCessna 172R · S/N 17281612Cancelled Sep 19, 2012 · Exported to Angola · Built 2012 · Africair IncN10437Curtiss Wright C-46A · S/N 347096Cancelled Sep 18, 2012 · Revoked, canceled · Air Corp Of MiamiN105ECessna 310 · S/N 35479Cancelled Sep 18, 2012 · Revoked, canceled · Built 1956 · Jansen Robert AbrahamN3589DPiper PA-31-350 · S/N 31-8052135Cancelled Sep 18, 2012 · Sale reported, canceledN4656PPiper PA-23-250 · S/N 27-179Cancelled Sep 18, 2012 · Revoked, canceled · Built 1960 · Cabral VictorN198CHRobinson Helicopter R22 BETA · S/N 3974Cancelled Sep 17, 2012 · Exported to Brazil · Built 2005 · De Oliveira Janio FranciscoN25218Cessna 152 · S/N 15280536Cancelled Sep 12, 2012 · Registration expired, pending cancellation · Built 1977 · Casanova Jose AN25412Cessna 152 · S/N 15280640Cancelled Sep 12, 2012 · Registration expired, pending cancellation · Built 1977 · Lopez Emilio L JrN25703Beech 95-B55 (T42A) · S/N TC-1610Cancelled Sep 12, 2012 · Registration expired, pending cancellation · Built 1973 · A 1 Aircraft Sales IncN3389SCessna 210J · S/N 21059189Cancelled Sep 12, 2012 · Sale reported, canceled · Built 1969N3482BBeech D18S · S/N A-982Cancelled Sep 12, 2012 · Sale reported, canceled · Built 1953N3505GBeech C-45H · S/N AF-370Cancelled Sep 12, 2012 · Sale reported, canceledN4327CAeronca 7EC · S/N 7EC336Cancelled Sep 12, 2012 · Revoked, canceled · Built 1955 · Rose John C IIN846TWBoeing 727-31 · S/N 18753Cancelled Sep 12, 2012 · Revoked, canceled · Built 1964 · Saeta Holding Company IncN9876HCessna T-50 · S/N 4521Cancelled Sep 12, 2012 · Revoked, canceled · Built 1943 · Universal Air Svc IncN2782GDouglas C-47 · S/N 43-48843Cancelled Sep 10, 2012 · Sale reported, canceledN3244RCessna 411 · S/N 411-0244Cancelled Sep 10, 2012 · Sale reported, canceled · Built 1966N3317SCessna 210J · S/N 21059117Cancelled Sep 10, 2012 · Sale reported, canceled · Built 1969N5153ACessna P210N · S/N P21000832Cancelled Sep 10, 2012 · Sale reported, pending cancellation · Built 1983N9090HCessna T-50 · S/N 2264Cancelled Sep 10, 2012 · Revoked, canceled · Built 1942 · Liberty School Of Avia IncN91496Ryan NAVION · S/N NAV4291Cancelled Sep 10, 2012 · Revoked, canceled · Built 1946 · I B A Trading CorpN5085JCessna 310R · S/N 310R0205Cancelled Sep 6, 2012 · Sale reported, pending cancellation · Built 1975N6904CLockheed 1049-54 · S/N 4018Cancelled Sep 6, 2012 · Revoked, canceled · Built 1952 · Florida State Tours IncN72206Wsk-Pzl Meilec PZL M18B · S/N 1Z026-28Cancelled Sep 6, 2012 · Registration pending, canceled · Built 1997N309SLPiper PA-23-250 · S/N 27-2232Cancelled Sep 5, 2012 · Sale reported, canceled · Built 1962N66193Cessna T-50 · S/N 3632Cancelled Sep 5, 2012 · Revoked, canceled · Dodge William EN90410Cessna 182RG · S/N R18201445Cancelled Sep 5, 2012 · Sale reported, canceled · Built 1980N914BVDouglas DC-8-61 · S/N 45912Cancelled Sep 5, 2012 · Sale reported, canceled · Built 1967N4948PCessna 152 · S/N 15284855Cancelled Aug 31, 2012 · First renewal notice · Built 1981 · Robwes IncN53589Cessna 172S · S/N 172S9408Cancelled Aug 31, 2012 · First renewal notice · Built 2003 · Dean And Blaylock IncN2536NPiper PA-38-112 · S/N 38-79A0905Cancelled Aug 30, 2012 · Registration pending, canceled · Built 1979N323LBSwearingen SA226TC · S/N TC-323Cancelled Aug 30, 2012 · Registration pending, canceled · Built 1979N59030Cessna T-50 · S/N 2512Cancelled Aug 30, 2012 · Revoked, canceled · Built 1942 · Robertson Aviation EnterprisesN60145Cessna T-50 · S/N 5173Cancelled Aug 30, 2012 · Revoked, canceled · Built 1943 · Caribbean Traders IncN60497Boeing PT-27 · S/N 753871Cancelled Aug 30, 2012 · Revoked, canceled · Built 1942 · Silliman Adele M
Back to Miami, FL