Skip to content

Cancelled registrations · 119

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

N5846Bakewell JF CASSUTT RACER IIIM · S/N PFA 034-13003Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 2001 · Erickson Casey N15756Piper PA-28-180 · S/N 28-7305135Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1972 · Gustavsen Grant K N247SPBrown Stephen O FISHER SUPER KOALA · S/N 33Cancelled Jan 27, 2022 · Sale reported, canceled N6362JPiper PA-28-180 · S/N 28-4773Cancelled Apr 13, 2021 · Exported to Guatemala · Built 1968 · Bullard Jeffrey S N5562QMooney M20E · S/N 634Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1965 · Tangobravo Consulting LLC N47678Piper PA-28-181 · S/N 28-7890115Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1977 · Mcconnell Roger R N5888Collins BRIAN HP-16T · S/N 9Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1978 · Heroheme Gary E N66117Cessna 150M · S/N 15075848Cancelled Feb 14, 2018 · Built 1974 · Aerotech Academy Inc N4920VDehavilland DH-104 · S/N 04283Cancelled Nov 18, 2017 · Revoked, canceled · Federal Leasing Co N505WHHoatson Wendell M SONEX · S/N 782Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 2006 · Hoatson Wendell M N4290TPiper PA-28R-200 · S/N 28R-7235003Cancelled Jun 22, 2017 · Registration expired, pending cancellation · Built 1971 · M Y Air N2819RCessna 182K · S/N 18258419Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1967 · Jeffries James W N115WPStevens Cole SPRINT II · S/N 5150CCancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1990 · Stevens Cole N774WSCessna 152 · S/N 15279971Cancelled May 9, 2014 · Exported to Ecuador · Built 1977 · Brummett Jamie N20BFFaley Robert W REVOLUTION MINI-500 · S/N 0089Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1996 N4875ECessna 182R · S/N 18268280Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1982 · Northcutt Craig N19370Cessna 150L · S/N 15074372Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1973 · Dewalle Dennis C N65117Opdahl KR-1 · S/N 1Cancelled Jun 13, 2013 · Sale reported, canceled · Built 1975 N80539Low-Spellmeyer QUICKIE · S/N 180Cancelled May 13, 2013 · Registration expired, pending cancellation · Salmon Richard J N96998Taylorcraft BC12-D · S/N 9298Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1946 N57496Lockheed F-5G · S/N 8497Cancelled Feb 21, 2013 · Revoked, canceled · Built 1945 · Weather Modification Co N10WSSpark Wallace R ACRODUSTER SA750 · S/N 001SCancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1981 · Donnelly Brian A N67177Cessna T-50 · S/N 6439Cancelled Sep 5, 2012 · Revoked, canceled · Built 1943 · Theos Alexander N160NNiswonger JN B8M · S/N 1Cancelled Aug 9, 2012 · Registration expired, pending cancellation · Built 1970 · Niswonger Jerome W H N303SCPiper PA-34-220T · S/N 34-8433030Cancelled Jun 18, 2012 · Exported to Brazil · Built 1984 · Wings To There Aviation LLC N1041DTaylorcraft BL-65 · S/N 1370Cancelled Jun 7, 2011 · Sale reported, canceled · Built 1940 N67361Cessna 152 · S/N 15281779Cancelled Aug 10, 2010 · Triennial form not returned · Built 1978 · M Y Air N7015QRobinson Helicopter R44 · S/N 0462Cancelled Jun 13, 2008 · Triennial form not returned · Built 1998 · Concrete Paving Contractors Inc N89UDehavilland BEAVER DHC-2 MK.1 · S/N 160Cancelled Sep 27, 2006 · Triennial form not returned · Built 1952 · Devries Douglas F N5494XCessna T206H · S/N T20608016Cancelled May 26, 2006 · Exported to Lesotho · Built 1999 · Mission Aviation Fellowship N2954PPiper PA-28-181 · S/N 28-7990587Cancelled Apr 19, 2006 · Triennial form not returned · Built 1979 · M I Air Corp N4093NMooney M20F · S/N 680173Cancelled Feb 16, 2006 · Second triennial mailing, no response · Built 1968 · Bennett Tom R N9636BCessna 172RG · S/N 172RG0934Cancelled Nov 15, 2005 · Built 1981 · M I Air Corp N12162Cessna 208B · S/N 208B0829Cancelled Apr 28, 2005 · Exported to Democratic Republic of the Congo · Built 2000 · Mission Aviation Fellowship N999FPPhillips Floyd E PHILLIPS · S/N 001Cancelled Mar 11, 2005 · Triennial form not returned · Phillips Floyd E N49393Cessna 152 · S/N 15281233Cancelled Sep 10, 2004 · Triennial form not returned · Built 1977 · M I Air Corp N9666RCessna U206G · S/N U20606927Cancelled Jun 28, 2004 · Exported to Democratic Republic of the Congo · Built 1986 · Pactec N34021Cessna 177B · S/N 17701601Cancelled Oct 31, 2003 · Triennial form not returned · Built 1970 · Coutrakon George B N1232XCessna 208B · S/N 208B0989Cancelled Jul 15, 2003 · Exported to Indonesia · Mission Aviation Fellowship N61416Schweizer 269C-1 · S/N 0006Cancelled Jul 15, 2003 · Triennial form not returned · Built 1995 · M I Air Corporation N111CMCessna TU206G · S/N U20606130Cancelled Aug 30, 2002 · Exported to Indonesia · Mission Aviation Fellowship N5494BCessna TU206G · S/N U20605808Cancelled Feb 13, 2002 · Exported to Zimbabwe · Built 1980 · Mission Aviation Fellowship N756HECessna TU206G · S/N U20604097Cancelled Dec 7, 2001 · Exported to Mexico · Built 1977 · Mission Aviation Fellowship N4688CCessna U206G · S/N U20603843Cancelled Nov 30, 2001 · Triennial form not returned · Built 1977 · Pactec N21084Aeronca KCA · S/N 56Cancelled Apr 12, 2001 · Triennial form not returned · Davies Harold D N8604KUniversal Stinson 108-1 · S/N 108-1604Cancelled Apr 12, 2001 · Triennial form not returned · Davies Harold D N1128HCessna 208 · S/N 20800330Cancelled Feb 14, 2001 · Exported to Brazil · Mission Aviation Fellowship N95692Taylorcraft BC12-D · S/N 7992Cancelled Dec 18, 2000 · Triennial form not returned · Swank Mt N6168UCessna TU206G · S/N U20605361Cancelled Jul 11, 2000 · Exported to Indonesia · Mission Aviation Fellowship N2529WPiper PA-28-161 · S/N 28-8516076Cancelled May 1, 2000 · Triennial form not returned · Sharp Larry R

Back to Redlands, CA