Skip to content

Cancelled registrations · 176

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

N7581QCessna T310Q · S/N 310Q0081Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1970 · John L Burghardt Law Corp N33570Piper PA-28-140 · S/N 28-7525209Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1975 · Chico Avn Inc N15351Piper PA-32-300 · S/N 32-7340039Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1972 · Chico Aviation Inc N506KBeech 95 · S/N TD-173Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Built 1958 · Coulter J H N28LMMeyer TORO 77-1 · S/N 78-3Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Built 1978 · Grigsby Daniel E N6586NDowner BELLANCA 14-19 · S/N 2039Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1950 N4421YPiper PA-25-235 · S/N 25-4041Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1966 · North Valley Aviation N43521Taplin James B RV-6 · S/N 162Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1992 · Klemm Harlan K N3442ZPiper PA-22-160 · S/N 22-7361Cancelled Nov 9, 2012 · Built 1960 · Andrus Aaron M N8200NPiper PA-28-140 · S/N 28-25401Cancelled Nov 9, 2012 · Sale reported, pending cancellation · Built 1969 N74183Douglas C-54 · S/N 10314Cancelled Oct 19, 2012 · Sale reported, pending cancellation · Built 1943 N6601PPiper PA-24-180 · S/N 24-1723Cancelled Oct 9, 2012 · Sale reported, pending cancellation · Built 1960 N4028VCessna 150M · S/N 15076681Cancelled Oct 3, 2012 · Sale reported, canceled · Built 1975 N3160NCessna 140 · S/N 13418Cancelled Sep 27, 2012 · Registration expired, pending cancellation · Built 1947 · Mcgowan Samuel D N6570NCessna T182 · S/N 18267837Cancelled Sep 4, 2012 · Exported to Colombia · Built 1981 · Dan Jay Aircraft Sales N776SCPiper PA-34-200T · S/N 34-8170026Cancelled Aug 29, 2012 · Exported to Mexico · Built 1981 · Dan Jay Aircraft Sales N50229Cessna 150H · S/N 15069151Cancelled Aug 10, 2012 · Revoked, canceled · Built 1968 · Carlson Morris L N1763FCessna 172H · S/N 17255158Cancelled Jul 30, 2012 · Sale reported, canceled · Built 1966 N6367VAlon A2 · S/N A-43Cancelled Jun 25, 2012 · Registration pending, canceled · Built 1965 N10280Grumman G-164 · S/N 80Cancelled Jun 22, 2011 · Sale reported, canceled · Built 1961 N38976Schweizer SGS 2-8 · S/N 55Cancelled Apr 15, 2011 · Expired dealer · Built 1944 · Reagan Enterprises N4471VSchweizer SGS 2-8A · S/N 46Cancelled Mar 24, 2011 · Expired dealer · Reagan Enterprises N8605Fleet 7 · S/N 361Cancelled Mar 24, 2011 · Expired dealer · Built 1930 · Reagan Enterprises N38BHHaviland Bill L NORTHWING MAVERICK · S/N 81215Cancelled Jul 8, 2010 · Triennial form not returned · Built 1998 · Haviland Bill L N9484WPiper PA-28-235 · S/N 28-11222Cancelled Feb 18, 2010 · Exported to Canada · Built 1969 · Dan Jay Aircraft Sales Inc N3065TCessna 320C · S/N 320C0065Cancelled Oct 19, 2009 · Registration revoked · Built 1965 · Hyman Dennis C N1511PPiper PA-22-135 · S/N 22-2376Cancelled Jun 30, 2009 · Registration revoked · Built 1954 · Birk Harold N5259KCessna 172P · S/N 17274034Cancelled Jun 5, 2008 · Exported to Malaysia · Built 1980 N2280LBeech 58 · S/N TH-775Cancelled May 28, 2008 · Exported to South Africa · Built 1976 · Dan Jay Aircraft Sales Inc N135EZCessna TU206B · S/N U206-0727Cancelled May 22, 2008 · Exported to Mexico · Built 1966 · Butte Creek Aviation Services LLC N702AULockheed SP-2H · S/N 147968Cancelled Jun 6, 2007 · Triennial form not returned · Aero Union Corporation N6494WCessna P210N · S/N P21000786Cancelled Jan 11, 2007 · Exported to Canada · Built 1981 · Dan Jay Aircraft Sales Inc N210HECessna T210M · S/N 21062338Cancelled Oct 5, 2006 · Exported to Mexico · Built 1977 · Chico Administrative Services Inc N720MAPiper PA-28R-200 · S/N 2844021Cancelled Apr 18, 2006 · Exported to Japan · Built 1999 · Dan Jay Aircraft Sales Inc N2742GDouglas C54G-DC · S/N 36089Cancelled Dec 13, 2005 · Exported to Canada · Built 1945 · Aero Union Corp N4958MDouglas C-54G · S/N 36009Cancelled Dec 13, 2005 · Exported to Canada · Built 1945 · Aero Union Corp N62297Douglas C-54E · S/N 27328Cancelled Dec 13, 2005 · Exported to Canada · Aero Union Corporation N713AULockheed SP-2H · S/N 145903Cancelled Sep 22, 2005 · Triennial form not returned · Aero Union Corporation N980APLockheed P2V-7 · S/N 140980Cancelled Sep 22, 2005 · Triennial form not returned · Aero Union Corp N926AULockheed P3B · S/N 152731Cancelled May 13, 2005 · Triennial form not returned · Built 1966 · Aero Union Corporation N911NTAerospatiale AS350BA · S/N 1556Cancelled Dec 11, 2003 · Triennial form not returned · Built 1985 · Enloe Medical Center N4994HDouglas C54D-DC · S/N 10653Cancelled Feb 7, 2002 · Exported to Canada · Built 1945 · Aero Union Corporation N62342Douglas C54D-DC · S/N 10613Cancelled Jan 25, 2001 · Exported to Canada · Aero Union Corporation N11712Douglas C54A-DC · S/N 3088Cancelled Mar 28, 2000 · Exported to Canada · Aero Union Corporation N3406TCessna 177 · S/N 17700706Cancelled Mar 10, 2000 · Triennial form not returned · Schreck John W N703AULockheed P2V-7 · S/N 147967Cancelled Feb 14, 2000 · Exported to Chile · Aero Union Corporation N720AULockheed P2V-7 · S/N 145917Cancelled Jun 25, 1998 · Triennial form not returned · Aero Union Corporation N62295Douglas C-54B · S/N 10428Cancelled Aug 27, 1997 · Triennial form not returned · Aero Union Corporation N18XCessna T337H · S/N 33701831Cancelled Oct 18, 1996 · Exported to Mexico · Sheridan William A N1793XCessna T210L · S/N 21060813Cancelled Jun 12, 1996 · Triennial form not returned · Strisower Enterprises Inc

Back to Chico, CA