Skip to content

Cancelled registrations · 37

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

N34648Stinson 10A · S/N 8048Cancelled Sep 23, 2023 · Revoked, canceled · Built 1941 · Mcsorley John H N279GWickliffe C D/Sanderlin DC SHA GLASAIR · S/N 279Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1988 · Korney Stephen N360AZAmerican Legend AL3 · S/N AL-1122Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 2008 · Cub N360az LLC N68319Consolidated Vultee BT-13 · S/N 8249Cancelled Jun 5, 2020 · Revoked, canceled · Built 1942 · Brown Keith C N34022Taylorcraft BF · S/N 2873Cancelled Apr 17, 2020 · Revoked, canceled · Built 1941 · Raschke Larry E N6943CBeech AT-11 · S/N 42-37618Cancelled May 4, 2019 · Revoked, canceled · Built 1942 · Young C A N3675XAero Commander 100 · S/N 320Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1969 · Tedford Sylvia D N554LARobinson Helicopter R22 ALPHA · S/N 0426Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1984 · Gamut Enterprises Inc N5128TScofield Jerry STRIPLIN SKYRANGER · S/N SR83014SCCancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1984 · Scofield Jerry D N157DTTopping Donald Roger B-8M · S/N 10039Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1984 · Topping Donald R N7553PPiper PA-24-180 · S/N 24-2761Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1961 · Dawson Donald Dale N90374Shouse Lewis RANS S-7 · S/N 0204361Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Shouse Lewis N448CStinson 108-2 · S/N 108-3448Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1947 · Merizan R I N29482Cessna 177 · S/N 17700917Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1968 · Brickner Wilfried N3371GGrunau Baby Glider II-B-2 · S/N 120Cancelled Jun 13, 2011 · Revoked, canceled · Built 1961 · Lilienthal Soaring Club Of Cal N5860WPiper PA-28-150 · S/N 28-2373Cancelled Jul 29, 2009 · Triennial form not returned · Built 1965 · A R D Engineering N192STailwind W-8 · S/N 001WSCancelled Jun 15, 2005 · Triennial form not returned · Built 1969 · Eatmon Teddy D N8462FPiper PA-28-151 · S/N 287715268Cancelled Dec 16, 1998 · Triennial form not returned · Byers Ogle H N28PTTesta-Phillip RUTAN-VARIEZE · S/N 191Cancelled Sep 12, 1998 · Triennial form not returned · Testa Phillip J N8036WKopecky Frank M. QUICKIE · S/N 0194Cancelled Apr 4, 1998 · Korney Steve N114RMBell 214B-1 · S/N 28021Cancelled Oct 22, 1996 · Exported to South Korea · Seoul Air Leasing Inc N514RMBell 214B · S/N 28058Cancelled Apr 12, 1994 · Exported to South Korea · Seoul Air Leasing Inc N5728TCessna 172E · S/N 17251628Cancelled Sep 18, 1985 · Tomich Luis A N16183Cessna 150L · S/N 15073529Cancelled Apr 27, 1983 · Administratively canceled · Noya Emilia N8423CPiper PA-28-235 · S/N 28-7610077Cancelled Apr 9, 1981 · Baker Beatrice J N91160North American NAVION · S/N NAV-4-56Cancelled Oct 17, 1979 · William Joseph N14594Goossen BENSEN B-8M · S/N 1Cancelled Jun 7, 1979 · Goossen Edward D N92337Cessna 182N · S/N 18260160Cancelled Jul 27, 1976 · Fulps Frank B N3084MPiper PA-12 · S/N 12-1772Cancelled Mar 12, 1974 · Built 1947 · Meadors C M N60003Cessna 150J · S/N 15069999Cancelled Dec 16, 1971 · Miller Melvin W N74128Focke-Wulf Flugzeugbau KRANICH III · S/N 52Cancelled Nov 28, 1966 · Lilienthal Soaring Club N87000Engineering & Research 415-C · S/N 173Cancelled Feb 19, 1958 · Gregory George L N57872Fairchild PT-26 · S/N 6603AECancelled Dec 31, 1953 · Carter Marvin N2768HEngineering & Research ERCOUPE 415-C · S/N 3393Cancelled Mar 9, 1951 · Built 1946 · Delpert Flying Service N8315HEmigh TROJAN A-2 · S/N 18Cancelled Jun 16, 1949 · Delpert Flying Service N8318HEmigh TROJAN A-2 · S/N 21Cancelled May 26, 1949 · Horn Julia N122Canadian Aeroplane JN4C · S/N 1078Cancelled May 22, 1930 · Otis Harold H L

Back to Norwalk, CA