OpenAirDocs.org
Sugar Land, TX

Cancelled registrations · 40

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 = 'SUGAR LAND'
  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.

N461JMMeier John H CX4 · S/N 61Cancelled Feb 22, 2025 · Meier John HN15302Piper PA-28R-200 · S/N 28R-7335047Cancelled Sep 5, 2023 · Built 1972 · Anson Air LLCN8159UCessna 172F · S/N 17252059Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1964 · Mjh Aero IncN5501XAero Commander S2R · S/N 1701RCancelled Oct 2, 2021 · Registration expired, pending cancellation · Alaniz Pedro FN101TGGreak-Gerald CHRISTEN EAGLE II · S/N GREAK-0001Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1983 · Greak Gerald TN820LKDJI PHANTOM 4 PRO · S/N 0AXDE360A30388Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Karambelas NicholasN804AMEarly Aeroplane Manufactory LL BEAVER RX 550 PLUS · S/N 4000AMCancelled Mar 13, 2020 · Sale reported, canceled · Built 2016N51BESkycatch BDU · S/N BDUC0106Cancelled Mar 12, 2019 · Registration expired, pending cancellation · Bechtel Equipment Operations IncN54BESkycatch BDU · S/N BDUC0109Cancelled Mar 12, 2019 · Registration expired, pending cancellation · Bechtel Equipment Operations IncN22NDSikorsky S-76B · S/N 760416Cancelled Oct 11, 2018 · Exported to Canada · Noble Drilling Services IncN704LECessna 150M · S/N 15078689Cancelled May 4, 2018 · Registration expired, pending cancellation · Built 1976 · Breeze Scott WalterN51007Cessna 150J · S/N 15069704Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1968 · Breeze Scott WN69643Cessna 310Q · S/N 310Q0831Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1973 · Fromm Robert E JrN742LBBeech 95-B55 (T42A) · S/N TC-1963Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1976 · Millis Group IncN991RCPiper PA-32-260 · S/N 32-7400030Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1974 · Clearman RobinN28BESkycatch BDU · S/N BDUC0086Cancelled Dec 8, 2015 · Bechtel Equipment Operations IncN581Grumman American Avn. AA-5A · S/N AA5A0608Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1978 · Shelley Michael JN700XFHawker Siddeley HS.125 SERIES 700A · S/N NA 0272Cancelled May 21, 2014 · Exported to Singapore · Built 1980N9SMMacleod Steven M AVID HEAVY HAULER · S/N 888Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Macleod Steven MN3666HBalloon Works FIREFLY 7 · S/N F7-063Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1983N54995Cauthen F4U CORSAIR · S/N 95Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1982 · Barry David MarkN2233UBrantly B-2B · S/N 480Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1968 · Gremillion Joe WN567JMMartinez Ivan C SONERAI II LS · S/N 0058Cancelled Jan 2, 2013 · Registration expired · Built 2002 · Martinez Ivan CN36912Cessna 414A · S/N 414A0249Cancelled Jul 14, 2010 · Exported to Mexico · Built 1979 · Breeze Scott WN8708ZCessna P206C · S/N P206-0508Cancelled Jul 13, 2007 · Exported to Malaysia · Built 1968 · Dhc Enterprises LLCN767CHEurocopter AS 350 B2 · S/N 3146Cancelled Jul 25, 2005 · Exported to Nigeria · Built 1998 · Odengene Air Shuttle IncN2231LCessna T303 · S/N T30300167Cancelled Feb 12, 2001 · Exported to Belize · Hinson Paul DN9708QCessna 172M · S/N 17265785Cancelled Nov 17, 2000 · Exported to Canada · Suger Land Aviation IncN303RHSchempp-Hirth STANDARD CIRRUS · S/N 248Cancelled Sep 16, 1998 · Triennial form not returned · Scrogin John M IIIN89522Cessna 152 · S/N 15282768Cancelled Apr 18, 1998 · Triennial form not returned · Sugar Land Jet Center IncN165CAPiper PA-31T · S/N 31T8020008Cancelled Jun 9, 1997 · Exported to Mexico · Prentice David FN2955UCessna U206F · S/N U20602472Cancelled Sep 18, 1995 · Exported to Tanzania · Hoopes GaryN182FACessna 182Q · S/N 18265771Cancelled Apr 1, 1993 · Exported to Tanzania · Superior Aviation EnterprisesN402FACessna 402C · S/N 402C0205Cancelled Sep 11, 1992 · Exported to Tanzania · Superior Aviation EnterprisesN12RFBeech C90 · S/N LJ575Cancelled Nov 1, 1991 · Exported to Zambia · Keith Norris Aircraft IncN6739VBeech 58 · S/N TH1133Cancelled Oct 30, 1991 · Exported to Japan · Keith Norris Aircraft IncN91BBPiper PA-31-310 · S/N 31-141Cancelled Mar 14, 1989 · Triennial form not returned · Built 1967 · Benson William H JrN99GCRockwell International 500-S · S/N 3229Cancelled Jan 25, 1989 · Exported to Finland · Gordon Gragg Aircraft Sales IncN4098FCessna 172 · S/N 36998Cancelled Oct 4, 1963 · Hull AviationN9268TCessna 180C · S/N 50768Cancelled Nov 29, 1962 · Nalco Chemical Co
Back to Sugar Land, TX