OpenAirDocs.org
San Juan, PR

Cancelled registrations · 246

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 = 'PR' AND d.registrant_city = 'SAN JUAN'
  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.

N71FSIsrael Aircraft Industries 1125 WESTWIND ASTRA · S/N 071Cancelled Jun 3, 2026 · Exported to Chile · Built 1994 · Air 71 LLCN65LHBell 206B · S/N 2639Cancelled Mar 2, 2026 · Exported to Sri Lanka · Built 1979 · Windsock Management LLCN22088Cessna 172S · S/N 172S10439Cancelled May 15, 2025 · Built 2007 · Flight World IncN5313MCessna 152 · S/N 15284527Cancelled Apr 16, 2025 · Built 1980 · Flight World IncN744BASaab-Scania SF340A · S/N 340A-105Cancelled Feb 21, 2025 · Tropical Transport Services LtdN792BASaab-Fairchild 340A · S/N 340A-092Cancelled Feb 21, 2025 · Tropical Transport Services Ltd IncN154DBeech 95-B55 · S/N TC-1740Cancelled Jul 31, 2024 · Exported to Guatemala · Built 1974 · Le Pichon LLCN7049TBritten-Norman BN-2A-21 · S/N 643Cancelled May 10, 2023 · Built 1971 · Yellow Media Group IncN678TABritten-Norman BN2A-26 ISLANDER · S/N 77Cancelled Mar 5, 2023 · Blue Waters Air Charter LLCN14181Piper PA-23-250 · S/N 27-4746Cancelled Jul 23, 2022 · Registration expired, pending cancellation · Built 1971 · Blue Waters Air Charters LLCN251AMAeros SKY RANGER BCAR'S · S/N SKR05021527Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 2005 · Andreu JesusN302PRPiper PA-23-250 · S/N 27-7954120Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1979 · Flight World IncN2395ZPiper PA-23-250 · S/N 27-7954107Cancelled Feb 2, 2021 · Exported to Bahamas · Built 1979 · Yellow Media Group IncN279CCPiper PA-31-310 · S/N 31-402Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1969 · Reyes Carlos EN16035Cessna 150L · S/N 15073429Cancelled Jan 12, 2021 · Registration expired, pending cancellation · Built 1972 · Flight World IncN117PDMBB BK 117 A-3 · S/N 7090Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Ecolift CorpN160PDBell OH-58A · S/N 70-15120Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Puerto Rico Police DepartmentN161PDBell OH-58A · S/N 71-20559Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Puerto Rico Police DepartmentN62749Piper PA-23-250 · S/N 27-7654198Cancelled Aug 11, 2020 · Exported to Bahamas · Built 1976 · Yellow Media Group IncN8RTCessna 310P · S/N 310P0091Cancelled May 2, 2020 · Registration expired, pending cancellation · Built 1969 · Caribbean Aerial Surveys IncN2659DCessna 170B · S/N 20811Cancelled Mar 20, 2020 · Revoked, canceled · Built 1952 · West Indies AirwaysN222KXPiper PA-23-160 · S/N 23-1794Cancelled Jan 22, 2020 · First renewal notice · Built 1958 · Reyes Carlos EN479NCPiper PA-32-260 · S/N 32-581Cancelled Jan 22, 2020 · First renewal notice · Built 1966 · Flight World IncN479TTCessna 172P · S/N 17274090Cancelled Jan 22, 2020 · First renewal notice · Built 1980 · Flight World IncN25300Bellanca 14-9 · S/N 1022Cancelled Nov 15, 2019 · Revoked, canceled · Built 1940 · Apex Mfg Laboratories IncN757FVCessna 152 · S/N 15279713Cancelled Oct 8, 2019 · Third renewal notice · Built 1977 · Flight World IncN603ABCessna 402C · S/N 402C0603Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Tropical Transport Services Ltd IncN6218MCessna 152 · S/N 15284640Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1980 · Flight World IncN7275MDJI PHANTOM 3 PROFESSION · S/N P78DCF2903 1527Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Martinez Pedro MN9427JPiper PA-28-180 · S/N 28-3538Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1966 · Latitude Aviation LLCN20RCCessna 172M · S/N 17264224Cancelled Aug 6, 2019 · Registration expired · Built 1974 · Flight World IncN211CRPiper PA-23 · S/N 23-358Cancelled Aug 6, 2019 · Registration expired · Built 1955 · Flight World IncN5315HCessna 152 · S/N 15284085Cancelled Aug 6, 2019 · Registration expired · Built 1979 · Flight World IncN89224Cessna 152 · S/N 15282680Cancelled Aug 6, 2019 · Registration expired · Built 1978 · Flight World IncN42848Piper J3C-65 · S/N 15168Cancelled May 15, 2019 · Revoked, pending cancellation · Built 1945 · West Indies AirwaysN10CVBell 206B · S/N 2851Cancelled Mar 4, 2019 · Registration expired, pending cancellation · Rotary Power Group IncN10WFPiper PA-34-200T · S/N 34-7970008Cancelled Jan 29, 2019 · Registration expired, pending cancellation · Built 1978 · Martinez Edgardo NN593HMDJI INSPIRE 1 · S/N W13DCB25020196Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Garcia-Melchor EnriqueN229BNBritten-Norman BN-2A-6 · S/N 229Cancelled Nov 2, 2018 · Blue Waters Air Charters LLCN555DMBritten-Norman BN2A-26 ISLANDER · S/N 129Cancelled Nov 2, 2018 · Vieques Aviation Management CorpN20EGDJI PHANTOM 2 · S/N PH645292431Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Garcia EnriqueN446FACessna 150A · S/N 15059162Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1961 · Orsini Francisco AN147ACCessna T310Q · S/N 310Q0713Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1973N512UXTrimble Navigation UX5 · S/N EBX00756Cancelled May 30, 2018 · Sale reported, canceledN306CCChaves Carlos A MONI · S/N 264TCancelled Apr 19, 2018 · Registration expired, pending cancellation · Chaves Carlos AN3978NBeech 35 · S/N D-736Cancelled Apr 5, 2018 · Revoked, canceled · Built 1947 · West Indies AirwaysN79287Cessna 172K · S/N 17258024Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1969 · Scuotto Giovanni EN3465WPiper PA-32-260 · S/N 32-337Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1966 · St Barth Management Services & Travel LLCN70JGCessna 402B · S/N 402B0363Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1973 · Ortiz Jose I GonzalezN926MVEurocopter EC 130 B4 · S/N 3609Cancelled Mar 1, 2018 · Exported to Dominican Republic · Built 2002 · Nader Corp
Back to San Juan, PR