Skip to content

Cancelled registrations · 761

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

N605BEBombardier CL-600-2B16 · S/N 5821Cancelled Oct 25, 2022 · Exported to San Marino · Built 2009 · N605be LLC N835FTPyka P-4006 · S/N 6903Cancelled May 8, 2021 · Registration expired, pending cancellation · Pyka Inc N41FYPiper PA-30 · S/N 30-924Cancelled Oct 29, 2020 · Registration expired, pending cancellation · Built 1965 · Dahlbacka Glen H N68252Boeing N2S-3 · S/N 75-7649Cancelled May 5, 2020 · Revoked, pending cancellation · Built 1942 · Moebus William H N22496Aeronca 65-C · S/N C4449Cancelled Apr 3, 2020 · Revoked, canceled · Built 1939 · Robertson Earl A N48618Aeronca 0-58B · S/N O58B5392Cancelled Sep 20, 2019 · Revoked, canceled · Built 1942 · Rolando Michael A N49029Taylorcraft DC-65 · S/N L5428Cancelled Sep 6, 2019 · Revoked, canceled · Built 1945 · Griffin Arthur N561THDJI PHANTOM 3 PROFESSION · S/N P76DCJ13A20750Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Harris Tywain D N6421PCessna P210N · S/N P21000179Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1978 · Paisin Marc David N352TMDJI PHANTOM 3 PROFESSION · S/N P76DCH12010669Cancelled May 7, 2019 · Registration expired, pending cancellation · Alameda County Sheriffs Office N94XRWelter Lawrence H GLASAIR · S/N 595Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1990 · Oakland Aviation Museum N86040Aeronca 11AC · S/N 11AC462Cancelled Apr 12, 2019 · Revoked, canceled · Built 1946 · Mackie L H N29SJCessna M337B · S/N 337M0318Cancelled Jan 29, 2019 · Registration expired, pending cancellation · Oakland Aviation Museum N205ACAircover Integrated Solutions QR425 · S/N 0116-1Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Alameda County Sheriffs Office N3926VCessna 170 · S/N 18236Cancelled Jan 15, 2019 · Revoked, canceled · Built 1948 · George Harry F Jr N705HQAlameda County Sheriffs Office AIR COVER QR425 · S/N 0117-1Cancelled Jan 10, 2019 · Registration expired, pending cancellation · Alameda County Sheriffs Office N97HKWing-Chiu Thomas Lee SKSTR KFX VIXEN SER5 · S/N V9609-0048Cancelled Sep 14, 2018 · Registration expired, pending cancellation · Built 1999 · Oakland Aviation Museum N47754Taylorcraft DC-65 · S/N 6234Cancelled Aug 28, 2018 · Revoked, canceled · Built 1942 · Hodges Roy A N8120QCessna 414 · S/N 414-0020Cancelled Aug 2, 2018 · Revoked, canceled · Built 1969 · Hurd Irving J N4680VCurtiss Wright C-46A · S/N 26773Cancelled Jul 19, 2018 · Revoked, canceled · Built 1942 · Transocean Air Lines N687KRDJI PHANTOM 3 PROFESSION · S/N P76DCG14013453Cancelled May 31, 2018 · Sale reported, canceled N50289Fairchild M-62A · S/N T435351Cancelled May 18, 2018 · Revoked, canceled · Built 1943 · Doutt John T N2758EChampion AERONCA 7AC · S/N 7AC-6338Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1946 · Oakland Aviation Museum N464BBBierman Benjamin Bruce 1600R EROS · S/N MK703Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 2004 · Oakland Aviation Museum N2703ADouglas DC3 · S/N 33570Cancelled Mar 23, 2018 · Revoked, canceled · Built 1954 · Transocean Air Lines N3155NCessna 120 · S/N 13413Cancelled Mar 23, 2018 · Revoked, canceled · Built 1947 · Transocean Air Lines N72SAPiper PA-28-140 · S/N 28-7125612Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Safadirazieli Sandra Administrator N67528Cessna 152 · S/N 15281893Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1978 · Everett Norris N DBA N757SKCessna 152 · S/N 15279966Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1977 · Everett Norris N DBA N66291Beech 76 · S/N ME-224Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1979 · Everett Norris N DBA N46861Cessna 152 · S/N 15283123Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1979 · Everett Norris N DBA N4014LRaven Industries RALLY RX7 · S/N RX7-276Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1982 · Balloon Excelsior N51586Cessna 172P · S/N 17274325Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1980 · Everett Norris N DBA N2332HErcoupe 415-D · S/N 2957Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1946 · Blackseth Kim Robert N1096MCessna 172L · S/N 17259496Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1971 · Flightwatch USA LLC N26437Stinson 10A · S/N 7625Cancelled Nov 22, 2017 · Revoked, canceled · Built 1940 · Pell Donald O N8744DPiper PA-22-160 · S/N 22-5926Cancelled Nov 21, 2017 · Revoked, canceled · Built 1958 · Transocean Air Lines N5087MTaylorcraft BC12-D · S/N 10387Cancelled Nov 18, 2017 · Revoked, canceled · Built 1946 · Hammond Richard J N2172HEngineering & Research ERCOUPE 415-C · S/N 2795Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Built 1994 · Oakland Aviation Museum N3006TCessna 320C · S/N 320C0006Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1964 · Data Support Co N23SHBabcock James W SPARROW HAWK · S/N 860106Cancelled Sep 7, 2017 · Registration expired, pending cancellation · Built 1988 · Oakland Aviation Museum N3734TPiper PA-28R-180 · S/N 28R-30042Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1967 · Sierra Academy Of Aeronautics Technical Institute N8135UCessna 150M · S/N 15077898Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1976 · I S B A Inc N43VCessna 310B · S/N 35699Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1958 · Peralta Community College District N55576Raven Industries RALLY RX7 · S/N RX7-134Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1979 · Stockwell Brent Emery N9492XCessna 210A · S/N 21057792Cancelled Feb 13, 2017 · Revoked, canceled · Built 1961 · Ogle Chas C N68804Boeing A75N1(PT17) · S/N 75-6948Cancelled Feb 4, 2017 · Revoked, canceled · King Charles H N718XBeech 95-B55 (T42A) · S/N TC-665Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Albertelli Joseph E Jr N7314LCessna A152 · S/N A1520784Cancelled Feb 4, 2017 · Revoked, canceled · Built 1978 · Ernst James F N7466YPiper PA-30 · S/N 30-529Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Comstock Aviation Inc

Back to Oakland, CA