OpenAirDocs.org
Spring, TX

Cancelled registrations · 146

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 = 'TX' AND d.registrant_city = 'SPRING'
  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.

N655LHAmerican Eurocopter AS350B3 · S/N 7225Cancelled Mar 26, 2012 · Exported to Canada · Built 2011 · All American Aviation LLCN515DMMcdonald David T MANTA 503H-12 · S/N 503-0901Cancelled Sep 22, 2011 · Exported to Thailand · Built 2009 · Mcdonald David TN8040UCessna 150M · S/N 15077880Cancelled Jul 19, 2011 · Exported to Argentina · Built 1976 · Debold DavidN13374Cessna 172M · S/N 17262710Cancelled Jun 7, 2011 · Registration pending, canceled · Built 1973N7988HRobinson Helicopter R22 BETA · S/N 4374Cancelled Oct 5, 2010 · Built 2008 · Higgins Leasing IncN3083KRobinson Helicopter R22 BETA · S/N 4049Cancelled Aug 24, 2010 · Exported to New Zealand · Built 2006 · Helicopter Services IncN5655ACessna 172R · S/N 17280247Cancelled Aug 22, 2007 · Exported to India · Built 1997 · Mcmeza Aviation IncN7534SRobinson Helicopter R22 BETA · S/N 3657Cancelled Jul 23, 2007 · Built 2004 · Helicopter Services IncN91505Cessna 172M · S/N 17261498Cancelled Jan 3, 2007 · Triennial form not returned · Built 1973 · Hopp Fredrick NN747LFRobinson Helicopter R22 BETA · S/N 2961Cancelled Nov 27, 2006 · Triennial form not returned · Built 1999 · Helicopter Services IncN9187HCessna 172M · S/N 17266001Cancelled Jul 29, 2005 · Exported to Czech Republic · Built 1975 · Go Fly-3 LLCN4865GCessna 172N · S/N 17273412Cancelled May 26, 2005 · Exported to Philippines · Built 1979 · United Flight Systems IncN15PEMikoyan MIG-15BIS · S/N 122073Cancelled Dec 30, 2004 · Triennial form not returned · Gooden Tobe DN6145HSchweizer 269C · S/N S1645Cancelled Sep 14, 2004 · Exported to Italy · Built 1993 · Helicopter Services IncN7198HRobinson Helicopter R22 BETA · S/N 3165Cancelled Sep 22, 2003 · Built 2001 · Helicopter Services IncN31WBBeech C90 · S/N LJ-536Cancelled Sep 3, 2003 · Exported to Mexico · Built 1972 · Lee Scott TN52729Cessna 172P · S/N 17274594Cancelled May 13, 2002 · Registration expired, pending cancellation · Built 1981 · Rainbow Aviation IncN15TXJohnson Allen T TAYLOR TITCH · S/N 1Cancelled Apr 4, 2002 · Johnson Allen TN8332FRobinson Helicopter R22 BETA · S/N 2594Cancelled Aug 29, 2001 · Exported to Australia · Helicopter Services IncN126TVEurocopter AS 350 B2 ECUREUIL · S/N 2944Cancelled May 2, 2001 · Triennial form not returned · Helicopter Services IncN249DKKuehn Louis F. TAILWIND W-8 · S/N 249Cancelled Sep 25, 2000 · Triennial form not returned · Kuehn Louis FN8126VPiper PA-28-161 · S/N 28-8016150Cancelled Sep 16, 2000 · Triennial form not returned · Cypress Rentals IncN2323VRobinson Helicopter R22 BETA · S/N 2100Cancelled Jun 22, 2000 · Hilliard Ira VN1792QCessna 150L · S/N 15073092Cancelled Apr 5, 2000 · Triennial form not returned · Quaintance Jack LN1192FCessna A185F · S/N 18502760Cancelled Jul 2, 1998 · Exported to Canada · Helmrich MarkN8316WRobinson Helicopter R22 BETA · S/N 2482Cancelled Apr 3, 1998 · Helicopter Services IncN8352ZCessna 210-5(205) · S/N 2050352Cancelled Apr 1, 1998 · Triennial form not returned · Owens Grady EN17KABeech C90 · S/N LJ1138Cancelled Jan 8, 1997 · Exported to Germany · J Michael Lea & Associates IncN6374FCessna 172N · S/N 17273209Cancelled Jan 8, 1997 · Exported to New Zealand · Mcguire RoyN111UFCessna 152 · S/N 15283283Cancelled Aug 23, 1996 · Triennial form not returned · United Flight Systems Inc DBAN44211Piper PA-34-200 · S/N 347450203Cancelled May 16, 1995 · Exported to Israel · Street Jerry BN223TVHughes 269C · S/N 1290868Cancelled Dec 21, 1994 · Triennial form not returned · Sunrise Helicopters IncN4084ARobinson Helicopter R22 BETA · S/N 1795Cancelled Oct 28, 1993 · Exported to Canada · Helicopters International IncN222UFCessna 172N · S/N 17268085Cancelled Jul 16, 1993 · Triennial form not returned · United Flight Systems Inc DBAN4073SRobinson Helicopter R22 BETA · S/N 1889Cancelled Feb 10, 1993 · Helicopters International IncN8050BRobinson Helicopter R22 BETA · S/N 1136Cancelled Jan 14, 1993 · Triennial form not returned · Helicopters International IncN3210RNanchang China YAK-18A · S/N 2232036Cancelled Sep 8, 1992 · Imle Barclay C BN128SCessna 172M · S/N 17262981Cancelled Apr 20, 1992 · Triennial form not returned · Jarnagin Andrew BN2321ZRobinson Helicopter R22 BETA · S/N 2031Cancelled Mar 3, 1992 · Exported to South Africa · Helicopters International IncN200AXAerodis America AA200 · S/N 002Cancelled Oct 25, 1991 · Exported to Indonesia · Aerodis America IncN714KGCessna 150M · S/N 15079230Cancelled Apr 17, 1991 · Triennial form not returned · Baccus Jim DN49ZPBell 206B · S/N 3121Cancelled Apr 9, 1991 · Exported to South Africa · Helicopters International IncN9513DPiper PA-22-160 · S/N 22-6429Cancelled Feb 14, 1985 · Administratively canceled · Smith Howard CN81476Piper PA-28-161 · S/N 288016163Cancelled Jan 12, 1981 · Carpenter Floyd EN6135BCessna 182A · S/N 34135Cancelled Oct 18, 1977 · Exported to Canada · Moss Jack HN7140ACessna 172 · S/N 29240Cancelled May 4, 1973 · Riverside Harbor Corp
Back to Spring, TX