Skip to content

Cancelled registrations · 107

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 = 'ID' AND d.registrant_city = 'POCATELLO' 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 = 'ID' AND d.registrant_city = 'POCATELLO'
  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 = 'ID' AND d.registrant_city = 'POCATELLO'
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.

N251ZABell OH-58C · S/N 72-21397Cancelled Jan 18, 2025 · Registration pending, canceled N969YBLeading Edge Aerial Tech PV35X · S/N 3264Cancelled Dec 23, 2024 · Bannock County N97182Stinson 108 · S/N 108-182Cancelled Dec 30, 2023 · Revoked, canceled · Built 1946 · Caraon Lyle C N6547RPowrachute PEGASUS · S/N A273PEGCancelled Dec 11, 2023 · Sale reported, canceled N11255Waco RNF · S/N 3458Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Gregerson Scott T N11464Waco INF · S/N 3451Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Gregersen Scott T N5822Waco GXE · S/N 1495Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Gregersen Scott T N604YWaco RNF · S/N 3323Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Gregersen Scott T N6494Stearman C3-B · S/N 192Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Gregersen Scott T N806MWaco ASO · S/N 3051Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Gregersen Scott T N82KPerth Amboy BIRD BK · S/N 2005-56Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Gregersen Scott T N4265EPiper PA-38-112 · S/N 38-78A0513Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1978 · Idaho State University N4315APiper PA-22-150 · S/N 22-3667Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Dobbins Darin S N960RPPatterson Robert J IDAHO MOUNTAIN BLUEB · S/N BP-001Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Patterson Robert J N74368Bellanca 14-13-2 · S/N 1481Cancelled Sep 27, 2019 · Registration pending, canceled · Built 1947 N52743Cessna 182P · S/N 18262813Cancelled Apr 15, 2019 · Built 1974 · Teton Leasing LLC N207SUSteadidrone PTY QU4D X · S/N ISU003Cancelled Jan 30, 2019 · Registration expired, pending cancellation · Idaho State University N205SUMicro Aerial Projects ISU HEX · S/N ISU001Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Idaho State University N204SUSteadidrone PTY QU4D · S/N ISU002Cancelled Aug 9, 2018 · Registration expired, pending cancellation · Idaho State University N9168KStinson 108-1 · S/N 108-2168Cancelled Jul 13, 2018 · Registration expired, pending cancellation · Built 1947 · Rudolph Terry A N4040VStinson 108-1 · S/N 108-1376Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1946 · Rudolph Terry A N43388Taylorcraft BC12-D · S/N 7047Cancelled Mar 22, 2018 · Registration expired, pending cancellation · Built 1946 · Howlett H C II N3441VCessna 195 · S/N 7145Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1948 · Techstar Inc N366SBFairchild F-27F · S/N 97Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1963 · Idaho State University N2337HEngineering & Research ERCOUPE 415-C · S/N 2962Cancelled Oct 28, 2017 · Revoked, canceled · Built 1946 · Clark Duane N7392ECessna 210 · S/N 57092Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1960 · Idaho State University N20650Cessna 172M · S/N 17261462Cancelled Jul 25, 2017 · First renewal notice · Built 1973 · Idaho State University N88ATPiper AEROSTAR 602P · S/N 62P08628165003Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1981 · Skyline Ranch Investment Co N2981QCameron Balloons N-105 · S/N 5173Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Built 1985 · Fun Air Balloon LLC N99587Ercoupe 415-C · S/N 2210Cancelled Jan 20, 2016 · Third renewal notice · Neves Kenda N6127KRepublic RC-3 · S/N 313Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1947 · Idaho State University N652AMAircraft Mfg & Development CH 2000 · S/N 20-1022Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 2003 · Beasley Allen A N1877GChampion 7KCAB · S/N 108Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1968 · Northwest Aviation Inc N59595Ira Munn SERAPH · S/N 001Cancelled Aug 27, 2013 · Sale reported, canceled N23102Dehavilland DH115 VAMPIRE · S/N 865Cancelled Aug 22, 2013 · Sale reported, canceled N47075Breiter AEROSPORT QUAIL · S/N EB-1Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1976 N588WWilliams Oliver E DYKE DELTA JD-2 · S/N 1064Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1982 · Williams Oliver E N19DGGregersen A-1TC · S/N 1Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1971 · Gregersen Richard P N26972Cessna 320E · S/N 320E-0061Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1967 · Dammire Co N78963Breiter Edward HAWK · S/N EB-4Cancelled Jul 30, 2013 · Sale reported, canceled N36BBSmith Elmer W AF86-1 · S/N 54Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Smith Elmer W N5833RCorbridge Ken ROTEC RALLY 3 · S/N 25454Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Idaho Investment & Leasing Co DBA N933JBWalton Jerry B S1 PITTS · S/N 3Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Walton Jerry B N824LQCessna 421 · S/N 421-0135Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1968 · Idaho State University N714PMCessna A185F · S/N 18504408Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1983 · Northwest Pipeline Corp N801RDPatton MEYERS STX12 · S/N PAT76-001Cancelled Apr 26, 2013 · Sale reported, pending cancellation N5196NBoeing E75 · S/N 75-5780Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1944 N56768Boeing A75N1(PT17) · S/N 75-4796Cancelled Jan 31, 2013 · Sale reported, canceled · Built 1943 N36305Taylorcraft BC-65 · S/N 3223Cancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1941 · Gregersen Dick N31620Howard DGA-18 · S/N 622Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Gregersen Dick

Back to Pocatello, ID