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.

N311DRSportaire 2 · S/N TT-1Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1959 · Rogers David M N8292CPiper PA-22-135 · S/N 22-2357Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1954 · Marshall Michel N22022Luscombe 8A · S/N 872Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1938 · Bunke Carl R N3033YCessna 182E · S/N 18254033Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1962 · Mccorkle David E N997SLBell OH-58A · S/N 72-21354Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Riverside County Sheriffs Department N3283QCessna 402 · S/N 402-0083Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1967 · Davis Douglas Roy DBA N8908CPiper PA-22-135 · S/N 22-1504Cancelled Nov 21, 2017 · Revoked, canceled · Built 1953 · Gargano Joseph L N9461TCessna 210 · S/N 57261Cancelled Nov 21, 2017 · Revoked, canceled · Built 1960 · Capri Enterprises N9704HConsolidated Vultee SNV-1 · S/N 6884Cancelled Nov 21, 2017 · Revoked, canceled · Built 1942 · Brown Lawrence J N1878KLuscombe 8E · S/N 4605Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1947 · Thomas W Wathen Foundation N827QKRobinson Helicopter R44 · S/N 1718Cancelled Oct 23, 2017 · Exported to China · California Aviation Services Inc N146PDRobinson Helicopter R44 II · S/N 10739Cancelled Sep 25, 2017 · Exported to China · Built 2005 · California Aviation Services Inc N352PHarlan John D PELICAN PL · S/N 526Cancelled Sep 11, 2017 · Exported to Czech Republic · Built 2010 · Harlan John D N70280Davis Morris C N3-PUP · S/N D 101Cancelled Sep 7, 2017 · Registration expired, pending cancellation · Davis Morris C N4097ARaven S-60A · S/N S60A-190Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1982 · Marsh Clyde S N52VYYakovlev YAK 52 · S/N 855608Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1985 · Gauthier Joseph M N4167XAero Commander 100 · S/N 346Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1969 · Adair Edward A N62652Cessna 172P · S/N 17275319Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1981 · Lubak Lawrence E N13933Fleet 7 · S/N 326Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1930 · Sheehan Michael F N3SEAerotechnik L-13 SEH VIVAT · S/N 900330Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Bunke Rodney G N8280JRobinson Helicopter R22 BETA · S/N 0892Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1988 · California Aviation Services Inc N9621YBeech 95-A55 · S/N TC-376Cancelled Feb 13, 2017 · Revoked, canceled · Built 1963 · California Aero Sales Inc N7753SSchweizer SGS 1-26D · S/N 453Cancelled Feb 4, 2017 · Revoked, canceled · Built 1969 · Karno Robert E N9134TBeech B23 · S/N M-1152Cancelled Feb 4, 2017 · Revoked, canceled · Built 1969 · Friendship Flight Club N5454UBeech 35-C33 · S/N CD-1102Cancelled Sep 14, 2016 · Sale reported, canceled · Built 1967 N6208SCessna TR182 · S/N R18201651Cancelled Aug 5, 2016 · Exported to Chile · Riverside Air Service Inc N5303RCessna 172F · S/N 17252824Cancelled Jun 6, 2016 · Built 1965 · Phillips Roberta L N75783Luscombe 8A · S/N 4330Cancelled May 20, 2015 · Registration pending, canceled · Built 1946 N3865DBeech 77 · S/N WA-252Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1981 · Riverside Air Service N206HREverhart Howard R MINI-500 HELICOPTER · S/N 206Cancelled May 13, 2015 · Registration expired, pending cancellation · Everhart Howard R N72644Cessna 140 · S/N 9820Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1946 · Bunke Carl R N74315Bellanca 14-13-2 · S/N 1428Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1947 · Marquart Edwin E N47873Taylorcraft DCO-65 · S/N 5285Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1943 · Tomsett Richard N II N5022GWelch Bryan T QUICKIE · S/N 059Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1980 · Baginski John P N3646EAeronca 7AC · S/N 7AC-6966Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1947 · Bunke Rodney G N1413RGrumman American Avn. AA-1B · S/N AA1B-0513Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1974 · Marshall Robert E N699CLockheed 18-56 · S/N 2354Cancelled Sep 3, 2014 · Revoked, canceled · Built 1943 · Byrd Edwin L N6875CPiper PA-34-200T · S/N 34-7870165Cancelled Jul 23, 2014 · Exported to Mexico · Built 1978 · Riverside Air Service Inc N7086ERobinson Helicopter R44 II · S/N 13609Cancelled Apr 8, 2014 · Exported to China · California Aviation Services Inc N3187KRobinson Helicopter R44 II · S/N 11561Cancelled Dec 17, 2013 · Exported to China · Built 2006 · California Aviation Services Inc N70400Robinson Helicopter R44 II · S/N 13557Cancelled Dec 17, 2013 · Exported to China · Built 2013 · California Aviation Services Inc N70774Robinson Helicopter R44 II · S/N 13564Cancelled Dec 17, 2013 · Exported to China · California Aviation Services Inc N5528YPiper PA-23-250 · S/N 27-2626Cancelled Nov 14, 2013 · Registration expired, pending cancellation · Built 1964 · Petrikas Christopher J N330FCClark James A ROTORWAY EXEC 90 · S/N 5245Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Everhart Howard R N94LVLopez Elias V VARI-EZE · S/N 1Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Lopez Elias N4070HRobinson Helicopter R22 BETA · S/N 1727Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1991 · Mendoza Akira N45891Sherman BABY ACE D · S/N 777Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1980 · Sherman Paul E N4071GRobinson Helicopter R22 BETA · S/N 1833Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1991 · Mendoza Akira N99996Mooney M20K · S/N 25-0614Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1981 · Sdb Aviation N2149Hoops SP-1 · S/N 1Cancelled Sep 10, 2013 · Registration expired, pending cancellation · Built 1978 · Wiles Frederick M

Back to Riverside, CA