Skip to content

Cancelled registrations · 37

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 = 'BIG SPRING' 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 = 'BIG SPRING'
  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 = 'BIG SPRING'
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.

N204WFAerostar Acft Corp Of Texas M20E · S/N 21-0021Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1971 · Carroll Randolph L N173CTCirrus Design SR22 · S/N 2961Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 2008 · Caseys Aircooled Engine LLC N7802TCessna 172 · S/N 47402Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1960 · Thomas Charles S N322Grumman G-21A · S/N B73Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1941 · Edwards Wilson C N9620FHughes 269C · S/N 700020Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1970 · Menix Frank D N1109GMesserschmitt ME 109 C4K · S/N 40/2Cancelled Oct 16, 2015 · Exported to Australia · Edwards Wilson C N2731SCessna 150G · S/N 15066631Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1967 · Mcclure Robert N7821UCessna 172E · S/N 17251821Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1964 · Hu Hoover F N3282Grumman G-21A · S/N 1110Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1945 · Edwards Wilson C N9535Grumman Acft ENG Cor-Schweizer G-164A · S/N 1190Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1973 · Mcclure Robert N5724PPiper PA-24-250 · S/N 24-798Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1959 · Morehead Carol D N26EWHiller UH-12D · S/N 1105Cancelled Jun 4, 2012 · Registration pending, canceled · Built 1959 N11GWWarren-Fayo JF-1 · S/N 112236Cancelled May 24, 2011 · Revoked, canceled · Built 1971 · Wagner Jack L N1026AGrumman HU 16E · S/N 2130Cancelled Jun 17, 2002 · Triennial form not returned · Edwards Wilson C N43086Aeronca/Carter J D AERONCA CARTER 7AC · S/N 7AC-1274JDCancelled Aug 30, 2001 · Sale reported N8895WPiper PA-28-235 · S/N 2810458Cancelled Mar 17, 1998 · Triennial form not returned · Big Spring Flying Club N29779Taylorcraft BC12-D · S/N 2627Cancelled Feb 11, 1994 · Triennial form not returned · Hart Edward N5459ECessna 182R · S/N 18268324Cancelled Nov 6, 1992 · Triennial form not returned · Cosden Pipe Line Co N5777MPiper PA-24-250 · S/N 241253Cancelled Apr 11, 1991 · Triennial form not returned · Casey Monroe N5185JCessna 172N · S/N 17273722Cancelled Jan 31, 1991 · Triennial form not returned · Sneed Boyce N74WWCessna T210L · S/N 21060182Cancelled Oct 14, 1981 · Forsan Oil Co N38228North American F-51D · S/N 44-84660Cancelled Oct 14, 1976 · Administratively canceled · Howard Development Co N43405Piper PA-28-151 · S/N 28-7415486Cancelled Sep 21, 1976 · Built 1974 · Dieterich Christopher H N1209XMooney M20C · S/N 2612Cancelled Jun 26, 1973 · Phil Burns N8859CPiper PA-18-135 · S/N 18-2918Cancelled Feb 21, 1971 · Dahse C A N1368BSilvaire 8F · S/N 5995Cancelled Jun 26, 1970 · Rickabaugh H M N9066PPiper PA-24-260 · S/N 24-4534Cancelled Jun 12, 1970 · Big Spring Aircraft Inc N85612Aeronca 7AC · S/N 7AC-4356Cancelled Apr 15, 1959 · Mcclendon J W N98314Piper J3C-65 · S/N 18476Cancelled Jul 19, 1954 · Exported to Nicaragua · Big Spring Flying Service N80700Globe GC-1A · S/N 103Cancelled May 2, 1951 · Built 1946 · Thomas Clyde E N1595NPiper J3C-65 · S/N 23127Cancelled Mar 9, 1951 · Built 1947 · Cecil Hamilton Flying Service N3350KGlobe GC-1B · S/N 1343Cancelled Mar 9, 1951 · Globe Swift Sales Co N76493Cessna 140 · S/N 10925Cancelled May 27, 1949 · King Ray N47791Fairchild M-62A · S/N T41-596Cancelled Feb 3, 1949 · Built 1941 · Underwood J E DBA U & S Flying Services N37284Interstate S-1A · S/N 127Cancelled Apr 8, 1947 · U & S Flying Service N92427Piper J3C-65 · S/N 16894Cancelled Apr 8, 1947 · Underwood J E DBA U&S Flying Service N15055Taylor E-2 · S/N 206Cancelled Jun 15, 1936 · Phillips James D

Back to Big Spring, TX