Skip to content

Cancelled registrations · 45

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 = 'AZ' AND d.registrant_city = 'PARKER' 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 = 'AZ' AND d.registrant_city = 'PARKER'
  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 = 'AZ' AND d.registrant_city = 'PARKER'
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.

N8500HLake LA-4-200 · S/N 1088Cancelled Dec 7, 2024 · Sale reported, canceled · Built 1983 N331SDSchweizer TH55A/269A · S/N 291105Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1969 · La Paz County Sheriffs Dept N860MCSchweizer TH55A/269A · S/N 1080998Cancelled Jun 1, 2018 · Sale reported, canceled N906SDBell OH-58A · S/N 70-15142Cancelled Jun 1, 2018 · Sale reported, canceled N119FTBell OH-58C · S/N 69-16108Cancelled May 30, 2018 · Sale reported, canceled N22031Fairchild 24W-9 · S/N W204Cancelled May 18, 2018 · Revoked, canceled · Built 1939 · Kramer Robert D N59250Boeing A75N1(PT17) · S/N 75-3127Cancelled May 18, 2018 · Revoked, canceled · Built 1942 · Sampleys Flying Service Inc N63BJPiper PA-32RT-300T · S/N 32R-7887217Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1978 · Hooper Jerald R N467YNNorth Wing Uum SPORT X2 · S/N LS7022Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 2012 · Bline Jeffrey O N2393XBell OH-58A · S/N 68-16787Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Colorado River Indian Tribes Police Department N48979Taylorcraft DCO-65 · S/N 4939Cancelled May 30, 2017 · Built 1943 · Cramer Todd L N95174Piper PA-28-140 · S/N 28-25833Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1969 · Mcconnell James F N7033SCessna 150H · S/N 15067733Cancelled Dec 2, 2014 · Revoked, canceled · Built 1967 · Bybee Ronald Gene N972VBeech 77 · S/N WA-39Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1979 · Roberts Darrell N22871Piper J3C-65 · S/N 2789Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1939 · Collinske Amos J N5386QRogers Todd W ROGERS ROTORWAY · S/N J-316Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1989 · Lopez Gabriel A N6570ZPiper PA-25-235 · S/N 25-2119Cancelled Aug 7, 2013 · Revoked, canceled · Built 1962 · Agricultural Applicators Corp N6274ZPiper PA-25 · S/N 25-339Cancelled Aug 5, 2013 · Revoked, canceled · Built 1960 · Agricultural Applicators Corporation N2210ZTate Gary L B8M · S/N 1Cancelled Jul 11, 2013 · Sale reported, canceled N1510NBalloon Works FIREFLY 7-B · S/N F7B-015Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1982 · Mcclellan John E N88058Eagle EAGLE DW-1 · S/N DW-1-0038-81Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Poston Sprayers N8423KStinson 108-1 · S/N 108-1423Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1946 · Dinkfeld Steven D N70317Piper J3C-65 · S/N 17294Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1946 · Collinske Amos J N5482HPiper PA-18A · S/N 18-73Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1950 · Chappue Michael T N288DBeverly MIDGET MUSTANG I · S/N 645Cancelled Feb 11, 2013 · Sale reported, pending cancellation · Built 1969 N2180PPiper PA-23 · S/N 23-789Cancelled Aug 27, 2012 · Registration expired, pending cancellation · Built 1956 · Coronado Racing Corp N78ECCessna 320E · S/N 320E-0090Cancelled May 7, 2012 · Registration expired, pending cancellation · Built 1967 · Willoughby Robert J N1871RCessna 560XL · S/N 560-5297Cancelled Dec 23, 2010 · Exported to Canada · Built 2002 · Agp Enterprises LLC N516LPCessna T210L · S/N 21061313Cancelled Sep 21, 2010 · Exported to Mexico · Built 1976 · State Of Arizona La Paz County Sheriffs Office N1537WBeech 58 · S/N TH-221Cancelled Jun 30, 2009 · Registration revoked · Built 1972 · Liberty Equip Leasing Co Inc DBA N40770Piper J3F-65 · S/N 7484Cancelled Aug 28, 2002 · Built 1941 · Robinson Richard Ray N135HAHiller UH-12E · S/N HA3035Cancelled Sep 26, 1995 · Exported to Germany · Morris Richard Gary N241DTSwearingen SA-226T · S/N T242Cancelled Mar 3, 1994 · Triennial form not returned · Gerson Richard L Trustee N8812WEagle EAGLE DW-1 · S/N DW1007782Cancelled Jan 6, 1992 · Triennial form not returned · Poston Sprayers N5085ECessna 180B · S/N 50385Cancelled Jul 31, 1991 · Triennial form not returned · Boukather Philip K N8494JMurphy Ross B VARI-EZE · S/N 147Cancelled Mar 28, 1991 · Triennial form not returned · Murphy Ross B N9799VCessna A188 · S/N 188-0249Cancelled Apr 15, 1982 · Administratively canceled · Campo Robert H DBA N7466MCessna 175 · S/N 55766Cancelled Nov 3, 1977 · Beard Ralph N53219Cessna A188B · S/N 18801696TCancelled Jul 7, 1977 · Greer K Elroy N7072ZPiper PA-25-235 · S/N 25-2854Cancelled May 13, 1976 · Exported to Mexico · Agricultural Applicators Corp N8509ABeech A35 · S/N D-2017Cancelled Dec 12, 1974 · Built 1949 · Davis Chas N9388VMooney M20E · S/N 700017Cancelled Nov 10, 1972 · L & P Aviation N6555ZPiper PA-25-235 · S/N 25-2101Cancelled Dec 22, 1971 · Sampleys Flying Service Inc N49055Taylorcraft DCO-65 · S/N L-4707Cancelled May 5, 1950 · Turk H P N68107Cessna UC-78 · S/N 6267Cancellation date not recorded · Harold P Turk

Back to Parker, AZ