Skip to content

Cancelled registrations · 32

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 = 'AK' AND d.registrant_city = 'BARROW' 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 = 'AK' AND d.registrant_city = 'BARROW'
  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 = 'AK' AND d.registrant_city = 'BARROW'
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.

N1086APiper PA-18 · S/N 18-672Cancelled Dec 30, 2023 · Sale reported, canceled · Built 1951 N31310Douglas DC3 · S/N 12431Cancelled Dec 19, 2023 · Revoked, canceled · Built 1944 · United States Navy Owner N172WKCessna 172H · S/N 17255250Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1966 · Patkotak R Crawford A N9928TCessna 182D · S/N 18253028Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Built 1960 · Lowery Jerry E N84549Cessna 172K · S/N 17258518Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1969 · Patkotak Crawford A N4048BDehavilland DHC-6 TWIN OTTER · S/N 125Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1968 · Ehredt M O N4711QCessna A185E · S/N 185-1165Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1966 · Felder Leonard N62453Stinson L-5 · S/N 76-247Cancelled Aug 5, 2013 · Revoked, canceled · Built 1943 · Ehredt M O N3366ZPiper PA-22-150 · S/N 22-7307Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1960 · Wiseman David B N94678Cessna 152 · S/N 15285760Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1983 · Sovereign Ltd N6439XCessna 180D · S/N 18050939Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1960 · Coffin Robert H N651MCPiper PA-23-250 · S/N 27-2673Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1964 N722NRDouglas DC3-S · S/N 43342Cancelled Oct 16, 2012 · Sale reported, pending cancellation · Built 1951 N786SRBeech B200 · S/N BB-1016Cancelled Jun 20, 2012 · First renewal notice · Built 1982 · North Slope Borough N785SRBell Helicopter Textron 206L-1 · S/N 45526Cancelled Apr 1, 2004 · Triennial form not returned · Built 1980 · North Slope Borough N3542HPiper PA-31-350 · S/N 31-7952233Cancelled Sep 19, 2001 · Triennial form not returned · Cape Smythe Air Service Inc N110JKPiper PA-31T3 · S/N 31T-8375005Cancelled Jun 11, 2001 · Triennial form not returned · Cape Smythe Air Service Inc N220CSPiper PA-31T3 · S/N 31T8275013Cancelled Dec 12, 2000 · U S Bancorp Leasing & Financial N218CSPiper PA-31T3 · S/N 31T-8275016Cancelled Feb 17, 1999 · Triennial form not returned · Cape Smythe Air Service Inc N61500Cessna A185F · S/N 18504217Cancelled Apr 15, 1998 · Triennial form not returned · Cape Smythe Air Service Inc N4109EPiper PA-31-350 · S/N 318353003Cancelled Aug 16, 1996 · Triennial form not returned · Cape Smythe Air Service Inc N9961DPiper PA-22-150 · S/N 226752Cancelled Jun 14, 1995 · Triennial form not returned · Sessom Jody R N21369Cessna A185F · S/N 18503055Cancelled Jan 8, 1985 · Administratively canceled · Cape Smythe Air Service N7301UCessna 207A · S/N 20700390Cancelled Mar 1, 1982 · Mythe Air Service Inc N64605Douglas C-47 · S/N 17217Cancelled Jun 4, 1981 · Naval Arctic Research Laboratory N6900MStinson 108-3 · S/N 108-4900Cancelled May 8, 1981 · Schraer David J N3978GCessna U206 · S/N U206-0978Cancelled Feb 10, 1972 · Built 1967 · Ehredt M O N8791DPiper PA-18A 150 · S/N 18-6332Cancelled Dec 23, 1971 · Oliver J Smith N3370BPiper PA-18A-135 · S/N 18-3493Cancelled Dec 31, 1970 · Riedel George Madison N6899KPiper PA-20 · S/N 20-672Cancelled Jan 19, 1966 · James W Helmricks N4440MPiper PA-12 · S/N 12-3393Cancelled May 22, 1965 · Bills Paul E N515NCurtiss Robertson ROBIN J-1 · S/N 709Cancelled Oct 18, 1955 · Fess E Stangl

Back to Barrow, AK