Cancelled registrations · 29

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

N761HQCessna T210M · S/N 21062273Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1977 · Bush Charles N75886North American SNJ-5 · S/N 12142369Cancelled Feb 4, 2017 · Revoked, canceled · Brown Paul D N88882Douglas C-47B · S/N 15844Cancelled Feb 4, 2017 · Revoked, canceled · Egli Duane A N84270Cessna 172K · S/N 17258401Cancelled Jul 7, 2016 · Exported to Mexico · Built 1969 · Surratt Alan G N185CBCessna A185E · S/N 185-1563Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Bush Charles E N78818Piper PA-11 · S/N 111592Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1947 · Perkins Travis L DBA N76APPiper PA-32R-300 · S/N 32R-7680290Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1976 N4932DCessna 182A · S/N 51032Cancelled Aug 30, 2012 · Sale reported, pending cancellation · Built 1958 N25598Cessna 152 · S/N 15280757Cancelled Mar 22, 2011 · Exported to Argentina · Built 1977 · Burks Joseph L N50812Cessna 150J · S/N 15069567Cancelled Mar 5, 2001 · Triennial form not returned · Hobbs Hilton D N8877QAero Commander S2R · S/N 1477RCancelled Feb 1, 1999 · Triennial form not returned · Hemme Curtis L N18532Cessna 150L · S/N 15073921Cancelled May 20, 1993 · Triennial form not returned · Olivas Alfredo DBA N6557ZPiper PA-25-235 · S/N 25-2103Cancelled Jul 23, 1985 · Exported to Mexico · Willey C R N9594PPiper PA-25-235 · S/N 25-7656003Cancelled Apr 28, 1982 · Exported to Mexico · Willey C R N86451Douglas DC3 · S/N 43-48138Cancelled Jun 2, 1978 · Exported to Democratic Republic of the Congo · Egli Duane N9984QMcdonnell Douglas DC3/C47 · S/N 51-41406Cancelled Jun 24, 1977 · Exported to Democratic Republic of the Congo · Egli Aerial Enterprises N39430Douglas DC-4 · S/N 42-931Cancelled May 13, 1977 · Exported to Democratic Republic of the Congo · Built 1946 · Fabens Air Service N17TEBoeing B-17G · S/N 44-85784Cancelled Aug 4, 1976 · Exported to United Kingdom · Built 1974 · Egli Duane N75886North American AT-6F · S/N 12142369Cancelled Jan 20, 1971 · Brown Paul D N1382CPiper PA-18A · S/N 18-2642Cancelled Nov 30, 1970 · West-Air Dusting Co N89518Cessna 120 · S/N 8554Cancelled Oct 12, 1970 · Air Repair N1221CPiper PA-22-135 · S/N 22-1027Cancelled Jun 5, 1970 · Air Repair N29257Culver LCA · S/N 125Cancelled Apr 15, 1970 · Built 1940 · Air Repair N32740Piper J3C-65 · S/N 5573Cancelled Jul 20, 1966 · Williams Johnny N7563ZPiper PA-25-235 · S/N 25-3619Cancelled Oct 6, 1965 · Exported to Mexico · Texas Dustin Service Inc N84301Aeronca 7AC · S/N 7AC-2996Cancelled Feb 23, 1956 · Mowad William J L Leblanc Raul Maldondo N2333HErcoupe 415-C · S/N 2958Cancelled Nov 2, 1955 · Exported to Mexico · Built 1946 · Ivey William E N19030Taylorcraft A · S/N 136Cancelled Mar 9, 1950 · Built 1937 N70902Piper J3C-65 · S/N 17923Cancelled Feb 8, 1949 · Hargis Wyvil Q

Back to Fabens, TX