OpenAirDocs.org
N Hollywood, CA

Cancelled registrations · 32

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 = 'CA' AND d.registrant_city = 'N 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.

N7911Holmes B-8-GYROCOPTER · S/N H-11-1-41Cancelled Feb 4, 2017 · Revoked, canceled · Holmes James WN90961Douglas DC-6B · S/N 44689Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1955 · Aerospace Products IncN6340CDouglas DC-7 · S/N 45154Cancelled Aug 6, 2013 · Revoked, canceled · Built 1957 · International Aerodyne IncN6645RBeech C-45H · S/N 52-10836Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1952N8556KStinson 108 · S/N 108-1556Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1947 · Pickel Harold PN20983Culver LCA · S/N 112Cancelled Jul 13, 2009 · Registration revoked · Built 1940 · Spunt Herbert AN61726Douglas C-47 · S/N 20024Cancelled Dec 14, 1998 · Triennial form not returned · Aerospace Products IncN2332QBeech 23 · S/N M398Cancelled Feb 9, 1994 · Exported to Philippines · Cameron L H DBAN9367TPiper PA-38-112 · S/N 3878A0051Cancelled Feb 9, 1994 · Exported to Philippines · L H Cameron DBAN4585KCessna P210N · S/N P21000224Cancelled Dec 11, 1991 · Triennial form not returned · Air Rotor IncN5759YBell Helicopter Textron 206L-1 · S/N 45563Cancelled Mar 29, 1991 · Triennial form not returned · Rs Aviation IncN41640Piper PA-28-151 · S/N 28-7415300Cancelled May 19, 1983 · Built 1974 · Quinonez IvanN31APBeech 3NM · S/N CA-141Cancelled May 20, 1976 · Built 1952 · Aerospace Products IncN6600RBeech C-45H · S/N 52-10781Cancelled Mar 23, 1971 · Consolidated Air Parts CoN6611RBeech C-45H · S/N 52-10691Cancelled Mar 23, 1971 · Consolidated Air Parts Co CorpN6623RBeech C-45H · S/N 52-10789Cancelled Mar 23, 1971 · Consolidated Air Parts CoN6626RBeech C-45H · S/N 52-10935Cancelled Mar 23, 1971 · Consolidated Air Parts CoN6639RBeech C-45H · S/N 52-10635Cancelled Mar 23, 1971 · Consolidated Air Parts CoN803DDouglas DC-7B · S/N 44854Cancelled Jul 2, 1970 · California Airmotive CorpN807DDouglas DC-7B · S/N 44858Cancelled Jul 2, 1970 · California Airmotive CorpN238YShort L C A · S/N 2Cancelled Jun 28, 1966 · Lawrence C ShortN6641MStinson 108-3 · S/N 108-4641Cancelled Feb 25, 1965 · Tippins Herbert C Et AlN6316CDouglas DC-7 · S/N 44280Cancelled Sep 20, 1963 · Built 1954 · Bmr CoN6319CDouglas DC-7 · S/N 44283Cancelled Aug 19, 1963 · Built 1954 · Bmr CoN57133Cessna T-50 · S/N 4857Cancelled Oct 11, 1955 · Gray Claude LN1655BLuscombe 11A · S/N 11-161Cancelled Oct 8, 1953 · Built 1948 · Hoffman WayneN97299Stinson 108 · S/N 108-299Cancelled Jul 25, 1951 · Brown Philip RN97418Stinson 108 · S/N 108-418Cancelled May 18, 1949 · Schlensker Robert EN6259Stearman C3-B · S/N 156Cancelled Apr 20, 1948 · Clarke FrankN1954Re/Loudermilk 10 · S/N 1Cancelled Mar 29, 1948 · Re Carlo Et AlN908NGreat Lakes 2T-1A · S/N 138Cancelled Dec 28, 1940 · Goodrich JuddN66600Cessna T-50 · S/N 6206Cancellation date not recorded · Wilson S Wiley
Back to N Hollywood, CA