Idaho Falls, ID
Cancelled registrations · 84
Query with SQL
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 = 'IDAHO FALLS' 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 = 'IDAHO FALLS' 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.
N1786HSchraeder Jim SPIRIT XL · S/N 2930N7222SCessna 150H · S/N 15067922N7525YCameron Balloons US N-90 · S/N 5859N352GLLoucks Gary D SH 2 · S/N 305N23CHPiper PA-23-250 · S/N 27-7405274N56KJPilatus PC-12/47E · S/N 1431N79JWWoehl Jack L KITFOX · S/N 186N7750TSteven Barnard OUTCAST CUB · S/N 2018-02N830SSPiper PA-30 · S/N 30-1958N141ZXPowrachute PC 2000 · S/N A-322 POWN2695WMooney M20E · S/N 1010N3705PPiper PA-22-150 · S/N 22-3421N13TJTherp Todd J ACRO SPORT II · S/N 519804049N7DNNapper David H BUSHBY MUSTANG 1 · S/N 1056N1605YPowrachute AIRWOLF · S/N A056ULSN191TPBeech C90A · S/N LJ1223N28317Interstate S-1A · S/N 9N39377Richardson John G VARIEZE · S/N K48700543AN8160BPiper PA-32-301 · S/N 32-8024007N73872Bell 47G · S/N CCI-263N446DMBeech E18S · S/N BA-330N9740XCessna 210B · S/N 21058040N17339Aero Commander CALLAIR A-9B · S/N 1419N8297HCallair A-9 · S/N 1166N84813Aeronca 7CCM · S/N 7AC-3527N7347ECessna 210 · S/N 57047N37418Callair S-1A-90F · S/N 261N82ZBeech E35 · S/N D-3942N57231Raven S-60A · S/N S60A-163N4954ZPiper PA-22-108 · S/N 22-8553N4606UCessna TU206G · S/N U20604998N3978EAeronca 11BC · S/N 11-BC-63N384TBSocata TB-20 TRINIDAD · S/N 1730N45926Luscombe 8A · S/N 2453N2070AStone DR Leslie H KITFOX SERIES 6 · S/N S60009-037N5PQPiper Thomas C MURPHY REBEL · S/N 113N235TSCessna T182T · S/N T18208418N7378ACessna A150M · S/N A1500727N250RKKnowles Robert H VARI-EZE · S/N 1940N25435Cessna 152 · S/N 15280657N4407MPoulter Edwin F ROTEC RALLY 3 · S/N 25253N58717Cessna 182P · S/N 18262255N219HYAviat A-1B · S/N 2219N50124Beech F33A · S/N CE-535N3RCrawford Timothy L WIDEBODY LONG EZ · S/N 2N297ALGrumman Acft ENG Cor-Schweizer G-164B · S/N 188BN13ADReich Alan O AERO DART · S/N AD0000N11PUAero Design Eleven 11 · S/N ADE 0001N8451LPiper PA-28RT-201T · S/N 28R-8131064N2336XPiper PA-31T · S/N 31T8120002
Back to Idaho Falls, ID