Skip to content

Cancelled registrations · 50

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

N2978MPiper PA-12 · S/N 12-1365Cancelled Aug 26, 2023 · Revoked, canceled · Built 1946 · Wedding Win N1574EAeronca 7AC · S/N 7AC5139Cancelled May 15, 2020 · Revoked, canceled · Built 1946 · Snyder Ray N35320Piper J3C-65 · S/N 6286Cancelled Mar 25, 2020 · Revoked, canceled · Built 1941 · Bush Richard N61VTAmerican AA-1A · S/N AA1A-0047Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1971 · Cyr Michael C N57064Fairchild M-62C(PT-23A) · S/N T43-5636Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1943 · Sargent William E DBA N76TCHayes/Pietenpol AIRCAMPER · S/N 01Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Hayes Henry C N93479Hiller UH-12E · S/N 1442Cancelled May 22, 2013 · Registration expired, pending cancellation · Hayden James M N7280PPiper PA-24-250 · S/N 24-2456Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1961 · Burkdoll Hull Hull & Murphey N5674XAyres S2R-600 · S/N 2433RCancelled Feb 8, 2013 · Sale reported, canceled N39989Taylorcraft BF · S/N 6648Cancelled Nov 29, 2012 · Revoked, canceled · Built 1945 · Marsh Robert M N4658NBoeing A75N1(PT17) · S/N 75-6473Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1942 N39206Taylorcraft BC12-D · S/N 6460Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1945 · Payne Larry K II N67912Boeing E75 · S/N 75-8607Cancelled Oct 11, 2012 · Sale reported, pending cancellation N5502XAero Commander S2R · S/N 1702RCancelled Sep 21, 2012 · Sale reported, pending cancellation · Built 1972 N46277Howard DGA-15P · S/N 520Cancelled Jul 31, 2012 · Revoked, canceled · Built 1940 · Wedding Win N337BBeech H35 · S/N D-4929Cancelled Dec 3, 2009 · Registration revoked · Built 1957 · Cazan George M N3463JCessna 150G · S/N 15066163Cancelled May 22, 2001 · Triennial form not returned · Copeland Jackie D N9071GCessna TU206G · S/N U20603800Cancelled Dec 2, 1996 · Exported to Mexico · City Of Blythe N7031GCessna 172K · S/N 17258731Cancelled Feb 10, 1992 · Sheble Aviation Inc N976BBell 47G-2 · S/N 1378Cancelled Apr 23, 1991 · Triennial form not returned · Clayton James C N70454Cessna A188B · S/N 18801923Cancelled Jul 1, 1986 · Cyr Joel M N9702KStinson 108-2 · S/N 108-2702Cancelled Aug 20, 1978 · Exported to Canada · Christain F M N1599HCessna 177RG · S/N 177RG0773Cancelled Oct 19, 1977 · Hancock La Vell F N1768PPiper PA-18A 150 · S/N 18-4103Cancelled Jun 26, 1974 · Sargent William E And Sargent Estell R N7636XCessna 172B · S/N 17248136Cancelled Dec 19, 1973 · Dalsanders Bruce C N34369Meyers MAC-145 · S/N 212Cancelled Jun 29, 1973 · Stone Robert A N3262KGlobe GC-1B · S/N 1255Cancelled Jun 26, 1973 · Mcgowam C R N7206BBeech J35 · S/N D5512Cancelled Nov 26, 1971 · Stanislaus Food Products Co N4917YPiper PA-25-235 · S/N 25-4720Cancelled Oct 5, 1971 · Sampleys Flying Service Inc N7174ACessna 172 · S/N 29274Cancelled Jul 14, 1971 · Scarbrough George R N5113NBoeing A75N1(PT17) · S/N 75-6911Cancelled May 5, 1971 · William E Sargent N2441EAeronca 7AC · S/N 7AC-6020Cancelled Dec 4, 1970 · Ray Snyder N2593PPiper PA-18A 150 · S/N 18-4339Cancelled Aug 18, 1970 · William E Sergent N91935Piper J3C-65 · S/N 16350Cancelled May 25, 1965 · Built 1946 · Sargent William E N92143Piper J3C-65 · S/N 16585Cancelled May 21, 1965 · William E Sargent N35469Piper J3F-65 · S/N 6373Cancelled May 20, 1965 · Sargent William E N70075Stinson L-5G · S/N 3644Cancelled May 20, 1965 · Sargent William E N1495CPiper PA-18A-135 · S/N 18-2692Cancelled Mar 21, 1963 · Sargent W E And Or Estell Ruth Sargent N98230Piper J3C-65 · S/N 18394Cancelled Jan 2, 1957 · Exported to Mexico · Sargent William E N1062APiper PA-18 · S/N 18-645Cancelled Feb 20, 1956 · Exported to Mexico · Sargent William E N56054Fairchild M-62A · S/N T42-3350Cancelled Oct 26, 1955 · Pettays Ellmo Chester N99946Ercoupe 415-C · S/N 2569Cancelled Sep 23, 1955 · Built 1946 · Dennis H B N209WStinson SM-8A · S/N 4004Cancelled Mar 15, 1955 · Built 1930 · Neale Harold W N407NTravel Air E-4000 · S/N 1338Cancelled Oct 3, 1952 · Everhart Marion D N887ETimm COLLEGIATE · S/N 102Cancelled May 2, 1950 · Sargent William E N53844Fairchild M-62A · S/N 9834AECancelled Feb 28, 1949 · Sinnock R L N16484Arrow F · S/N 6Cancelled May 3, 1948 · Womble Lewis Earl N238HFleet 2 · S/N 106Cancelled Apr 1, 1944 · Built 1929 · Born James Et Al N8085E H Elliott ELLIOTT SPORT · S/N 100Cancelled May 15, 1940 · Alfred W Dunagan N7901Thunderbird W-14 · S/N 2817Cancelled Apr 1, 1935 · March Theron

Back to Blythe, CA