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.

N810CKMcdonnell Douglas DC-8-52 · S/N 45814Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1966N824ATDouglas DC-9-32 · S/N 47278Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1968N847AABoeing 727-223 · S/N 20988Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1975N929LDouglas DC-9-32 · S/N 47174Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1968N955ASMcdonnell Douglas DC-9-82(MD-82) · S/N 48080Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1981N104WAMcdonnell Douglas DC-10-10 · S/N 46727Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1973N3107PSwearingen SA227-AC · S/N AC-496Cancelled Aug 21, 2013 · Sale reported, canceledN914AWBoeing 757-225 · S/N 22208Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1984N978ZMcdonnell Douglas DC-9-31 · S/N 47250Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1968N144GWag LANCAIR IV · S/N L1V-102Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1996 · Florida Interwest CorpN6031XMooney M20A · S/N 1621Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1960N6729YPiper PA-23-250 · S/N 27-4061Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1968 · Alfonso Paula MariaN6846LPiper PA-31P · S/N 31P-50Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1971 · Edward Investments CorpN711RCCessna 401 · S/N 401-0277Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1968 · Vasquez DavidN7620UBoeing 727-222 · S/N 19537Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1968N7624UBoeing 727-222 · S/N 19541Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1968N2817WBoeing 727-247 · S/N 20873Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1974N60780Cessna 150J · S/N 15070573Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1969 · Atlantic Airways IncN6246ZCessna U206G · S/N U20606201Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1981 · Vhor Srl CorpN6310JDouglas DC-7 · S/N 45150Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1957 · Vazquez S AN63696Piper PA-31-325 · S/N 31-7712027Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1977 · Pyfrom Patavia TaniyhaN64707Bell 47G-3B-1 · S/N 3666Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Riggs Rock AN401DABoeing 727-232 · S/N 21145Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1975N403DABoeing 727-232 · S/N 21147Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1975N4534PPiper PA-23-250 · S/N 27-38Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1960 · Intermarketing Air CorpN4801Aero Commander 680 · S/N 680-313-9Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1956 · Six Brothers IncN499DABoeing 727-232 · S/N 21143Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1975N5188RCessna 172M · S/N 17263405Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1974 · Kerrick W Glenn LN51PJGreco-Bruno DOLPHIN I · S/N GB-001Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1987 · Greco-Bruno Aircraft CorpN53244Cessna A188B · S/N 18801707TCancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1974 · Diacsa IncN846ATMcdonnell Douglas DC-9-32 · S/N 47226Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1968N1986Boeing 727-23 · S/N 18442Cancelled Aug 14, 2013 · Sale reported, canceled · Built 1965N2889VBeech 35 · S/N D-296Cancelled Aug 14, 2013 · Sale reported, canceled · Built 1947N400BBeech G35 · S/N D-4663Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1956 · Hilton Maurice JosephN418DABoeing 727-232 · S/N 21271Cancelled Aug 14, 2013 · Sale reported, canceled · Built 1977N438MBeech A65 · S/N LC-250Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1967 · Vargas RamonN4521PPiper PA-23-250 · S/N 27-25Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1960 · Anderson DouglasN66196North American SNJ-4 · S/N 27125Cancelled Aug 14, 2013 · Revoked, canceled · Built 1943 · Conrad W HN109CKLockheed L-1011-385-1-15 · S/N 193N1205Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1981N3625XAero Commander 100 · S/N 353Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1969 · Chico Aero ClubN3773BBeech E18S · S/N BA-59Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1955 · Enriquez Mario AN250JWLockheed 18-56 · S/N 2408Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1944 · Boyd Robert LN2611BAero Commander 520 · S/N 520-123Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1954 · Guerra AmilcarN2796ABell 47D1 · S/N 475Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Bomback Donald C Sr DBAN300NAPiper PA-31-310 · S/N 31-763Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1971 · M K D FisheriesN7623UBoeing 727-222 · S/N 19540Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1968N9810WPiper PA-28-140 · S/N 28-23310Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1967N1444DCessna 170B · S/N 20027Cancelled Aug 7, 2013 · Revoked, canceled · Built 1951 · Hixson G RN1853UMcdonnell-Douglas DC-10-30 · S/N 47812Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1984 · Aircraft And Engine Parts LLCN2358HBalloon Works FIREFLY 7 · S/N 7729Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1978 · Whitehouse Walter E
Back to Miami, FL