Skip to content

Cancelled registrations · 198

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 = 'OR' AND d.registrant_city = 'HILLSBORO' 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 = 'OR' AND d.registrant_city = 'HILLSBORO'
  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 = 'OR' AND d.registrant_city = 'HILLSBORO'
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.

N609BJBucker Jungmann C.A.S.A. 1.131 · S/N E3B-609Cancelled Dec 4, 2024 · Exported to Brazil · Built 1963 · Antique Aircraft Inc N3074PPiper PA-44-180 · S/N 44-7995236Cancelled Feb 8, 2024 · Hillsboro Aero Academy LLC N6719PPiper PA-24-250 · S/N 24-1846Cancelled Jan 27, 2024 · Sale reported, canceled · Built 1960 N6308QCessna 152 · S/N 15285227Cancelled Dec 26, 2023 · Built 1981 · Hillsboro Aero Academy LLC N8360KPiper PA-44-180 · S/N 44-8195018Cancelled Dec 26, 2023 · Built 1981 · Hillsboro Aero Academy LLC N515CKRaytheon B200 · S/N BB-1726Cancelled Dec 13, 2023 · Exported to Brazil · Built 2000 · Hillsboro Aviation Inc N80CTCessna 152 · S/N 15282491Cancelled Mar 11, 2023 · Built 1978 · Hillsboro Aero Academy LLC N9066FPaul Gaywood E CH 601 HD · S/N 6-4188Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 2004 · Robb Ian B N596LSDJI PHANTOM 2 VISION + · S/N CA250939081944Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Clean Water Services N306CMEmbraer EMB-550 · S/N 55000035Cancelled Dec 29, 2021 · Exported to Malta · Built 2016 · C & M Premier LLC N547LMRaytheon B200 · S/N BB1642Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1998 · Corsair Two LLC N478ERCessna 172R · S/N 17280623Cancelled Aug 2, 2021 · Built 1998 · Hillsboro Aero Academy LLC N564WCDJI PHANTOM 2 VISION + · S/N CB112218208164Cancelled May 4, 2021 · Second renewal notice · Clean Water Services N2YKYakovlev YAK 52 · S/N 9311703Cancelled Feb 11, 2021 · Third renewal notice · Built 1993 · Classic Aircraft Aviation Museum Inc N486ARArney Neil VANS RV6 · S/N 23995Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 2008 · Twin Oaks Airpark Inc N7892PPiper PA-24-250 · S/N 24-3121Cancelled Feb 20, 2020 · First renewal notice · Built 1962 · Twin Oaks Airpark Inc N8UJAerospatiale AS350 B2 ECUREUIL · S/N 2408Cancelled Oct 21, 2019 · Exported to Fiji · Vertol Systems Company Inc N25PJGates Lear Jet 25B · S/N 111Cancelled Oct 7, 2019 · Second renewal notice · Built 1973 · Premier Jets Inc N64895Cessna 152 · S/N 15281461Cancelled Sep 24, 2019 · Built 1978 · Hillsboro Aero Academy LLC N7526SRobinson Helicopter R22 BETA · S/N 3584Cancelled Jun 12, 2019 · Built 2004 · Hillsboro Aero Academy LLC N8361NRobinson Helicopter R22 BETA · S/N 2901Cancelled Jun 12, 2019 · Built 1998 · Hillsboro Aero Academy LLC N28721Piper PA-44-180 · S/N 44-7995296Cancelled Apr 18, 2019 · Hillsboro Aero Academy LLC N756ZDouglas DC-7BF · S/N 45400Cancelled Feb 27, 2019 · Third renewal notice · Built 1957 · Aero Air LLC N594GEHorizon Hobby 350 QX3 AP · S/N 1234567Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Eaton Bradley S N74325Bellanca 14-13-2 · S/N 1438Cancelled Dec 3, 2018 · Sale reported, canceled N22LGGreene PAZMANY PL-1 · S/N 237Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1990 · Coolidge Marvin L N161ALRockwell International 690A · S/N 11210Cancelled Jan 30, 2018 · First renewal notice · Built 1974 · Aero Air LLC N700SGCessna 310L · S/N 310L-0203Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1967 · Kaufmann Delbert A N294CDElford Jon R VANS RV-7 · S/N 72471Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Elford Jon R N158LGAmerican Blimp A-1-50 · S/N 108Cancelled Jan 10, 2018 · Registration expired, pending cancellation · American Blimp Corporation N42014Cessna 182L · S/N 18258808Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1968 · Gorman Jack N1898Paxton Paul RIDGERUNNER III · S/N 1898Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 2007 · Seurer Henry V N485ERPiper PA-44-180 · S/N 44-7995223Cancelled Dec 8, 2017 · Second renewal notice · Built 1979 · Hillsboro Aero Academy LLC N124MBBamberg Michael Lee BAMBERG HP-15/18 · S/N MB-2Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Bamberg Michael L N5440HCessna 172M · S/N 17265438Cancelled Sep 27, 2017 · First renewal notice · Built 1975 · Twin Oaks Airpark Inc N623LGAmerican Blimp A-60+ · S/N 023Cancelled Jul 14, 2017 · Registration expired, pending cancellation · American Blimp Corporation N622LGAmerican Blimp A-60+ · S/N 022Cancelled Jul 12, 2017 · Registration expired, pending cancellation · American Blimp Corporation N542DShuff Doug MINI-500 · S/N 245Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Shuff Doug W N2548SRobinson Helicopter R22 BETA · S/N 0607Cancelled May 23, 2017 · Registration expired, pending cancellation · Hillsboro Aviation Inc N71131Yakovlev YAK-55M · S/N 950504Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Mad Par Aviation Inc N72111Yakovlev YAK-55M · S/N 950505Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Mad Par Aviation Inc N72811Yakovlev YAK-55M · S/N 950507Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Mad Par Aviation N71034Yakovlev YAK-55M · S/N 950506Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Mad Par Aviation N71435Yakovlev YAK-55M · S/N 950503Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Mad Par Aviation Inc N227SHRobinson Helicopter R22 BETA · S/N 4009Cancelled Mar 28, 2017 · Built 2006 · Hillsboro Aero Academy LLC N714WNCessna 152 · S/N 15279491Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1977 · Ebner Michael E N66RVVangrunsven Richard/Diane RV-6 · S/N 1Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1988 · Vangrunsven Richard E N450WWCessna 421 · S/N 421-0080Cancelled Jun 23, 2016 · Third renewal notice · Built 1968 · Hendrickson Del R N6515RCessna 172RG · S/N 172RG0188Cancelled Dec 19, 2015 · Built 1979 · Hillsboro Aero Academy LLC N220ZThiele James R OZ BALLOONS AX-8 · S/N 002Cancelled Dec 3, 2015 · Third renewal notice · Built 1980 · Thiele James R

Back to Hillsboro, OR