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.

N9264YPiper PA-31-310 · S/N 31-348Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1968 · Everrready Air Charters IncN9890ZCurtiss Wright C-46D · S/N 33111Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1942 · Garcia Pedro AN9994QDouglas DC3C · S/N 25966Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1943 · Aero-Elite CorporationN999CSPiper PA-31-325 · S/N 31-7612099Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1976 · Bryus CorporationN2644ZCessna 310R · S/N 310R1814Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1979N430PCCessna 401 · S/N 401-0061Cancelled Jun 27, 2013 · Sale reported, canceledN4451BBoeing 720-059B · S/N 18086Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1961N5002RHughes 269C · S/N 1080Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1982N5504VCessna T210L · S/N 21060969Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1975N87517Cessna 310R · S/N 310R0601Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1975 · Williams RichardN8135FCessna 208B · S/N 208B5020Cancelled Jun 19, 2013 · Exported to Suriname · Africair IncN105SDHead H L BUSHMASTER · S/N 105-85Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1985 · Head H LN2711JBeech 65-80 · S/N LD-11Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1962 · Aircraft Recovery Services IncN27751Piper PA-31-350 · S/N 31-7852145Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1978 · Chaban PeterN4024QCessna 401 · S/N 401-0124Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1967 · Octavia Wildlife IncN4850PPiper PA-23-250 · S/N 27-423Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1961 · Triton Development Company IncN491PDouglas DC3C · S/N 43075Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1946 · Normair International IncN49822Cessna 152 · S/N 15281341Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1978 · Swanko Edward HN50314Douglas DC3C · S/N 12868Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1944 · Art EnterprisesN505SAMitsubishi MU-2B · S/N 008Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1966 · Malibu Leasing CorpN8820FHughes 269A · S/N 0163Cancelled Jun 18, 2013 · Registration expired, pending cancellation · C B R O IncN2982YCessna 182E · S/N 18253982Cancelled Jun 17, 2013 · Exported to Colombia · Built 1962 · Atlantic Aviation Group IncN653SSGrumman G-73 · S/N J-53Cancelled Jun 14, 2013 · Registration expired, pending cancellation · U S Distributors IncN65858Mcdonnell Douglas MD 83 · S/N 49578Cancelled Jun 14, 2013 · Sale reported, pending cancellationN748USBoeing 727-281 · S/N 20570Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1972N9701RCessna TU206G · S/N U20606945Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Built 1986 · Burnside-Ott Avn Training Ctr IncN3227Shyrock Gene R EXEC · S/N 3227Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Shryock Gene RN5093Grumman Acft ENG Cor-Schweizer G-164A · S/N 1122Cancelled Jun 13, 2013 · Sale reported, canceled · Built 1973N54735Piper PA-31-350 · S/N 31-7405257Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1974 · Gonzalez Jose LN58CAMitsubishi MU-2B-20 · S/N 170Cancelled Jun 13, 2013 · Sale reported, canceled · Built 1969N232DEasley Clarence Eldon PITTS S2-E · S/N 1Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1981 · Miller Jeffrey LN37159Cessna 404 · S/N 404-0123Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1978 · Coordinated Developments IncN456TTCessna 310K · S/N 310K0008Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1966 · Basulto ArmandoN49984Piper PA-31-350 · S/N 31-7552074Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1975 · Cooper James WilliamN8134LCessna 208B · S/N 208B5015Cancelled Jun 12, 2013 · Exported to Tanzania · Built 2013 · Africair IncN8161GDouglas DC-6A · S/N 43818Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1953 · L P Crew Air Services IncN103HLCondor CONDOR II · S/N 83-101-2Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Condor Aircraft CorpN103UASky High Products CONDOR III+II · S/N 83-103-3-2Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Sky High Products IncN107HLCondor CONDOR III · S/N 83-101-3Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Condor Aircraft CorpN110HLCondor CONDOR II · S/N 83-150-2Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Condor Aircraft CorporationN110UAPerez Luis M CONDOR III+II · S/N 83-110-3-2Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Perez Luis MN111HLCondor CONDOR II · S/N 83-151-2Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Condor Aircraft CorporationN112HLCondor CONDOR II · S/N 83-152-2Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Condor Aircraft CorporationN212DDDouglas C-117D · S/N 43386Cancelled Jun 11, 2013 · Registration expired, pending cancellation · D&D Parts IncN244MPRockwell International 690B · S/N 11531Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1979 · Gor Com Enterprices IncN272LDouglas DC3A · S/N 2263Cancelled Jun 11, 2013 · Sale reported, canceled · Built 1940N2816WBoeing 727-247 · S/N 20872Cancelled Jun 11, 2013 · Sale reported, canceled · Built 1974N32253Beech C-45 · S/N 41-2364Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Future Air FraithN3801SBedwell Douglas F KR-2 · S/N 3959Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Kirk Christopher HN4420BFuture Flights QUICKSILVER MX II · S/N 1401Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Future Flights Inc
Back to Miami, FL