Skip to content

Cancelled registrations · 82

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

N2072PPiper PA-23 · S/N 23-659Cancelled Apr 26, 2024 · Revoked, pending cancellation · Built 1956 · Overture Leo N5381ACessna 310B · S/N 35581Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1957 · Mountain Airframe LLC N900LAero Commander 680-F · S/N 680F-1341-136Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1963 · Arkansas Round Engines LLC N3962Beech D18S · S/N A-193Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1946 · Shepard Group LLC N14BTCessna 337B · S/N 337-0552Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1966 · Shepard Group LLC N7321VBellanca 17-30 · S/N 30158Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1968 · Shepard Group LLC N6649ECessna 175 · S/N 56149Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Shepard Group LLC N9638EAeronca 11AC · S/N 11AC-1279Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1946 · Nichols John B N7301LPiper PA-18-150 · S/N 18-7509045Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1975 · Boyd Harley D N11ZBellanca 17-30A · S/N 73-30537Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1973 N362KSSchleicher ASK-21 · S/N 21225Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1984 · Taylor Fred G N631BBeech D18S · S/N A-430Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1948 · Taylor Everett W N9282Beech C-45H · S/N CA136Cancelled Oct 14, 2014 · Revoked, pending cancellation · Overturf Leo N7083TPiper PA-22-108 · S/N 22-8753Cancelled Aug 26, 2014 · Registration expired, pending cancellation · Otto Ronald L DBA N3489PPiper PA-23-160 · S/N 23-1463Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1958 N9007ZCessna 337A · S/N 337-0327Cancelled Jun 5, 2013 · Sale reported, canceled N94089Ercoupe 415-C · S/N 1412Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1946 · Taylor Everett W N825RBeech K35 · S/N D-6073Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1959 · Ouachita Aircraft Co Inc N8400YPiper PA-30 · S/N 30-1549Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1967 · Ouachita Aircraft C Inc N7923YPiper PA-30 · S/N 30-1013Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1966 · Quachita Aircraft Co Inc N79SWHiller H-23D · S/N 1136Cancelled May 9, 2013 · Registration expired, pending cancellation · Aerial Ignition Inc N155EMMonteleone Gene R SONERAI II L · S/N 81895581Cancelled May 3, 2013 · Registration expired, pending cancellation · Monteleone Gene R N6307KRepublic RC-3 · S/N 528Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1947 · Otto Ronald L DBA N5971ECessna 150 · S/N 17471Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1959 · Dunks Kenneth Alan N56RSBeech J35 · S/N D-5555Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1958 · Ouachita Aircraft Co Inc N7612DPiper PA-22-150 · S/N 22-5316Cancelled Feb 27, 2013 · Sale reported, pending cancellation · Built 1957 N8323PPiper PA-24-250 · S/N 24-3574Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1963 N86769Bellanca 14-13 · S/N 1130Cancelled Nov 14, 2012 · Sale reported, pending cancellation · Built 1946 N4044LCessna 421 · S/N 421-0044Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1967 N5655ECessna 150 · S/N 17155Cancelled Sep 28, 2012 · Revoked, canceled · Built 1959 · Mclemore Jim N5063BBeech F35 · S/N D-4315Cancelled Sep 6, 2012 · Sale reported, pending cancellation · Built 1955 N83BDBodkin Dennis Herbert BOREDOM FIGHTER WII · S/N 147Cancelled Aug 27, 2012 · Registration expired, pending cancellation · Bodkin Dennis H N5524DBeech H35 · S/N D-5054Cancelled Aug 23, 2012 · Revoked, canceled · Ouachita Aircraft Co Inc N14BWWood Bill L BOREDOM FIGHTER 11 · S/N 147-BCancelled Aug 7, 2012 · Sale reported, canceled · Built 1996 N48179Grumman American Avn. AA-5 · S/N AA5-0709Cancelled Aug 7, 2012 · Revoked, canceled · Seneca Aviation Inc N1801GChampion 7ECA · S/N 554Cancelled Aug 1, 2012 · Sale reported, canceled · Built 1968 N46957Grumman American Avn. AA-5 · S/N AA5-0690Cancelled Aug 1, 2012 · Revoked, canceled · Seneca Aviation Inc N320JRRowsey James H KITFOX IV · S/N 1567Cancelled Jul 27, 2012 · Registration expired · Built 2000 · Rowsey James H N9272ZBell TH-13T · S/N 3650Cancelled Jul 28, 2011 · Expired dealer · Built 1967 · Brainerd Philip S DBA N8622QBeech S35 · S/N D-7647Cancelled Jul 27, 2011 · Expired dealer · Built 1965 · Talimena Aircraft N8813YPiper PA-30 · S/N 30-1971Cancelled Jul 25, 2011 · Expired dealer · Built 1969 · Ouachita Aircraft Co Inc N8315JCessna 150G · S/N 15066215Cancelled Jul 22, 2011 · Expired dealer · Built 1967 · Overturf Leo N16539Piper PA-28-180 · S/N 28-7305279Cancelled Jul 13, 2011 · Expired dealer · Built 1973 · Ouachita Aircraft N2173PPiper PA-23 · S/N 23-779Cancelled Jul 11, 2011 · Sale reported, pending cancellation · Built 1956 N11HLBeech 58 · S/N TH-18Cancelled Jul 7, 2011 · Expired dealer · Built 1970 · Ouachita Aircraft Co N1FUPiper PA-31-310 · S/N 31-768Cancelled Jul 7, 2011 · Expired dealer · Built 1971 · Ouachita Aircraft Co Inc N128DCCarlson D W/Carlson L E STOL CH 801 · S/N 84297Cancelled Apr 5, 2011 · Exported to Saudi Arabia · Built 2007 · Hampton Vernon L N862RBeech 35-33 · S/N CD-13Cancelled Mar 28, 2011 · Expired dealer · Built 1959 · Overturf Leo N7219ACessna 172 · S/N 29319Cancelled Mar 25, 2011 · Expired dealer · Built 1956 · Seneca Aviation N528NCessna 337B · S/N 337-0688Cancelled Mar 17, 2011 · Expired dealer · Built 1967 · Overturf Leo

Back to Mena, AR