Skip to content

Cancelled registrations · 122

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

N2677VCessna 170 · S/N 18187Cancelled Apr 11, 2025 · Built 1948 · Constatine Lucas L N7374NCessna 182P · S/N 18263157Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Felix Jose Manuel N1592EAeronca 7AC · S/N 7AC5157Cancelled May 15, 2020 · Revoked, canceled · Built 1946 · Seafair Boat Company N68248Fairchild PT-26 · S/N T424348Cancelled May 5, 2020 · Revoked, pending cancellation · Built 1943 · Eaton D C N31874Aeronca 65-TL · S/N 9131TCancelled Dec 2, 2019 · Revoked, canceled · Built 1941 · Ericksen R G N9825BBellanca 14-19-2 · S/N 4077Cancelled Sep 6, 2019 · Revoked, canceled · Built 1958 · Miner Doris N8448LBensen B-8M · S/N D.P.1Cancelled Jul 19, 2018 · Revoked, canceled · Built 1968 · Drumpus John Jr N94358Engineering & Research 415-C · S/N 1581Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Lamprecht E R N88229Piper J3C-65 · S/N 15846Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Sorensen Herbert N89490Cessna 120 · S/N 8522Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Davidson Donald N95PTerrill Special 100 · S/N HLT-100Cancelled Nov 21, 2017 · Revoked, canceled · Built 1957 · Cox Gerald A N6895BCessna 210M · S/N 21062851Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1978 · Smith Antonio M N6876CWinslow-Bensen GYRO-COPTER · S/N WB-1Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Winslow Henry E N81VStits Playboy SA3A · S/N P001Cancelled Feb 4, 2017 · Revoked, canceled · Built 1956 · Onofrey Paul Albert N5102ACessna 172 · S/N 28102Cancelled Dec 22, 2014 · Revoked, canceled · Built 1955 · Sahm Roland R N16MWWard Mahlon L WARD SPECIAL · S/N 101Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Ward Mahlon L N5672DRaven Industries RX6 · S/N RX6-300Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1978 · Hardy James Ray N2336FCessna 210E · S/N 21058536Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1964 · Trans Atlantic Charter Service Inc N5166VBell 47D1 · S/N 264Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Northrop Institute Of Technology N8211ENorth American SNJ-5 · S/N 52020Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1958 N2734PPiper PA-22-150 · S/N 22-3041Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1955 N8359PPiper PA-24-250 · S/N 24-3616Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1964 · Gatling Coley N222WStinson 108-1 · S/N 108-1008Cancelled Nov 1, 2012 · First renewal notice · Built 1946 · Kolerich Tony D N3779CFairchild 24W-40 · S/N 171Cancelled Sep 20, 2012 · Sale reported, canceled · Built 1940 N57342Timm N2T-1 · S/N 270Cancelled Aug 27, 2012 · Revoked, canceled · Built 1943 · Frame William C N54304Cessna T-50 · S/N 2657Cancelled Aug 22, 2012 · Revoked, canceled · Built 1943 · Roberts Bert S N5184BBell 47J · S/N 1719Cancelled Aug 13, 2012 · Revoked, canceled · Santa Monica Chrysler Plymouth Inc N4546DBeech G35 · S/N D-4676Cancelled Jul 19, 2012 · Revoked, canceled · Built 1956 · Star Dusters N23FPPitcher Frederick M MINI 500 · S/N 330Cancelled Jul 6, 2012 · Registration expired, pending cancellation · Pitcher Frederick M DBA N1431ZCessna 185 · S/N 185-1147Cancelled Jun 21, 2012 · Sale reported, canceled N70711Robinson Helicopter R44 · S/N 1497Cancelled Mar 8, 2012 · Exported to Panama · Built 2005 · Vargas Efrain N66692Cessna 150M · S/N 15076215Cancelled Aug 12, 2011 · Exported to Philippines · Built 1974 · Pourzahraee M Reza N37839Culver LFA · S/N 343Cancelled Jan 21, 2011 · Revoked, pending cancellation · Built 1941 · Wright Harold F N1760QCessna 150L · S/N 15073060Cancelled May 31, 2007 · Exported to Philippines · Built 1971 N4753GCessna 414 · S/N 414-0933Cancelled Aug 27, 2002 · Exported to Mexico · Built 1977 · Ennis Sales N567YVPiper PA-46-310P · S/N 46-8408016Cancelled Sep 5, 2000 · Triennial form not returned · Lowe Andrew J N1775XCessna T210L · S/N 21060796Cancelled Dec 1, 1995 · Exported to Mexico · Ennis G Thomas DBA N9001FHughes 369H · S/N 980002Cancelled Jul 8, 1992 N99KRHawker Siddeley DH.125-3A/R · S/N 25149Cancelled Apr 15, 1991 · Triennial form not returned · Northrop University N1644BLuscombe 11A · S/N 11-150Cancelled Sep 24, 1980 · Built 1948 · Bonham Richard H N9210FHughes 269C · S/N 380669Cancelled Sep 7, 1978 · Exported to Japan · Built 1977 · New Japan Trading Inc N1528LBeech 200 · S/N BB132Cancelled Nov 17, 1976 · Exported to Thailand · Built 1976 · C Itoh Aviation Inc N7059LCessna 310K · S/N 310K0159Cancelled Jun 10, 1975 · Conway Metalcraft Co Inc N5543GCessna 150J · S/N 15071043Cancelled Aug 13, 1974 · Devlin Peter Paul N2461NCessna 140 · S/N 12714Cancelled Feb 21, 1974 · Exported to Canada · Athans George Dennis Rogers & Michael Mcgarry N3207TCessna 177 · S/N 177000507Cancelled Nov 15, 1972 · Sutton Albert P N6547CRandall Special BENSON B-8 MODIFIED · S/N 1S.S.R.Cancelled Nov 1, 1972 · Randall Sidney S N1514Edwards B-8M · S/N 001Cancelled Feb 23, 1972 · Crandall Richard D N9622ACessna 140A · S/N 15343Cancelled Nov 10, 1971 · Levensailor Irene N43419Taylorcraft BC12-D · S/N 7078Cancelled Mar 4, 1971 · Bickel Robert A Or Theresa A Bickel

Back to Inglewood, CA