Skip to content

Cancelled registrations · 32

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

N64CCBell UH-1B · S/N 62-1894Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Overseas Aircraft Support Inc N81114Bell UH-1H · S/N 74-22526Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Overseas Aircraft Support Inc N64771S M & T UH-1B · S/N 63-8704Cancelled Sep 18, 2020 · Sale reported, canceled · Built 1963 N8507PPiper PA-24-400 · S/N 26-87Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Overseas Aircraft Support Inc N3037DCessna 310 · S/N 35237Cancelled May 30, 2018 · Sale reported, canceled N659ACBell UH-1 · S/N 66-01096Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Oas Aircraft Support LLC N662ACBell UH-1 · S/N 68-15451Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Oas Aircraft Support LLC N663ACBell UH-1 · S/N 67-17454Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Oas Aircraft Support LLC N7786MMooney M20F · S/N 22-0034Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1974 · Monette Ronald A N630VBell UH-1H · S/N 67-17703Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 1967 · Oas Parts LLC N687FDBell UH-1H · S/N 65-10101Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Oas Parts LLC N310ASBell UH-1H · S/N 6509606Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Oas Parts LLC N903HESouthwest Florida SW205 · S/N 5586Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1966 · Oas Parts LLC N75550Destiny Powered Parachutes CHROME BLUE DESTINY · S/N 1B0069Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Hansen Don N77KDBalloon Works FIREFLY 7 · S/N 766Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1977 · Butler William M N7117FBalloon Works FIREFLY 8B · S/N F8B-131Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Butler William M N665ACBell UH-1 · S/N 68-15493Cancelled Oct 26, 2011 · Exported to Argentina · Overseas Aircraft Support Inc N668ACBell UH-1 · S/N 68-16250Cancelled Oct 26, 2011 · Exported to Argentina · Overseas Aircraft Support Inc N1541EBalloon Works FIREFLY 7-B · S/N 10256Cancelled Jun 7, 2011 · Registration pending, canceled · Built 1981 N270SABell UH-1H · S/N 76-22652Cancelled May 23, 2011 · Exported to Vietnam · Overseas Aircraft Support Inc N470SABell UH-1H · S/N 76-22654Cancelled Apr 19, 2011 · Exported to Vietnam · Overseas Aircraft Support Inc N114ACGarlick Helicopters UH-1H · S/N 9464Cancelled Jul 6, 2009 · Exported to Mexico · Overseas Aircraft Support Inc N37995Bell UH-1B · S/N 60-3559Cancelled Feb 6, 2009 · Exported to Australia · Built 1960 · Overseas Aircraft Support Inc N7232YBell UH-1H · S/N 66-16729Cancelled Dec 17, 2008 · Exported to Argentina · Overseas Aircraft Support Inc N7232LBell UH-1H · S/N 65-09600Cancelled Nov 14, 2008 · Exported to Australia · Built 1965 · Overseas Aircraft Support Inc N81110Bell UH-1H · S/N 69-15532Cancelled Aug 19, 2008 · Overseas Aircraft Support Inc N205TAGarlick Helicopters UH-1H · S/N 65-12860Cancelled Jan 23, 2008 · Exported to Mexico · Built 1965 · Overseas Aircraft Support Inc N5517LBell UH-1H · S/N 68-16251Cancelled Oct 1, 2007 · Exported to Mexico · Overseas Aircraft Support Inc N138JBBell UH-1H · S/N 70-16325Cancelled May 9, 2007 · Exported to Argentina · Overseas Aircraft Support Inc N72171Bell UH-1H · S/N 65-09744Cancelled Sep 27, 2006 · Exported to Mexico · Built 1965 · Overseas Aircraft Support Inc N734HECessna 172N · S/N 17268860Cancelled Aug 18, 1997 · Exported to Chile · R And B Leasing Inc N8900XCessna 182D · S/N 18253300Cancelled Jun 14, 1991 · Carson Raymond D

Back to Lakeside, AZ