Skip to content

Cancelled registrations · 250

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 = 'WA' AND d.registrant_city = 'BELLINGHAM' 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 = 'WA' AND d.registrant_city = 'BELLINGHAM'
  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 = 'WA' AND d.registrant_city = 'BELLINGHAM'
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.

N4031LEurocopter AS 350 B2 ECUREUIL · S/N 2907Cancelled Jan 24, 2020 · Exported to Canada · Built 1995 · Kenmore Crew Leasing Inc Trustee N5530GCessna 150J · S/N 15071030Cancelled Dec 3, 2019 · Exported to Argentina · Built 1969 · Kenmore Crew Leasing Inc Trustee N8841RDowner BELLANCA 14-19-3 · S/N 4195Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Carmack John N20547Taylorcraft A · S/N 556Cancelled Nov 15, 2019 · Revoked, canceled · Built 1938 · Sharp T W N484EJPiper PA-22-135 · S/N 22-1860Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1954 · Archambault Michael E Jr N673XMDJI PHANTOM 3 PROFESSION · S/N P76DCD27010990Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Amorterra LLC N4036HEurocopter AS 350 B2 · S/N 2919Cancelled Oct 8, 2019 · Exported to Canada · Built 1996 · Kenmore Crew Leasing Inc Trustee N34AZRolladen-Schneider OHG LS3-A · S/N 3349Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1979 · Axelson John R N511TLGulfstream Aerospace G1159B · S/N 199Cancelled Aug 8, 2019 · Exported to Mexico · Built 1977 · Kenmore Crew Leasing Inc Trustee N652LFDJI PHANTOM 3 PROFESSION · S/N P76DCH23A20024Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Eagle-Eye Aerial Solutions LLC N321MHHawker Beechcraft C90GTI · S/N LJ-2053Cancelled Apr 23, 2019 · Exported to Brazil · Kenmore Crew Leasing Inc Trustee N4043DRobinson Helicopter R44 · S/N 0817Cancelled Feb 25, 2019 · Exported to Australia · Built 2000 · Kenmore Crew Leasing Inc Trustee N805JMCessna 208B · S/N 208B0485Cancelled Feb 5, 2019 · Exported to Chile · Kenmore Crew Leasing In Trustee N517NMCessna 208B · S/N 208B0728Cancelled Dec 11, 2018 · Exported to Costa Rica · Built 1999 · Kenmore Crew Leasing Inc Trustee N853DCHawker Beechcraft 390 · S/N RB-255Cancelled Dec 7, 2018 · Exported to Germany · Kenmore Crew Leasing Inc Trustee N803PBEmbraer EMB-145LR · S/N 14500803Cancelled Oct 26, 2018 · Exported to Ethiopia · Kenmore Crew Leasing Inc Trustee N537YWAeromao AEROMAPPER · S/N AMEV2 010Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Western Washington University N29721Taylorcraft BC12-65 · S/N 2568Cancelled Aug 18, 2018 · Registration pending, canceled · Built 1941 N537ZWAeromao AEROMAPPER · S/N AMEV2-009Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Western Washington University N795PBEmbraer EMB-145LR · S/N 145795Cancelled Aug 6, 2018 · Exported to Ethiopia · Built 2004 · Kenmore Crew Leasing Inc Trustee N537XWAeryon Labs SCOUT · S/N SN000019Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Western Washington University N9337FHughes 269B · S/N 0041Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1964 · Adrenalin Airshows Inc N863RSPiper PA-34-220T · S/N 3449499Cancelled Jan 17, 2018 · Exported to Brazil · Built 2014 · Kenmore Crew Leasing Inc Trustee N2549TNavion NAVION H · S/N NAV-4-2549Cancelled Jan 16, 2018 · Built 1970 · Snowie J Allan N662CPCirrus Design SR20 · S/N 2309Cancelled Dec 12, 2017 · Exported to Bolivia · Kenmore Crew Leasing Inc Trustee N15985Embraer EMB-145LR · S/N 145248Cancelled Dec 5, 2017 · Exported to Guatemala · Built 2000 · Kenmore Crew Leasing Inc Trustee N5513PPiper PA-24-250 · S/N 24-576Cancelled Nov 21, 2017 · Revoked, canceled · Built 1958 · Fisher William N733ZXCessna 172N · S/N 17268689Cancelled Oct 6, 2017 · Exported to Guatemala · Built 1977 · Kenmore Crew Leasing Inc Trustee N5071MTaylorcraft BC12-D · S/N 10371Cancelled Apr 26, 2017 · Sale reported N642DEMacleod Malcolm J BOWERS FLYBABY 1 · S/N 88-3Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1991 · Clarke David P N7489ZJohnson J W/Johnson V M ZODIAC CH 601 HD · S/N 63136Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1997 · Hahn Allen H N203RHBell 206L-3 · S/N 51520Cancelled Mar 2, 2017 · Exported to Guatemala · Built 1991 · Kenmore Crew Leasing Inc Trustee N118PSSieber Paul P NIEUPORT 11 · S/N 009Cancelled Dec 21, 2016 · Exported to Canada · Built 2003 · Snowie J Allan N110DKKesterson Clayton C NIEUPORT 11 · S/N 006Cancelled Dec 20, 2016 · Exported to Canada · Built 2002 · Snowie Joseph Allan N6610CBell 206L-3 · S/N 51425Cancelled Oct 8, 2015 · Exported to Guatemala · Built 1991 · Kenmore Crew Leasing Inc Trustee N1308Piper PA-31T2 · S/N 31T-8166008Cancelled Jul 15, 2015 · Exported to Canada · Built 1981 · Kenmore Crew Leasing Inc Trustee N461RSikorsky S-61R (CH-3E) · S/N 69-05805Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1970 · Glacier Helicopter Inc N462RSikorsky S-61R (CH-3E) · S/N 67-14715Cancelled May 12, 2015 · Registration expired, pending cancellation · Glacier Helicopter Inc N96MHHolstine Mark W KITFOX · S/N 101Cancelled May 11, 2015 · Sale reported, canceled N96ZGauthier Sport 1 · S/N 1Cancelled Mar 24, 2015 · Built 1962 · Gauthier David J N210XCessna 210L · S/N 210-60803Cancelled Feb 23, 2015 · Exported to Brazil · Built 1975 · Kenmore Crew Leasing Inc Trustee N39221Girard Richard N SENSOR 510 · S/N GIRARD 1Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Girard Richard N N91ERJohnson R W / Read J M RV-4 · S/N 884Cancelled Dec 3, 2014 · Exported to Brazil · Kenmore Crew Leasing Inc Trustee N3214YBeech B36TC · S/N EA-571Cancelled Dec 1, 2014 · Exported to Brazil · Built 1994 · Kenmore Crew Leasing Inc Trustee N63531Cessna 150M · S/N 15077376Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1975 · Wight Marine Services Co Inc N5358WPiper PA 46-350P · S/N 4636344Cancelled Oct 20, 2014 · Exported to Brazil · Built 2003 · Kenmore Crew Leasing Inc Trustee N1408APiper PA-22 · S/N 22-319Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1951 · Redding R A N782DGPiper PA46R-350T · S/N 4692096Cancelled Aug 27, 2014 · Exported to Brazil · Kenmore Crew Leasing Inc Trustee N3186ZMaule MXT-7-180 · S/N 14069CCancelled Jun 17, 2014 · Exported to Canada · Coltran Richard L N427DCLearjet 45 · S/N 2079Cancelled Oct 28, 2013 · Exported to Brazil · Built 2007 · Kenmore Crew Leasing Inc

Back to Bellingham, WA