Skip to content

Cancelled registrations · 443

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

N19874Cessna 172M · S/N 17260825Cancelled Oct 28, 2023 · Revoked, canceled · J And M Aviation N9577CDouglas DC3 · S/N 13321Cancelled Aug 22, 2023 · Revoked, pending cancellation · United States Navy Department Of National Defense N751PWDJI FLAMEWHEEL F550 · S/N 958265104022Cancelled Apr 6, 2023 · Registration expired, pending cancellation · West Coast Aerials LLC N2581ZBalloon Works FIREFLY 8 · S/N F8-409Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1994 · Brinkerhoff Bruce E N751WADJI S900 · S/N 958265110801Cancelled Oct 1, 2022 · Registration expired, pending cancellation · West Coast Aerials LLC N596FSDJI S1000 PREMIUM · S/N 958265110122Cancelled Jul 2, 2022 · Registration expired, pending cancellation · West Coast Aerials LLC N6675WDJI S1000 PREMIUM · S/N BF272055248340Cancelled Jul 2, 2022 · Registration expired, pending cancellation · West Coast Aerials LLC N858TJDJI MAVIC PRO · S/N 08QCE6501201YSCancelled Jul 2, 2022 · Registration expired, pending cancellation · Rodriguez Alex J N640JSFoxtech Hobby KRAKEN 130 · S/N NADVC1Cancelled Apr 2, 2022 · Registration expired, pending cancellation · West Coast Aerials LLC N558WCDJI Innovations PHANTOM 2 VISION + · S/N PH645208853Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Larsen Erick F N345JMccord Robert W EAA BIPLANE P1 · S/N 123Cancelled Jan 13, 2020 · First renewal notice · Built 1981 · Hood Charles L N988BWDJI INSPIRE 1 PRO · S/N W21AC16010563Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Black Widow Aerial Inc N2874UCessna 172D · S/N 17250474Cancelled Nov 22, 2019 · Revoked, canceled · Built 1963 · Munari Geno N9286EAeronca 11AC · S/N 11AC923Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Edgar James D N639GKFreefly Systems ALTA · S/N 88690Cancelled May 3, 2019 · Registration expired, pending cancellation · Kocsis Josef F N789VPFreefly Systems ALTA · S/N VP-ALTA-01Cancelled Mar 14, 2019 · Registration expired, pending cancellation · Petersen Joel N572VPAerial Pixels FX8 ELITE PRO · S/N VP-FX8EP-01Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Petersen Joel S N420VPDJI S900 · S/N VP-S900-01Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Petersen Joel N249VPDJI S1000 · S/N VP-S1000-01Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Petersen Joel S N315NAAerospatiale SA315B · S/N 2506Cancelled Oct 25, 2018 · Exported to Ecuador · Built 1978 · Towards 2000 Inc N67811Fairchild M-62A · S/N FT624Cancelled Aug 28, 2018 · Revoked, canceled · Novice 26 Flying Club N3061GAircoupe F-1A · S/N 5764Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1961 · Moore Lowell B N75314Consolidated Vultee BT-13A · S/N 11295Cancelled Apr 6, 2018 · Revoked, canceled · Built 1943 · Soller Roger H N562LCDJI PHANTOM 2 VISION + · S/N PH645267552Cancelled Mar 27, 2018 · First renewal notice · Child David W N706DCDJI PHANTOM 3 PROFESSION · S/N 03Z0137433Cancelled Mar 27, 2018 · Child David W N8480XCessna 172C · S/N 17248980Cancelled Mar 1, 2018 · Revoked, pending cancellation · Built 1961 · Mooney Flyers Inc N101WJEmbraer EMB-110P1 · S/N 110203Cancelled Feb 23, 2018 · Registration pending, pending cancellation · Built 1978 N4712Quicksilver MXL SPORT · S/N M5161347Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 2001 · Chicco Miguel E N565MLDJI S1000+ · S/N BK180342257162Cancelled Feb 7, 2018 · First renewal notice · Child David W N55444Noorduyn UC-64AS · S/N 140Cancelled Nov 21, 2017 · Revoked, canceled · Built 1943 · Fleetway Inc N61828Noorduyn UC-64A · S/N 509Cancelled Nov 21, 2017 · Revoked, canceled · Built 1944 · Fleetway Inc N62861Consolidated Vultee BT-13A · S/N 11421Cancelled Nov 21, 2017 · Revoked, canceled · Built 1943 · Mantz Paul Air Svc N5289CBeech B35 · S/N D-2588Cancelled Nov 20, 2017 · Revoked, canceled · Built 1950 · Fleetway Inc N53281Fairchild M-62A · S/N T-42-1745Cancelled Nov 20, 2017 · Revoked, canceled · Built 1942 · Boudreau Ernest E N272BPMcdonnell Douglas Helicopter 500N · S/N LN040Cancelled Sep 18, 2017 · Exported to New Zealand · Built 1992 · City Of Burbank N192KCRobinson Helicopter R22 BETA · S/N 1987Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1991 · Complete Aviation Services Inc N4466EPiper PA-38-112 · S/N 38-78A0617Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1978 · Cobbs Adam N2092PWalker Dan RAND ROBINSON KR-2 · S/N 7231Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 2009 · Rohwer Donald G N761UWCessna T210M · S/N 21062538Cancelled Feb 4, 2017 · Revoked, canceled · Built 1978 · Sky Roamers Air Travel Inc N88937Douglas DC-4 · S/N 18337Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Liberty Air Inc N200VTCessna 550 · S/N 550-0083Cancelled Oct 28, 2015 · Exported to Venezuela · Built 1980 · Van Nuys Skyways Inc N22YFLockheed YF-22A · S/N 3997Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1990 · Lockheed Corporation N22YXLockheed YF-22A · S/N 3998Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1990 · Lockheed Corporation N9343CPiper PA-28R-201T · S/N 28R-7803254Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1978 · Higgins Melvin W N11GBCessna 152 · S/N 15281855Cancelled Dec 30, 2014 · Exported to Sri Lanka · Built 1978 · Brogan George A N5209ACessna 310 · S/N 35409Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1956 · Hannam John D N2570Challenger CHALLENGER I · S/N 001Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1992 · Chicco Francesco A N1478CCessna 177B · S/N 17702734Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1977 · Coats Robert L N68177Noorduyn UC-64 · S/N 419Cancelled Oct 23, 2013 · Revoked, canceled · Built 1944 · Fleetway Inc N558TBeech 95-55 · S/N TC-92Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1961 · Aviation Unlimited

Back to Burbank, CA