Cancelled registrations · 21

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 = 'HUNTINGTON PARK' 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 = 'HUNTINGTON PARK'
  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 = 'HUNTINGTON PARK'
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.

N4006BNorth American SNJ-4 · S/N 88-26609Cancelled Nov 29, 2012 · Revoked, canceled · Built 1953 · Halcyon Films N39144Taylorcraft BF12-65 · S/N 3360Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1942 · Allied Aluminum Company N15692Erco 415-C · S/N 1Cancelled Oct 9, 2009 · Registration revoked · Built 1939 · Whipperman Robert F N911RNBell OH-58A · S/N 70-15123Cancelled Jan 7, 2000 · City Of Huntington Park Police Department N577GNCessna 320E · S/N 320E0070Cancelled Nov 27, 1970 · Exported to Australia · Newton George N2932FCessna 182J · S/N 18257032Cancelled Oct 16, 1970 · Exported to Australia · Built 1966 · Newton George E N4606VSchweizer TG3A · S/N 61Cancelled Nov 1, 1965 · Aeronaut Soaring Club N1278HAeronca 15AC · S/N 15AC-294Cancelled Feb 19, 1958 · Rogers Robert E N59804Fairchild M-62A · S/N T40-322Cancelled Feb 14, 1956 · Hollenbeck E C N63162Consolidated Vultee BT-13 · S/N 79-340Cancelled Oct 24, 1955 · Elofson Randall C N2091VCessna 120 · S/N 14319Cancelled Sep 16, 1953 · Thompson Clyde D And Thompson Marianne A N3108KCulver V · S/N V-327Cancelled Nov 17, 1952 · Sweetnam John E N215WStinson SM-8A · S/N 4024Cancelled Jul 8, 1948 · Built 1930 · Bradford Amazon N87395Ercoupe 415-C · S/N 568Cancelled Sep 24, 1947 · Whipperman F Robert N14590Stinson SR-5A · S/N 9328ACancelled Apr 6, 1939 · Built 1935 · Hoffman Marvin Daniel N17014Porterfield 35W · S/N 306Cancelled Jul 17, 1938 · Mcmichael Robert W N161HAeromarine-Klemm L-26-A · S/N 2-19Cancelled Oct 3, 1935 · Built 1929 · Danenberg Lawrence W N943YErhart Edwin/Wiemann Sherwood P T GLIDER · S/N 1Cancelled Feb 1, 1932 · Built 1930 · Erhart Edwin A/Wiemannsherwood D N2225Curtiss JN4D · S/N 34151Cancelled May 3, 1930 · Built 1918 · Whittelsey R A N59176Consolidated Vultee SNV-1 · S/N 5882 (05695)Cancellation date not recorded · Built 1942 · Mccurdy Richard F N68114Cessna UC-78 · S/N 3874Cancellation date not recorded · Lorenzen W C

Back to Huntington Park, CA