Skip to content

Cancelled registrations · 266

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 = 'SANTA ANA' 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 = 'SANTA ANA'
  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 = 'SANTA ANA'
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.

N7773DRobinson Helicopter R44 · S/N 1397Cancelled Jun 29, 2024 · Registration pending, canceled · Built 2004 N9155HRotz Lynn E RAF 2000 GTX SE · S/N H2-95-6-165Cancelled Feb 3, 2024 · Registration pending, canceled N731LYCessna P210N · S/N P21000491Cancelled Jan 20, 2024 · Registration pending, canceled N574BPCessna 560 · S/N 560-0022Cancelled Nov 14, 2023 · Built 1989 · Agave Air LLC N18DWWilliams David T DYKE DELTA JD-2 · S/N 1093Cancelled Feb 9, 2023 · Sale reported, canceled · Built 1972 N447FTCanadair CL-44D4 · S/N 16Cancelled Jul 6, 2022 · Jordan Harlan Wayne N3375CBuschmann Robert E HELICYCLE · S/N 26Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Tran Nghia H N67546Fairchild M-62A · S/N FT777Cancelled Jul 27, 2021 · Revoked, canceled · Built 1943 · Hollywood Air Shows N67560Fairchild M-62A-3 · S/N FT-684Cancelled Jul 27, 2021 · Revoked, canceled · Built 1943 · Armstrong George N875GVVesely Gregory J EXEC 162 F · S/N 6279Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 2003 · Tran Nghia Huu N9103HCessna 172M · S/N 17265946Cancelled May 8, 2021 · Registration expired, pending cancellation · Collins George M N5VRCessna 414A · S/N 414A0603Cancelled Mar 30, 2021 · Exported to Mexico · Built 1980 · Oc Aircraft Sales Inc N717CNHughes 269C · S/N S1206Cancelled Mar 27, 2021 · Registration pending, canceled · Built 1985 N87297Cessna 310R · S/N 310R0506Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1975 · Twin Props 87297 LLC N6417HPiper J3C-65 · S/N 19594Cancelled Apr 3, 2020 · Revoked, canceled · Built 1946 · Wardlow Floyd N5761ECessna 150 · S/N 17261Cancelled Dec 20, 2019 · Revoked, canceled · Built 1959 · Holcombe Willard G N4398GMartinez Barbaro NORTHWING APACHE · S/N BMNA-001Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Martinez Barbaro N6968CBeech AT-11 · S/N 42-37158Cancelled Oct 11, 2019 · Revoked, canceled · Built 1957 · Oka Ted N54ADDJI PHANTOM 3 PROFESSION · S/N P76DCI24A2724Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Allied Drones LLC N301ADAllied Drones HV44B · S/N ADHV44 2 0001Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Allied Drones LLC N36162Taylorcraft BC12-65 · S/N 3141Cancelled Aug 29, 2019 · Revoked, canceled · Built 1941 · Mcmahan Mary Sue N67218Consolidated Vultee BT-13 · S/N 1661Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1941 · Alexander C H N1390CDJI PHANTOM 2 VISION + · S/N BG270948224371Cancelled Jan 9, 2019 · Registration expired, pending cancellation · County Of Orange N78201Globe GC-1B · S/N 2201Cancelled Oct 1, 2018 · Revoked, canceled · Built 1946 · Gill Jack A Jr N32163Waco UPF-7 · S/N 5795Cancelled Jul 19, 2018 · Revoked, pending cancellation · Built 1941 · Zacharias Eugene F N5836QMooney M20C · S/N 3127Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1965 · Orellana Jesse A N2799LCessna 172H · S/N 17255999Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Gutierrez Maria A N6814FCessna 150F · S/N 15063414Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1966 · Namdar Mamood N41DWBeech A35 · S/N D-1972Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1949 · Susag Richard N76283Cessna 140 · S/N 10691Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Canyon Flg Club Inc N9081EAeronca 11AC · S/N 11AC713Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Denton Allan N3739NBeech 35 · S/N D-949Cancelled Nov 18, 2017 · Revoked, canceled · Built 1947 · Ferry Charles N N22118Cessna 150H · S/N 15068071Cancelled Oct 28, 2017 · Revoked, canceled · Built 1967 · Patton Garth E N3218CBeech E35 · S/N D-3882Cancelled Jul 28, 2017 · Built 1954 · Blake John R N2432TDalke C Arthur QUICKIE-2 · S/N 2242-001Cancelled Apr 14, 2017 · Registration expired, pending cancellation · Built 1986 · Nomady Mark D N704TCCessna 150M · S/N 15078852Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1976 · Gehringer Walter S N20GSCessna 421 · S/N 421-0148Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1968 · Aviation Investment Enterprises Inc N74129Semco Balloon 30-AL · S/N SEM-2Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Semich Mark Miles N74351Bellanca 14-13-2 · S/N 1464Cancelled Feb 4, 2017 · Revoked, canceled · Built 1947 · Clark David H N77896Luscombe 8A · S/N 3623Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Fritzie Edward J N8834PPiper PA-24-260 · S/N 24-4290Cancelled Jun 21, 2016 · Exported to Canada · Built 1965 N828HKKellermann/Stits SA-11A PLAYMATE · S/N 55Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1970 · Costa Walter F N700RAAero Commander 680FP · S/N 1282128Cancelled May 12, 2015 · Registration expired, pending cancellation · Mcbride Leonard H N714EKCessna 150M · S/N 15079118Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1976 · Rafc Inc N3983Volksplane WE-1 · S/N 1001Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1974 · Dennis William Van N8181FCessna 150F · S/N 15064281Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1966 · Profab Inc.N43AAMoynagh Russell J 3/4 SCALE P-40 · S/N MJ-12-001Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Moynagh Russell J N8539Tallman NIEUPORT C-1-28 · S/N 7171-2-19Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Tallmantz Avn Inc N8457YPiper PA-30 · S/N 30-1616Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1967 · Janke Roger R N8072ECessna 172N · S/N 17272128Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1978 · Clark Norman D

Back to Santa Ana, CA