Skip to content

Cancelled registrations · 58

Query with SQL

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 = 'BAYTOWN' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'BAYTOWN'
  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.

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 = 'BAYTOWN'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N48DKCessna 551 · S/N 551-0095Cancelled Sep 7, 2022 · Registration expired, pending cancellation · Built 1978 · Aviation Star S II LLC N4059JCessna 150G · S/N 15065359Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1966 · Davidson Raymond N1431JRockwell International 112A · S/N 431Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1975 · N1431j LLC N21CWThorp T-18 · S/N 697Cancelled May 1, 2020 · Revoked, canceled · Whitt Charles E N755PPDJI PHANTOM 3 STANDARD · S/N PSADCH270600NECancelled Apr 3, 2020 · Registration expired, pending cancellation · Files Patrick H Jr N85935Aeronca 11AC · S/N 11AC347Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Richardson Aubrey L Jr N9294ALee Anson George WHITMAN TAIL WIND · S/N 131Cancelled Jun 26, 2018 · Registration pending, canceled N32JTTillery PITTS SPECIAL S-1 · S/N 496-HCancelled Apr 2, 2018 · Revoked, canceled · Built 1975 · Tillery Jack Lee N602KLWsk-Pzl-Mielec TS-11 ISKRA · S/N 1H0602Cancelled Apr 2, 2018 · Registration expired, pending cancellation · Little Karley Y N975DFPearson Jon M DRAGONFLY · S/N 001Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 2009 · Weir Steven Wayne N3732RCessna 172H · S/N 17255532Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1966 · Flynt Harvey W N9262FQuad City Mfg CHALLENGER II · S/N CH2-0997-1660Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Mr Aviation N466CWWilliam Pendery HIMAX 1700R · S/N 1Cancelled Mar 5, 2018 · Registration expired, pending cancellation · M R Aviation N136ELBeech A36 · S/N E-561Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1974 · Angel Brothers Aviation Ltd N25KLLittle Karley Y WEEDHOPPER · S/N 25Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Little Karley Y N217EDPierce Edward NIEPORT 17 · S/N 00891Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Pierce Edward R N39564Aeronca 65-TAF · S/N F5412TACancelled Oct 24, 2017 · Registration expired, pending cancellation · Built 1942 · Richter Mark D N7534YPowrachute PEGASUS · S/N A271PEGCancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 2004 · Martin Bobby R N171DPQuad City Ultralight Acft CHALLENGER I · S/N 0994-0505Cancelled May 20, 2015 · Sale reported, canceled · Built 1994 N221GLMikoyan Gurevich MIG 21 · S/N 94A7809Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1976 · Lewis Gary Dean N43302Piper PA-32-260 · S/N 32-7500036Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1975 · Allen Jerry T N62431Faulk Marvin FAULK · S/N 3Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Faulk Marvin L N64JTLake LA-4 · S/N 417Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1969 · Bolding John H Sr N6417CBeech C18S · S/N 43-33344Cancelled Aug 6, 2013 · Revoked, canceled · Built 1943 · Lewis Gary D N7877UCessna 172F · S/N 17251877Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1964 · Roberts Bill J N900ABBell 206B · S/N 4211Cancelled Aug 22, 2012 · Exported to China · Built 1992 · Angel Brothers Enterprises Ltd N118RFFlowers K L THORP T-18 · S/N 418Cancelled Jun 7, 2012 · Registration expired, pending cancellation · Flowers Kenneth L N45892Luscombe 8A · S/N 2419Cancelled Oct 9, 2009 · Registration revoked · Built 1946 · Francis B M N3WCCox William M BEARHAWK · S/N 303Cancelled Jun 26, 2009 · Triennial form not returned · Built 2004 · Cox William M N503MXFiler Ted H III MINI-MAX EROS · S/N 20672Cancelled Jun 14, 2005 · Triennial form not returned · Filer Ted H III N6353BCessna 182A · S/N 34253Cancelled Sep 30, 2002 · Built 1957 · Magill Terry Keith N106BKKeith Bobby MINI MAX 1600R · S/N 1626PCancelled Aug 12, 1999 · Triennial form not returned · Keith Bobby N1315JRockwell International 112A · S/N 315Cancelled Apr 1, 1999 · Triennial form not returned · Harvey Willie R N75256Piper PA-28-181 · S/N 287690319Cancelled Sep 16, 1998 · Triennial form not returned · Raceco Inc N2149RCessna 182G · S/N 18255349Cancelled May 1, 1997 · Triennial form not returned · Allison Ralph N825RJCessna 172M · S/N 17262504Cancelled Jun 24, 1993 · Exported to New Zealand · Bay Area Aviation Inc N416CACessna 172N · S/N 17267788Cancelled Jul 15, 1992 · Exported to Turkey · Channel Aviation N888GPiper PA-24-180 · S/N 24545Cancelled Jul 8, 1991 · Channel Aviation Inc N714XUCessna 152 · S/N 15279521Cancelled May 14, 1984 · Johnson Richard W N29093Cessna TU206C · S/N U206-1066Cancelled Jul 29, 1982 · Built 1968 · Burgess Pat R Et Al N41261Piper PA-28-151 · S/N 28-7415147Cancelled Nov 12, 1980 · Hasco Inc N44SGBeech 65-A80 · S/N LD-198Cancelled Nov 12, 1980 · Built 1964 · Hamilton W Kilpatrick III DBA Rancho San Gabriel N7551NCessna U206G · S/N U20603667Cancelled Aug 23, 1978 · Exported to New Zealand · R W Johnson Construction Co Inc N40931Piper PA-28R-200 · S/N 28R-7435142Cancelled Apr 1, 1976 · Built 1973 · Homer Charles H Jr N64JKPiper PA-31 · S/N 31-187Cancelled Nov 26, 1975 · Exported to Canada · Pearl Beer Hauling Co N9253CCessna 180 · S/N 31352Cancelled Apr 10, 1973 · John Gary Raynor N3209DCessna 180 · S/N 32007Cancelled Jun 7, 1971 · Gray Elmer J N9188DPiper PA-22-160 · S/N 22-6246Cancelled Feb 24, 1971 · Bert H Black N29801Taylorcraft BL12-65 · S/N 2649Cancelled Jan 14, 1971 · Wallace W O N8077TCessna 175A · S/N 56777Cancelled Jun 29, 1970 · Welch C B

Back to Baytown, TX