Cancelled registrations · 27

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 = 'SEAL BEACH' 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 = 'SEAL BEACH'
  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 = 'SEAL BEACH'
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.

N875BWBob Wilson 800 TURBO HRD · S/N V72019Cancelled Apr 4, 2023 · Registration expired, pending cancellation · Wilson Robert David N97691Stinson 108 · S/N 108691Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1946 · Burns Johnny N7753CNaval Aircraft Factory N3N-3 · S/N 4405Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1943 · Brown Frank A N282RQHudson Robert L HUDSON RQ 282 · S/N 0001Cancelled May 6, 2015 · Registration expired, pending cancellation · Hudson Robert L N6634YPiper PA-23-250 · S/N 27-3946Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1968 · Golden Royal Enterprises Inc N23WVVilla William C JR BUSHBY MUSTANG II · S/N 1473Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1995 N7585FChampion 7ECA · S/N 741-70Cancelled Oct 19, 2012 · Sale reported, pending cancellation · Built 1970 N38RNMinear PIETENPOL · S/N 001Cancelled Sep 21, 2012 · Sale reported, canceled · Built 1979 N150MPAerospatiale AS350B · S/N 2084Cancelled Apr 19, 2012 · Exported to Canada · Built 1988 · Smith Glenn DBA N211DRRihn PITTS S-1 REPLICA · S/N 602-HCancelled Mar 3, 2010 · Triennial form not returned · Built 1978 · Rihn Daniel R N1033ASalmon Millard M KR-2 · S/N 3295Cancelled Oct 28, 2002 · Second triennial mailing, no response · Built 1979 · Pinson Robert J N41ALLarson Alan H GLASAIR 1RG · S/N 704Cancelled Jun 18, 2001 · Larson Alan H Trustee N29267Cessna TU206C · S/N U206-1201Cancelled Aug 12, 1999 · Triennial form not returned · Brim Rodney M N61913Cessna 172M · S/N 17264881Cancelled Feb 20, 1998 · Triennial form not returned · Choppin Kerry F N335QPiper PA-60-601P · S/N 61P0356110Cancelled Dec 1, 1997 · Exported to Canada · J E Pistons Inc N4328YPiper PA-28-161 · S/N 288416024Cancelled Apr 24, 1991 · Triennial form not returned · Welch Preston F N78810Cessna 172K · S/N 17257776Cancelled May 10, 1984 · Revoked, pending cancellation · Built 1968 · Harvey Thayer A N57261Consolidated Vultee BT-13A · S/N 7331Cancelled Oct 24, 1955 · Hatch Raleigh M N36674Aeronca 65-TAF · S/N F1231TACancelled Aug 31, 1948 · Built 1941 · Jasper Raymond Carlton N901WStinson SM-8A · S/N M-4104Cancelled Mar 20, 1939 · Built 1930 · Miller J/Carroll W D/Hutton H H N12268Crawford Power Glider Mfg CRAWFORD · S/N 8Cancelled Dec 1, 1934 · Crawford Power Glider Manufactory N941YCrawford POWERED GLIDER · S/N 7Cancelled Jan 27, 1933 · Built 1930 · Crawford Powered Glider N878NCrawford Motor & Airplane Manu CRAWFORD'S GLIDER · S/N 2Cancelled Jan 12, 1933 · Crawford Motor & Airplane Manufactory Inc N450ECrawford Motor & Airplane Mfg CRAWFORD SPECIAL · S/N 504Cancelled May 22, 1930 · Built 1928 · Crawford Motor And Airplane Manufactory Inc N3053Crawford A-1 · S/N 505Cancelled Mar 14, 1930 · Built 1928 · Crawford Power Glider Mfgr.N2387Thomas Morse S4C · S/N 678Cancelled Apr 30, 1929 · William F Crawford N5455Mccreery Roger Lynd LEPERE FIGHTER · S/N 8Cancelled Feb 2, 1929 · Built 1921 · Mcgreery Roger Lynd

Back to Seal Beach, CA