Skip to content

Cancelled registrations · 503

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

N617HPEurocopter AS 350 B3 · S/N 3471Cancelled Mar 12, 2026 · Exported to Canada · Built 2001 · California Highway Patrol N341HPEurocopter AS 350 B3 · S/N 3407Cancelled Nov 14, 2025 · Exported to Canada · Built 2001 · California Highway Patrol N621XTHammersmith Kirk LANCAIR ES · S/N ES-191Cancelled Jun 30, 2025 · Registration pending, canceled · Built 2004 N7401Midget Mustang BM-1 · S/N 19567Cancelled Jun 30, 2025 · Sale reported, canceled · Built 1968 N24418Semco Balloon T · S/N SEM97Cancelled Jul 27, 2024 · Revoked, canceled · Hoffman Dennis M N367FCChilcote Mike EXEC · S/N 3586Cancelled Jul 20, 2024 · Chilcote Michael A N2953JCessna 150G · S/N 15065753Cancelled Mar 9, 2024 · Sale reported, canceled · Built 1966 N3254FMooney M20E · S/N 670047Cancelled Feb 3, 2024 · Sale reported, canceled · Built 1967 N6433NCessna T210N · S/N 21063009Cancelled Sep 16, 2023 · Sale reported, canceled · Built 1978 N7933MBeech V35 · S/N D-8265Cancelled Feb 1, 2023 · Built 1966 · Chelini David Joseph N39386Lake LA-4-200 · S/N 535Cancelled Jan 14, 2023 · Registration pending, canceled · Built 1972 N41LGBeech 77 · S/N WA-74Cancelled Dec 30, 2022 · Sale reported, canceled · Built 1979 N230RWCatalina Imaging JABIRU J230 · S/N 246Cancelled Jul 26, 2022 · Registration expired, pending cancellation · Built 2006 · N230rw LLC N65HHRockwell International NA-265-65 · S/N 465-1Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1981 · Yankee Dawdle LLC N111XZDJI INSPIRE 1 PRO · S/N W21ACL27011413Cancelled May 7, 2022 · Registration expired, pending cancellation · Padden Ian N28FGPartenavia P 68 OBSERVER · S/N 325-18-OBCancelled May 7, 2022 · Registration expired, pending cancellation · Built 1984 · State Of California Department Of Fish And Game N65326Quad City Ultralight CHALLENGER · S/N 040448Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2001 · Flying Panthers Flight School Inc N2663MHuckle Michael B PHOENIX · S/N 001Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1993 · Huckle Michael B N4396Glasflugel STANDARD LIBELLE · S/N 210Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1971 · Altstatt Daniel J N14915Ritner FALCONOR F-9 · S/N 4101Cancelled Oct 9, 2021 · Sale reported, canceled · Built 1975 N53484Cessna 337G · S/N 33701653Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Amthor G M N2966SCessna 150G · S/N 15066866Cancelled Jun 26, 2021 · Sale reported, canceled · Built 1967 N26WGCessna 177RG · S/N 177RG0894Cancelled May 6, 2021 · Exported to Russia · Built 1976 · Valenzuela A C Jr N2629RCessna 182K · S/N 18258329Cancelled May 4, 2021 · First renewal notice · Built 1967 · Sacramento Aero Club Inc N41743Funk B75L · S/N 225Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1946 · Flying Panthers Flight School Inc N41746Funk B75L · S/N 228Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1946 · Flying Panthers Flight School Inc N81109Mcclish FUNK B75L · S/N 239Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1946 · Flying Panthers Flight School Inc N89VFunk B85C · S/N 288Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1946 · Flying Panthers Flight School Inc N6812FCessna 150F · S/N 15063412Cancelled Oct 21, 2020 · Sale reported, canceled · Built 1966 N6347RPiper PA-28-140 · S/N 28-21517Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Mccabe Rebecca A N96801Taylorcraft BC12D-85 · S/N 9101Cancelled Sep 18, 2020 · Sale reported, canceled · Built 1946 N347WNBell UH-1V · S/N 73-22066Cancelled Mar 27, 2020 · Sale reported, canceled N706WFDJI Innovations INSPIRE 1 · S/N W130CB14020092Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Fallen Leaf Films LLC N2694APiper PA-22-135 · S/N 22-942Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Built 1953 · Obrien Shawn M N670XFDJI PHANTOM 3 PROFESSION · S/N P77DCG24010520Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Fusion Real Estate Network N750XWDJI Innovations PHANTOM 2 H3-3D · S/N PH645390020Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Westervelt Ecologigal Services N1652JPiper PA-28-140 · S/N 28-24046Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1967 N590XFSensefly EBEE RTK · S/N ER-02-21949Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Formation Enviromental LLC N8874MBeech A23 · S/N M-613Cancelled Sep 6, 2019 · Revoked, canceled · Built 1964 · Kinney Walter C N8738DPiper PA-22-160 · S/N 22-5920Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1958 · Equity Guarantee Company Inc N100VJDehavilland DH-100 MK 6 · S/N 611Cancelled Feb 7, 2019 · Registration expired, pending cancellation · Maitland Flying Svc N4817MBeech 95-B55 (T42A) · S/N TC-2147Cancelled Feb 2, 2019 · Built 1978 · Dick James & Associates Inc N2519KLuscombe 8A · S/N 5246Cancelled Jan 9, 2019 · Revoked, canceled · Built 1947 · Douke Wallace F N6874TCessna 310D · S/N 39174Cancelled Dec 17, 2018 · Registration expired, pending cancellation · Built 1960 · Capital Asset Recovery Inc N6610DCessna 172N · S/N 17272897Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1979 · Sac Aero Flying Club Inc N94565Cessna 152 · S/N 15285727Cancelled Jun 4, 2018 · Sale reported, canceled · Built 1983 N827CHCessna 150M · S/N 15076202Cancelled Jun 1, 2018 · Sale reported, canceled · Built 1974 N1084JAero Commander 112 · S/N 84Cancelled May 30, 2018 · Sale reported, canceled · Built 1973 N1753QCessna 150L · S/N 15073053Cancelled May 30, 2018 · Sale reported, canceled · Built 1971 N2392YCessna 177 · S/N 17700192Cancelled May 30, 2018 · Sale reported, canceled · Built 1967

Back to Sacramento, CA