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 SWAA083575Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294, STR 2L. REPAIRED FRAME PER ER.SDR SWAA083605Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083601Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083604Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083603Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083602Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083600Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR 08FDEA02552Frame · chafedDOT 5, AFT PIT, STA 1148, FRAME WORN FROM HYDRAULIC LINES CHAFING, LOCATED BETWEEN STR 21L TO STR 22L. REPAIRED FRAME AT STA 1148 BETWEEN STR 21L TO STR22L. REF SRM 51-40-3 FIG 1. THIS IS CLASSIFIED AS A MAJOR REPAIR. INSTALLED DOUBLER ON FRAME AT STA 11SDR 2008FA0000562Frame · crackedDURING STRUCTURAL INSP, FOUND LOWER FRAME WEB CRACKED AT FLANGE CORNER. TEE ATTACHED TO FRAME CRACKED THRU LOWER RIVET HOLE. DOUBLER ATTACHED TO LOWER AFT SIDE OF WEB WAS ALSO CRACKED. THE AFT CLIP, ATHAT ATTACHES THE LOWER FRAME TO THE SIDEWALL SEAT TRACK SDR ASAA0843293Frame · dentedAFT PIT FRAME AT STA 727C IS DENTED ABOVE THE STR 24L REMOVED DAMAGED AREA FABBED FILLER + REPAIR ANGLES + INSTALLED IAW SRM 51-70-11, FIG 1.SDR ASAA0843260Failsafe · corrodedCORROSION ON FAILSAFE AT STA 847 BETWEEN STR 28L, 28R IN AFT CARGO PIT REMOVED DAMAGED AREA FABBED FILLER, REPAIR ANGLE, INSTALLED IAW SRM 53-70-11, FIG 1.SDR 08FDEA02502Frame · damagedPREVIOUS FRAME REINFORCING PLATE REPAIR LOCATED IN MAIN CABIN ON FRAME 54.2 INNER FLANGE BETWEEN STRINGERS 11 TO 15 LT, HAS 1 EACH EXTERNAL FORMED REPAIR PLATE MEASURING 21.8 INCHES LONG BY 2.2 INCHES TALL AND THE FRAME INNER FLANGE HAS A CUT OUT MEASURING 11 SDR CALA0800646Frame · crackedRIGHTHAND SIDE STATION 827 FRAME BETWEEN S-8 AND S-9 AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRAKCED. REPAIRED FRAME AT STATION 827 BETWEEN S-8 AND S-9R PER EA5310-04498.SDR 2008UALA03597Frame · dentedAFT PIT FRAME DENTED STA 1340, STR 25R - 26R. ACCOMPLISHED MAJOR REPAIR AT GSO. REMOVED DAMAGE, FABRICATED REPAIR AND INSTALLED PER SRM 53-00-07 REPAIR 5. THIS IS A CAT B REPAIR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSPECTION STARTING AT 50000FC AND 12000FC SDR 2008UALA03596Frame · dentedAFT PIT AT BS 1480, APPROX STR 26L, FRAME HAS DENT AT INBOARD FLANGE. ACCOMPLISHED MAJOR REPAIR AT GSO. REMOVED DAMAGE, FABRICATED REPAIR AND INSTALLED PER SRM 53-00-07 REPAIR 5. THIS IS A CAT B REPAIR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSPECTION STARTINGSDR 2008UALA03595Frame · puncturedAFT CARGO PIT LWR LOBE FRAME WEB PUNCTURED AT BS 1600 LBL 15. FOUND WEB PUNCTURED. INSTALLED REPAIR DOUBLER REF KAL FRR UAL-744-0417 AND FAA FORM 8100-9. AC OK FOR SERVICE.
SDR SWAA083565Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 992, STR 17R. REPAIRED FRAME PER ER.SDR SWAA083552Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR TRAX200800835Frame · corrodedCORROSION ON FRAME AND SKIN AT FS 333 STR 25 LT. FABRICATED AND DRILLED -1 DOUBLER. INSTALLED -1 DOUBLED, AND -2 FRAME INSERT REF CRJ200 SRM 51-42-06. SEALED REPAIR AREA, REFINISHED REPAIR AREA, AND BLENDED AREA ON STRAP AO23. REINSTALLED HYD CLAMPS, ABOVESDR KCSA081300Frame · damagedFRAME WEB DAMAGED APPROX 20" FWD OF I/B AILERON AT WBL-445 (B)SDR KCSA081298Frame · crackedSTA-1319 LBL-120 LOWER FRAME TO LONGERON SUPPORT CRACKED 1" (B)SDR SWAA083520Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20R. REPAIRED FRAME PER SRM.SDR 08FDEA02415Frame · damagedFIGURE "8" HOLE ON STA 760 FRAME I/B OF STR 5L. FABRICATED REPAIR PART (CHANNEL) FOR FRAME STA 760, STRINGER 5L, REF SRM 51-40-03. HEAT TREATED, TRACKING NR 208-06-060, TREATED AND PRIMED AND INSTALLED REF SRM 51-10-2 PG 1-7, 51-30-2 PG 2, 51-40-03 FIG 1, THSDR 08FDEA02410Frame · crackedFRAME CRACKED AT LOCK FASTENER, STA 800 STRINGER 14R. REMOVED DAMAGED PORTION OF FRAME ANGLE, FABRICATED REPAIR ANGLE AND FRAME FILLER. HEAT TREATED, ALODINED AND PRIMED AND INSTALLED. REF SRM 51-40-2 FIG 1, 51-30-2 PG 2, THIS IS CLASSIFIED AS A MAJOR REPAISDR 08FDEA02409Frame · crackedFWD LAV BS 312 FRAME CRACKED FROM O/B WEB FASTENER TO O/B RADIUS JUST BELOW S-13 R. FABRICATED 3 REPAIR PARTS FOR FWD LAV BS 312 FRAME, REF SRM 53-10-4 FIG 1, HEAT TREATED, TRACKING NR 2008-06-068, 2008-06-064, AND 2008-06-065, TREATED AND PRIMED AND INSTALLESDR 08FDEA02407Frame · damagedFUSELAGE FORMER FRAME DOUBLE DRILLED ON VERT FLANGE WITH LESS THEN 1/4 D DISTANCE BETWEEN HOLES AT FS 760 BETWEEN STR 3R AND 4R REPAIR DOUBLE DRILLED HOLE ON FRAME STA 760 BETWEEN STR 3R AND 4R REF SRM 53-10-4 FIG 1. THIS IS CLASSIFIED AS A MAJOR REPAIR.SDR 08FDEA02404Frame · chafedORIGINAL DISCREPANCY STILL EXISTS. AFT PIT LT SIDE WALL BODY FRAME IB FLANGE CHAFED, 1148, STR 21L - L CHECKED WEAR AREA FOR MATERIAL LOSS, ORIGINAL THICKNESS "T' .065' MATERIAL LOSS MEASURE .017', REMAINING MATERIAL .048' AND IS OUT OF LIMITS REF SRM 53-1SDR CALA0800670Frame · crackedSTATION 400 RIGHT FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. REPAIRED CRACKED FRAME AT BODY STATION 400 AT A/C BRACKET BETWEEN S-8R AND S-9R PER EA5310-04498.SDR CALA0800668Frame · crackedSTATION 440 RIGHT-HAND FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. REPAIRED CRACKED FRAME AT BODY STATION 440 AT A/C BRACKET BETWEEN S-8 AND S-9R PER EA5310-04498.SDR CALA0800645Frame · crackedLEFTHAND SIDE STATION 907 FRAME BETWEEN S-8 AND S-9 AIRCONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED FRAME AT STATION 907 BETWEEN S-8 AND S-9 PER EA5310-04498 OPERATION 02.SDR CALA0800644Frame · crackedLEFTHAND SIDE STATION 747 FRAME BETWEEN S-8 AND S-9 AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED FRAME AT STATION 747L BETWEEN S-8 AND S-9 PER EA5310-04498 OPERATION 02.SDR CALA0800643Frame · crackedLEFTHAND SIDE STATION 727B FRAME BETWEEN S-8 AND S-9 AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED FRAME AT STATION 727B BETWEEN S-8 AND S-9 PER EA5310-04498, OPERATION 02.SDR CALA0800642Frame · crackedLEFTHAND SIDE STATION 867 FRAME BETWEEN S-8 AND S-9 AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED LEFTHAND SIDE STATION 867 FRAME BETWEEN S-8 AND S-9 PER EA 5310-04498 OPERATION 02.SDR CALA0800641Frame · crackedRIGHTHAND SIDE STATION 907 FRAME BETWEEN S-8 AND S-9 AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED FRAME AT STATION 907 BETWEEN S-8 AND S-9 PER EA 5310-04498.SDR CALA0800640Frame · crackedRIGHTHAND SIDE STATION 867 FRAME BETWEEN S-8 AND S-9 AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED FRAME AT STATION 867 BETWEEN S8 AND S9R PER EA5310-04498.SDR CALA0800639Frame · crackedRIGHTHAND SIDE STATION 727B FRAME BETWEEN S-8 AND S-9 AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED FRAME AT STATION 727B BETWEEN S-8 AND S-9 PER EA5310-04498, OPERATION 02.SDR CALA0800638Frame · crackedRIGHTHAND SIDE STATION 747 FRAME BETWEEN S-8 AND S-9 AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED FRAME AT STATION 747 BETWEEN S-8 AND S-9 PER EA5310-04498.SDR CALA0800637Frame · crackedLEFTHAND SIDE STATION 827 FRAME BETWEEN S-8 AND S-9 AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED FRAME AT STATION 827 BETWEEN S-8 AND S-9 A/C BRACKET MOUNT PER EA5310-04498, OPERATION 02.SDR CALA0800635Frame · crackedLEFTHAND SIDE STATION 787 FRAME BETWEEN S-8 AND S-9 AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED CRACKED LEFTHAND FRAME STATION 787 BETWEEN S-8 AND S-9 A/C BRACKET MOUNT REF EA5310-04498 OP 02.SDR 2008UALA03559Frame · dentedFWD LWR CARGO PIT FUSELAGE FRAME DENTED AT UPR CHORD STA 600, STR 23L-24L. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07. THIS IS A CAT B RPR IN ZONE 2 AND REQUIRES SUPPLEMENTAL INSPECTIONS STARTING IN 25000FC AND 11000FC THEREAFTER. THIS ISDR 2008UALA03558Frame · dentedAFT PIT AT BS 1520, APPROX STR 26L, FRAME HAS DENT AT INBOARD FLANGE. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07. THIS IS A CAT B RPR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSPECTIONS STARTING AT 50000FC AND 12000FC THERE AFTER. THIS INSP SDR 2008UALA03557Frame · dentedFWD PIT STA 660 STR 24 - 25R FRAME DENTED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07. THIS IS A CAT B REPAIR IN ZONE 2 AND REQUIRES SUPPLEMENTAL INSPECTIONS STARTING IN 25000FC AND 11000FC THEREAFTER. THIS
INSP CONSISTS OF BOTH DETASDR 2008UALA03554Frame · dentedAFT PIT FRAME AT FS 1460 STR 26L HAS DENT. REMOVED DAMAGE FABRICATED AND INSTALLED REPAIR IAW 53-00-07 REPAIR 5 THIS IS A CAT B REPAIR IN ZONE 1 AND REQUIRES S UPPLEMENTAL INSPECTIONS STARTING AT 50000FC AND 12000FC THERE AF TER. INSPS CONSISTS OF BOTH DETAISDR 08FDEA02389Frame · dentedAFT CARGO COMPARTMENT, LT SIDE, STA 1340, S026L, FRAME IS DENTED. REPAIRED DENTED FRAME BY INSTALLING A FABRICATED DOUBLER REPAIR, ON MAE TRAVELER NR T8/741854, IAW SRM 53-00-07, REPAIR NR 5. THIS REPAIR IS CLASSIFIED AS A CATAGORY "A" MAJOR REPAIR.SDR 08FDEA02388Frame · dentedAFT CARGO COMPARTMENT LT STA 1460 S-26L, FRAME IS DENTED. CUT OUT DAMAGED AREA IAW SRM 53-00-01, FIG 201. NDT, HFEC IAW NTM 51-00-00, FIG 6, OF CUT OUT AREA. FABRICATED SPLICE ANGLE IAW SRM 53-00-07, MAT. 7075T6, .071 INCH C, BATCH NR 532681, PO NR MST 0023SDR SWAA083481Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR CALA0800633Frame · corrodedFUSELAGE FRAME HAS CORROSION STATION 992 RBL-48 AT FLOORLINE. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER AND FILLER REF SRM 51-70-11.SDR COMA0860298Frame · crackedDURING FS 640 FRAME INSPECTION FOUND 640 FRAME CRACKED ON RT AT STRINGER 9 CUTOUT. REMOVED DAMAGED SECTION OF FRAME FROM STRINGER 6-20 AND REPLACED WITH SPLICED IN REPAIR FRAME AND BONDED DOUBLER PER, S/B 601R-53-061E PART C. (S)SDR SWAA083429Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500C, LBL 18 TO RBL 19. REPAIRED FRAME PER SRM.SDR SWAA083444Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 433, RBL 3. REPAIRED SKIN PER SWA EA.
Back to JASC 5311