Skip to content

Cancelled registrations · 45

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

N32782Piper J4A · S/N 4-1313Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1940 · Ferguson Alan K N66926Fairchild M-62A · S/N 4743AECancelled Mar 20, 2020 · Revoked, canceled · Built 1943 · Hatt Herman O N3309EAeronca 7AC · S/N 7AC6753Cancelled May 18, 2018 · Revoked, canceled · Built 1947 · Bell David W N6798RCessna T210G · S/N T210-0198Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1966 · Sherman Keith D N1457PPiper PA-23-150 · S/N 23-520Cancelled Mar 23, 2018 · Revoked, canceled · Built 1956 · Travis Transportation Co N3919YCessna 210D · S/N 21058419Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1964 · Sherman Keith D N3981PCessna 310 · S/N 35358Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1956 · Kaiser David R N69CMidget Mustang MM-1 · S/N 262Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1968 · Classen Albert F N9985ACessna 170A · S/N 19345Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1950 N6744BPiper PA-22-150 · S/N 22-4078Cancelled Oct 11, 2012 · Sale reported, pending cancellation · Built 1956 N10978Cessna 150L · S/N 15075182Cancelled Mar 22, 2011 · Exported to Russia · Built 1973 · Scott Benjamin N8466JCessna 150G · S/N 15066366Cancelled Sep 15, 2009 · Registration revoked · Built 1967 · Wheeler Ronald D N4245VCessna 170 · S/N 18601Cancelled Apr 22, 2009 · Triennial form not returned · Built 1948 · Andrews Frank C N113LNCessna 150L · S/N 15073505Cancelled Oct 10, 2007 · Exported to Philippines · Built 1972 · Wallace James A N93194Cessna 152 · S/N 15285438Cancelled Sep 7, 2007 · Exported to Philippines · Built 1981 · Militante Michael J N5585RCessna 172F · S/N 17253185Cancelled Mar 7, 2007 · Exported to Philippines · Built 1965 · Ruther Melvin E N125ATLockheed T-33A · S/N 51-17468Cancelled Dec 15, 2004 · Triennial form not returned · Flanders Gary H N29KNavion NAVION A · S/N NAV-4-779Cancelled Mar 20, 2003 · Exported to Canada · Built 1947 · Carver John E N5155Winberg SPORTSMAN · S/N 211Cancelled Aug 20, 2002 · Triennial form not returned · Built 1968 · Winberg Oscar V N65FDSiai-Marchetti SF260 · S/N 723Cancelled Jun 20, 2000 · Mach 1 Motorsports Inc N245SWBeech 76 · S/N ME19Cancelled Jul 24, 1998 · Exported to Canada · Mozsary Peter G N4099VRaven Industries RALLY RX7 · S/N RX7331Cancelled Jun 30, 1994 · Second triennial mailing, no response · Mercer Bennie B N6065VBeech C-45G · S/N AF-206Cancelled Aug 3, 1977 · Meredith Adrian H N6998XCessna 172B · S/N 17247898Cancelled Jul 1, 1976 · Exported to Canada · Russell Jerry D N11JKKrause SONERAI I · S/N 0047Cancelled May 12, 1976 · Krause James R N5797VBeech A23-19 · S/N MB-57Cancelled Oct 10, 1975 · Exported to Canada · Miller G George N3732FCessna 172H · S/N 17255227Cancelled Jun 22, 1973 · Hussey Paul S DBA Key Realty N2857PPiper PA-22-150 · S/N 22-3157Cancelled Jun 21, 1973 · Williams Fred C N37462Interstate S-1B1 · S/N 253Cancelled Jan 19, 1971 · Gregory Edward C N67704Taylorcraft DC-65 · S/N 6016Cancelled Mar 1, 1965 · Darrell I Woodruff N43891Taylorcraft BC12-D · S/N 7550Cancelled Aug 17, 1956 · Miller Arthurl & Josephine E N66762Consolidated Vultee BT-13A · S/N 3007Cancelled Oct 24, 1955 · Village Paint Store N53677Fairchild PT-26 · S/N T-42-3276Cancelled Oct 13, 1955 · Built 1942 · Smiley Lee / Staedler Harry N66984Consolidated Vultee BT-13A · S/N 6324Cancelled Oct 12, 1955 · Brumbaugh Paul J N61882Ryan Aeronautical ST3KR · S/N 2103Cancelled Sep 1, 1954 · Schrader William B N16581Waco YKS-6 · S/N 4516Cancelled Feb 20, 1951 · Larios Paul S N48237Ryan Aeronautical ST3KR · S/N 1253Cancelled Nov 17, 1948 · Copeland Arthur E N47616Fairchild M-62A · S/N T42-3331Cancelled May 13, 1948 · Built 1942 · Smith Sidney B & Smith Melvin H N80887Globe GC-1A · S/N 290Cancelled Mar 5, 1948 · Starry Marvin N23641Taylorcraft BC-65 · S/N 1371Cancelled Dec 12, 1944 · Built 1939 · Vallejo Flying Club Inc Unit #1 N4010Waco GXE · S/N 1175Cancelled Aug 16, 1934 · Ulrey John D N2069Ryan M-1 · S/N 4Cancelled May 6, 1934 · Built 1926 · Christman Harold D N946Curtiss JN4D · S/N 1492ACancelled Mar 14, 1930 · Built 1927 · Jones R P N68268Cessna T-50 · S/N 4676Cancellation date not recorded · Sink Ernest L N68908Cessna T-50 · S/N 3101Cancellation date not recorded · Middleton Paul B

Back to Vallejo, CA