JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 jasc_code = '5311' 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 jasc_code = '5311' 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 SWAA083881Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 13R. REPAIRED FRAME PER SWA EA.SDR GLB2008F00002Frame · crackedFRAME CRACKED AT STRINGER CUTOUT AT FS 164 STRINGER 9AR APPROXIMATELY 1.25 INCH IN LENGTH. MAINT REPAIRED CRACK AT STRINGER RELIEF HOLE FS 164, STRINGER 9R, REPAIR APPROXIMATELY 5.5 INCH X 2.5 INCH. 2024-T3, .071. RII INSPECTION COMPLIED WITH IAW TASKCARD 8.SDR 2008UALA03857Frame · damagedFUSELAGE FRAME 196.5 CRACKED AND BUCKLED FROM DAMAGE FROM TOW TRACTOR. *S/D* MAJOR REPAIR. REPLACED UPPER AND LOWER FRAME CAPS AND WEB.SDR SWAA083818Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083823Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083821Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083819Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083817Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083820Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083854Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER SWA EA.SDR 2008UALA03868Frame · dentedAFT PIT FRAME DENTED AT INBOARD FLANGE, BS 1400 BETWEEN STR 15L-26L. ACCOMPLISHED MAJOR REPAIR. CUT OUT FRAME DAMAGE AND INSTALLED DOUBLER REPAIR PER SRM 53-00-07, REPAIR 5.SDR 08FDEA02827Frame · damagedINTERIOR FUSELAGE STA 344 STRINGER TIE AT STR 7R HAS 02 FASTENERS WITH "O" ED. REMOVED STRINGER TIE IAW B727 SRM 51-30-2, CUT OUT DAMAGE FRAME DIM 1.5 X 5/8 IAW B727 SRM 53-10-4 FIG 2. FABRICATED NEW STRINGER TIE FROM 7075T6 .032 DIM 3 X 3.75. FRAME REPAIR SDR USAA920081341Frame · crackedCLT -MAJOR REPAIR- Q3 CHECK - CRACKED FRAME, BS 747, S8R -S9R. REPAIRED FRAME, BS 747, S8R - S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E. (B)SDR 2008UALA03820Frame · dentedAFT PIT AT STA 1480 BETWEEN, STR 25L AND STR 26L, FRAME DENTED AT INBOARD FLANGE. ACCOMPLISHED MAJOR REPAIR AT GSO. CUT OUT DAMAGED FROM FRAME AND INSTALLED DOUBLER RPR PER SRM 53-00-07, RPR 5.SDR 2008UALA03819Frame · dentedAFT PIT FRAME IS DENTED AT INBOARD FLANGE AT BS 1380, STR 26L. ACCOMPLISHED MAJOR REPAIR AT GSO. CUT OUT DAMAGE AND INSTALLED DOUBLER RPR PER SRM 53-00-07, RPR 5.SDR 2008UALA03818Frame · dentedAFT PIT LT SIDE SLANT AREA HAS DENTED FRAME STA 1580 BETWEEN STR 26L AND 27L. ACCOMPLISHED MAJOR REPAIR AT GSO. CUT OUT DAMAGE AND INSTALLED DOUBLER RPR PER SRM 53-00-07, RPR 5. CREATED FOR REQUIRED REINSPECTIONS.SDR 2008UALA03817Frame · dentedAFT PIT FRAME DENTED AT INBOARD FLANGE, BS 1420 BETWEEN STR 25L - 26L, 2 PLACES. ACCOMPLISHED MAJOR REPAIR AT GSO. CUT OUT DAMAGE AND INSTALLED DOUBLER RPR PER SRM 53-00-07, RPR 5. CREATED FOR REQUIRED REINSPECTIONS.SDR CALA0800701Frame · crackedFRAME CRACKED STATION 747 AT S-9L. INSTALLED REPAIR ON FRAME AT STATION 747 S-9L PER EA 5310-04498.SDR CALA0800696Frame · crackedFRAME CRACKED STATION 907 AT S-9L. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED REPAIR DOUBLERS PER EA 5310-04498 OP 2.SDR 08FDEA02816Frame · corrodedCENTER WING LOWER BARREL INTERNAL FRAME AFT FACE LOWER FLANGE HAS CORROSION JUST BELOW THE BLEED AIR DUCT; FS 1381; STRINGER 51R TO STRINGER 51L. REMOVED CORROSION. ORIGINAL THICKNESS, 0.080. MATERIAL LOSS IS 0.029. REMAINING THICKNESS 0.051 IAW SRM 53-00-SDR 2008UALA03808Frame · dentedFWD PIT STA 540 LT SIDE FRAME DENTED ABOVE SPLICE STR 25L. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. CUT OUT DAMAGE AND INSTALLED DOUBLER RPR PER REO-G12385 REV B, AND EVA-71745.SDR 2008UALA03806Frame · dentedAFT PIT LT SIDE SLANT AREA HAS DENTED FRAME STA 1500 AT STR 26L. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. CUT OUT DAMAGE AND INSTALLED NEW STR SECTION PER SRM 53-00-07, RPR 5.SDR 08FDEA02789Frame · damagedSCREW MARKS ON FRAME 1110 AT STR 27R AND 27L UNDER TIE DOWN POINTS.SDR 08FDEA02777Frame · corrodedLWR AFT CARGO PIT, CORROSION ON UPPER FLANGE OF FRAME AT STA 1090 STR 27L REMOVED CORROSION, ORIGINAL "T" .063, REMOVED .017, REMAINING .046 OUT OF LIMITS. FABRICATED REPAIR DOUBLER FROM 7075-0 .063, HEAT TREAT T6, APPLIED ALODINE, PRIMER AND INSTALLED REPAISDR COMA0860319Frame · crackedDURING FA 640 FRAME INSPECTION FOUND 640 FRAME CRACKED ON LT SIDE AT STRINGER 9 CUTOUT. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED REPAIR DOUBLER IN ACCORDANCE WITH REO 601R-53-61-557. (A)SDR COM2008F00002Frame · crackedDURING FS 640 FRAME INSPECTION FOUND 640 FRAME CRACKED ON LT SIDE AT STRINGER 9 CUTOUT. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED REPAIR DOUBLER IN ACCORDANCE WITH REO 601R-53-61-557. (S)SDR 2008UALA03776Frame · damagedFRAME AT BS 1681 BETWEEN STR'S 16 - 18R HAS DAMAGE. ACCOMPLISHED A MAJOR REPAIR AT GSO. AT HMV-2 A FRAME REPAIR WAS ACP AT BS 1681 BETWEEN S16 -18R PER EVA IMC-20468A. DUE TO BACO DTA RESULTS IT HAS BEEN DETERMINED THAT THIS REPAIR IS TIME LIMITED TO 24 MO'SSDR 2008UALA03775Frame · dentedAFT PIT AT STA 1520, STR 25L FRAME DENTED AT INBOARD FLANGE. SUPPLEMENTAL DATA UPDATE ACCOMPLISHED MAJOR REPAIR AT GSO. RPR FRAME IAW SRM 53-00-07 RPR 5 DETAIL I. THIS IS A CAT B RPR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSPECTIONS STARTING AT 50,000C AND 12SDR 2008UALA03774Frame · dentedAFT PIT AT STA 1560, APPROX STR 26L, FRAME DENTED AT INBOARD FLANGE. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. AFT PIT AT STA 1560, APPROX STR 26L, FRAME DENTED AT INBOARD FLANGE. RPR FRAME IAW SRM 53-00-07 RPR 5 DETAIL I. THIS IS A CAT B RPR IN ZONE 1 AND SDR 2008UALA03773Frame · dentedAFT PIT FRAME DENTED AT INBOARD FLANGE BS 1440, STR 26L. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. RPR FRAME IAW SRM 53-00-07 RPR 5 DETAIL I. THIS IS A CAT B RPR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSPECTIONS STARTING AT 50,000C AND 12,000C THEREAFTER PER SSDR 2008UALA03772Frame · dentedAFT PIT LT SIDE SLANT AREA HAS DENTED FRAME AT STA 1480 AT STR 26L. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. REPAIRED ON NR 31083.
SDR 2008UALA03771Frame · dentedAFT PIT LT SIDE SLANT AREA HAS DENTED FRAME STA 1540 AT STR 26L. *S/D* ACCOMPLISHED A MAJOR REPAIR AT GSO. RPR FRAME IAW SRM 53-00-07 RPR 5 DETAIL I. THIS IS A CAT B RPR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSPECTIONS STARTING AT 50,000C AND 12,000C THEREASDR CALA0800693Frame · crackedFRAME CRACKED STATION 400 AT S-9 RIGHT. REPAIRED FRAME PER EA 5310-04498 OP2.SDR CALA0800692Frame · crackedFRAME CRACKED STATION 380 AT S-9 RIGHT. REPAIRED FRAME PER EA 5310-04498 OP2.SDR CALA0800690Frame · crackedFRAME CRACKED STATION 867 AT S-9 RIGHT. REPAIRED FRAME PER EA 5310-04498 OP2.SDR CALA0800689Frame · crackedFRAME CRACKED STATION 867 AT S9L. REPAIRED FRAME PER EA 5310-04498 OP2.SDR 08FDEA02755Frame · crackedCRACK IN MAIN FRAME STA 380, BETWEEN STRINGER 7R AND RIGHT FWD DOOR, CUTOUT FRAME. REPAIRED FRAME REF SRM 53-10-4 FIG 2, REMOVED AND REINSTALLED DOOR TRIM AND DOOR TRIM SUPPORT REF SRM 51-30-02 PG'S 1-10. THIS IS CLASSIFIED AS A MAJOR REPAIR.SDR 08FDEA02741Frame · chafedFOUND SCRUB MARKS AT EMERGENCY EXIT, C 57.2, P14-15A, RT ON INNER FRAME FLANGE. REPAIR PERFORMED BY REWORK TO SMOOTH CONTOUR, NDT FOR CRACK FREE CONDITION AND FLAP PEENING IAW RAS/EFW/9000054/2008 ISS A, APPROVED BY EA 6-5316-123024.SDR AIEA200800259Frame · crackedDURING C-CHECK FOUND FRAME CRACKED AT STATION 320 STRINGER 25R. FRAME REPAIRED AS PER SRM 53-10-04 FIGURE 10. (A)SDR AIEA200800258Frame · crackedDURING C-CHECK FOUND FRAME CRACKED AT STATION 280 STRINGER 26L. FRAME REPAIRED AS PER SRM 53-10-04 FIGURE 10. (A)SDR AIEA200800257Frame · crackedDURING C-CHECK FOUND FRAME CRACKED AT STATION 280 STRINGER 26R. FRAME REPAIRED AS PER SRM 53-10-04 FIGURE 10. (A)SDR CALA0800688Frame · crackedRIGHT STATION 787 FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. CUT OUT DAMAGE AT STATION 787 BETWEEN S-8 AND S-9, REPAIRED PER EA 5310-04498.SDR CALA0800687Frame · crackedRIGHT STATION 727B FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. CUT OUT DAMAGE AT STATION 727B BETWEEN S-8 AND S-9, REPAIRED PER EA 5310-04498.SDR CALA0800686Frame · crackedRIGHT STATION 727A FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. CUT OUT CRACKED AREA OF BODY STATION 727A FRAME BETWEEN S-8 AND S-9, INSTALLED REPAIR ANGLES A AND B IAW EA 5310-098.SDR CALA0800685Frame · crackedRIGHT STATION 747 FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. CUT OUT DAMAGE AT STATION 747 BETWEEN S-8 AND S-9, REPAIRED PER EA 5310-04498.SDR CALA0800684Frame · crackedRIGHTHAND STATION 827 FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. CUT OUT DAMAGE AT STATION 827 BETWEEN S-8 AND S-9, REPAIRED PER EA 5310-04498.SDR CALA0800683Frame · crackedRIGHT STATION 867 FRAME CRACKED AT AIR CONDTIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. CUT OUT DAMAGE AT STATION 867 RIGHTHAND S-8 AND S-9, REPAIRED PER EA 5310-04498.SDR CALA0800682Frame · crackedRIGHT STATION 907 FRAME CRACKED AT AIR CONDTIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. CUT OUT DAMAGE AT STATION 907 RIGHTHAND BETWEEN S-8 AND S-9, REPAIRED PER EA 5310-04498.SDR CALA0800681Frame · crackedRIGHT STATION 360 FRAME CRACKED AT AIR CONDTIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. REPAIRED CRACKED FRAME AT STATION 360 RIGHTHAND PER EA5310-04498.SDR CALA0800680Frame · crackedRIGHT STATION 482 FRAME CRACKED AT AIR CONDTIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. CUT OUT DAMAGE AT STATION 482 RIGHTHAND AT S-8 AND S-9, REPAIRED PER EA 5310-04498.
Back to JASC 5311