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 05FDEA00310Frame · dentedMAIN DECK LT SIDEWALL STRUCTURE FRAME STA 1761 FOUND WITH DENT ON INNER CHORD AT L-12. CARRIED OUT REPAIR AS PER SRM 53-30-00 FIG 1 VOL I.SDR ABXA050064Frame · crackedCRACKED FRAME AT STA 1152, LONGERON 15 LEFT, FORWARD OF LEFT EPR TRANSMITTER. REPAIRED AREA IAW DC-9 SRM.SDR SWAA050484Frame · crackedDURING SPV, FOUND FRAME AT BS 500, STRINGER 9L, CRACKED. REPAIRED FRAME PER SRM.SDR ASOA05140Frame · crackedDURING A C-CHECK IN MCN, THE FUSELAGE FRAME FS 718, STRINGER 10-11, LHS AND RHS WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE FUSELAGE FRAME FS 718, STRINGER 10-11, LHS AND RHS IAW ASA EO 600-53-0066. (M)SDR DHL2005781556Frame · crackedDURING A C-CHECK, AFT PIT FRAME DENTED BS 1130 STR 26 RT. CUT OUT DAMAGED AREA FROM FRAME BS 1130 STR 26 RT IAW 727 SRM 53-10-1 FIG 1. FABRICATED DOUBLER FROM 7075-T6 .063 PO NR 9001660 8.5 X 3 INCHES & STRIP FROM 7075T6 .063 PO NR 9001660 8.5 X 1 INCHES ANDSDR UPS05844118Frame · crackedINSPECTION TYPE:C1 FRAME CRACKED AT STA 55 BETWEEN L24R & L25R AT DUCT SUPPORT ROD MOUNT. CUT OUT CRACKED FRAME SECTION. FAB FILLER AND 2 REPAIR ANGLES FROM SHT 7075/0-.071, HEAT TREAT TO T6 ON SAA SVC ORDER 7034931. INSTALLED ALL PARTS REF SRM 53-2-0 FIG 2SDR ABXA050062Window Frame · crackedCRACK INDICATIONS ON LOWER LEFT WINDSHIELD ZEE. REMOVED AND INSTALLED NEW ZEE ANGLE IAW DC-9 SRM 51-30-5 AND 51-30-8.SDR ABXA050061Window Frame · crackedCRACK INDICATIONS ON LOWER RIGHT WINDSHIELD ZEE. REMOVED AND REPLACED NEW ZEE ANGLE IAW DC-9 SRM 51-30-5 AND 51-30-8.SDR AWXA200500307Frame · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK CORROSION WAS FOUND ON FRAME AT FORWARD SIDE OF BS 847 JUST INBOARD OF STR 25 RT. MAINTENANCE REMOVED DAMAGED SECTION OF FRAME AT BS 847 FROM STR 25 RT TO STR 26 RT; FABRICATED A FILLER AND REPAIR ANGLE; INSTALLED REPAIRSDR SWAA050466Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH FRAMES CRACKED AT BS 480, STRINGER 8R AND STRINGER 8L. REPAIRED FRAME SECTIONS PER SRM.SDR SWAA050458Shear Tie · corrodedDURING SPV, FOUND SHEAR TIE AT BS 360, STRINGER 27R, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050446Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME FROM BS 827 TO BS 907, STRINGER 8L, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR ABXA050058Frame · crackedSTRUCTURAL ANGLE LOCATED BENEATH FIRST OFFICER'S WINDOW CRACKED AT INBOARD END. REPAIRED AREA IAW REA D953-51500MR AND IAW DWG SR09530268.SDR ABXA050056Frame · crackedSTRUCTURAL ANGLE LOCATED BENEATH CAPTAIN'S WINDSHIELD WAS CRACKED AT INBOARD END. REPAIRED AREA IAW REA D953-51500MR AND IAW DWG SR09530268.SDR ABXA050057Frame · crackedBOTH ENDS OF STRUCTURAL ANGLE LOCATED BENEATH CENTER WINDSHIELD ARE CRACKED. REPAIRED AREA IAW REA D953-51500MR AND DWG SR09530268.SDR SWAA050451Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 380, STRINGER 13L, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA050447Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 188, RBL 33, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR WRLA2005058Spar Cap · corrodedDURING "C04" CHECK INSPECTION, FOUND CORROSION IN CENTER W/W UPPER SURFACE, UPPER CAP AND SUPPORT FITTING SLANT PRESSURE PANEL STRUCTURE, AROUND FASTENER HEAD AT STA 1376 X=-8, X=-16, X=-31 TTL 6 LOCATIONS.SDR DHL2005781527Frame · dentedDURING A "C" CHECK, FRAME DENTED AT S25L BS950F. REMOVED FASTENER FOR ACCESS AT STA S25L BS950F IAW B727 SRM 51-30-2. CUT OUT DAMAGE AREA DIM 1.5 INCH BY 1 INCH IAW B727 SRM 51-40-3 FIG1. FABRICATED FRAME REPAIR MAT USED 7075T6 .071 PO NR 900573 DIM 9 3/4 ISDR DHL2005781526Frame · dentedDURING A "C" CHECK AT FLIGHTSTAR AIRCRAFT SERVICES IN JACKSONVILLE FLORIDA, THE FOLLOWING DISCREPANCY WAS NOTED; FRAME DENTED ABOVE S25R BS1050. REMOVED FASTENERS FOR ACCESS AT S25R BS 1050 IAW B727 SRM 51-30-2. CUT OUT DAMAGED AREA DIM 1 1/2 BY 1 INCH IAW BSDR USAA050257Frame · crackedCLT - FOUND FRAME CRACKED .5 INCH, STATION 827 STRINGER 9R. INSTALLED FILLER/DOUBLER IAW TR 53-10-20A. (M)SDR USAA050256Frame · crackedCLT - FOUND FRAME CRACKED .3750 INCH, STATION 887 STRINGER 9R. INSTALLED FILLER/DOUBLER IAW TR 53-10-20A. (M)SDR USAA050254Frame · crackedCLT - FOUND FRAME CRACKED .5 INCH, STATION 827 STRINGER 9R. INSTALLED FILLER/DOUBLER REPAIR IAW TR 53-10-20A. (M)SDR 05FDEA00292Frame · dentedMAIN DECK SIDE WALL STRUCTURE FRAME STA 1761 FOUND WITH DENT ON INNER CHORD AT L-12. CARRIED OUT REPAIR AS PER SRM 53-30-00 FIG 1 VOL I.SDR C2XA05SH010Frame · gougedSHV - DURING C-CHECK, SEVERAL GOUGES FOUND ON LEFT HAND EMERGENCY EXIT DOOR LOWER INTERNAL FRAME.SDR USAA050239Frame · crackedCLT - FOUND FRAME CRACKED 1 INCH, STATION 616 WL 200 RIGHT SIDE. FABRICATED REPAIR ANGLE AND INSTALLED PER TR 53-62-01. (M)SDR 2003794Frame · crackedDURING ROUTINE STRUCTURAL INSPECTION, A 1.3 INCH FRAME CRACK WAS DISCOVERED AT FS 450 STRINGER 10R. REPAIRED CRACKED FRAME AREA, AIRCRAFT RETURNED TO SERVICE.SDR SWAA050420Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 380, STRINGER 9R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR DHL2005781520Frame · dentedDURING A "C" CHECK, AFT CARGO DENT FRAME STA 1110 AT STA 23 LT. REMOVED FASTENERS FOR ACCESS AT AFT CARGO STA 1110 AT STA 23 LT IAW B727 SRM 51-30-2. CUT OUT DAMAGE AREA DIMENSION 2 INCH BY 1 INCH IAW B727 SRM 51-40-3 FIG 1. FABRICATED FRAME REPAIR MAT USEDSDR 2005UALA00154Frame · dentedAFT PIT STA 1620 FRAME IS DENTED ON INBD FLANGE AT STR 25R. INSTALLED NESTED J-ANGLE REPAIR.SDR 2005UALA00153Frame · dentedAFT PIT STA 1620, FRAME IS DENTED AT STR 25L ON INBD FLANGE. INSTALLED NESTED J-ANGLE REPAIR.SDR 2005UALA00152Frame · dentedAFT PIT STA 1560 AT STR 26L FRAME IS DENTED ON INBD FLANGE. INSTALLED NESTED J-ANGLE REPAIR.SDR 2005UALA00151Frame · dentedAFT PIT STA 1360 AT STR 26L FRAME INBD FLANGE IS DENTED. INSTALLED NESTED J-ANGLE REPAIR.SDR 2005UALA00150Frame · dentedAFT PIT STA 1580 AT STR 26L FRAME IS DENTED ON INBD FLANGE. INSTALLED NESTED J-ANGLE REPAIR.SDR 2005UALA00140Frame · dentedAFT PIT STA 1480 FRAME IS DENTED ON INBD FLANGE AT STR 26L. INSTALLED NESTED J-ANGLE REPAIR.SDR 2005UALA00139Frame · dentedFRAME FLANGE AT BS 1540 AND STR 25L DENTED. INSTALLED NESTED J-ANGLE REPAIR.SDR AWXA200500315Frame · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK CORROSION WAS FOUND ON AFT CARGO DOOR FORWARD TORQUE BOX FRAME AT BS 794.3, STR 25 RT. MAINTENANCE REMOVED CORRODED SECTION AFT CARGO DOOR FORWARD TORQUE BOX FRAME AT BS 794.3, STR 25 RT; FABRICATED A NEW REPLACEMENT SECSDR 05043626Frame · crackedRIGHT FS 718 FRAME IS CRACKED AT .75 INCH IN LENGTH STR 10R - STR 12R.SDR SWAA050408Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 1128, RBL 26, CORRODED. REMOVED AND REPLACED FRAME SECTION PER BAC DRAWING, SRM.SDR SWIA200515054Frame · crackedCRACKED FRAME FLANGE AT FS 605 AND STRINGER 9 LT SIDE ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-61-1305.SDR 2005UALA00137Frame · dentedAFT PIT STA 1460 AND STR 25L, FRAME IS DENTED ON THE INBD FLANGE. INSTALLED NESTED J-ANGLE REPAIR.SDR AWXA200500303Frame · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK 3 EACH .25 INCH CRACKS WERE FOUND IN FUSELAGE FRAME AT BS 663.75, BETWEEN STR 2 RT & STR 3 LT. MAINTENANCE CUT OUT CRACKS IN FRAME AT BS 663.75, BETWEEN STR 2 RT & STR 3 LT; FABRICATED FILLERS AND A REPAIR ANGLE; INSTALLSDR AWXA200500293Frame · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK 2 EACH .1875 INCH CRACKS WERE FOUND IN R-2 DOOR LOWER FORWARD FRAME SECTION BS 957, STR 16 RT. MAINTENANCE CUT OUT DAMAGE IN R-2 DOOR LOWER FORWARD FRAME SECTION; FABRICATED A FILLER AND REPAIR ANGLE; INSTALLED REPAIR PASDR USAA050232Frame · crackedPIT - FOUND FRAME CRACKED .25, BS 440 BETWEEN S8R AND S9R. CUT OUT DAMAGE AND INSTALLED REPAIR ANGLES PER TYPICAL REPAIR 53-10-20A. (M)SDR SWAA050392Frame · crackedDURING SCHEDULED C3 CHECK, FOUND FWD CARGO DOOR CUTOUT FRAME AT BS 440, UPPER SIDE OF LOWER STOP CRACKED. REPAIRED FRAME PER EA.SDR SWAA050391Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 616, RBL 63, CRACKED. REPAIRED FRAME SECTION PER EA.SDR CALA0500045Frame · corrodedINSPECTION FOUND FRAME IN AFT BAGGAGE BIN CORRODED AT STA 907 ABOVE S21R. A REPAIR WAS INSTALLED IAW SRM 51-70-11.SDR USAA050231Frame · crackedPIT - FOUND FRAME CRACKED .25 INCH, FS 887 S-9R. DOUBLER REPAIR INSTALLED PER 53-10-20A. (M)SDR SWIA200514564Frame · crackedTHREE SUPPORT CRACKS FOUND ON FRAME JUST AFT OF ELECTRONICS BAY DOOR, MARKED. ITEM FOUND AT C-CHECK INSPECTION. HFEC INSPECTION ON 3 SUSPECT CRACKS AS REQUESTED ON E & E BAY DOOR FRAME STRUCTURE, NO CRACKS FOUND. NDTM PT1 51-20-06.SDR ABXA050045Frame · corrodedCORROSION ON FRAME FS 832 LONGERON 30. REPAIRED IAW DC-9 SRM 53-03.
Back to JASC 5311