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.

N282WABoeing 727-247 · S/N 21484Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1978 · Rp Aviation IncN3308LDouglas DC-9-14 · S/N 45703Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1966 · International Airline Sup Grp IncN8244KStetson William SPORT A-1 · S/N 95-01Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1995 · Stetson WilliamN427FBDouglas DC-8F-54 · S/N 45684Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1963 · Agro Air Associates IncN611SCRobinson Helicopter R22 BETA · S/N 3869Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 2005 · Alj Engines Supply IncN93RAAero Commander 680W · S/N 1722-2Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1968 · American Avn Ground Services IncN95141Quicksilver Enterprises QUICKSILVERMXIISPRIN · S/N SPRINT II 557Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Pinder Keith AN705DSBell 206L-3 · S/N 51488Cancelled Mar 1, 2017 · Exported to Colombia · Lpg Aircraft Parts IncN17HRCessna 172H · S/N 17255645Cancelled Feb 28, 2017 · Exported to Guatemala · Built 1966 · Santos RodrigoN40443Kurtz Jay B CAPELLA XS · S/N 993Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1994 · Tucker John C JrN61FBRockwell International NA-265-60 · S/N 30680Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Fine Airlines IncN97277Cessna 172P · S/N 17276172Cancelled Feb 24, 2017 · Third renewal notice · Built 1984 · Elide Leasing IncN4092PTextron G36 · S/N E-4092Cancelled Feb 23, 2017 · Exported to Brazil · Built 2016 · Rolim Freight Forward IncN379CPPiper PA-23-250 · S/N 27-2737Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1964 · Hayes Gracie VN56CABubel John A BUCCANEER II · S/N B2B-K026Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1996 · Bubel John AN203LRans S12XL · S/N 07950637Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Kinghorn Alexander DN596AHLockheed L-1011-385-3 · S/N 193J1196Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1980 · Agro Air Associates IncN627WDBritten-Norman BN2A-26 ISLANDER · S/N 627Cancelled Feb 16, 2017 · Registration expired, pending cancellation · World Aviation Enterprises IncN663ASPiper PA-31-310 · S/N 31-529Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1969 · World Aviation Enterprises IncN731BARobinson Helicopter R22 BETA · S/N 3013Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1999 · Alj Engines Supply IncN784ALMcdonnell Douglas DC-8-63F · S/N 46135Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1970 · Miami Leasing IncN458XLAerospatiale AS350 B2 ECUREUIL · S/N 1688Cancelled Feb 13, 2017 · Exported to Colombia · Angel Emiliano TrusteeN9270HGrumman G-44 · S/N 1384Cancelled Feb 13, 2017 · Revoked, canceled · Built 1944 · Ward Sales Co IncN9876CNorth American TB-25N · S/N 4428874ACancelled Feb 13, 2017 · Revoked, canceled · Caribbean Cargoes IncN98821Piper J3C-75S · S/N 19067Cancelled Feb 13, 2017 · Revoked, canceled · Built 1946 · Baker AntonN9921ZBeech C-45H · S/N AF-724Cancelled Feb 13, 2017 · Revoked, canceled · Intrntnl Aircraft Deliveries IncN6550KRepublic RC-3 · S/N 816Cancelled Feb 4, 2017 · Revoked, canceled · Built 1947 · Browne JackN6933CLockheed 1049H-82 · S/N 4826Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Bal Trade IncN7277CNorth American T-28A · S/N 49-1668ACancelled Feb 4, 2017 · Revoked, canceled · Neville Rosario EN7417ZPiper PA-25-235 · S/N 25-3389Cancelled Feb 4, 2017 · Revoked, canceled · Built 1965 · Hurlbut W M DBAN74659Lockheed 18-56 · S/N 2190Cancelled Feb 4, 2017 · Revoked, canceled · Madden & Playford Aircraft CoN7466CNorth American AT-6 · S/N 4482487Cancelled Feb 4, 2017 · Revoked, canceled · Perez Evelie AN74694Consolidated PBY-5A · S/N 46631Cancelled Feb 4, 2017 · Revoked, canceled · Cardiff DonN74830Douglas A-26B · S/N 41-39298RCancelled Feb 4, 2017 · Revoked, canceled · Rum Cay Development Co IncN7486XCessna 172B · S/N 17247986Cancelled Feb 4, 2017 · Revoked, canceled · Built 1960 · Mcquale JohnN7511ZPiper PA-25-235 · S/N 25-3548Cancelled Feb 4, 2017 · Revoked, canceled · Built 1965 · Eldridge Hudson BN7662MCessna 175 · S/N 55962Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Acreage Clearinghouse IncN774RDouglas DC-7B · S/N 44868Cancelled Feb 4, 2017 · Revoked, canceled · Built 1955 · Betair IncN7822QCessna 402A · S/N 402A0122Cancelled Feb 4, 2017 · Revoked, canceled · Built 1969 · Aviation Facilities IncN7867QCessna 310Q · S/N 310Q0650Cancelled Feb 4, 2017 · Revoked, canceled · Aviation Facilities IncN7869UCessna 172F · S/N 17251869Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Hernandez JohnN7877BConsolidated Vultee PBY-6A · S/N 46659Cancelled Feb 4, 2017 · Revoked, canceled · Aircraft Instrument CorpN7878BConsolidated Vultee PBY-6A · S/N 46650Cancelled Feb 4, 2017 · Revoked, canceled · Aircraft Instrument CorpN7880BConsolidated Vultee PBY-6A · S/N 46639Cancelled Feb 4, 2017 · Revoked, canceled · Aircraft Instrument CorpN7883BConsolidated Vultee PBY-6A · S/N 64005Cancelled Feb 4, 2017 · Revoked, canceled · Aircraft Instrument CorpN7884BConsolidated Vultee PBY-6A · S/N 64033Cancelled Feb 4, 2017 · Revoked, canceled · Aircraft Instrument CorpN8005NPiper PA-28-140 · S/N 28-25246Cancelled Feb 4, 2017 · Revoked, canceled · Built 1968 · Tatum Joseph JN82776Aeronca 7AC · S/N 7AC-1423Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Slightom AncilN8338Lockheed 1049G · S/N 4616Cancelled Feb 4, 2017 · Revoked, canceled · Crosson Jack AN8579EAeronca 7GC · S/N 7GC100Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Helair Incorporated
Back to Miami, FL