North Hollywood, CA

Cancelled registrations · 187

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

N61773Cessna 172M · S/N 17264790Cancelled Mar 7, 2026 · Sale reported, canceledN917AULockheed P-3A · S/N 150510Cancelled Nov 2, 2025 · Sale reported, pending cancellationN724MAGrumman S2F · S/N 136724Cancelled Apr 20, 2024 · Sale reported, canceledN327MAGrumman S2F-1 · S/N 136723Cancelled Jan 27, 2024 · Sale reported, canceledN743MAGrumman S2F · S/N 136743Cancelled Jan 27, 2024 · Sale reported, canceledN755AKKalents Armen COZY MK-IV · S/N MK-1065Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Kalents ArmenN713TSFreefly ALTA · S/N 716500Cancelled Dec 17, 2020 · Strataswarm IncN500EPDJI INSPIRE 2 · S/N 09YDE6UL040173Cancelled Jun 26, 2020 · Sale reported, canceledN151WRBalz Gunther W TM-1 THUNDER MUSTANG · S/N 24Cancelled Apr 17, 2020 · Built 2001 · Richards Wayne DN5734WPiper PA-28-150 · S/N 28-1403Cancelled Apr 10, 2020 · Revoked, canceled · Built 1963 · Kootstra DeweyN4095BAeronca 15AC · S/N 15AC-420Cancelled Dec 27, 2019 · Exported to France · Built 1949 · Flying Circus PicturesN780DYFreefly Systems ALTA 8 · S/N 685055Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Strataswarm IncN3203XCessna 150G · S/N 15064603Cancelled Nov 29, 2019 · Revoked, canceled · Built 1966 · Panza Pascal EN8688TCessna 182C · S/N 52588Cancelled Nov 15, 2019 · Revoked, canceled · Built 1960 · Snow HazelN23552Aeronca 65-C · S/N C5109Cancelled Oct 25, 2019 · Revoked, canceled · Built 1939 · Goldberg GeraldN659RSDJI SPREADING WINGS S900 · S/N 0370020498Cancelled Jul 1, 2019 · Registration expired, pending cancellation · Ocampo Raphael TN659SSDJI SPREADING WINGS S900 · S/N 0370061076Cancelled Jul 1, 2019 · Registration expired, pending cancellation · Ocampo Raphael TN659TRDJI INSPIRE 1 PRO · S/N W21ACI16011979Cancelled Jul 1, 2019 · Registration expired, pending cancellation · Ocampo Raphael TN71664Luscombe 8A · S/N 3091Cancelled Jun 12, 2019 · Revoked, canceled · Built 1946 · Rackliffe RichardN631ZJDonovan Davis CINESTAR 8 · S/N APCS8-001Cancelled May 2, 2019 · Registration expired, pending cancellation · Strataswarm IncN627FSDonovan Davis SS1 · S/N SS000001Cancelled Apr 4, 2019 · Registration expired, pending cancellation · Strataswarm IncN6318FDonovan Davis 280MM MINI MOJO · S/N AP280MOJO-001Cancelled Mar 15, 2019 · Registration expired, pending cancellation · Strataswarm IncN631NSDJI INSPIRE 1 PRO · S/N W21ACI16011197Cancelled Mar 15, 2019 · Registration expired, pending cancellation · Strataswarm IncN631USDJI S900/A2 · S/N CD91E25CBFE0D2D93617984441FE2CCancelled Mar 15, 2019 · Registration expired, pending cancellation · Strataswarm IncN628CWDJI PHANTOM 2 · S/N PH645189992Cancelled Mar 13, 2019 · Registration expired, pending cancellation · Strataswarm IncN617UYDonovan Davis SS2 · S/N SS000002Cancelled Mar 12, 2019 · Registration expired, pending cancellation · Strataswarm IncN617TZDJI PHANTOM 2 · S/N PH636159944Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Strata Swarm IncN612TBAerial Freaks MOJO 280 · S/N MJ000001Cancelled Mar 8, 2019 · Registration expired, pending cancellation · Strataswarm IncN587NJDJI INSPIRE 1 · S/N W13DCB14020599Cancelled Feb 1, 2019 · Registration expired, pending cancellation · Imt Global IncN64243Cessna 172M · S/N 17265117Cancelled Jan 7, 2019 · Exported to Philippines · Gasc AviationN6253GCessna 172N · S/N 17273582Cancelled Jan 2, 2019 · Exported to Philippines · Built 1979 · Gasc AviationN714VTCessna 152 · S/N 15279473Cancelled Sep 17, 2018 · Exported to El Salvador · Built 1977 · Gasc AviationN53502Taylorcraft DCO-65 · S/N 5943Cancelled Sep 15, 2018 · Revoked, canceled · Built 1944 · Bendall Walter HN33AXOleksiy Zayika MR 14 · S/N 14001Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Zayika OleksiyN33197Piper J4A · S/N 4-1352Cancelled Apr 10, 2018 · Revoked, canceled · Built 1940 · West Bill QN81100Funk B75L · S/N 230Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Schorr Richard CN23066Luscombe 8A · S/N 990Cancelled Oct 28, 2017 · Revoked, canceled · Built 1939 · Schwebach Edward NN911SPIsrael Aircraft Industries 1124 · S/N 244Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1979 · Flightstar IncN9641CNorth American B-25J · S/N 4430010ACancelled Feb 13, 2017 · Revoked, canceled · Arrow Sales CoN72754Cessna 140 · S/N 9937Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Stai MartinN7980FCessna 150F · S/N 15064080Cancelled Feb 4, 2017 · Revoked, canceled · Built 1966 · Van Riessen Paul AlanN889LBCessna 172S · S/N 172S9889Cancelled Feb 3, 2017 · Exported to Thailand · Built 2005 · California Management And Consulting LLCN2565LCessna 172H · S/N 17255765Cancelled Sep 12, 2016 · Exported to Thailand · Built 1967 · Gasc AviationN4649LCessna 152 · S/N 15284206Cancelled Aug 11, 2015 · Exported to Philippines · Built 1980N118FAReinstra/Mcdonnel Douglas F-18A · S/N 161973Cancelled May 18, 2015 · Registration expired, pending cancellation · Reinstra Hal GN688EADouglas DC3 · S/N 12943Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Cameron And Stall Inc DBAN66957Fairchild M-62A · S/N 2103AECancelled Oct 25, 2013 · Revoked, canceled · Getz Paul RN5982XBrantly B-2 · S/N 126Cancelled Aug 7, 2013 · Revoked, canceled · Built 1961 · Vanoni A BN542RBKarnes David MINI-MAX · S/N 335Cancelled Jul 11, 2013 · Sale reported, canceledN800STDominion SKYTRADER 800 · S/N PROTOTYPECancelled May 13, 2013 · Registration expired, pending cancellation · Can Am Aviation Corp
Back to North Hollywood, CA