Fairbanks, AK
Cancelled registrations · 776
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 = 'AK' AND d.registrant_city = 'FAIRBANKS' 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 = 'FAIRBANKS' 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.
N513XCCub Crafters CC19-180 · S/N CC19-0024N7170AMorgan Edward L EDGE X 582 · S/N 582-646N756MRCessna TU206G · S/N U20604204N5154HCessna T182T · S/N T18208115N9027KFairchild C-119 · S/N 53-8073N1980PRhynalds Don J PITTS S-1S · S/N DR2N437PRCrisenbery Richard NORTHSTAR 6 · S/N 601N7529MRobinson Helicopter R44 · S/N 1224N9330DPiper PA-22-160 · S/N 22-6347N2002YTaylorcraft F19 · S/N F-143N974DLMcdonnell Douglas MD-88 · S/N 53242N2822TSchauer William A JR STARDUSTER TOO SA300 · S/N 661N5454ECessna A185F · S/N 18503974N7455KPiper PA-20 · S/N 20-366N911AYEurocopter Deutschland EC135T1 · S/N 0065N1864GChampion 7KCAB · S/N 96N40573Piper PA-18-150 · S/N 18-7709016N9272UMorgan William E NORTH WING · S/N NWA6002002MN337WBCessna T337B · S/N 337-0700N60476Ruess Roger W XT-912-B · S/N XT-912-60N4667CCessna 170B · S/N 25611N6174CDouglas DC-6A · S/N 44075N56ATArctic S-1B2 · S/N 1007N322KBHughes Helicopters HUGHES 369D · S/N 1280401DN1695DCessna 170B · S/N 20337N170UADouglas DC-6A · S/N 45518N500UADouglas DC-6A · S/N 44597N247UAInsitu SCANEAGLE · S/N 06-245N2356VCessna 140 · S/N 14592N8054JPiper AEROSTAR 601 · S/N 61-0537-132N3142MPiper PA-12 · S/N 12-1597N6314VHelio H-250 · S/N 2534N812CEAir Tractor AT-802 · S/N 802-0494N457RMDehavilland DHC-2 MK.I · S/N 780N129DRNorth American T-28A · S/N 944N970UAAlaska CTR For Unmanned Acft F450 · S/N ACUASI 450-1N971UAAlaska CTR For Unmanned Acft F550 · S/N ACUASI550-1N13DYAviat A-1 · S/N 1392N511CCRobinson Helicopter R44 II · S/N 10173N371PTDJI PHANTOM 3 ADVANCED · S/N P76DCJ18A20909N372PTDJI MAVIC PRO · S/N 08QDE4T01203WVN127EGScott Reymiller EG2 · S/N 002N3473BBeech E35 · S/N D-3699N28626Luscombe 8A · S/N 1455N4073QRobinson Helicopter R22 BETA · S/N 1857N888DGDouglas C-118A · S/N 44675N500LWHughes Helicopters HUGHES 369D · S/N 470120DN562RENorth Wing APACHE · S/N RE044N990LBPiper PA-34-200T · S/N 34-7970235N15LELaflin Lloyd LAFLIN LLOYD · S/N 826-320-668SFB
Back to Fairbanks, AK