Skip to content

Cancelled registrations · 57

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

N6280GCessna 150K · S/N 15071780Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1970 · Ball David N4202Mooney M20 · S/N 1004Cancelled Apr 21, 2021 · Non-citizen corporation, flight hours not reported · Built 1955 · Soaring America Aviation Corp N8712FHughes 269A · S/N 111-0025Cancelled Sep 6, 2019 · Revoked, canceled · Built 1961 · Amacorp Industrial Leasing Co Inc N71284Luscombe 8A · S/N 2711Cancelled Jul 8, 2019 · Revoked, canceled · Built 1946 · Donaldson Christo N57156Fairchild M-62A · S/N T423397Cancelled Apr 5, 2018 · Revoked, canceled · Built 1942 · Brighton Harold H N1934FCessna 172N · S/N 17273024Cancelled May 12, 2015 · Registration expired, pending cancellation · Built 1979 · Hernandez Fernando A N1170NLiu Kevin Renruey CH-7 ANGEL · S/N 1Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Liu Kevin Renruey N48PHughes Tailwind W-8 · S/N 21Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1958 · Sawin Douglas H N7339NCessna 182P · S/N 18263123Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1974 · Rey Jose E N1822Eich J3M · S/N 1Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1968 · Eich James N5004QFirth Brad BEAVER · S/N SB2396Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Firth Brad A N9207VMooney M20F · S/N 690055Cancelled Jun 11, 2013 · Sale reported, pending cancellation · Built 1969 N8017KStinson 108-2 · S/N 108-3017Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1947 · Ainsworth Don N7129XCessna 150A · S/N 15059229Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1961 · Bouvia James K N86829Bellanca 14-13-2 · S/N 1190Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1946 N1507RGrumman American Avn. AA-1B · S/N AA1B0657Cancelled Aug 6, 2012 · Registration expired, pending cancellation · Built 1976 · Cooper Harold B N77499Cessna 120 · S/N 11943Cancelled Jun 28, 2011 · Revoked, pending cancellation · Built 1946 · Bodcor Enterprises N8960LGrumman American Avn. AA-1B · S/N AA1B-0410Cancelled Sep 15, 2009 · Registration revoked · Built 1974 · Rogers William E N89CCCessna 172M · S/N 17261260Cancelled Oct 30, 2008 · Triennial form not returned · Built 1973 · Lam Lawrence N3580YCessna 182F · S/N 18254480Cancelled Feb 20, 2008 · Exported to Nicaragua · Built 1962 N6381XCessna 402B · S/N 402B1344Cancelled Jul 12, 2007 · Sale reported · Built 1978 N47143Eich JE2 · S/N 771Cancelled Apr 20, 1992 · Triennial form not returned · Eich James P N102YTPiper PA-32-300 · S/N 32-7340076Cancelled Aug 12, 1982 · Administratively canceled · Woodman Thomas W N51283Cessna 150 · S/N 15069893Cancelled Jul 7, 1977 · Robinson Byrl E N1284XMooney M20E · S/N 157Cancelled Jul 15, 1974 · Grani Gregory A DBA Grani Installation Co N3626RPiper PA-28-180 · S/N 28-5723Cancelled Jan 7, 1972 · Martinson Arthur J Md N3467VCessna 195 · S/N 7164Cancelled May 20, 1965 · M C Johns N5831BCessna 182 · S/N 33831Cancelled May 20, 1965 · Amacorp Industrial Leasing Co Inc N8765FHughes 269A · S/N 0088Cancelled May 20, 1965 · Amacorp Industrial Leasing Co Inc N80906Globe GC-1A · S/N 309Cancelled Feb 13, 1964 · Press Richard N8649ABeech A35 · S/N D-2125Cancelled Jun 30, 1958 · Frawley James R N24972Piper J3F-50 · S/N 3574Cancelled Mar 23, 1954 · Rich Frank Arthur N9365HStinson VULTEE V-77 · S/N 77-27Cancelled Nov 9, 1951 · Craig John H N637YWaco INF · S/N 3372Cancelled Nov 4, 1949 · Barlow Harold L N50209Fairchild PT-19A · S/N T40-221Cancelled Feb 3, 1949 · Livere Gerald E N34913Timm Wally D AERO-CRAFT 2SA · S/N 5Cancelled Dec 22, 1948 · Built 1942 · Lights Inc N14418Beech B17L · S/N 31Cancelled Apr 15, 1948 · Built 1935 · Boardman Ross B & Alexander J K N849WBird BK · S/N 2053-33Cancelled Mar 25, 1948 · Schober Kurt H N118KMonocoupe MONOPREP · S/N 6076Cancelled Feb 10, 1948 · Kurt H Schober N661KStearman C3-R · S/N 5009Cancelled Jul 15, 1941 · Airport Management Inc N7144Curtiss Wright ROBIN · S/N 5Cancelled Apr 9, 1941 · Nelson Alden Burke N99KFokker SUPER UNIVERSAL · S/N 861Cancelled Feb 1, 1941 · Airport Management Inc N628MFleet 2 · S/N 209Cancelled Nov 16, 1940 · Airport Management Inc N936YWhittier Donald W GAVIOTA ST-1-A · S/N 1Cancelled Sep 15, 1940 · Built 1930 · Schober Max H N962YAlcor OLYMPIC DUO-4 · S/N 101Cancelled Aug 15, 1934 · Alhambra Airport & Air Transport Co Inc N920YSalitrnik Eugene A PRIMARY GLIDER · S/N 1Cancelled Jan 25, 1933 · Built 1930 · Salitrnik Eugene N185WAlhambra Glider Club ALHAMBRA PRIM GLIDER · S/N 1Cancelled Dec 15, 1931 · Alhambra Glider Club N10118Collins Maurice W SAILPLANE GLIDER · S/N 1Cancelled Apr 20, 1931 · Built 1930 · Bowlus Glenn H N4442Alexander COMBINATION EAGLEROC · S/N 403Cancelled Jan 23, 1931 · George T Friedrich N5010Waco GXE · S/N G-1343Cancelled Sep 19, 1930 · Kurt H Schober

Back to Alhambra, CA