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.

N162UALopez Rey A CONDOR III · S/N 83-162-3Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Lopez Rey AN350AKPiper PA-31-310 · S/N 31-7401240Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1974 · Gonzalez Orlando JosephN55554Raven Industries RALLY RX7 · S/N RX7-124Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1979 · Tropical Balloons IncN6034TBeech 65 · S/N LC-172Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1965 · Redi-Power IncN6059Kozik RRKB8M GYROPLANE · S/N KK-1006Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1972 · Lester Gary WN6060KCessna R172K · S/N R1722024Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1976 · Salta Investments IncN608LLockheed 18-56 · S/N 2305Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1942 · Vintage Sales CorpN6098YCessna T210N · S/N 21064249Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1981 · Strato Fleet Executive Air CorpN5256YCessna T210N · S/N 21064138Cancelled Apr 24, 2013 · Exported to Brazil · Rolim Freight Forward IncN16780Bell 206L · S/N 45112Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1977 · Municipal Helicopters IncN5694DBeech G50 · S/N GH-103Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1959 · Whinnery Lewis AN5696YPiper PA-23-250 · S/N 27-2816Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1965 · Titan Properties IncN569QABeech G18S · S/N BA-606Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1961 · Von Mandel Mark JN578JCDouglas DC-8-31 · S/N 45275Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1960 · Jfc Enterprises IncN58335Hughes 269C · S/N 390762Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1979 · Helitours International IncN5854CBeech D18S · S/N A-588Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1951 · Sun Air Bahamas IncN150PYAirbus Industrie A300 B4-203 · S/N 150Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Pyramid Leasing Two IncN20PCCessna 150J · S/N 15071116Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1969 · Skinner B WN5537GCessna 150J · S/N 15071037Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1969 · George T Baker Aviation SchoolN5594HBeech 95-B55 (T42A) · S/N TC-1483Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1972 · Martinez MarieN5652KMaule M-6-235 · S/N 7449CCancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1983 · Green Fredricke MN931JHCessna 172N · S/N 17273826Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1980 · Alliance Air IncN49435Cessna 152 · S/N 15281264Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1978 · Aviation Business IncN502RMMohammed Ricardo R MINI 500 · S/N 0359Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Mohammed Ricardo RN5240JCessna 404 · S/N 404-0621Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1980 · Cook John CN5413YPiper PA-23-250 · S/N 27-2492Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1964 · Maintenance Services IncN5471YPiper PA-23-250 · S/N 27-2562Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1964 · Big Old Bird Charter Co IncN54835Piper PA-23-250 · S/N 27-7554136Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1975 · Gustinger Alfred JrN55TRBeech E-55 · S/N TE-1166Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1979 · Isquerdo JoaquinN990ZMcdonnell Douglas DC-9-31 · S/N 47136Cancelled Apr 18, 2013 · Sale reported, pending cancellation · Built 1967N37573Douglas DC-6B · S/N 44897Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1956 · Aero Rentals IncN38MSBeech D18S · S/N A-224Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1946 · Raimun Charters IncN406VWCessna 411 · S/N 4110208Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1966 · Brockway Dale HN43LBeech E18S-9700 · S/N BA-228Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1956 · International Aero Sales IncN4FBAero Commander 680V · S/N 1688-68Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1967 · Rodrigo FernandoN34ELCessna 182S · S/N 18280688Cancelled Apr 16, 2013 · Exported to Nicaragua · Built 2000 · Atlantic Aviation Group IncN2307MThrift-Roy BENSEN B8MG · S/N RLT-003Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Harris Anthony JN2537NPiper PA-38-112 · S/N 38-79A0906Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1979 · Riggs Charles AN27012Balloon Works FIREFLY 7 · S/N 758Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1976 · Smith Charles A JrN2965KLuscombe 8A · S/N 5692Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1947 · Parker Robert WN30609Thrush S2R-T34 · S/N T34-404Cancelled Apr 12, 2013 · Exported to Colombia · Built 2012 · Africair IncN14344Piper PA-23-250 · S/N 27-7304925Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1972 · Burkley WilliamN1501KBalloon Works FIREFLY 7 · S/N 11116Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1981 · Caplan Donald SN1671ECessna 172N · S/N 17271088Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1978 · Hernandez OctavioN1037ADouglas DC3-S · S/N 43341Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Sierra InocencioN1045GConvair VT-29D · S/N 52-5818Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Caribbean Aviation CorpN617SEDouglas DC-6B · S/N 44088Cancelled Apr 10, 2013 · Revoked, pending cancellation · Built 1974 · Span East Airlines IncN24994Cessna 152 · S/N 15280501Cancelled Apr 9, 2013 · Exported to Bolivia · Built 1977 · Hawk Aviation Sales And Charter IncN5309TPiper PA-34-200 · S/N 34-7250248Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1972 · Roach James DN5413GCessna 404 · S/N 404-0032Cancelled Apr 9, 2013 · Registration expired, pending cancellation · 404 Aviation Inc
Back to Miami, FL