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.

N6586XCessna TU206G · S/N U20605960Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Solid Gold Music Centers IncN702DHBoeing 727-30C · S/N 19793Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1968 · Air Trading International LLCN8415XRobinson Helicopter R22 · S/N 0358Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1983 · International Flight Center IncN9180YAerostar International RAVEN S49A · S/N S49A-3185Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1994 · Tansey Barbara WN471USBoeing 727-51 · S/N 18807Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1965 · International Airline Support GroupN7029ZConvair HC-131A · S/N 52-5798Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Harmer IncN747TRAero Commander 680 · S/N 680-311-8Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1956 · Nunez Juan PN722GSBoeing 707-321C · S/N 19373Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1967 · Air Trade LeasingN9888ADehavilland DH104 DOVE 7A · S/N 04534Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Visionair International IncN9889CBeech C-45G · S/N AF-263Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1953 · Rivera CharlieN429UEBritish Aerospace BAE JETSTREAM 3101 · S/N 807Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1988 · Caribbean Eagle IncN4639PPiper PA-23-250 · S/N 27-160Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1960 · Galeano Nestor RaulN4865LCessna 152 · S/N 15284236Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1980 · Air Sal Leasing IncN5067JCessna T310R · S/N 310R0187Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1975 · International Flight CenterN5123QCessna T210L · S/N 21059623Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1972 · Blankenship Lewis SN6356UCessna T210R · S/N 21064942Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Consuela Enterprises IncN661AVDouglas DC-8-63F · S/N 45969Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1968 · Miami Leasing IncN17320Douglas DC3-G202A · S/N 1966Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1937 · Jet Engine Support IncN49472Douglas C-47 · S/N 43-48155Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Air Caribbean Transporter IncN666CZPfeiffer Emil AIR COMMAND 532 · S/N 0334Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Pfeiffer EmilN86402Cessna T337D · S/N 337-1174Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1969 · Rum Cay Courier IncN105HLCondor CONDOR III+2 · S/N 83-101-3-2Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1983 · Condor Aircraft CorpN122JMPiper PA-31-310 · S/N 31-496Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1969 · Diaz Julio RamonN444ARMitsubishi MU-2B-35 · S/N 555Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1971 · Aldora CorporationN524MDMcdonnell-Douglas DC-10-30 · S/N 46999Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1979 · Miami Leasing IncN5394VCessna T210L · S/N 21060929Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1975 · Mcintosh JohnN5964YPiper PA-23-250 · S/N 27-3134Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1966 · International Jet Center IncN701SSButler AEROSTAR 601 · S/N 61-0060-113Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1970 · Systems Tourism Marketing CorpN884GBeech 65-88 · S/N LP-23Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1966 · Crown Aviation Services IncN9987QSikorsky S-51 · S/N WA/H/56Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Visionair International IncN708DHBoeing 727-25 · S/N 18275Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1964 · Air Trading International LLCN89793Cessna 152 · S/N 15282869Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1978 · Keith YuhrN9016QDouglas C54-D · S/N 10697Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Knightsbridge IntlN92GSBoeing 720-047B · S/N 18452Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1962 · Blue Metals IncN30607Thrush S2R-T34 · S/N T34-399Cancelled Sep 6, 2013 · Exported to Colombia · Built 2012 · Africair IncN404CJBoeing 737-401 · S/N 23886Cancelled Sep 3, 2013 · Exported to Venezuela · Built 1989 · Shell Aerospace Supplies IncN961MCCessna 172S · S/N 172S9617Cancelled Aug 29, 2013 · Sale reported, canceled · Built 2004N76562Cessna 120 · S/N 10998Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1946 · Miami Air Force IncN144SARobinson Helicopter R44 II · S/N 10786Cancelled Aug 27, 2013 · Sale reported, canceled · Built 2005N342PSCessna 402B · S/N 402B0429Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1973N55PKPiper PA-32-301 · S/N 32-8206029Cancelled Aug 27, 2013 · Sale reported, canceledN578ALCessna 208B · S/N 208B2378Cancelled Aug 27, 2013 · Exported to France · Built 2012 · Africair IncN61410Anderson John H AVID FLYER MK 4 · S/N 1414DCancelled Aug 27, 2013 · Sale reported, canceled · Built 2002N713UPMcdonnell Douglas DC-8-71 · S/N 46014Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1968N727WAPiper PA-23-250 · S/N 27-3592Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1966N54326Boeing 727-231 · S/N 20233Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1969N6822Boeing 727-223 · S/N 19700Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1968N926LDouglas DC-9-32 · S/N 47172Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1968N3203PAero Commander 681 · S/N 6019Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1969N807CKDouglas DC-8-55 · S/N 45767Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1966
Back to Miami, FL