Cancelled registrations · 40

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 = 'OH' AND d.registrant_city = 'LANCASTER' 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 = 'OH' AND d.registrant_city = 'LANCASTER'
  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 = 'OH' AND d.registrant_city = 'LANCASTER'
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.

N9556HCessna 172M · S/N 17266227Cancelled Mar 2, 2023 · Registration expired, pending cancellation · Built 1976 · Fairfield Aviation LLC N4942ZPiper PA-22-108 · S/N 22-8535Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Boyer Martin N246DVRaun David A HORIZON · S/N H086Cancelled Nov 12, 2019 · Built 1995 · Johnston Felix E N90617Hughes 269A · S/N 96-0651Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1966 · Slater Steven A N6462BCessna 172 · S/N 29662Cancelled Aug 6, 2013 · Revoked, canceled · Built 1956 · Rogers Robert I N4897LBales Gerald L CGS HAWK · S/N H8340CCancelled Jun 12, 2013 · Registration expired, pending cancellation · Bales Gerald L N54BDDoolittle Robert ACRO SPORT · S/N 1Cancelled Jul 24, 2012 · First renewal notice · Doolittle Robert N2256WHughes 269A · S/N 1181018Cancelled Mar 14, 2012 · Second renewal notice · Built 1968 · American Air Adventures Inc N1813CJones Brian K TITAN 1 · S/N T93277SOHK0075Cancelled Nov 30, 2011 · Built 2009 · Jones Brian K N7180SFortier James G EXEC LE · S/N 032154Cancelled Oct 14, 2008 · Triennial form not returned · Loos Darrell M N186SStevens William RAF 2000 GTX SE · S/N H2-00-11-479Cancelled Sep 23, 2003 · Built 2001 · Stevens William N66430Cessna 150M · S/N 15076043Cancelled Sep 12, 2002 · Triennial form not returned · Built 1974 · Leach Frank A N6639FCessna 150F · S/N 15063239Cancelled Dec 4, 2000 · Triennial form not returned · Willard Jack R N721RADehavilland DHC-6-300 · S/N 840Cancelled Jul 27, 2000 · Exported to Netherlands Antilles · Ricart Aviation Sales LLC N111PSPiper PA-34-220T · S/N 34-8233205Cancelled Jul 25, 2000 · Exported to United Kingdom · Ricart Aviation Sales LLC N72SLCessna 550 · S/N 550-0504Cancelled Sep 23, 1999 · Exported to Mexico · Ricart Aviation Sales LLC N688CAPiper PA-31T · S/N 31T7820046Cancelled Nov 19, 1997 · Exported to Brazil N8280YBeech A36 · S/N E2813Cancelled Feb 2, 1995 · Exported to Brazil · Long Randall S DBA N90GDBeech E-90 · S/N LW138Cancelled Sep 27, 1994 · Exported to Brazil · Long Randall S DBA N466AZCessna TR182 · S/N R18201374Cancelled May 11, 1994 · Exported to Canada · Long Randall S DBA N3088WBeech 58 · S/N TH1511Cancelled Mar 4, 1994 · Exported to Brazil · Long Randall S DBA N2166TPiper PA-28-180 · S/N 287205016Cancelled Jan 14, 1993 · Exported to Sweden · Long Randall S DBA Mcr Aviation N5250ECessna T182 · S/N 18268302Cancelled Oct 8, 1991 · Exported to Brazil · Long Randall S DBA N66989Cessna 152 · S/N 15281708Cancelled Apr 25, 1991 · Triennial form not returned · Laird Naomi A N20578Cessna 172M · S/N 17261410Cancelled Aug 2, 1983 · Administratively canceled · Boltz G Brian N16386Piper PA-28-180 · S/N 28-7305243Cancelled Nov 24, 1982 · Administratively canceled · Mcafee Roger N19960Cessna 172M · S/N 17260889Cancelled Apr 15, 1982 · Administratively canceled · Stevenson H James N9483JPiper PA-28-180 · S/N 28-3735Cancelled Jan 24, 1978 · Tipple Devon W N4181VCessna 170 · S/N 18514Cancelled Jun 30, 1975 · Hammond B Alan N35584Cessna 172I · S/N 17256851Cancelled Apr 11, 1975 · Exported to Canada · Built 1968 · Centurion Aviation Services Inc N920GRockwell International NA-265-60 · S/N 306-74Cancelled Jan 28, 1975 · Anchor Hocking Corp N8313MCessna A150K · S/N A15000013Cancelled Jun 7, 1974 · Centurion Aviation Services Inc N9826KStinson 108-2 · S/N 108-2826Cancelled Jul 27, 1971 · Exported to Canada · Harper Gregory T N24146Funk B · S/N 72Cancelled May 22, 1965 · Built 1940 · Shaw Frank W N38587Piper J5A · S/N 51007Cancelled Mar 13, 1962 · Built 1941 · Capers Flying Club N8467KStinson 108-1 · S/N 108-1467Cancelled Feb 17, 1956 · Lancaster Flying Service N3586EAeronca 11AC · S/N 11AC-1814Cancelled Nov 15, 1955 · Eaarl E Jenkins N273CStinson 108-2 · S/N 108-3273Cancelled Oct 4, 1955 · Kauffman Porter W N15049Taylor E-2 · S/N 200Cancelled Mar 4, 1955 · Built 1935 · Smith Samuel Etal N15021Piper E-2 · S/N 183Cancelled Aug 15, 1939 · Smith Samuel M & Raymond E Giles

Back to Lancaster, OH