Cancelled registrations · 20

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 = 'OK' AND d.registrant_city = 'BLACKWELL' 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 = 'OK' AND d.registrant_city = 'BLACKWELL'
  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 = 'OK' AND d.registrant_city = 'BLACKWELL'
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.

N5560LRaven Industries RALLY RX7 · S/N RX7-161Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1979 · Gasbag International Airways Ltd N107BGOklahoma Light SPORT HORNET · S/N 071Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Oklahoma Light Aircraft LLC N714WXCessna 152 · S/N 15279500Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1977 · Brown Lari N4227PPiper PA-23-160 · S/N 23-1723Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1959 · Million Tom L N73949Bell 47J-2 · S/N 2837Cancelled May 30, 1996 · Exported to Greece · Stettnisch Jerry A DBA N5154JCessna 172N · S/N 17273716Cancelled Sep 23, 1992 · Triennial form not returned · Kice David J N9576ACessna 170A · S/N 19137Cancelled Jan 16, 1952 · Mcculloch Doyle N645CStinson 108-3 · S/N 108-3645Cancelled Jun 2, 1949 · Blackwell Aircraft Sales N72835Cessna 140 · S/N 10024Cancelled May 2, 1949 · Mauk Walter D N33273Piper J5A · S/N 5-474Cancelled May 8, 1943 · Walter D Mauk N4535Travel Air 2000 · S/N 390Cancelled May 20, 1940 · Walter D Mauk N196VCessna CG-2 · S/N 68Cancelled Mar 8, 1933 · Blackwell Glider Club N1600Swallow SWALLOW · S/N 131Cancelled Jan 11, 1933 · Built 1927 · Varner Everett E N144VCessna GC-1 · S/N 249Cancelled Apr 4, 1932 · Skyways Inc N162KMonocoupe 113 · S/N 356Cancelled Apr 4, 1932 · Built 1930 · Lynn John B N4805Ford 4-AT-B · S/N 17Cancelled Apr 4, 1932 · Skyway Inc N435WTravel Air B-4000 · S/N 1328Cancelled Mar 22, 1932 · Lee Orville N4251Travel Air 5000 · S/N 170Cancelled Apr 13, 1931 · Built 1927 · Lee O J N1378Travel Air Manufacturing BIPLANE · S/N 137Cancelled May 10, 1928 · Lee Orville N59532Piper J4E · S/N 4-1644 (43-3006) ARMYCancellation date not recorded · Built 1943 · North G H

Back to Blackwell, OK