West Hollywood, FL

Cancelled registrations · 24

Query with SQL
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 = 'FL' AND d.registrant_city = 'WEST HOLLYWOOD'
  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.

N27381Aeronca 60-TF · S/N 1940TCancelled Feb 4, 2021 · Revoked, canceled · Built 1940 · Moyer John HN1072CMooney M20A · S/N 1343Cancelled Oct 2, 2019 · Revoked, canceled · Built 1958 · Davis Aircraft & Engine ServiceN6494BCessna 172 · S/N 29694Cancelled Apr 5, 2018 · Revoked, canceled · Built 1957 · Flamingo Flyers IncN2031MPiper J3C-65 · S/N 20797Cancelled Mar 23, 2018 · Revoked, canceled · Built 1946 · A And R Avia Svc IncN20372Cessna 172M · S/N 17261233Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1973 · Selim Shahir PierreN906CABell 206B · S/N 4078Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1989 · Crescent Airways IncN80976Cessna 172M · S/N 17266822Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1976 · Selim Shahir PN285CABell 206B · S/N 1678Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1975 · Crescent Airways IncN6387MUniversal Stinson 108-3 · S/N 108-4387Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1948 · South East Aviation IncN318LABeech C90 · S/N LJ-892Cancelled Jul 22, 2011 · Expired dealer · Built 1980 · Air Crane IncN1484VCessna 172M · S/N 17263618Cancelled Sep 21, 2009 · Registration revoked · Built 1974 · Nor Roz Inc DBAN78CFBell Helicopter Textron 206L-1 · S/N 45206Cancelled Dec 27, 1995 · Exported to Canada · Crescent Airways IncN2210WBell 206B · S/N 3530Cancelled Jan 2, 1991 · Triennial form not returned · Crescent Airways IncN8101JBell 47G-3B-2 · S/N 6825Cancelled Nov 8, 1978 · Exported to Venezuela · Crescent Airways IncN51246Cessna U206F · S/N U20601988Cancelled Jun 8, 1973 · Exported to Canada · Nor Roz Inc Safari AviationN1391EChampion AERONCA 7AC · S/N 7AC-4953Cancelled Nov 15, 1972 · Built 1946 · Bayer William DavidN6534KRepublic RC-3 · S/N 800Cancelled Mar 1, 1972 · Evans WilliamN9858CNorth American T-28A · S/N 49-1731ACancelled Mar 2, 1971 · Crescent Airways IncN3629FNorth American SNJ-5 · S/N 43933Cancelled Oct 26, 1970 · West Broward Improvement CorpN5200ZPiper PA-22-108 · S/N 22-8870Cancelled Jul 9, 1970 · Wheelers Aero-Glass CoN2983SCessna 150G · S/N 15066883Cancelled Apr 29, 1970 · Built 1967 · Ritter Rental System IncN26828Piper J4F · S/N 4-922Cancelled Sep 3, 1968 · Civil Air Patrol North Perry SquadronN6457MStinson 108-3 · S/N 108-4457Cancelled May 20, 1965 · Feigel Hugh B SrN440CStinson 108-2 · S/N 108-3440Cancelled Nov 25, 1964 · Weiser Melvin H And Cohee Edward T Jr
Back to West Hollywood, FL