OpenAirDocs.org
Redwood City, CA

Cancelled registrations · 97

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 = 'CA' AND d.registrant_city = 'REDWOOD CITY'
  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.

N15GXBombardier BD-700-1A10 · S/N 9278Cancelled Jun 29, 2026 · Exported to Switzerland · Built 2008 · Oracle Navigation LLCN499DMMorss Dave 320 · S/N SH-2Cancelled Jul 30, 2024 · Built 1993 · Morss Dave SN299DMMorss Dave SH III · S/N SH3Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Morss Dave SN877VFDJI MAVIC 2 PRO · S/N 163DFBN001MGK6Cancelled May 4, 2020 · Forbes Susan EN58605Aeronca 0-58B · S/N 12803Cancelled Jan 31, 2020 · Revoked, canceled · Jones Jewell BN449CPDJI INSPIRE 1 · S/N W13DCL07061065Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Cape Productions IncN745NSDJI INSPIRE 1 PRO · S/N W21ACI27010571Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Sinfiel LLCN684CPDJI INSPIRE 1 · S/N W13DDA12061426Cancelled Sep 9, 2019 · Registration expired, pending cancellation · Cape Productions IncN103CEDJI PHANTOM 4 · S/N 07DDD330A10263Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Cape Productions IncN118CEDJI PHANTOM 3 PROFESSION · S/N P76DCE16011703Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Cape Productions IncN121CPDJI INSPIRE 1 · S/N W13DCB07020101Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Cape Productions IncN209PCDJI INSPIRE 1 · S/N W21ACJ30010442Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Cape Productions IncN229PCDJI INSPIRE 1 · S/N W13DCK04050087Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Cape Productions IncN236PCDJI INSPIRE 1 · S/N W21ACJ23010484Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Cape Productions IncN245PCDJI INSPIRE 1 · S/N W13DDA12060317Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Cape Productions IncN295CPDJI INSPIRE 1 · S/N W13DCB17020686Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Cape Productions IncN386CPDJI INSPIRE 1 · S/N W13DCJ27050170Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Cape Productions IncN598CPDJI INSPIRE 1 · S/N W13DDA12061300Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Cape Productions IncN659CPDJI INSPIRE 1 · S/N W13DCB12020151Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Cape Productions IncN494CPDJI INSPIRE 1 · S/N W13DCD21030618Cancelled Apr 23, 2019 · Registration expired, pending cancellation · Cape ProductionsN483CPDJI INSPIRE 1 · S/N W13DCH19041427Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Cape ProductionsN484CPDJI INSPIRE 1 · S/N W13DCA30020241Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Cape ProductionsN460CPDJI INSPIRE 1 · S/N W13DCF19040959Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Cape ProductionsN467CPDJI INSPIRE 1 · S/N W13DCC30030482Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Cape ProductionsN652DR3D Robotics X8+ · S/N 006Cancelled Dec 14, 2018 · Registration expired, pending cancellation · Cape Productions IncN653DR3D Robotics X8+ · S/N 015Cancelled Dec 14, 2018 · Registration expired, pending cancellation · Cape Productions IncN654DR3D Robotics X8+ · S/N 016Cancelled Dec 14, 2018 · Registration expired, pending cancellation · Cape Productions IncN655DR3D Robotics X8+ · S/N 017Cancelled Dec 14, 2018 · Registration expired, pending cancellation · Cape Productions IncN656DR3D Robotics X8+ · S/N 018Cancelled Dec 14, 2018 · Registration expired, pending cancellation · Cape Productions IncN47679Taylorcraft DC-65 · S/N 4245Cancelled Aug 28, 2018 · Revoked, canceled · Built 1942 · Sattler HarryN737HKCessna 172N · S/N 17269428Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1977 · Royal Aircraft CorpN90890Hiller OH-23B · S/N 717Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1954 · Hiller Stephen S DBAN1160TBeech V35B · S/N D-9928Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1976 · Madge Robert JN3780GShoulders Bensen B7MC · S/N 1Cancelled Nov 22, 2017 · Revoked, canceled · Built 1962 · Shoulders Kenneth RN9060NPitts Special S-1C · S/N 18Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1967 · Baranski-Walker KevinN9654KStinson 108-2 · S/N 108-2654Cancelled Feb 4, 2017 · Revoked, pending cancellation · Built 1947 · Mcdowell Milford WN109CEDJI INSPIRE 1 · S/N W13DCC30030186Cancelled Jun 16, 2016 · Cape Productions IncN119CEDJI INSPIRE 1 · S/N W13DCK04050733Cancelled Jun 16, 2016 · Cape Productions IncN86788Bellanca 14-13 · S/N 1149Cancelled Oct 6, 2014 · Revoked, pending cancellation · Built 1946 · Hewitt RobertN5779VBeech A23-24 · S/N MA-38Cancelled Jul 18, 2014 · First renewal notice · Built 1966 · Shoemaker DavidN329QSBoeing 727-21 · S/N 19038Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1966 · Emery Worldwide Airlines IncN537KFSchmidt Herman James SKY STAR AC/KITFOX 2 · S/N 537Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1994N20680Cessna 172M · S/N 17261487Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1973 · Stock Charles AN644SEBeech 95 · S/N TD-181Cancelled Aug 6, 2013 · Revoked, canceled · Built 1959 · Gerry Schloss TextilesN4171PPiper PA-23-160 · S/N 23-1658Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1959 · Fallon Leslie AN5938Hiller UH-12E · S/N 2167Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1961N8407EPiper PA-34-220T · S/N 34-8133149Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1981N8118HHiller UH-12A · S/N 118Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1949N5209Weilage WEILAGE BOON JR · S/N 0730166Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1971N8479BMcnally-Bell MONERAI · S/N 166Cancelled Nov 29, 2012 · Sale reported, pending cancellation · Built 1979
Back to Redwood City, CA