OpenAirDocs.org
None, OK

Cancelled registrations · 414

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 = 'OK' AND d.registrant_city = 'NONE'
  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.

N55833Piper PA-36-285 · S/N 36-7360011Cancelled Jun 28, 2001 · Exported to CanadaN43706Piper PA-36-285 · S/N 36-7460017Cancelled Jun 21, 2001 · Exported to Portugal · Built 1974N1202DCessna 208B · S/N 208B0475Cancelled Jun 15, 2001 · Exported to GermanyN8161FCessna 150F · S/N 15064261Cancelled Jun 15, 2001 · Exported to MexicoN5838BCessna 182 · S/N 33838Cancelled Jun 14, 2001 · Exported to MexicoN905ACHampshire Aeroplane Club PFALZ D-3 · S/N DT16Cancelled Feb 28, 2001 · Exported to New ZealandN71566I.C.A.-Brasov IS-28B2 · S/N 59Cancelled Dec 8, 2000 · Exported to PanamaN687DADiamond Aircraft Ind DA20-A1 · S/N 10213Cancelled Dec 7, 2000 · Exported to AustriaN555RWCessna TU206C · S/N U206-0952Cancelled Dec 6, 2000 · Exported to MexicoN4314ATemco D-16 · S/N TTN-33Cancelled Nov 16, 2000 · Exported to CanadaN1109PHughes Helicopters HUGHES 369D · S/N 1100849DCancelled Nov 3, 2000 · Exported to CanadaN4926RCessna A188B · S/N 18802443TCancelled Jul 17, 2000 · Exported to BrazilN6053USchweizer 269C · S/N S1623Cancelled Mar 30, 2000 · Exported to CanadaN67925Cessna 152 · S/N 15282103Cancelled Jan 20, 2000 · Exported to PanamaN42527Piper J3C-65 · S/N 14802Cancelled Dec 8, 1999 · Exported to BrazilN5192UCessna 206 · S/N 206-0192Cancelled Dec 7, 1999 · Exported to CanadaN2296EWSK PZL Mielec M-18A · S/N 1Z 017-17Cancelled Sep 17, 1999 · Exported to AustraliaN5123CCessna T210N · S/N 21063706Cancelled Jul 29, 1999 · Exported to MexicoN5436YCessna T210N · S/N 21064205Cancelled Mar 10, 1999 · Exported to MexicoN5691XRockwell International S-2R · S/N 2392RCancelled Feb 25, 1999 · Exported to TurkeyN5534XAero Commander S2R · S/N 1734RCancelled Feb 23, 1999 · Exported to PhilippinesN4225CCessna 414 · S/N 414-0526Cancelled Feb 8, 1999 · Exported to CanadaN9435GCessna A188B · S/N 18801484Cancelled Feb 8, 1999 · Exported to ArgentinaN7225JJones William H CHALLENGER SPECIAL · S/N 1196CW0626Cancelled Dec 2, 1998 · Sale reportedN23004Raytheon 1900D · S/N UE-319Cancelled Jul 7, 1998 · Exported to ZambiaN6954GCessna A188B · S/N 18801217Cancelled May 7, 1998 · Exported to UruguayN18FABeech 65-88 · S/N LP15Cancelled Apr 9, 1998 · Exported to MexicoN90050S N I A S AS-350B ECUREUIL · S/N 1317Cancelled Apr 9, 1998 · Exported to CanadaN120UUCessna 152 · S/N 15280111Cancelled Mar 27, 1998 · Exported to CanadaN734EMCessna 172N · S/N 17268797Cancelled Feb 2, 1998 · Exported to CanadaN803CAPiper PA-31T1 · S/N 31T8104029Cancelled Jan 30, 1998 · Exported to AustriaN1127SCessna 208B · S/N 208B0606Cancelled Jan 22, 1998 · Exported to KenyaN1216YBell UH-1H · S/N 6509565Cancelled May 20, 1997 · Exported to ChileN9255QPiper PA-34-220T · S/N 3448079Cancelled May 19, 1997 · Exported to GermanyN2529XCessna P206 · S/N P2060029Cancelled May 13, 1997 · Exported to ParaguayN275CAPiper PA-31T · S/N 31T7820089Cancelled Dec 12, 1996 · Sale reportedN7075BWSK PZL Mielec M-18A · S/N 1Z02414Cancelled Sep 12, 1996 · Exported to AustraliaN4862QCessna A188B · S/N 18802598TCancelled Jul 5, 1996 · Exported to CanadaN80721Robinson Helicopter R22 BETA · S/N 1325Cancelled May 29, 1996 · Exported to United KingdomN70327Cessna A188B · S/N 18801888TCancelled Apr 25, 1996 · Exported to CanadaN40613Maule M-4-220C · S/N 2139CCancelled Jan 26, 1996 · Exported to CanadaN220PMLearjet 24 · S/N 158Cancelled Aug 23, 1995 · Exported to BrazilN8418LCessna 172I · S/N 17256618Cancelled May 10, 1994 · Exported to LithuaniaN200KHughes 369HS · S/N 940646SCancelled Dec 28, 1993 · Exported to IndonesiaN16DBPiper PA-28R-201 · S/N 28R7737107Cancelled May 19, 1993 · Exported to DenmarkN512AAHarris Roland W FALCON XP · S/N 600179Cancelled May 10, 1993 · Exported to United KingdomN11SNYakovlev/Anderson YAK-11 · S/N N1701231Cancelled May 5, 1993 · Exported to United KingdomN8233APiper PA-28-181 · S/N 288090353Cancelled Apr 7, 1993 · Exported to GermanyN3489WPiper PA-32-260 · S/N 32368Cancelled Feb 12, 1993 · Exported to Canada · Sold To CanadaN9SSherrill PITTS SPECIAL S-1 · S/N 362HCancelled Jan 29, 1993 · Exported to United Kingdom
Back to None, OK