Deregistered aircraft
383,637 cancelled U.S. registrations since the 1920s. A registration ends when the aircraft is exported, when it expires or is revoked, or at the owner’s request, and the FAA can then give the N-number to another aircraft. Enter an N-number to see every aircraft that carried it.
Cancellations per year
| 1920 | 1 |
|---|---|
| 1921 | 2 |
| 1923 | 3 |
| 1925 | 1 |
| 1926 | 1 |
| 1927 | 134 |
| 1928 | 373 |
| 1929 | 653 |
| 1930 | 1,300 |
| 1931 | 669 |
| 1932 | 706 |
| 1933 | 1,152 |
| 1934 | 673 |
| 1935 | 588 |
| 1936 | 548 |
| 1937 | 583 |
| 1938 | 512 |
| 1939 | 631 |
| 1940 | 678 |
| 1941 | 548 |
| 1942 | 344 |
| 1943 | 369 |
| 1944 | 144 |
| 1945 | 191 |
| 1946 | 332 |
| 1947 | 1,073 |
| 1948 | 4,300 |
| 1949 | 3,466 |
| 1950 | 1,805 |
| 1951 | 3,335 |
| 1952 | 1,315 |
| 1953 | 1,246 |
| 1954 | 1,630 |
| 1955 | 6,033 |
| 1956 | 3,704 |
| 1957 | 1,629 |
| 1958 | 1,436 |
| 1959 | 1,525 |
| 1960 | 2,334 |
| 1961 | 1,472 |
| 1962 | 1,159 |
| 1963 | 1,657 |
| 1964 | 2,195 |
| 1965 | 6,152 |
| 1966 | 672 |
| 1967 | 1,590 |
| 1968 | 1,889 |
| 1969 | 1,772 |
| 1970 | 7,584 |
| 1971 | 6,493 |
| 1972 | 3,388 |
| 1973 | 4,146 |
| 1974 | 5,041 |
| 1975 | 4,292 |
| 1976 | 4,419 |
| 1977 | 3,383 |
| 1978 | 2,289 |
| 1979 | 2,289 |
| 1980 | 3,237 |
| 1981 | 3,663 |
| 1982 | 2,960 |
| 1983 | 1,851 |
| 1984 | 1,495 |
| 1985 | 810 |
| 1986 | 352 |
| 1987 | 123 |
| 1988 | 3,604 |
| 1989 | 5,004 |
| 1990 | 3,758 |
| 1991 | 4,566 |
| 1992 | 3,278 |
| 1993 | 2,746 |
| 1994 | 3,019 |
| 1995 | 2,904 |
| 1996 | 2,604 |
| 1997 | 3,197 |
| 1998 | 2,992 |
| 1999 | 2,587 |
| 2000 | 2,973 |
| 2001 | 2,495 |
| 2002 | 2,849 |
| 2003 | 3,139 |
| 2004 | 3,396 |
| 2005 | 3,726 |
| 2006 | 4,102 |
| 2007 | 4,402 |
| 2008 | 4,836 |
| 2009 | 6,216 |
| 2010 | 4,763 |
| 2011 | 10,394 |
| 2012 | 18,597 |
| 2013 | 35,285 |
| 2014 | 10,638 |
| 2015 | 7,048 |
| 2016 | 3,875 |
| 2017 | 13,449 |
| 2018 | 19,476 |
| 2019 | 10,672 |
| 2020 | 7,052 |
| 2021 | 6,337 |
| 2022 | 6,830 |
| 2023 | 5,217 |
| 2024 | 4,183 |
| 2025 | 3,488 |
| 2026 | 3,057 |
The peak in 2011 to 2014 followed the FAA’s 2010 rule that every owner register again; registrations that weren’t renewed were cancelled.
Latest cancellations
Query with SQL
duckdb -csv -c "-- The latest 50; without the LIMIT, every cancelled registration
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.cancel_date IS NOT NULL
ORDER BY d.cancel_date DESC, d.deregistration_id
LIMIT 50"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.
-- The latest 50; without the LIMIT, every cancelled registration 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.cancel_date IS NOT NULL ORDER BY d.cancel_date DESC, d.deregistration_id LIMIT 50
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.
N222XWCessna 208B · S/N 208B0990N247PFSkydweller S L SOLAR IMPULSE SI2 · S/N 1N266RWRobinson Helicopter R66 · S/N 1205N288DSBeech 35-C33 · S/N CD-974N300ERBombardier BD-100-1A10 · S/N 20428N302TCBombardier CL-600-2D24 · S/N 15288N379GHHylio HYL-150 · S/N 17906110206N400SRBeech 95-B55 (T42A) · S/N TC-1970N60063Textron 208B · S/N 208B5962N673SMTextron 408 · S/N 408-0073N674SMTextron 408 · S/N 408-0074N7003CThrush S2R-T660 · S/N T660-197DCN70056Thrush S2R-T660 · S/N T660-196DCN919NXAirbus A321-231 · S/N 02919N1086Gulfstream Aerospace G-IV · S/N 1086N163ACDJI AGRAS T50 · S/N 1581F6BUB24690016TQ2N24587DJI AGRAS T100 · S/N 1581F8ZLC257E0024X2FN369LMMatteson Lynn C KITFOX IV-1200 · S/N ADU150N370LNCessna 500 · S/N 500-0101N548YBDJI AGRAS T50 · S/N 1581F6BUB2472001E739N550XTGteex Revolution INDEPENDENCE 19 · S/N 212985300C895N550ZAGteex Revolution INDEPENDENCE 19 · S/N 2129853006C44N551AGGteex Revolution INDEPENDENCE 19 · S/N 212985300678FN64472Cessna 172M · S/N 17265254N6570DJI AGRAS T40 · S/N 64TBKAF002006PN6723ACessna 172 · S/N 28823N6863ECessna 175A · S/N 56363N72GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 275N763FWSikorsky UH-60A · S/N 86-24514N77414Cessna 120 · S/N 11855N8333EMooney M20A · S/N 1511N8386RPiper PA-28-140 · S/N 28-22340N867ACGteex Revolution INDEPENDENCE 19 · S/N 212985300C6F3N905DBDJI AGRAS T40 · S/N 1581F574B2285001023XN303FTNimbus Aerospace NX-1 · S/N 00001N4212XAero Commander 100-180 · S/N 5212N458ACAirbus Industrie A320-232 · S/N 3332N6005DTextron 208B · S/N 208B5976N723SMTextron 208 · S/N 20800723N914ATBell Textron Canada 412EP · S/N 39143N919NKAirbus A320-271N · S/N 9272N102SEEmbraer ERJ 190-100 IGW · S/N 19000102N19070Cessna 150L · S/N 15074142N262DHCirrus Design SR22 · S/N 4213N294XPRaytheon Corporate Jets HAWKER 800XP · S/N 258294N309TACostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 429N322GKBeech F90 · S/N LA-64N371PHFairchild SA227-AC · S/N AC-576N387PHSwearingen SA227-AC · S/N AC-531N399WMRaytheon B200 · S/N BB-1747