OpenAirDocs.org
Saipan, MP

Cancelled registrations · 37

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 = 'MP' AND d.registrant_city = 'SAIPAN'
  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.

N910BSTextron 208B · S/N 208B5554Cancelled Feb 6, 2023 · Exported to Costa Rica · Built 2019 · Tandem Skydive Saipan IncN675ACPilatus Britten-Norman BN2T ISLANDER · S/N 2183Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1983 · Arctic Circle Air CoN192PBBell 206B · S/N 825Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1972 · Micronesian Aviation Corp IncN3689YCessna 210C · S/N 21058189Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1963 · Medicruiser LLCN7328FCessna 172N · S/N 17273244Cancelled Sep 8, 2020 · Registration expired · Built 1979 · Marianas Air Transfer IncN1029FCessna 172N · S/N 17272936Cancelled Aug 5, 2020 · Built 1979 · Marianas Air Transfer IncN8189BCessna 172 · S/N 29989Cancelled May 2, 2020 · Registration expired, pending cancellation · Built 1957 · Murphy Michael BN291QEnstrom F-28A · S/N 307Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 1975 · Crowe Kenneth RN13230Cessna 172M · S/N 17262593Cancelled Jul 3, 2019 · Registration expired, pending cancellation · Built 1973 · Coral Ocean Airways IncN161DPBeech 95-B55 · S/N TC-2151Cancelled Apr 5, 2019 · First renewal notice · Built 1978 · Saipan Airline IncN76NFShort Bros SD3-30 200 · S/N SH 3044Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1980 · Aviation Services (Cnmi) LtdN6989ACessna 172 · S/N 29089Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1956 · Quincy Corp DBAN11287Cessna 150L · S/N 15075301Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1973 · Christian Robert FN177STHughes 369HS · S/N 820407SCancelled Jul 19, 2017 · Registration expired, pending cancellation · Milagros Z Fishing Company IncN7163JBell 47G-4A · S/N 7626Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1968 · Kassandra Z Fishing Co IncN2294WBell 47G-5 · S/N 7969Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1969 · Larry Z Fishing Co IncN5797VBeech D55 · S/N TE-702Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1969 · Guerrero Pedro RN103SFBeech L-23D · S/N RLH 41Cancelled Dec 15, 2014 · Registration expired, pending cancellation · Built 1961 · Saipan War MemorialN9131FHughes 369HS · S/N 230448SCancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1973 · Chloe Z Fishing Company IncN7573Bell 47G-2 · S/N 2413Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1959 · Larry Z Fishing Co IncN5172KHughes Helicopters HUGHES 369D · S/N 1123DCancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1982 · Laura Z Fishing Co IncN102SFBeech L-23D · S/N RLH 62Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1959N9822FHughes 369HS · S/N 150691SCancelled May 30, 2013 · Registration expired, pending cancellation · Built 1975 · Margaret Z Fishing CoN8885TCessna 182C · S/N 52785Cancelled May 16, 2013 · Registration expired, pending cancellation · Built 1960 · Sirok James SN7470FHughes 269C · S/N 170553Cancelled May 8, 2013 · Registration expired, pending cancellation · Blue Island CorporationN8259XLong Robert R LONG T-300 · S/N 089-410Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Amerasia CorpN108CAStol UC-1 · S/N 014Cancelled Jun 14, 2012 · Registration pending, canceled · Built 1973N238BAAero Vodochody L-39 · S/N 132131Cancelled Feb 29, 2012 · Third renewal notice · Built 1981 · Island Aviation CorpN104EBEmbraer EMB-110P1 · S/N 110421Cancelled Sep 9, 2003 · Triennial form not returned · Built 1982 · Cci CorpN74NFShort Bros. & Harland SD3-30 · S/N SH3016Cancelled Feb 26, 2003 · Triennial form not returned · Built 1978 · Aviation Services (Cnmi) LtdN2YZHughes 369HS · S/N 1280002SCancelled Feb 21, 2002 · Exported to Philippines · Built 1968 · Americopters Marketing IncN1903UCessna U206F · S/N U20602273Cancelled Oct 19, 2000 · Exported to Australia · Pacific Partners IncN216EBEmbraer EMB-110P1 · S/N 110447Cancelled Oct 27, 1998 · Exported to Australia · Pacific Island Aviation IncN1256HPiper PA-32-300 · S/N 327740033Cancelled Aug 28, 1998 · Triennial form not returned · Pacific Island Aviation IncN9087Enstrom F-28A · S/N 211Cancelled Mar 16, 1998 · Triennial form not returned · Micronesian Aviation Corporation DBAN350APAerospatiale AS350B · S/N 1252Cancelled Oct 9, 1997 · Triennial form not returned · Micronesian Avaition CorporationN85GAAerospatiale AS350B · S/N 2362Cancelled Aug 14, 1997 · Exported to Canada · Micronesian Aviation Corp DBA
Back to Saipan, MP