Skip to content

Cancelled registrations · 33

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

N360SEJoe Nichols STOL 750 · S/N 75-10375Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Nichols Joe R N51GACessna 310 · S/N 35102Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Gantex Inc N975WASiai-Marchetti S.205/22R · S/N 4-125Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1968 · Smith Kevin F N516LLLawane J Luckett QUICKIE L · S/N 323Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 2017 · Luckett Lawane J N71222Luscombe 8A · S/N 2649Cancelled Aug 5, 2019 · Revoked, canceled · Built 1946 · Tanner Carl W N8019MCessna 310I · S/N 310I0019Cancelled Oct 23, 2018 · Built 1964 · G & S Flight Service Inc N3237ZPiper PA-22-150 · S/N 22-7182Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1959 · Irvin Herman D N8607LPiper PA-25-235 · S/N 25-5034Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1969 · Williams Jimmy Z N8018UQuicksilver GT-400 · S/N 57778652Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 2003 · Cristi Ceferino N39333Aeronca 65-LB · S/N L18332Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1942 · West Ark Oil Co N383JSSmith Joe C HORIZON 2 · S/N 1Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 2000 · Smith Joe C N8587ABeech A35 · S/N D-2009Cancelled Feb 4, 2017 · Revoked, canceled · Built 1949 · Gilbreth John T N2884ECessna 172N · S/N 17271359Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1978 · Rinehart D A N787AAJunior Reagan/Rec-7ex FALCON-XP · S/N 600149Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1985 · Rec-Tex N8436DPiper PA-22-160 · S/N 22-5691Cancelled Jul 15, 2013 · Registration expired · Built 1957 · Williams J Darrell N4690GCessna 172N · S/N 17273316Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Jenkins Charles N5477ZPiper PA-22-108 · S/N 22-9259Cancelled Jan 30, 2013 · Sale reported, canceled · Built 1962 N96799Taylorcraft BC12-D · S/N 9099Cancelled Nov 26, 2012 · Sale reported, pending cancellation · Built 1946 N48362Taylorcraft DCO-65 · S/N 5001Cancelled Nov 13, 2012 · Revoked, canceled · Built 1943 · Schraer Earl W N95DEZivko Aeronautics EDGE 540-T · S/N 2018Cancelled Apr 14, 2006 · Built 2004 · Estes David W N2282YCessna 177 · S/N 17700082Cancelled Aug 17, 2005 · Triennial form not returned · Built 1967 · Hill Gary E N4870BCessna 152 · S/N 15283685Cancelled Jan 18, 2000 · Triennial form not returned · Whitmire Enterprises Inc N8161SPiper PA-28-161 · S/N 288016217Cancelled Sep 9, 1996 · Second triennial mailing, no response · Allenberg Jack D N29JGGreen Jack W KR-2 · S/N 4603Cancelled Dec 24, 1992 · Green Jack W N6132UWright B-8M · S/N W-1Cancelled Feb 1, 1971 · Wright F D N75498Cessna T-50 · S/N 3102Cancelled Sep 24, 1970 · Gremmels Stephen B N27667Taylorcraft BL-65 · S/N 2309Cancelled Sep 4, 1970 · Hall Lt Michael D N80711Globe GC-1A · S/N 114Cancelled Jun 30, 1970 · Hendricks Harry Eugene N1431EAeronca 7AC · S/N 7AC-4994Cancelled Sep 6, 1956 · Built 1946 · Kilgore Kenneth W & Comiskey Ernest J N34569Aeronca 65-CA · S/N CA15711Cancelled Oct 19, 1955 · Built 1941 · Mcintyre Robert Thomas N2260EAeronca 7AC · S/N 7AC-5834Cancelled Jun 16, 1949 · Mcdanel G And T Brashier Jr N54718Fairchild M-62A · S/N T43-5766Cancelled Dec 23, 1948 · Du Temple Octave Joseph N54747Fairchild M-62A · S/N T43-5742Cancelled Dec 23, 1948 · Dutemple Octave J

Back to Sherman, TX