Skip to content

Cancelled registrations · 57

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 = 'EL CAMPO' 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 = 'EL CAMPO'
  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 = 'EL CAMPO'
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.

N1947WStorch Aviation Australia PTY SS-MK4 · S/N 083Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Bode Mike W N306FRMcbride C/Kahn M M RV6 · S/N 24480Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 2002 · Southern Star Aviation LLC N3711EPiper PA-36-300 · S/N 36-7860044Cancelled Oct 28, 2019 · Second renewal notice · Built 1978 · Bruton Paul N9723Grumman Acft ENG Cor-Schweizer G-164A · S/N 1239Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1974 · Gardner James S N32219Grumman G-164A · S/N 1348Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Gardner Air Service Inc N772ZFGrumman Acft ENG Cor-Schweizer G-164A · S/N 961Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1972 · Garner James S N50666Grumman G-164A · S/N 1322Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Gardner Air Service Inc N1296WWeatherly 201C · S/N 1004Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1976 · Gardner James S N5016PAir Tractor AT-502B · S/N 502B-0420Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1997 · Independent Dusting Service Inc N90QLBeech F90 · S/N LA-2Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1979 · Quality Lease Air Services LLC N9717Grumman Acft ENG Cor-Schweizer G-164A · S/N 1237Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1974 · Sharp Air Service Inc N54229Grumman Acft ENG Cor-Schweizer G-164B · S/N 160BCancelled May 15, 2017 · Registration expired, pending cancellation · Gardner Air Service Inc N90191Weatherly 620B · S/N 1615Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1996 · Gardner James S N731YKCessna A188B · S/N 18803260TCancelled Nov 17, 2014 · Registration expired, pending cancellation · Smith Larry N60655Cessna 150J · S/N 15070481Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1969 · Borwn Greg W N2938WWeatherly 201B · S/N 605Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1972 · Gardner Shirley A N8641HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1443Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1975 · Sharp Air Service Inc N974XGrumman G-164A · S/N 488Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1968 · Sharp Air Service Inc N3649KAir Tractor AT-301 · S/N 301-0238Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1979 N5074Grumman Acft ENG Cor-Schweizer G-164A · S/N 1110Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1973 · Sharp Air Svc Inc N9151GCessna A188B · S/N 18801395Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1973 · Sharp G K N8659HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1451Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1975 · Sharp Air Service Inc N731LPCessna A188B · S/N 18802980TCancelled May 7, 2013 · Registration expired, pending cancellation · Built 1977 · El Campo Metro Airport Inc N615UGrumman G-164 · S/N 343Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1965 · Sharp Air Svc Inc N53123Cessna A188B · S/N 18801634TCancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 1974 · Gardner Air Service Inc N94482Hiller UH-12B · S/N 462Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1951 N3438PPiper PA-23-160 · S/N 23-1406Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1958 · Coastal Flying Service Inc N9863VCessna A188 · S/N 188-0113Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1966 · Coastal Flying Service Inc N7130ZPiper PA-25-235 · S/N 25-2948Cancelled Nov 9, 2011 · Exported to Argentina · Built 1964 · Gardner James S N8817GCessna 150F · S/N 15062917Cancelled Apr 18, 2011 · Expired dealer · Built 1966 · Coastal Flying Service N8486VRockwell International S-2R · S/N 2246RCancelled May 12, 2009 · Triennial form not returned · Built 1976 · Gardner Air Service Inc N165DPChampion 7GCAA · S/N 20Cancelled Apr 21, 2008 · Exported to Mexico · Built 1965 · Gardner James S N63116Kuypers Norbert F ZEPHYR II · S/N 1Cancelled Aug 25, 2000 · Triennial form not returned · Sharp Marcus V N756CNCessna U206G · S/N U20603985Cancelled Dec 11, 1985 · Sharp G K N2865JCessna 188 · S/N 18803540TCancelled Apr 15, 1983 · El Campo Metro Airport Inc N658YGrumman G-164 · S/N 311Cancelled May 26, 1976 · Dickey Ellis N1583MCessna A188A · S/N 18800683Cancelled Aug 14, 1975 · Built 1970 · Gardner Air Service Inc N41TSGrumman Acft ENG Cor-Schweizer G-164A · S/N 1169Cancelled Jun 9, 1975 · Built 1973 · Thompson Flyers Inc N4584YPiper PA-25-235 · S/N 25-4259Cancelled Mar 14, 1975 · Exported to Mexico · Built 1967 · Ag Aviation Inc N11AAGrumman G-164A · S/N 685Cancelled Dec 5, 1974 · Agricultural Applicators Corp N9663ZCallair A-9 · S/N 1053Cancelled Oct 7, 1974 · Gardner Jim N4506NBoeing A75N1(PT17) · S/N 752677Cancelled Oct 28, 1971 · Thompson Dusting Serv Inc N47822Aeronca 0-58B · S/N C3792-TACancelled Jun 29, 1970 · Dahlstedt Clayton N5736KBeech S35 · S/N D-7528Cancelled Jun 23, 1970 · Rice Belt Flying Club N2828GBeech C-45F · S/N 43-35815Cancelled May 22, 1965 · Wendel Alvah J N54341Fairchild M-62A · S/N T43-7150Cancelled May 21, 1965 · George P Witcher N1681MBoeing B75N1 · S/N 75-7758Cancelled Jul 10, 1964 · Richland Aviation N54285Boeing A75N1 · S/N 75-785Cancelled Jul 10, 1964 · Riceland Aviation N6669HPiper J3C-65 · S/N 19873Cancelled Jul 10, 1964 · Riceland Aviation N81749Aeronca 7AC · S/N 7AC-370Cancelled Jul 10, 1964 · Riceland Aviation

Back to El Campo, TX