Skip to content

Cancelled registrations · 287

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

N819NLasley LASLEY SPORT · S/N 1Cancelled Sep 3, 2013 · Revoked, canceled · Built 1968 · James A Lasiey N3128Rohmann NON-EUCLIDEAN SPECIA · S/N R-2Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1970 · Hardin Clyde W N503FSMonroe Mark SPYDER · S/N 800Cancelled Aug 8, 2013 · Sale reported, canceled N5357ZPiper PA-22-108 · S/N 22-9083Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1961 N4892BCessna 310 · S/N 35192Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1955 N2529APiper PA-38-112 · S/N 38-78A0732Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1956 · Proctor Keith W N7873CJohnson-Stits SA-7D · S/N P-381Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1965 N19116Cessna 150L · S/N 15074181Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1972 N7579RPiper PA-28-140 · S/N 28-22146Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1966 · Crettol Alicia N790VFleet 7 DELUXE · S/N 372Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1930 · Sheehan Michael F N57RABell 47G-5 · S/N 25006Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1970 · Orco Aviation Inc DBA N714ZSCessna 152 · S/N 15279567Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1977 · Bundesman Marion E N3407PPiper PA-23-160 · S/N 23-1371Cancelled Jun 12, 2013 · Sale reported, canceled · Built 1958 N888RRCessna 402B · S/N 402B1001Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Western States Aviation Inc N1610EAeronca 7AC · S/N 7AC-5175Cancelled Jun 10, 2013 · Registration pending, canceled · Built 1946 N4254CDavis Morris C KR-1 · S/N MCD-1Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Davis Morris C N9157VStinson 108-3 · S/N 108-4107Cancelled Jun 5, 2013 · Sale reported, canceled N3757JAero Commander 520 · S/N 520-131Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1954 · Western States Aviation Inc N9331SBeech C23 · S/N M-1641Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1975 · Brannigan John Michael N9026RRobinson Helicopter R22 · S/N 0022Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1993 · Raincross Helicopters Ltd N86143Peeters TAILWIND A-1 · S/N 102Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1976 · Gammill Travis G N838KSSchleicher ASW-20 · S/N 20599Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1982 · Snedden Jerald R N3129Stits Flut-R-Bug SA6B · S/N 99583Cancelled May 9, 2013 · Sale reported, canceled · Built 1969 N78BWWilson-Ben KR-2 · S/N 2750Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1980 · Wilson Ben J N17999Burkhart Grob Flugzeugbau G102 ASTIR CS · S/N 5558SCancelled May 6, 2013 · Registration expired, pending cancellation · Harris Robert R N6591FCessna 150F · S/N 15063191Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1966 · Russum Roy A N6619NCessna T210N · S/N 21063123Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1978 · Hackbarth Edward E N6376WPiper PA-28-140 · S/N 28-20439Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1964 · Wilcox Gary N6086Cessna 310 · S/N 58-2137Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1958 · Adair Edward A N33602Sikorsky S-58ET · S/N 58-727Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1974 · Heli Flite Inc N2222MCessna 310G · S/N 310G0003Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1961 · Morrow John M N812BWCessna 402A · S/N 402A0086Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1969 N597BBeech A35 · S/N D-1618Cancelled Mar 26, 2013 · Revoked, canceled · Built 1948 · Grieve Floyd G N90DSSauser Donald J QC · S/N 1Cancelled Mar 26, 2013 · Sale reported, canceled · Built 1997 N84RRMiller Johnie AMERICAN EAGLET · S/N 0084Cancelled Mar 25, 2013 · Sale reported, canceled N9874YChampion 7FC · S/N 7FC-431Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1961 N8017FCessna 150F · S/N 15064117Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1966 N71517Luscombe 8A · S/N 2944Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1946 N99947Ercoupe 415-C · S/N 2570Cancelled Jan 3, 2013 · Sale reported, pending cancellation · Built 1946 N357MBPiper PA-23-250 · S/N 27-4508Cancelled Dec 12, 2012 · Exported to Mexico · Built 1970 · Wholesale Aircraft Sales N45894Sherman-Hambleton PIETENPOL AIR CAMPER · S/N 7777Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Sherman Paul E N45NEAero Commander 560-E · S/N 877Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1960 · M And C Enterprises N4220PPiper PA-23-160 · S/N 23-1714Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1959 · Moretti Aviation N989XXFurukawa Keiichi DSA-1 MINI PLANE · S/N 2601Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Furukawa Keiichi N21USPiccard AX-6 · S/N 621Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1971 · Colver Matthew R N3597WPiper PA-32-260 · S/N 32-494Cancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1966 · Flannagan Edward W N37213Interstate S-1A · S/N 56Cancelled Sep 20, 2012 · Sale reported, canceled · Built 1941 N94386Cessna 182Q · S/N 18266422Cancelled Sep 12, 2012 · Revoked, canceled · Built 1978 · Steinhoefel Rudy M N316KWAero Commander 680FL · S/N 1753146Cancelled Sep 11, 2012 · Third renewal notice · Built 1968 · Petrikas Christopher J N104VPAlvarez Richard EVANS VP-1 · S/N 2144Cancelled Sep 10, 2012 · Built 1995 · Alvarez Richard A

Back to Riverside, CA