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 DHL2008764505Frame · dentedWHILE AT C CHECK REF N/R 098175, DENT ON MAIN CABIN FRAME BS 540 BETWEEN STR 16 AND 17R. REPAIRED IAW B727 SRM 51-40-3 FIG 1 AND 53-10-2 FIG 3 MATERIAL 7075-T6 .050 INCH DIM 7 1/8 INCH BY 6 INCH PO NR 9006742.SDR 2008UALA02926Frame Splice · gougedAFT PIT STA 1520 FRAME SPLICE GOUGED 3 EA PLACES STR 24R TO 25R. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE SPLICE. FABRICATED AND INSTALLED NEW SPLICE.SDR CALA0800480Frame · crackedSTATION 400 AT S8L AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED FRAME AT STATION 400 S8L BRACKET INBOARD MOUNT HOLE IAW EA 5310-04498.SDR CALA0800479Frame · crackedSTATION 440 AT S8L AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED FRAME AT STATION 440 S8L BRACKET INBOARD MOUNT HOLE IAW EA 5310-04498.SDR SWAA082746Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 188, STR 17R. REPAIRED FRAME CHORD PER SRM.SDR CALA0800475Frame · crackedFRAME CRACKED AT STATION 787 BETWEEN S8L AND S9L. CUT OUT DAMAGED AREA, FABRICATED REPAIR ANGLES AND INSTALLED PER EA5310-04498.SDR 08FDEA01904Frame · damagedAFT PIT, BILGE BODY FRAME, HAS A DRILL START ON UPPER FLANGE AND CORRODED WEB BS 1143, FWD AND AFT SIDE, STR 26R - 27R, WL 153 - 156 LEVEL 1 CORROSION BLENDED AREA, FLAP PEENED AREA, APPLIED ALODINE AND PRIMER TO AREA APPLIED CORROSION INHIBITOR TO AREA, REF ESDR UALA2011113006568Frame · dentedAFT CARGO BAY FRAME, BS 1420, S25L AND S26L, DENTED. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE, FABRICATED REPAIR AND INSTALLED IAW SRM 53-00-07 REPAIR 5.SDR ABXA080163Frame · crackedHOLE WITH CRACK IN FRAME STA 218, LONGERON 12 LEFT. REPAIRED IAW DC9 SSRM DWG K05159. (A)SDR 2008UALA02897Frame · dentedAFT PIT STA 1420, STR 25L AND STR 26L, FRAME DENTED. SUPPLEMENTAL DATA UPDATE ACCOMPLISHED MAJOR REPAIR AT GSO. REMOVED DAMAGE, FABRICATED RPR AND INSTALLED IAW SRM 53-00-07. RPR 5 BY MECH 110694 AND INSP BY QC 409 ON NR 20299. THIS IS A CAT B RPR IN ZONE SDR DHL2008764504Frame · dentedWHILE AT C CHECK REF N/R 098180, DENT AT MAIN CABIN FRAME BS 680 BETWEEN STR 16 AND 17R. FABRICATED REPAIR IAW B727 SRM 51-40-3 FIG1 AND 53-10-2 FIG3 MATERIAL 7075-T6 .050 INCH DIM 7 1/8 INCH BY 5 1/4 INCH PO NR 9006742.SDR DHL2008764503Frame · dentedWHILE AT C CHECK REF N/R098179, DENT AT MAIN CABIN FRAME BS 660 BETWEEN STR 16 AND 17R. REPAIRED IAW B727 SRM 51-40-3 FIG 1 AND 53-10-2 FIG 3 DOUBLER MATERIAL 7075-T6 .050 DIM 7 1/8 INCH BY 5 1/4 INCH PO NR 9006742.SDR DHL2008764502Frame · dentedWHILE AT C CHECK REF N/R 098174, DENT AT MAIN CABIN FRAME AT BS 520 BETWEEN STR 16 AND 17R. REPAIRED IAW B727 SRM 51-40-3 FIG 1 AND 53-10-2 FIG 3 MAT, 7075-T6 .050" DIM 5 1/8 INCH BY 8 1/4 INCH PO NR 9006742.SDR DHL2008764501Frame · dentedWHILE AT C CHECK REF N/R 098173, DENT AT RT MAIN CABIN FRAME BS 480 BETWEEN STR 16 AND 17R. REPAIRED IAW B727 SRM 51-40-3 FIG1 AND 53-10-2 FIG3 MATERIAL DOUBLER 7075-T6 .050 INCH DIM 7 1/4 INCH BY 5 3/4 INCH PO NR 9006742.SDR SWAA082737Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 787, STR 27R. REPAIRED FRAME PER SRM.SDR SWAA082731Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500, BETWEEN LBL 1 AND RBL 4, WL 148. REPAIRED FRAME PER SRM.SDR KCSA081253Frame · damagedFUSELAGE FRAME DAMAGED AT BS 1120, STR 13L.SDR CALA0800473Frame · crackedFRAME CRACKED AT STATION 440 BETWEEN S8L AND S9L. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES PER EA 35310-04498.SDR CALA0800472Frame · crackedFUSELAGE FRAME CRACKED AT STATION 787 BETWEEN S8R AND S9R. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES PER EA 5310-04498.SDR CALA0800471Frame · crackedFUSELAGE FRAME CRACKED AT STATION 907 BETWEEN S8R AND S9R. REMOVED DAMAGE, FABRICATED AND INSTALLED 2EA REPAIR ANGLES PER EA 5310-04498.SDR CALA0800470Frame · crackedFRAME CRACKED AT STATION 867 BETWEEN S8L AND S9L. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED REPAIR DOUBLERS PER EA 5310-04489.SDR CALA0800469Frame · crackedFUSELAGE FRAME CRACKED AT STATION 747 BETWEEN S8R AND S9R. REMOVED DAMAGE, FABRICATED ANGLES, TREATED, PRIMED AND INSTALLED PER EA 5310-04498 OP NR 2.SDR UALA2008111302866Frame · damagedSTA 294.5 FRAME AT STR 11L HAS TOOLING MARK. REPAIRED PER UA-EVA-71570 AND REO-L01074. THIS IS A TIME LIMITED REPAIR FOR 12 MONTHS. BOEING MUST ISSUE A NEW 8100-9 ON OR BEFORE 17MAY2009. RECEIVED FIRST STAGE APPROVAL.SDR UPS08552367Frame · dentedDENT IN BULK CARGO COMPARTMENT FUSELAGE FRAME STA 1480 BETWEEN S25R AND S26R. DENT SIZE L:=.085", W=.059", D=.030". DENT LOCATION, FROM PRODUCTION SPLICE 4.5", FROM TRANSITION PANEL 10". REMOVED CLIP AT STA 1480 AND S25R AND LINER SUPPORT IAW SRM 51-40-02. SDR UIEA200800212Frame · crackedMAIN DECK STA 1740 STRINGER 13R - 14R FRAME FOUND CRACKED. FRAME CRACKED AREA REPAIRED PER EO NR 4753B152.SDR 2008UALA02866Frame · damagedSTA 294.5 FRAME AT STR 11L HAS TOOLING MARK.SDR KCSA081247Strap · crackedFUSELAGE FRAME STABILIZATION STRAP CRACKED AT B.S.2230 ABOVE STR-42LSDR UPS08552369Frame · dentedDENTS IN AFT CARGO FUSELAGE FRAME STA 1340 APPROX BET S25L AND S26L (2EA). DENT SIZE NR 1 L=1.3 INCH, W=.75 INCH, D=.022 INCH. DENT SIZE NR 2 L=1.35 INCH, W=.8 INCH, D=.028 INCH. DENTS LOCATION IS 2.7 INCH FROM PRODUCTION SPLICE, 8.1 FROM TRANS PNL. CUTOUTSDR UPS08552368Frame · dentedDENT IN AFT CARGO FUSELAGE FRAME STA 1320, BETWEEN S25R AND S26R. DENT SIZE L = 1.5", W=.80", D= .030" DENT LOCATION: 6.10" FROM PRODUCTION SPLICES 7.15" FROM TRANS PNL 2. CUT OUT DAMAGE AREA DIMENSIONS L=1.51 INCH, W=1.40 INCH, IAW SRM 53-07-2R5 STEP NR 1 DSDR CALA0800468Frame · crackedFUSELAGE FRAME CRACKED AT STATION 867 BETWEEN S8R AND S9R. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES PER EA 5310-04498.SDR 2008UALA02840Frame · dentedAFT PIT STA 1500, STR 25L FRAME DENTED. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGE. INSTALLED "J" ANGLE REPAIR. HFEC INSPECTION VERIFIED DAMAGE REMOVED. NO CRACKS NOTED.SDR CALA0800466Frame · crackedFRAME CRACKED AT STATION 787 ABOVE S9R. INSTALLED REPAIR PARTS PER EC/RA 5310-04763, REPAIRED FRAME PER EC/RA 5310-04763.SDR CALA0800465Frame · crackedFRAME CRACKED AT STATION 827 ABOVE S9R. INSTALLED REPAIR PARTS PER EC/RA 5310-04763, REPAIRED FRAME PER EC/RA 5310-04763.SDR CALA0800464Frame · crackedFRAME CRACKED AT STATION 867 ABOVE S9R. INSTALLED REPAIR PARTS PER EC/RA 5310-04763, REPAIRED FRAME PER EC/RA 5310-04763.SDR 2008UALA02822Frame · dentedAFT PIT STA 1560, STR 26L, FRAME DENTED. ACCOMPLISHED MAJOR REPAIR AT GSO. REMOVED DAMAGE FAB AND INSTALL RPR IAW SRM 53-00-07. THIS IS A CAT B RPR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSP STARTING AT 50000 TOTAL FC AND 12000FC THEREAFTER. INSP PER SRM 53-SDR 2008UALA02821Frame · dentedAFT PIT STA 1340, STR 26L, FRAME DENTED. ACCOMPLISHED MAJOR REPAIR AT GSO. REMOVED DAMAGE FAB AND INSTALL RPR IAW SRM 53-00-07. THIS IS A CAT B RPR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSP STARTING AT 50000 TOTAL FC AND 12000FC THEREAFTER. INSP PER SRM 53-SDR 2008UALA02820Frame · dentedAFT PIT STA 1340 BETWEEN STR 26R AND 27R, FRAME DENTED. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. REMOVED DAMAGE FAB AND INSTALL RPR IAW SRM 53-00-07. THIS IS A CAT B RPR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSP STARTING AT 50000 TOTAL FC AND 12000FC THEREAFTSDR 2008UALA02819Frame · dentedAFT PIT STA 1560 AT STRL FRAME DENTED. ACCOMPLISHED MAJOR REPAIR AT GSO. REMOVED DAMAGE, FABRICATED AND INSTALLED RPR IAW SRM 53-00-07 FIG 201 RPR 5. THIS IS A CAT B RPR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSP STARTING AT 50,0 00 TOTAL FC AND 12,000FC THESDR MALA080106Frame · tornDENT AND TEAR IN FRAME FLANGE FS 630.112 RIGHT SIDE JUST ABOVE SEAT TRACK. COMPLIED WITH MESABA EOS53152 AND APPLICABLE SECTIONS OF 340 SRM CHS 51-20, 51-40 AND 51-70 FOR THE DENT IN THE RT SIDE FLANGE AT FS 630.112. CUT OUT DAMAGED FRAME FLANGE SECTION, FABSDR SWAA082673Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA082672Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 328, STR 20R. REPAIRED FRAME PER SRM.SDR F3LA200800269Frame · damagedDURING C2 C CHECK INSPECTION NOTED FRAME 73 DAMAGED FROM STRINGER 26 LEFT TO 26 RIGHT. MAINTENANCE REPAIRED FRAME IN ACCORDANCE WITH THE REQUIREMENTS OF EA A9-53R-30262 AND SRM 51-42-11 PARAGRAPH 6. UPON COMPLETION OF THE REPAIR IT WAS INSPECTED AND FOUND ACSDR F3LA200800268Frame · damagedDURING C2 C CHECK INSPECTION NOTED FRAME 72 DAMAGED AT STRINGER 27 RIGHT. MAINTENANCE REPAIRED IN ACCORDANCE WITH THE REQUIREMENTS OF EA A9-53R-30262 REV A AND SRM 51-42-11 PARAGRAPH 6. UPON COMPLETION OF THE REPAIR IT WAS INSPECTED AND FOUND ACCEPTABLE.SDR F3LA200800267Frame · damagedDURING C2 C CHECK INSPECTION NOTED FRAME 74 DAMAGED FROM STRINGER 26 LEFT TO STRINGER 26 RIGHT. MAINTENANCE REPAIRED FRAME IN ACCORDANCE WITH THE REQUIREMENTS OF EA A9-53R-30262 AND SRM 51-42-11 PARAGRAPH 6. UPON COMPLETION OF THE REPAIR IT WAS INSPECTED ANDSDR CALA0800458Frame · crackedFRAME CRACKED AT STA 400 BETWEEN S8R AND S9L. FABRICATED AND INSTALLED REPAIR ANGLES PER EA 5310-04498.SDR CALA0800457Frame · crackedFUSELAGE FRAME STA 400 HAS A CRACK BETWEEN S8R AND S9R. FABRICATED AND INSTALLED REPAIR ANGLES PER EA 5310-04498.SDR KCSA081241Stiffener · damagedFUSELAGE FRAME STIFFENER IS DAMAGED AT STA 880, STR 39R.SDR USAA920081131Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED FRAME, BS 480, S8R - S9R. REPAIRED FRAME BS 480, S8R - S9R IAW US AIRWAYS EA 100441 AND 100447.SDR CALA0800460Frame · crackedLAST FASTENER AT FRAME AT STATION 616 RBL 64 IN MID CABIN IS CRACKED. FABRICATED REPAIR PARTS, CAD PLATED, PRIMED AND INSTALLED REPAIR PARTS PER ECRA 5310-01158.SDR CALA0800459Frame · crackedLAST FASTENER IN FRAME AT STA 616 LBL 64 IN MID-CABIN IS CRACKED. FABRICATED REPAIR PARTS SENT OUT FOR CAD PLATING TRIMMED AND INSTALLED REPAIR PER ECRA 5311-01158.
Back to JASC 5311