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.

N3456RCessna 182L · S/N 18258756Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1967 · Patterson Harold ClydeN94666Cessna 152 · S/N 15285758Cancelled Jul 17, 2013 · Exported to Ecuador · Built 1983 · Delta Fox Aircraft Services IncN1105Curtiss PUSHER · S/N 1912Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Built 1962 · Aerial PromotionsN184AWBoeing 737-277 · S/N 22651Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1987N8101MTevar Manuel SPRINT II · S/N 030Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1989N883JBeech 65-88 · S/N LP-33Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1966N9873ANorth American T-28D · S/N 51-3505Cancelled Jul 16, 2013 · Sale reported, canceledN235KTFairchild F-27 · S/N 16Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1958N5002UCessna 185 · S/N 18503488Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Wallace James W F IVN627RABeech B200 · S/N BB1110Cancelled Jul 12, 2013 · Exported to Venezuela · Built 1983 · Lipari Investments LLCN6802NCessna T210N · S/N 21063153Cancelled Jul 12, 2013 · Exported to Guatemala · Built 1978 · Lopez And Company IncN7816CPiper PA-34-200T · S/N 34-7670104Cancelled Jul 12, 2013 · Exported to Guatemala · Built 1975 · Lopez & Co IncN955CDCirrus Design SR20 · S/N 1609Cancelled Jul 12, 2013 · Exported to Brazil · Built 2006 · Rolim Freight Forward IncN1162SBeech H-18 · S/N BA-691Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1964N21UBeech H-18 · S/N BA-709Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1964N250NLockheed 18-56 · S/N 2315Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1942N405CJBoeing 737-401 · S/N 23885Cancelled Jul 11, 2013 · Exported to Venezuela · Built 1989 · Shell Aerospace Supplies IncN416DABoeing 727-232 · S/N 21258Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1976N4732Boeing 727-235 · S/N 19452Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1967N4736Boeing 727-235 · S/N 19456Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1968N574SWBritish Aerospace JETSTREAM 3201 · S/N 835Cancelled Jul 11, 2013 · Sale reported, canceledN62242Douglas DC-6 · S/N 42857Cancelled Jul 11, 2013 · Sale reported, canceledN65HPBeech F33A · S/N CE-610Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1975N920MRCooper Marcus F III QUICKIE Q2 · S/N 2751Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1991N66601Pegasus QUASAR · S/N SWTQ0001Cancelled Jul 10, 2013 · Sale reported, canceled · Built 1989N119MPPerez Luis M BLUEHAWK · S/N 081956Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Perez Luis MN25254Cessna 152 · S/N 15280555Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1977 · General Aviation Intl CorpN317SPDouglas C-118A · S/N 53-3302Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Air Worthy Leasing CorpN9199YPiper PA-31-310 · S/N 31-176Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1968 · Blue Sky Tours IncN1201NMooney M20J · S/N 24-0555Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1978 · Shaffer Paul AN14338Piper PA-23-250 · S/N 27-7304921Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1972 · Pyfrom Patavia TN701DRPiper PA-31 · S/N 31-235Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1968 · Osmo IncN701WOmni Weld OMNI QUESTOR · S/N 0Q-1Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1983 · Leszczynski Francis VN792FABoeing 707-138B · S/N 17701Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1959 · Fba IncN7953LBeech A23-24 · S/N MA-129Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1966 · Hallaran Shawn QN88939Douglas C54B-DC · S/N 18397Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1944 · Bif Air IncN90019Bell 206B · S/N 4538Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 2000 · Intersouth IncN61238Cessna 150J · S/N 15070910Cancelled Jul 3, 2013 · Exported to Ecuador · Built 1969 · Miami Rent A Plane LLCN8869AStetson William A CGS HAWK II · S/N H-II-012-RCancelled Jul 3, 2013 · Registration expired, pending cancellation · Built 1987 · Stetson William AN267SSCessna 404 · S/N 4040432Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1979 · Fluhencio PadillaN2845EAerostar International S-60A · S/N S60A-3011Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1986 · Benihana Of TokyoN311RDFairchild F-27 · S/N 72Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Seidle William DN35981Cessna U206F · S/N U20602845Cancelled Jul 2, 2013 · Exported to Bolivia · Built 1975 · Alas Srl CorpN4063YBalloon Works FIREFLY 6B · S/N F6B-019Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1987 · Tansey BarbaraN63PCKnight DR VOLMER SPORTSMAN · S/N BK1Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Aquarius Rising Enterprises IncN66KSSwearingen SA-226T · S/N T209Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1971 · O.R.D. Inc.N9491MCessna 210K · S/N 21059391Cancelled Jul 2, 2013 · Exported to Bolivia · Built 1970 · Alas Srl CorpN1634VCessna 140 · S/N 13806Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1947 · Macivor James PN5722NRaven S55A · S/N S55A-727Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Roma CorpN6169XAero Commander 560-F · S/N 560F-1022-10Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1961 · Lorente Jorge
Back to Miami, FL