Skip to content

Cancelled registrations · 40

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

N4474HMooney M20J · S/N 24-0744Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Punt Henry N88805Russell TEENIE TWO · S/N 5-10477Cancelled Jul 6, 2020 · Revoked, pending cancellation · Russell Jerry D N43942Taylorcraft BF · S/N 7601Cancelled Dec 10, 2018 · Revoked, canceled · Built 1946 · Roberts David E N53421Boeing A75N1(PT17) · S/N 75-3218Cancelled Sep 13, 2018 · Revoked, canceled · Built 1942 · Most James L Avia N32963Piper J3C-85 · S/N 5747Cancelled May 18, 2018 · Revoked, canceled · Built 1940 · Mckisson Frank E N9059VMooney M20F · S/N 690007Cancelled Mar 16, 2018 · Revoked, canceled · Noar Raymond N8765KStinson 108-1 · S/N 108-1765Cancelled Nov 21, 2017 · Revoked, canceled · Built 1947 · Popma Norman J N5130ZPiper PA-22-108 · S/N 22-8771Cancelled Nov 18, 2017 · Revoked, canceled · Built 1961 · Bailey Jim N N2161GPiper PA-28-181 · S/N 28-7990193Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1978 · Spoolstra Calvin G N897Turpin JFT B-8M · S/N 12229Cancelled Feb 4, 2017 · Revoked, canceled · Built 1972 · Turpin James F N5948JCessna 182P · S/N 18263588Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1975 · Hill Rudy N1757ZCessna 336 · S/N 336-0057Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1963 · Pennington Dave N6170QCessna 421A · S/N 421A0110Cancelled Aug 5, 2013 · Revoked, canceled · Built 1969 · West Coast Leasing Co N3382HErcoupe 415-CD · S/N 4007Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1947 · Anderson Mary G N4224PHill Robert L BARNETT J-3 · S/N 1Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1981 · Hill Robert L N123JHBeech S35 · S/N D-7477Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1964 N8510GWright Deryl W KB-2 GYROPLANE · S/N KCT801040Cancelled Sep 18, 2012 · Registration expired, pending cancellation · Wright Deryl W N4439Maldewin MINIPLANE · S/N M-2Cancelled Aug 8, 2012 · Registration pending, canceled · Built 1970 N1078XPiper PA-28-235 · S/N 28-7510085Cancelled Jul 30, 2010 · Exported to South Africa · Built 1975 · Rogers Carrol E N2172TPiper PA-28-180 · S/N 28-7105164Cancelled Jul 13, 2009 · Registration revoked · Built 1971 · Holmes Lorne R N206TVRobinson Helicopter R22 BETA · S/N 2753Cancelled Jul 29, 2005 · Built 1997 · Tompkins Timothy W N970SMRobinson Helicopter R22 BETA · S/N 1970Cancelled May 20, 2004 · Exported to Mexico · Built 1991 · Zdarsky Ivo N4542SBeech 95-B55 (T42A) · S/N TC1892Cancelled Dec 11, 1990 · Exported to Canada · Peyton Earl DBA N4694QCessna T210L · S/N 21059594Cancelled Oct 31, 1977 · West Coast Leasing Company N1846KLuscombe 8E · S/N 4573Cancelled Jul 15, 1971 · Built 1946 · Chapman Craig B N34KKerns Glider KERNS · S/N 1-4Cancelled Mar 15, 1971 · Kerns Frank F N18190Monocoupe 90AF · S/N A-819Cancelled Jan 12, 1971 · Built 1941 · Sievers Raymond E N9603SChampion 7GCAA · S/N 26Cancelled Jun 26, 1970 · 47 Flying Service Inc N3525KPiper J3C-65 · S/N 22215Cancelled Jun 12, 1956 · Exported to Mexico · Mckisson Frank E N4073NCessna 120 · S/N 13531Cancelled Mar 23, 1956 · James L Most Aviation N30032Cessna T-50 · S/N 6079Cancelled Feb 23, 1956 · Built 1942 · Most James L DBA James L Most Aviation N63135Cessna T-50 · S/N 4318Cancelled Feb 16, 1956 · James L Most Aviation N54660Ryan Aeronautical ST3KR · S/N 1638Cancelled Oct 21, 1955 · Bodell Malcolm E N1983VCessna 140 · S/N 14194Cancelled Jun 26, 1953 · Exported to Chile · James L Most Aviation N76224Cessna 140 · S/N 10627Cancelled Jan 2, 1952 · James L Most Aviation N97848Stinson 108-1 · S/N 108-848Cancelled Mar 30, 1951 · Built 1946 · Bodell Malcolm E N4653NCessna T-50 · S/N 2833Cancelled Sep 9, 1949 · Bellflower Airport Inc N14693Aeronca C-3 · S/N A-564Cancelled Apr 14, 1948 · Swerdfeger R M N56759Boeing 75 · S/N 75-266 (40-1709)Cancellation date not recorded · Coughan James E N67222Cessna UC-78B · S/N 6052Cancellation date not recorded · Roberts Gordon E

Back to Bellflower, CA