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 SWAA083443Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 21L. REPAIRED FRAME PER SRM.SDR SWAA083412Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083413Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR CA080623009Frame · corroded(CAN) CORROSION FOUND ON TOP SURFACE OF FUSELAGE FRAMES 21 AND 24 BETWEEN ALL 4 SEAT RAILS.SDR TRAX200800815Frame · crackedSUSPECTED CRACK IN AFT LOWER LEG OF FS 280 FRAME AT RBL 12. WORK COMPLETED IN ACCORDANCE WITH: PERFORMED EDDY CURRENT INSPECTION OF SUSPECT AREA IAW CRJ 200 NDTM 61-20-06 PART 1 AND CONFIRMED CRACK MB7011995 06-21-08. PERFORMED EDDY CURRENT INSPECTION OF CUSDR KCSA081294Frame · crackedFUSELAGE FRAME WEB IS CRACKED AT STA. 1265, BELOW STR. 26L (B)SDR KCSA081295Frame · crackedFUSELAGE FRAME WEB IS CRACKED AT STA. 1265, BELOW STR. 26R (B)SDR 2008UALA03506Frame · corrodedRIGHT CORNER LATERAL SHEAR PLATE SUPPORT FRAME FOUND CORRODED ON UPPER AND LWR SURFACES. *S/D* ACCOMPLISHED A MAJOR REPAIR IN DEN. REMOVED SHEAR PLATE SUPPORT FRAME FROM FR69 - FR70 RT SIDE. COMPLETED INSTALL OF SUPPORT FRAME.SDR IXX2008F00077Frame · crackedDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT FRAME CLIP CRACK AT STATION XF 350.000 LONGERON 21. REMOVED CRACKED FRAME CLIP. FABRICATED FRAME CLIP. PERFORMED HEAT TREATMENT. PERFORMED NDT INSPECTION, NO CRACK NO CORROSION. CLEANED, TREASDR CALA0800617Frame · crackedFRAME STATION 440 RIGHT CRACKED AT S-9R. INSTALLED REPAIR ON FRAME AT STATION 440 S9R PER ECRA 5311-01410.SDR CALA0800616Frame · crackedFRAME STATION 400 LEFT CRACKED BETWEEN S8 AND S9 AFT SIDE OF AIR CONDITIONING (A/C) OUTLET ASSEMBLY SUPPORT BRACKET. INSTALLED REPAIR ANGLES PER EA 5310-04498 OP 02.SDR CALA0800615Frame · crackedSTATION 867 FRAME RIGHT CRACKED BETWEEN S8 AND S9 AFT SIDE OF AIR CONDITIONING (A/C) OUTLET ASSEMBLY SUPPORT BRACKET. REPAIRED FRAME PER EA 5310-04498 OP 2.SDR CALA08FA001Frame · crackedFRAME STATION 787 LEFT CRACKED BETWEEN S8 AND S9 AFT SIDE OF AIRCONDITIONING (A/C) OUTLET ASSEMBLY SUPPORT BRACKET. REPAIRED FRAME PER EA 5310-04498 OP 2.SDR SWAA083407Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500A, BL0 TO RBL 3, WL 148. REPAIRED FRAME PER SRM.SDR SWAA083372Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083373Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083374Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR CA080623008Frame · corroded(CAN) CORROSION WAS FOUND ON THE TOP SURFACE OF FUSELAGE FRAMES 21 AND 24 BETWEEN ALL 4 SEAT RAILS.SDR HNAA08A0004Frame · corrodedCORROSION FOUND ON FRAME STA X593.5 BETWEEN STR 30 AND 31 RT SIDE. REPAIRED IAW SRM 51-40-00 AND DRAWING 85330908. (S)SDR KCSA081289Frame · crackedSTA. 434 R1 DOOR FRAME HAS CRACK AT INBOARD HOLE OF FRAME AT STR. 26R (B)SDR SWAA083347Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 344, STR 22L. REPAIRED FRAME PER EA.SDR SWAA083356Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA083357Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 13R. REPAIRED FRAME PER SWA EA.SDR 08FDEA02297Frame · corrodedAFT BAGGAGE COMPARTMENT FRAME AT BS 1853 RBL 12 TO LBL 12 HAS CORROSION. REMOVED CORROSION IN REF TO SRM 51-21-01; VOL II. ORIGINAL THICKNESS 0.071 IN REF TO SRM 51-10-01; VOL III. REMOVED 0.017. REMAINING THICKNESS IS 0.054. AREA IS OUT OF LIMITS IN REF SDR 2008UALA03441Frame · dentedFWD CARGO PIT STA 620 STR 24L FRAME HAS DENT. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR.SDR 2008UALA03440Frame · dentedAFT PIT FRAME AT FS 1360 STR 26L HAS 1EA DENT. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR.SDR SWAA083266Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083267Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083287Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500A, BETWEEN BL 0 AND RBL 3. REPAIRED FRAME PER SRM.SDR DL757080881Frame · dentedAFT CARGO PIT STA 1540 LT FRAME AT STR 23L HAS A DENT. REPLACED DAMAGED FRAME FLANGE IAW SRM 53-00-07.SDR USAA920081362Frame · crackedMCN C21 MAJOR REPAIR NR 6112049- FRAMES CRACKED AT BS867, S9L, WL216. REPAIRED FRAME AT BS867, S9L, WL216 IAW AWA TASKCARD M1C53002. (B)SDR USAA920081361Frame · crackedMCN- C21 MAJOR REPAIR NR 6112049-FRAME CRACKED AT BS847, S9R,WL216. REPAIRED FRAME AT BS847, S9R,WL216 IAW AWA TASKCARD M1C53002. (B)SDR USAA920081335Frame · crackedMCN- C21 MAJOR REPAIR NR 6112049- FRAME CRACKED AT BS 480, S9R, WL216. REPAIRED FRAME AT BS480, S9R, WL216 IAW AWA TASKCARD M1C53002. (B)SDR SIMA200817804Frame · corrodedDURING A HMBV INSPECTION, A PREVIOUS REPAIR ON FLOOR FRAME 258.0 WAS FOUND CORRODED. REMOVED THE DAMAGED FILLER PLATE AND CLEANED THE AREA. FABRICATED A FILLER, DRILLED HOLES, CLEANED, TREATED AND INSTALLED FILLER. REPAIR DONE IAW SAAB 340 SRM (SRM 72LKS 30SDR CALA0800611Frame · crackedFOUND FRAME CRACK AT THE AIR CONDITION (A/C) BRACKET AT BODY STATION 360 BETWEEN S-8 AND S-9. REPAIRED PER ECRA 5310-04787.SDR KCSA081287Frame · dentedAFT PIT FLOORBEAM UPPER CHORD DENTED AT B.S.1760, RBL-23 (B)SDR KCSA081285Frame · dentedAFT PIT FLOORBEAM UPPER CHORD DENTED AT BS 1580, BL-0. (B)SDR MAL2008F00000Frame · damagedREPAIR AT STA 272 ON RT UPPER FRAME IN ACCORDANCE WITH EO S53108 & SRM 53-70-30. REPAIRED THE DAMAGE IAW EO S53108. (S)SDR 2008FA0000393Frame · damaged(REF DU4R2008217) DURING SCHEDULED INSPECTION, FOUND DOUBLE-DRILLED HOLE ON MAIN FRAME UPPER CAP AT BS 986.5 AT FLOOR LEVEL RT. (K)SDR 2008UALA03390Frame · dentedAFT PIT FRAME STA 1480 STR 26L HAD DENT. ACCOMPLISHED MAJOR REPAIR AT GSO. REPAIRED IAW SRM 53-00-07 REPAIR 5. THIS IS A CAT B REPAIR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSP STARTING AT 50,000 TOTAL FLT CYCLES PER SRM 53-00-07 REPAIR 5 TBL II AND 12,000FC SDR 2008UALA03389Frame · dentedAFT PIT FS 1520 STR 26L HAS DENT IN FRAME. ACCOMPLISHED MAJOR REPAIR AT GSO. REPAIRED IAW SRM 53-00-07 REPAIR 5. THIS IS A CAT B REPAIR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSP STARTING AT 50,000 TOTAL FLT CYCLES PER SRM 53-00-07 RPR 5 TBL II AND 12,000FC TSDR 2008UALA03388Frame · dentedAFT PIT FRAME AT BS 1320 BETWEEN STR 25R-26R INBOARD FLANGE IS DENTED. ACCOMPLISHED MAJOR REPAIR AT GSO. REPAIRED IAW SRM 53-00-07 RPR 5. THIS IS A CAT B REPAIR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSP STARTING AT 50,000 TOTAL FLT CYCLES PER SRM 53-00-07 RESDR HNAA0800254Frame · corrodedCORROSION SURFACE FOUND ON FRAMES STA 434.5 TO 445.5 RT STRINGER 31. SURFACE CORROSION REMOVED IAW EO8-53-08-3218 LPI ACCOMPLISHED.SDR HNA2008F00034Frame · corrodedSURFACE CORROSION FOUND ON FRAME BS 434.50 RT STRINGER 31. SURFACE CORROSION REMOVED IAW EO8-53-08-3218 LPI ACCOMPLISHED. (S)SDR IXX2008F00085Frame · crackedDURING ROUTINE C CHECK INSPECTION, FOUND ACCESSORY COMPARTMENT FRAME CRACKED AT STATION 255.000 LONGERON 25LT. REMOVED DAMAGED FRAME SEGMENT. FABRICATED NEW SEGMENT. PERFORMED HEAT TREATMENT. CLEANED, TREATED AND PRIMED AREA AND REPAIR PARTS. INSTALLED RESDR 08FDEA02980Frame · gougedFUSELAGE, FR 47 HOLE K REF TO EO 6-5310-7-5017 PT4, FOUND DAMAGED. HOLE K REPAIRED AS PER FEDEX EA 6-5310-121645.SDR UPS08852664Frame · corrodedINSPECTION TYPE-C1, AREA OF CORROSION EXFOLIATON ON AFT SIDE OF STA 70 FRAME, A PIT, BETWEEN L29L AND L30L. REMOVED DAMAGE AND FABRICATED DOUBLER IAW SRM 53-02-05 FIG 008C.SDR SWAA083218Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083214Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 7L. REPAIRED FRAME PER SWA EA.SDR DL757080863Frame · dentedAFT CARGO PIT STA 1540 LT FRAME AT STR 23L HAS A DENT. REPAIRED DENT IAW SRM 53-00-07.
Back to JASC 5311