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 SWAA072715Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072724Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072720Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072723Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 580, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072717Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072716Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072722Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR C1HA200796011Frame · corrodedCORROSION STA 312 AT DOGHOUSE, RT. REPAIRED FRAME AS REQUIRED IAW B727 SRM 53-10-4 FIG 14.SDR 07FDEA02004Frame · damagedGROOVE AND MISDRILLED SPOT AT C73, P 30-31 RT. REPAIR PERFORMED BY REWORK OF EXISTING GROOVE PER SRM 51-73-10 AND INSTALL RIVET LN9198-3200 IN DRILLED HOLE, APPROVED BY EA 6-5218-106451 AND RAS/DAHAM/4022141/2007 ISS. ASDR 07FDEA02000Frame · damagedFOUND 5 TOO LARGE HOLES AT JACKING POINT C 59, P26-27 RHS REPAIR PERFORMED BY HI-LOK HL110VF8 IN PLACE HL110VF6 IAW EA 6-5317-106466 AND RAS/DAHAM/4022180/2007 ISS. BSDR UPS07450022Doubler · crackedINSPECTION TYPE:C THROUGH THICKNESS CRACK FOUND AT BS 880 STR 9R TENSION TIE AT NR 10 FASTENER HOLE OF FRAME DOUBLER THE CRACK RUNNING AT UPWARD DIRECTION (CRACK LENGTH .25 INCH). M/DECK BS 880 RIGHT STR 9R FRAME ATTACH DOUBLER REPLACED AND INSTALLED AS PER SSDR 2007UALA01706Frame · dentedAFT PIT, LEFT STA 1580, STR 25L AREA, MAIN FRAME DENTED. MAJOR REPAIR ACCOMPLISHED: REMOVED DENT DAMAGE ON FRAME INBOARD FLANGE BETWEEN STR 23L - 24L & BETWEEN 26L-27L. REMOVED EXISTING PRODUCTION SPLICE. FABRICATED & INSTALLED A NEW PRODUCTION SPLICE ANGLSDR 2007UALA01705Frame · dentedAFT PIT, LEFT SIDE STA 1440, STR 25L AREA, MAIN FRAME DENTED. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE ON FRAME INBOARD FLANGE BETWEEN STR 23L - 23L & 25L, REMOVED EXISTING PRODUCTION SPLICE. FABRICATED & INSTALLED A NEW PRODUCTION SPLICE ANGLE. FABRICATESDR 2007UALA01704Frame · dentedAFT PIT, LEFT SIDE STA 1420 BETWEEN STR 24- 25L, MAIN FRAME DENTED. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE & EXISTING PRODUCTION SPLICE. FABRICATED & INSTALLED A NEW PRODUCTION SPLICE ANGLE. FABRICATED & INSTALLED 2 EA -15 STRINGER CLIPS.SDR 2007UALA01703Frame · crushedFWD PIT- LEFT SIDE, STA 600 BETWEEN STR 22- 25L MAIN FRAME CRUSHED (RIB). MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. FABRICATED & INSTALLED A J-ANGLE REPAIR NESTED INSIDE THE FRAME INBOARD FLANGE. FABRICATED & INSTALLED 2 EA -80 STRINGER CLIPS. FABRICATEDSDR 2007UALA01680Frame · bentFWD PIT LEFT SIDE, STA 580, STR 24L - 25L MAIN FRAME BENT (RIB). MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE AND EXISTING PRODUCTION SPLICE AND FABRICATED A REPAIR ANGLE AND INSTALLED. ALSO FABRICATED & INSTALLED 1 EA -80 STRINGER CLIP.SDR 2007UALA01679Frame · dentedAFT PIT, LEFT SIDE, STA 1480 BETWEEN STR 24 - 25L, MAIN FRAME HAS 2 EA DENTS. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE AND FABRICATED A J-REPAIR ANGLE AND INSTALLED NESTED INSIDE THE FRAME INBOARD FLANGE.SDR 2007UALA01678Frame · dentedFWD PIT, LEFT SIDE, STA 680, BETWEEN STR 23 - 24L, MAIN FRAME HAS DENT (RIB). MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE AND FABRICATED A J-REPAIR ANGLE AND INSTALLED TO NEST INSIDE THE FRAME INBOARD FLANGE.SDR 2007UALA01677Frame · dentedAFT PIT, RIGHT SIDE, STA 1580 AT STR 25R AREA, MAIN FRAME DENTED. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE AND FABRICATED A J-ANGLE REPAIR PIECE AND INSTALLED NESTED INSIDE FRAME INBOARD FLANGE.SDR 2007UALA01676Frame · dentedAFT PIT RIGHT SIDE, STA 1560 AT STR 25R, MAIN FRAME DENTED (RIB). MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE AND FABRICATED A J-ANGLE REPAIR PIECE AND INSTALLED NESTED INSIDE FRAME INBOARD FLANGE.SDR 2007UALA01675Frame · dentedFWD PIT, LEFT SIDE, STA 660, BETWEEN STR 24 -25L, MAIN FRAME DENTED (RIB). MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE AND EXISTING PRODUCTION SPLICE. FABRICATED A NEW PRODUCTION SPLICE AND 1 EA -30 STRINGER CLIP.SDR SWAA072701Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA072702Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072703Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072704Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072700Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072699Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294, STR 13L. REPAIRED FRAME PER SWA EA.SDR QXEA200700938Frame · crackedC1 OKC - RIGHT FS 280.00 FRAME CRACKED AT RBL9. REPAIRED IAW REO670-53-11-047 AND SRM 51-42-21.SDR QXEA200700937Frame · crackedC1 OKC - FOUND LEFT FS 280.00 FRAME CRACKED AT LBL9. REPAIRED IAW REO670-53-11-047 AND SRM 51-42-21.SDR DU4R20070125Frame · dentedFOUND DENT MAIN FRAME UPPER CAP IN FWD PIT BS 720 AT B/L 0. REPAIRED BY FABRICATING AND INSTALLING DOUBLER 5-5/8 BY 1-7/8 BY 1 FROM 7075-T6 .063 IAW B757 SRM 51-40-05, 51-40-02 AND 51-20-01.SDR 2007UALA01674Frame · dentedAFT PIT, LEFT SIDE, STA 1400, STR 25L AREA, MAIN FRAME HAS DENT. MAJOR REPAIR ACCOMPLISHED: REMOVED EXISTING REPAIR FROM FRAME INBOARD FLANGE AT STR 27L. FABRICATED & INSTALLED A NESTED J-ANGLE REPAIR WHICH IS NESTED INSIDE THE EXISTING CHORD BETWEEN STR 25SDR ASAA0741699Frame · crackedFRAME SKIN ATTACHMENT ANGLE IS CRACKED AT ATTACHMENT HOLE. REMOVED DAMAGED SECTION OF FRAME FABRICATED AND INSTALLED REPAIR SHEAR TIE FILLER AND ANGLE IAW SRM 53-00-07 REPAIR 3.SDR CALA0700269Frame · corrodedINSPECTION FOUND LOWER O/B CHORD CORRODED AT STA 227, RBL 0 TO LBL 3. REPAIRED IAW ECRA 5311-01324 ITEM 1-16, PAGE 1-3.SDR DLM88070615Frame · crackedREPAIR 3 CRACKS ON CANTED FRAME OUTER CAP. LEFT SIDE 2 CRACKS OF 1/2" LONG AND 1.125" LONG AT L-4L AND ONE 1/2" CRACK AT L-3L. INSTALLED NEW FRAME IAW SRM 53-03D FIG 30.SDR SWAA072681Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR 07FDEA01981Frame · corrodedFORWARD LOWER CARGO, DOOR TORQUE BOX FORWARD FRAME CORRODED. REMOVED CORROSION FROM FRAME AND WEB AND FOUND MATERIAL LOSS FOR BOTH TO EXCEED ALLOWABLE LIMITS IAW MD/DC 10 SRM53-00-01 VOL I FIG 1B. REPAIRED FRAME IAW FED EX EA NR 8-5350-109161 "FUSELAGE-FWD LSDR DL76L100107Frame · unknownFUSELAGE BS 1809.5 BULKHEAD OUTER CHORD REPAIR IAW EO 01-074914-12 ME08 RT C/W 01-074914-12 ME08 RT.SDR SWAA072665Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072662Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072664Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR DU4R20070126Frame · bentFOUND BENT MAIN FRAME UPPER SURFACE IN FWD PIT BS 660 AT S-24L. REPAIRED BY CUTTING OUT BENT SECTION OF FRAME. FABRICATED AND INSTALLED DOUBLER 11-1/2 BY ¼ BY 1 BY 2 FROM 7075-T6 .063 IAW B757 SRM 53-00-07 AND 51-20-01.SDR USAA200705U09Frame · crackedA 1 INCH LONG CRACK FOUND AT BS 440, S-24R. CLT - REPAIR: REMOVED DAMAGE, FABRICATED & INSTALLED FILLER & REPAIR ANGLES PER EA 98691.SDR ASAA0741698Frame · corrodedFRAME IS CORRODED. REMOVED CORRODED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR SECTION OF FRAME IAW SRM 53-00-07 REPAIR 3.SDR 2007FA0000481Spar · damagedFOUND SMOKING RIVETS ON TOP OF FUSELAGE IN AREA OF THE REAR CENTER SECTION SPAR. REMOVED RIVETS (APPROX. EIGHT ON EACH END OF SPAR) AND FOUND RIVET HOLES SEVERELY ELONGATED. FACTORY ORIGINAL RIVETS WERE .1250 INCH DIA. AND SEVERAL HAD BEEN REPLACED IN THE FISDR ASAA0741693Frame · corrodedAFT CARGO PIT FRAME DOUBLER FOUND CORRODED. FRAME REPLACED WITH NEW PART IAW SRM 51-40-05.SDR DHL2007740530Frame · dentedWHILE IN "C", FWD CARGO COMPT STA 600 +4" REINFORCEMENT FRAME IS DENTED ABOVE STR 24L. TRIMMED OUT DAMAGED (DIM.3" BY 1.25") IAW B727 SRM 51-10-1. FABRICATED REPAIR CHANNEL FROM 7075-0 .090 PO NR 7185240 (DIM 23" BY 5") IAW B727 SRM 53-10-4 FIG 1. HEAT TREASDR TRAX200700709Frame · corrodedFRAME AT FS349 AT STGR 27 CORRODED. REMOVED FRAME AT BS 349, BLENDED CORROSION FROM UNDERSIDE OF FRAME FOUND TO BE OUT OF LIMITS PER SRM, REMOVED INTERCOSTAL AT RT BS 349 AFT TO DOOR FRAME AND REMOVED LT VERT. FRAME AT ELEC. JUCTION BOX. INSTALLED NEW FRSDR TRAX200700711Frame · corrodedFRAME AT FS 364 AT STGR 27 CORRODED. WORK COMPLETED IN ACCORDANCE WITH CRJ 200 SRM 51-42-06, CRJ 200 SRM 51-21-06, CRJ 200 NDTM 51-20-04, CRJ 200 SRM 51-42-06, CRJ 200 SRM 51-00-00 & IAW CRJ 200 SRM 51-21-11.SDR TRAX200700710Frame · corrodedFRAME AT FS 333 AT STGR 27 CORRODED. WORK COMPLETED IN ACCORDANCE WITH CRJ 200 SRM 51-21-06, CRJ 200 NDTM 51-20-04. CRJ 200 SRM CRJ 200 51-00-00 APPLIED CIC IAW CRJ 200 SRM 51-21-11.SDR SWAA072604Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 8R. REPAIRED FRAME SECTION PER SWA EA.
Back to JASC 5311