N847HK, cancelled Mar 10, 2025
Service difficulty reports · 161
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N847HK' AND deregistration_id = 'N847HK-2025-03-10' ORDER BY difficulty_date DESC"
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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N847HK' AND deregistration_id = 'N847HK-2025-03-10' ORDER BY difficulty_date DESC
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.
SDR RAIA201902240002Clamp · leakingBLEED 2 LEAK IN ICING CONDITIONS. REPLACE CLAMPS AT BLEED VALVE. OPS CHECK GOOD.SDR RAIA201812210008Doubler · corrodedRT LOWER PARTITION DOUBLER AT FRAME 61 IS CORRODED. REMOVED AND REPLACED RT LOWER DOUBLER AT FRAME 61 THIS IS AN UPDATE PUT WRONG CONTROL NUMBER USED RAIA201812210001 NOW IS RAIA201812210008.SDR RAIA201812190004Door Sill · corrodedRT SILL FROM FRAMES 58-61 HAS CORROSION. REMOVED AND REPLACED RT SILL FROM FRAMES 58-61.SDR RAIA201812190003Door Sill · corrodedLT SILL FROM FRAMES 58-61 HAS CORROSION. REMOVED AND REPLACED LT SILL FROM FRAMES 58-61.SDR RAIA201812180009Gusset · corrodedCENTER GUSSET AT FRAMES 58-61 HAS CORROSION. REMOVED AND REPLACED CENTER GUSSET AT FRAMES 58-61.SDR RAIA201812180008Gusset · corrodedLT GUSSET AE FRAMES 58-61 HAS CORROSION. REMOVED AND REPLACED L/H GUSSET AT FRAMES 58-61.SDR RAIA201812180007Gusset · corrodedRT GUSSET AT FRAMES 58-61 HAS CORROSION. REMOVED AND REPLACED RT GUSSET AT FRAMES 58-61.SDR RAIA201812110023Floor Support · corrodedAT FRAMES 71-73 RT FLOOR SUPPORT HAS CORROSION. REMOVED AND REPLACED RT FLOOR SUPPORT AT FRAMES 71-73.SDR RAIA201812110022Floor Support · corrodedLT OMEGA BEAM FROM FRAMES 53-58 HAS SIGNS OF CORROSION. REMOVED AND REPLACED LT OMEGA BEAM FROM FRAMES 53-58.SDR RAIA201812110021Support · corrodedLT CROSS SUPPORT AT FRAME 39 HAS SIGNS OF CORROSION. REMOVED AND REPLACED LT CROSS SUPPORT AT FRAME 39.SDR RAIA201812110020Gusset · corrodedLT GUSSET FROM FRAMES 53-58 HAS SIGNS OF CORROSION. REMOVED AND REPLACED LT GUSSET FROM FRAMES 53-58.SDR RAIA201812110019Floor Support · corrodedCENTER OMEGA BEAM FROM FRAMES 35-38 HAS CORROSION. REMOVED AND REPLACED CENTER OMEGA BEAM FROM FRAMES 35-38.SDR RAIA201812110018Fitting · crackedRT SHEAR CLIP AT FRAME 26 STRINGER 15R AND 16R IS CRACKED. REMOVED AND REPLACED SHEAR CLIP AT FRAME 26 STRINGER 15R AND 16R.SDR RAIA201812110017Gusset · corrodedCENTER GUSSET FROM FRAMES 53-58 HAS CORROSION. REMOVED AND REPLACED CENTER GUSSET FROM FRAMES 53-58.SDR RAIA201812110016Door Sill · corrodedLT SILL FROM FRAMES 53-58 HAS CORROSION. REMOVED AND REPLACED LT SILL FROM FRAMES 53-58.SDR RAIA201812110015Door Sill · corrodedLT SILL FROM FRAMES 41-48 HAS CORROSION. REMOVED AND REPLACED LT SILL FROM FRAMES 41-48.SDR RAIA201812110014Gusset · corrodedLT GUSSETT FROM FRAMES 35-38 HAS CORROSION. REMOVED AND REPLACED L/H GUSSETT FROM FRAMES 35-38.SDR RAIA201812110013Door Sill · corrodedLT SILL FROM FRAMES 35-41 HAS CORROSION. REMOVED AND REPLACED LT SILL FROM FRAMES 35-41.SDR RAIA201812110012Door Sill · corrodedRT SILL FROM FRAMES53-58 HAS CORROSION. REMOVED AND REPLACED SILL FROM FRAMES 53-58.SDR RAIA201812110011Gusset · corrodedLT GUSSETT FROM FRAMES 38-45 HAS CORROSION. REMOVED AND REPLACED LT GUSSETT FROM FRAMES 38-45.SDR RAIA201812110010Door Sill · corrodedRT SILL FROM FRAMES 29-35 HAS SIGNS OF CORROSION. REMOVED AND REPLACED RT SILL FROM FRAMES 29-35.SDR RAIA201812110009Floor Support · corrodedLT OMEGA BEAM FROM FRAMES 38-45 HAS CORROSION. REMOVED AND REPLACED LT OMEGA BEAM AT FRAMES 38-45.SDR RAIA201812110008Door Sill · corrodedLT FLOOR SILL AT FRAMES 61-65 HAS CORROSION. REMOVED AND REPLACED LT FLOOR SILL AT FRAMES 61-65.SDR RAIA201812110007Floor Support · corrodedAT FRAME 65-68R FLOOR SUPPORT HAS CORROSION. REMOVED AND REPLACE RT FLOOR SUPPORT AT FRAME 65-68.SDR RAIA201812110006Floor Support · corrodedAT FRAME 68-71 RT FLOOR SUPPORT HAS CORROSION. REMOVED AND REPLACED R/H FLOOR SUPPORT AT FRAMES 68-71.SDR RAIA201812110005Floor Support · corrodedAT FRAME 61-65 O/B OMEGA BEAM HAS CORROSION. REMOVED AND REPLACED O/B OMEGA BEAM ASSY AT FRAME 61-65.SDR RAIA201812110004Door Sill · corrodedRT FLOOR SILL AT FRAMES 61-65 HAS CORROSION. REMOVED AND REPLACED RT FLOOR SILL AT FRAMES 61-65.SDR RAIA201812110003Floor Support · corrodedCENTER OMEGA BEAM AT FRAME 61-71 HAS CORROSION. REMOVED AND REPLACED CENTER OMEGA BEAM ASSY AT FRAME 61-71.SDR RAIA201812110002Gusset · corrodedCENTER GUSSET FROM FRAMES 35-38 HAS CORROSION. REMOVED AND REPLACED CENTER GUSSET FROM FRAMES 35-38.SDR RAIA201812110001Channel · crackedCARGO DOOR TORSION ROD SUPPORT HAT CHANNEL IS CRACKED AT FRAME 61. REMOVED AND REPLACED CARGO DOOR ROD SUPPORT HAT CHANNEL.SDR RAIA201812100045Threshold · corrodedSERVICE DOOR THRESHOLD PLATE IS CORRODED. REMOVED AND REPLACED SERVICE DOOR THRESHOLD PLATE.SDR RAIA201812100044Support Angle · corrodedSUPPORT ANGLE AT FRAME 17-18 IS CORRODED. REMOVE AND REPLACE SUPPORT ANGLE AT FRAME 17-18.SDR RAIA201812100043Floor Support · corrodedLT OMEGA BEAM BETWEEN FRAMES 23-29 ARE CORRODED. REMOVED AND REPLACED LT OMEGA BEAM BETWEEN FRAMES 23-29.SDR RAIA201812100042Floor Support · corrodedCENTER OMEGA BEAM FROM FRAMES 23-29 HAS CORROSION. REMOVED AND REPLACED CENTER OMEGA BEAM FROM FRAMES 23-29.SDR RAIA201812100041Gusset · corrodedLT GUSSET FROM FRAMES 46-52 HAS CORROSION. REMOVED AND REPLACED LT GUSSET FROM FRAMES 46-52.SDR RAIA201812100040Floor Support · corrodedLT OMEGA BEAM FROM FRAMES 46-52 HAS CORROSION. REMOVED AND REPLACED LT OMEGA BEAM FROM FRAMES 46-52.SDR RAIA201812100039Door Sill · corrodedRT SILL FROM FRAMES 41-48 HAS CORROSION. REMOVED AND REPLACED RT SILL FROM FRAMES 41-48.SDR RAIA201812100038Support · corrodedRT CROSS SUPPORT AT FRAME 44 RT OMEGA BEAM TO RT SILL HAS CORROSION. REMOVED AND REPLACED RT CROSS SUPPORT AT FRAME 44 RT OMEGA BEAM TO RT SILL.SDR RAIA201812100037Support · corrodedLT UPPER SEAT TRACK SUPPORT AT FRAMES 29-35 HAS SIGNS OF CORROSION. REMOVED AND REPLACED LT UPPER SEAT TRACK SUPPORT AT FRAMES 29-35.SDR RAIA201812100036Door Sill · corrodedLT SILL AT FRAME 23-29 HAS CORROSION. REMOVED AND REPLACED LT SILL AT FRAMES 23-29.SDR RAIA201812100035Floor Support · corrodedCENTER OMEGA BEAM END CAP CORRODED AND FRAME 23. REMOVED AND REPLACED CENTER OMEGA BEAM END CAP AT FRAME 23.SDR RAIA201812100034Door Sill · corrodedLT SILL BETWEEN FRAMES 18-23 IS CORRODED. REMOVED AND REPLACED LT SILL BETWEEN FRAMES 18-23.SDR RAIA201812100033Fitting · crackedRT SHEAR CLIP AT FRAME 25 STRINGER 15R AND 16R IS CRACKED. REMOVED AND REPLACED RT SHEAR CLIP AT FRAME 25 STRINGER 15RAND 16R.SDR RAIA201812100032Fitting · crackedRT SHEAR CLIP AT FRAME 24 STRINGER 15R AND 16R IS CRACKED. REMOVED AND REPLACED RT SHEAR CLIP AT FRAME 24 STRINGER 15R AND 16R.SDR RAIA201812100031Door Sill · corrodedRT SILL AT FRAMES 23-29 HAS CORROSION. REMOVED AND REPLACED RT SILL AT FRAMES 23-29.SDR RAIA201812100030Door Sill · corrodedRT SILL FROM FRAMES 48-52 HAS CORROSION. REMOVED AND REPLACED RT SILL FROM FRAMES 48-52.SDR RAIA201812100029Structure · corrodedSTOP SIGN AT FRAME 20 RT OMEGA BEAM HAS CORROSION. REMOVED AND REPLACED STOP SIGN AT FRAME 20.SDR RAIA201812100028Floor Support · corrodedLT OMEGA BEAM FROM FRAMES 35-38 IS CORRODED. REMOVE AND REPLACE LT OMEGA BEAM FROM FRAMES 35-38.SDR RAIA201812100027Floor Support · corrodedRT CROSS SUPPORT BETWEEN CENTER AND RT OMEGA BEAM AT FRAME 44 SHOWS SIGNS OF CORROSION. REMOVED AND REPLACED RT CROSS SUPPORT BETWEEN CENTER AND RT OMEGA BEAM AT FRAME 44.SDR RAIA201812100026Door Sill · corrodedLT SILL FROM FRAMES 48-52 HAS CORROSION. REMOVED AND REPLACED LT SIKLL FROM FRAMES 48-52.
Back to N847HK, cancelled Mar 10, 2025