OpenAirDocs.org
Santurce, PR

Cancelled registrations · 56

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 = 'SANTURCE'
  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.

N777NADouglas DC3-G103A · S/N 6331Cancelled Oct 23, 2021 · Revoked, canceled · Built 1942 · Interamerican Brokerage EnterpriseN93049Martin 202 · S/N 9132Cancelled Dec 20, 2019 · Revoked, canceled · Built 1946 · Rey Segui CompanyN9349TCessna 180C · S/N 50849Cancelled Oct 2, 2019 · Revoked, canceled · Built 1960 · Jimenez Jose C FacundoN382FHFairchild Hiller FH-1100 · S/N 145Cancelled Mar 16, 2018 · Revoked, canceled · Built 1968 · Office Of TransportationN4794SPiper PA-32-260 · S/N 32-1145Cancelled Apr 5, 2017 · Registration expired, pending cancellation · Built 1969 · North Cay Airways IncN6448KRepublic RC-3 · S/N 699Cancelled Feb 4, 2017 · Revoked, canceled · Built 1947 · Sierra RafaelN7554ZPiper PA-25-235 · S/N 25-3604Cancelled Feb 4, 2017 · Revoked, canceled · Built 1965 · Rice Richard BN219JMBeech 65-80 · S/N LD-65Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1962 · Carrasco AgustinN107QSCessna 172N · S/N 17273966Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1980 · Quick Silver Aviation IncN65432Beech C18S · S/N 4541Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Nieves Placido DiazN39544Douglas DC3 · S/N 11649Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1943 · Holyfield Dick GN4046GBell 206A · S/N 202Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1968 · Carrasco Augustin DBAN286SEDouglas DC3A · S/N 2004Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1938 · Holyfield Dick GN6607YPiper PA-23-250 · S/N 27-3912Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1968 · Nazer AlturoN65389Douglas DC3C · S/N 19382Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1942 · Interstate Air Service CorpN1126WBell 47G-3B-1 · S/N 2918Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Built 1964 · Kozpla Fishing CorpN1906QCessna 177RG · S/N 177RG0306Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1972N7507Sikorsky S-55 · S/N SA55-563Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1953 · Heliambulance Service CorpN7345Beech 65 · S/N LC-15Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1960 · Airport Aviation ServicesN62555Piper PA-31-310 · S/N 31-43Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1967 · Eximport CxaN6013YPiper PA-23-250 · S/N 27-3195Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1966 · Santini JoseN9090TBeech 65-A80 · S/N LD-207Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1964N7082MCessna 175 · S/N 55382Cancelled Mar 14, 2013 · Sale reported, pending cancellation · Built 1958N4TNMitsubishi MU-2B-15 · S/N 115Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1969 · Mcvey Charles JN6611ZPiper PA-25 · S/N 25-397Cancelled Nov 14, 2012 · Revoked, pending cancellation · Built 1960 · Rice Richard BN79044Douglas DC3C · S/N 9654Cancelled Sep 10, 2012 · Revoked, canceled · Built 1943 · Interstate Air Service CorpN8011EDouglas DC3C · S/N 4521Cancelled Sep 10, 2012 · Revoked, canceled · Built 1959 · Interstate Air Service CorpN4532YPiper PA-25-235 · S/N 25-4160Cancelled Jul 19, 2012 · Revoked, canceled · Rice Richard BN4382YPiper PA-25-235 · S/N 25-4886Cancelled Jun 27, 2012 · Revoked, canceled · Built 1969 · Rice Richard BN314QBeech 65-A80 · S/N LD-239Cancelled Feb 27, 2012 · Sale reported, pending cancellation · Built 1965N2386QBeech 23 · S/N M-458Cancelled Aug 26, 2011 · Sale reported, pending cancellation · Built 1963N259DABeech C18S · S/N 42-56753Cancelled Oct 14, 2009 · Registration revoked · Built 1942 · Diaz Aviation CorpN13352Beech C18S · S/N 6290Cancelled Oct 9, 2009 · Registration revoked · Built 1944 · Aviation Assoc Of Puerto Rico IncN28323Douglas DC3A · S/N 2253Cancelled Jul 21, 2009 · Registration revoked · Built 1940 · Interstate Air Service CorpN198WNorth American B-25C · S/N 4430937ACancelled Jul 9, 2009 · Registration revoked · Borinquen Imports Co IncN103PBeech D18S · S/N A-370Cancelled Jun 26, 2009 · Registration revoked · Built 1947 · Diaz Nieves PlacidoN8519RBellanca 14-19-3 · S/N 4281Cancelled May 1, 1998 · Caribbean Mooney CorpN712CSMooney M20F · S/N 221260Cancelled Nov 12, 1997 · Caribbean Mooney CorpN152ZLPiper PA-23-250 · S/N 272716Cancelled Mar 10, 1997 · Triennial form not returned · Puerto Rico Fire ServiceN9018EMaule M-5-235C · S/N 7060CCancelled Mar 10, 1997 · Triennial form not returned · Puerto Rico Fire ServiceN201GAMooney M20J · S/N 240078Cancelled Feb 18, 1997 · Caribbean Mooney CorpN8758UCessna 172F · S/N 17252662Cancelled Mar 23, 1995 · Triennial form not returned · Fairbank James HN345GPRepublic P-47N · S/N 539C/1537Cancelled Dec 10, 1980 · Thunderbolt IncN21787Douglas DC3A · S/N 2186Cancelled Jul 14, 1977 · Interstate Air Service CorpN34970Douglas DC3D-R-1830-90C · S/N 42966Cancelled Jul 12, 1977 · Built 1946 · Interstate Air Service CorpN3406Convair 340 · S/N 6Cancelled Jun 24, 1976 · Carribbean-Atlantic Airlines IncN4911YPiper PA-25-260 · S/N 25-4608Cancelled Nov 1, 1974 · Exported to Dominican Republic · Built 1968 · Aviation Associates Of Puerto Rico IncN5557JPiper PA-32-260 · S/N 32-1021Cancelled Apr 18, 1969 · Exported to France · Built 1968 · Aviation Associates Of Puerto Rico IncN6413JPiper PA-28-180 · S/N 28-4830Cancelled Apr 18, 1969 · Exported to France · Built 1968 · Aviation Associates Of Puerto Rico IncN5280ZPiper PA-22-108 · S/N 22-8975Cancelled Feb 4, 1964 · Built 1961 · Rodriguez Sergio E
Back to Santurce, PR