Skip to content

Cancelled registrations · 28

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 = 'AR' AND d.registrant_city = 'MCCRORY' 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 = 'AR' AND d.registrant_city = 'MCCRORY'
  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 = 'AR' AND d.registrant_city = 'MCCRORY'
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.

N42005Everett Elmo ZODIAC 601XL · S/N 6-5238Cancelled Oct 11, 2019 · Sale reported, canceled · Built 2005 N7683VAero Commander CALLAIR A-9B · S/N 1431Cancelled Feb 4, 2017 · Revoked, canceled · Dallas Ernest N3070RAir Tractor AT-802A · S/N 802A-0528Cancelled Oct 19, 2016 · First renewal notice · Built 2013 · Reynolds Flying Service Inc N2403VCessna 140 · S/N 14646Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1948 · Barnett Johnny Brent N8209KSchweizer G-164B · S/N 612BCancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1979 · Breckenridge Gerald H N5332Grumman G-164A · S/N 612Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1969 · Reid Steven E N1736SAero Commander S2R · S/N 1436RCancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1968 · Owens Paul DBA N6778ZPiper PA-25-235 · S/N 25-2413Cancelled Oct 25, 2013 · Revoked, canceled · Gayman Mark G N6636QGrumman Acft ENG Cor-Schweizer G-164A · S/N 1694Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1976 · Cain Flying Service Inc N4558Grumman Acft ENG Cor-Schweizer G-164A · S/N 1055Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1973 · Owens Flying Service Inc N39HCCrosby Harold CHALLENGER II SP · S/N HC 05Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1997 N6678KGrumman Acft ENG Cor-Schweizer G-164B · S/N 414BCancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1978 · Breckenridge Gerald H N83654Aeronca 7AC · S/N 7AC-2332Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1946 N9143RKing Dewey T-BIRD II · S/N 32497Cancelled Dec 15, 2009 · Triennial form not returned · King Dewey W N48553Grumman Acft ENG Cor-Schweizer G-164B · S/N 72BCancelled Aug 16, 2006 · Expired dealer · Built 1976 · Delta Air Inc N131CXCessna 750 · S/N 750-0131Cancelled Jun 18, 2001 · Exported to Canada · Centoco Manufacturing Corp N8457MCessna A150K · S/N A15000157Cancelled Dec 3, 1997 · Triennial form not returned · Odom Joe DBA N983ACAero Commander 680FL · S/N 134326Cancelled Aug 2, 1997 · Triennial form not returned · Breckenridge Gerald N48628Grumman Acft ENG Cor-Schweizer G-164B · S/N 92BCancelled Oct 30, 1996 · Triennial form not returned · Scarbrough Jim DBA N9780Grumman Acft ENG Cor-Schweizer G-164A · S/N 1275Cancelled Nov 2, 1993 · Scarbrough Jimmy R DBA N8089KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 557BCancelled Jun 8, 1992 · Triennial form not returned · Cain Flying Service N8691HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1470Cancelled Jul 22, 1983 · Administratively canceled · Reynolds Ernest DBA N9715PPiper PA-25-235 · S/N 25-7556028Cancelled May 2, 1978 · Built 1974 · Woods Flying Service Inc N6936FCessna 150F · S/N 15063536Cancelled Sep 21, 1976 · Revoked, pending cancellation · Built 1966 · Everett Elmo N7640ZPiper PA-25-235 · S/N 25-3774Cancelled Dec 3, 1971 · Hughes Ed N7718ZPiper PA-25-235 · S/N 25-3883Cancelled Sep 4, 1970 · Hughes Edgar Allen Jr N33977Taylorcraft BC12-65 · S/N 2829Cancelled Apr 6, 1961 · Built 1941 · Everett Elmo N1190EAeronca 7AC · S/N 7AC-4747Cancelled Nov 30, 1954 · Mann Claud E

Back to Mccrory, AR