Skip to content

Cancelled registrations · 173

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 = 'COSTA MESA' 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 = 'COSTA MESA'
  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 = 'COSTA MESA'
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.

N410DWinfield Doyle Edson EUROPA XS · S/N 147Cancelled Jul 27, 2026 · Exported to Mexico · Built 2011 · Edson Winfield Doyle N51BCChesnut Bruce J SR-25 · S/N 3273Cancelled Oct 19, 2024 · Sale reported, canceled · Built 1995 N195SJBell 206B · S/N 474Cancelled Jan 14, 2023 · Registration pending, canceled N800DCBeech D-50 · S/N DH-120Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1956 · Caffey Aviation LLC N26494Cessna 550 · S/N 550-0605Cancelled May 7, 2022 · Registration expired, pending cancellation · Built 1989 · Spirit Aviation Services Inc N97297Universal Stinson 108 · S/N 108-297Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1946 · Reinhardt Richard J N414RRCessna 414 · S/N 414-0364Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1972 · Spirit Aviation Services Inc N56PTGates Lear Jet 24D · S/N 276Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1973 · Maravia Sportfishing Inc N6985WPiper PA-28-140 · S/N 28-21183Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1965 · Orange Coast College N242TPCessna 210K · S/N 21059418Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1971 · Peppers Thomas F DBA N57164Fairchild M-62A · S/N T421546Cancelled Apr 10, 2020 · Revoked, canceled · Built 1942 · Josselson J N8264DBeech J35 · S/N D-5373Cancelled Nov 29, 2019 · Sale reported, canceled · Built 1957 N7412ZPiper PA-25-235 · S/N 25-3379Cancelled Aug 5, 2019 · Revoked, canceled · Built 1965 · Gebhart Robert H N123PHCessna 337E · S/N 33701269Cancelled Feb 12, 2019 · Built 1970 · Spirit Aviation Services Inc N336MACessna 550 · S/N 550-0036Cancelled Feb 12, 2019 · Built 1978 · Spirit Aviation Services Inc N7536ZPiper PA-25-235 · S/N 25-3581Cancelled Feb 9, 2019 · Revoked, canceled · Built 1965 · Gebhart Robert H N491RMCessna 401A · S/N 401A0044Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1969 · Mosier & Co Inc N2352FCessna 210E · S/N 21058552Cancelled May 21, 2018 · Revoked, canceled · Built 1964 · Smith Deanl L N72946Cessna 140 · S/N 10144Cancelled May 18, 2018 · Revoked, canceled · Built 1946 · Rose Eston A N4861FPiper PA-28-181 · S/N 28-7790068Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1976 · Barclay Christopher R Trustee N486KGCessna 310 · S/N 35176Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1955 · Orange Coast College Foundation N2022VCessna 120 · S/N 14233Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1947 · Templeton Joe R N2177Gilshelton B-8M · S/N GS-1Cancelled Oct 28, 2017 · Revoked, canceled · Built 1968 · Shelton Gilbert N4033ARobinson Helicopter R44 II · S/N 14128Cancelled Oct 12, 2017 · Exported to China · Helistream Inc N4030FRobinson Helicopter R44 II · S/N 14111Cancelled Sep 22, 2017 · Exported to China · Helistream Inc N4030TRobinson Helicopter R44 II · S/N 14115Cancelled Sep 22, 2017 · Exported to China · Helistream Inc N4029RRobinson Helicopter R44 II · S/N 14110Cancelled Sep 14, 2017 · Exported to China · Helistream Inc N4026PRobinson Helicopter R44 II · S/N 14100Cancelled Sep 1, 2017 · Exported to China · Helistream Inc N188SDEurocopter France AS350B2 · S/N 3859Cancelled Aug 3, 2017 · Exported to New Zealand · Built 2004 · County Of Orange Sheriff Coroner Dept N2061WNorth American T-28B · S/N 53-138135Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Drew Rodney J N7051FRobinson Helicopter R44 II · S/N 14085Cancelled Jun 29, 2017 · Exported to China N2215FCessna 310L · S/N 310L-0015Cancelled Feb 9, 2017 · Sale reported · Built 1966 N64VABell 206L-3 · S/N 51054Cancelled Feb 7, 2017 · Exported to New Zealand · Built 1983 · Helimart64va LLC N7028CRobinson Helicopter R44 II · S/N 13928Cancelled Feb 5, 2016 · Exported to China N7059FRobinson Helicopter R44 II · S/N 13929Cancelled Feb 5, 2016 · Exported to China N87DRBeech 65-B80 · S/N LD-414Cancelled May 14, 2015 · Sale reported, canceled · Built 1969 N9000WPiper PA-28-235 · S/N 28-10491Cancelled May 14, 2015 · Sale reported, canceled · Built 1964 N828VPVan Patten D R/Van Patten E C VANS RV-8 · S/N 81572Cancelled May 11, 2015 · Sale reported, canceled N4341QSikorsky HH-52A · S/N 1388Cancelled May 6, 2015 · Registration expired, pending cancellation · Coast Community College District N393QCessna 210D · S/N 21058439Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1964 · Grgurich William F N98USPiccard AX-6 · S/N 698Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1974 · Powel Nancy R N711MWWintle-Mcnitt KR-2 · S/N DJ-1Cancelled Dec 2, 2014 · Revoked, canceled · Wintle David T N986APiper PA-22 · S/N 22-298Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1951 · Loveless Howard D N9034APeabody Laurence SOLAR-6-10 · S/N EI-ATMCancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1979 · Peabody Lawrence D N5RNEiriavion PIK 20B · S/N 20148CCancelled Oct 14, 2014 · Registration expired, pending cancellation · Dabott Christopher G N44126Piper PA-28-151 · S/N 28-7415586Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1974 · Hanratty Brian J N675BBeech A35 · S/N D-1676Cancelled Oct 6, 2014 · Third renewal notice · Built 1948 · Herndon Alfred N28528Fairchild 24R-40 · S/N R-40-420Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1940 · Wintle David T N3779JCessna 150G · S/N 15065079Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Orange Coast College N1051NDouglas DC3C · S/N 13887Cancelled Sep 8, 2014 · Registration expired, pending cancellation · Built 1944 · Sea Star Pacific

Back to Costa Mesa, CA