Skip to content

Lake Jackson, TX

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 = 'LAKE JACKSON' 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 = 'LAKE JACKSON'
  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 = 'LAKE JACKSON'
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.

N731NFDJI PHANTOM 4 · S/N 07DDD330A10957Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Spectre Aerial Productions LLC N7727BCessna 140 · S/N 9581Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1946 · Elsberry Freddie L N34509Aeronca 65-CA · S/N C15281Cancelled Dec 19, 2019 · Revoked, canceled · Built 1941 · Singley James E Ptnr N16187Cessna 150L · S/N 15073532Cancelled Mar 22, 2018 · Registration expired, pending cancellation · Built 1972 · Phillips Ronald R N713MRBrown Roland L VELOCITY 173 ELITE · S/N 3RE056Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 2003 · Cook Robert C N9107JBushby Robert MUSTANG - II · S/N M-II-1070Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Bushby Robert N175XWackwitz Winnie D BOWERS FLY BABY · S/N 1Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1990 · Phillips Ronald R N9561TCessna 210 · S/N 57361Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1960 · Mueller Perry Jr N102KKKorenek Ken W KORENEK-TITAN S · S/N KTS-0502-001Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 2005 · Bailes John R N70645Jennings Walton Robert HI MAX 1700R · S/N 994-ISON AIRCRAFTCancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 2003 · Phillips Ronald R N7167SFisher Michael E HYSTER · S/N AH0001Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1991 · Phillips Ronald R N1199KLuscombe 8A · S/N 3926Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1946 · Phillips Ronald R N7565CForney F-1 · S/N 5682Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1959 · Veach Terrance L N39393Mitchell Oscar Willis WEEDHOPPER WM1 2 · S/N 3450219Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Mitchell Oscar Willis N45WGGermany-Wetherell SONERAI I · S/N 1Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1974 · Germany Garvin H Jr N1001KTexas Helicopter OH-13H/M74A · S/N 79 034Cancelled Apr 30, 2012 · Registration expired, pending cancellation · Built 1979 · Cisco Aviation LLC N81RVPiper PA-23-250 · S/N 27-2335Cancelled Jul 24, 2009 · Exported to Philippines · Built 1963 · Rensberger Scott C N1944VCessna 140 · S/N 14152Cancelled Jul 20, 1998 · Second triennial mailing, no response · Kirby Freeman G N4195GWindecker A/C7 · S/N 004Cancelled Oct 16, 1997 · Triennial form not returned · Lake Jackson Historical Association N1582SBeech 95-A55 · S/N TC317Cancelled Jul 18, 1995 · Triennial form not returned · Bundy Thomas C N52768Cessna 172P · S/N 17274604Cancelled Apr 17, 1991 · Triennial form not returned · Brazosport Flying Club Inc N6190ECessna 172 · S/N 46290Cancelled Oct 8, 1985 · Holt Russell F N6153RCessna T210F · S/N T210-0053Cancelled May 24, 1984 · Umland Alan W N89DAAero Commander 680V · S/N 1702-78Cancelled Nov 29, 1983 · Administratively canceled · B E S Leasing Co N5560CCessna 170A · S/N 19613Cancelled Aug 10, 1982 · Woodward G Thomas N7428Vickers VISCOUNT 745-D · S/N 126Cancelled Jun 21, 1976 · Exported to Ecuador · Haralson D L N44BDReed BD-4 · S/N 205Cancelled May 21, 1976 · Hubbell Reed N2870CCessna 170B · S/N 26413Cancelled Sep 15, 1970 · Exported to Canada · Built 1954 · Jetstream Corporation Of Brazosport N7960CGrumman TBM-3E · S/N 53209Cancelled Mar 20, 1970 · Exported to Canada · Cooper Barry A N4529NConsolidated Vultee BT-15 · S/N 1298Cancelled Mar 23, 1956 · Built 1941 · Baker Stewart F N4572NConsolidated Vultee BT-15 · S/N 10359Cancelled Mar 27, 1951 · Baker Stewart F N87428Ercoupe 415-C · S/N 601Cancelled Nov 15, 1949 · Built 1946 · Greene Leslie N N54382Fairchild M-62A · S/N T43-3991Cancelled Mar 1, 1949 · Bowen Duane Kenneth

Back to Lake Jackson, TX