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 05FDEA02724Frame · dentedMAIN DECK CARGO COMPARTMENT, FRAME FOUND DENT AT LEFT STA 1661, LONGERON 12L. CARRIED OUT REPAIR AS PER SRM 53-30-00.SDR 05FDEA02725Frame · dentedMAIN DECK CARGO COMPARTMENT FRAME FOUND DENT AT LEFT STA 5-0, LONGERON 11L. REPAIRED AS PER SRM 53-30-00.SDR ASOA05822Frame · corrodedDURING A C-CHECK IN YUL, THE FS 37 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED FS 37 AT STRINGER 14R IAW ASA EO 72-53-0166A. (M)SDR ASOA05735Frame · crackedDURING A C-CHECK IN MCN, THE FS 280 FRAME, RBL 9 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE FS 280 FRAME, RBL 9 IAW ASA EO 600-53-0318. (M)SDR ASOA05750Frame · crackedDURING A C-CHECK IN MCN, THE FORWARD SIDE OF FUSELAGE FRAME FS 718, STRINGER 10-11 RT WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE FORWARD SIDE OF FUSELAGE FRAME FS 718, STRINGER 10-11 RT IAW ASA EO 600-53-0066. (M)SDR ASOA05725Frame · crackedDURING A C-CHECK IN MCN, THE FUSELAGE FRAMES FS 718, STRINGER 10 LEFT AND THE FORWARD SIDE OF FS 718, STRINGER 10 AND 11 RIGHT WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE FUSELAGE FRAMES FS 718, STRINGER 10 LEFT AND 11 RT IAW ASA EO60SDR SWAA052615Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052614Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052613Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052612Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA052611Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L TO STR 9L AND STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052610Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA052609Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA052608Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R TO STR 9R AND STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA052607Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052605Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, STR 17R AND STR 17L. REPAIRED FRAME PER BFG ER.SDR 05FDEA02708Frame · dentedFORWARD CARGO BAY, FRAME IS DENTED AT BS 580 BETWEEN STRINGER LT 24 AND LT 23. REPAIRED FRAME IAW SRM 51-40-3.SDR SWAA052588Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER SWA EA & SRM.SDR 2005UALA00901Frame · dentedFRAME DENTED AT STA 1420 BETWEEN S26L AND S27L. TRIMMED OUT DAMAGES, ACP HFEC INSP, NO CRACK FOUND. FABRICATE, ALODINE, PRIME, AND INSTALL REPAIR PER TIMCO GEO-10827.SDR 2005UALA00900Frame · dentedFRAME DENTED AT STA 1620, STR 25R. TRIMMED OUT DAMAGES, ACP HEFC INSP, NO CRACK FOUND. FABRICATE, ALODINE, PRIME, AND INSTALL REPAIR PER TIMCO REO-G10821, REV B.SDR 2005UALA00899Frame · dentedFRAME DENTED AT STA 1500, STR 25L. TRIMMED OUT DAMAGE, ACP HEFC INSP, NO CRACK FOUND. FABRICATE, ALODINE, PRIME, AND INSTALL REPAIR PER TIMCO REO-G10823.SDR 2005UALA00898Frame · dentedFRAME DENTED AT STA 1460 BETWEEN S25L AND S26L. TRIMMED OUT DAMAGES, ACP HEFC INSP, NO CRACK FOUND. FABRICATE, ALODINE, PRIME, AND INSTALL REPAIR PER TIMCO REO-G10825.SDR 2005UALA00897Frame · dentedFRAME DENTED AT STA 1440 BETWEEN S26L AND S27L. TRIMMED OUT DAMAGES, ACP HEFC INSP, NO CRACK FOUND. FABRICATE, ALODINE, PRIME, AND INSTALL REPAIR PER TIMCO REO-G10826.SDR 2005UALA00896Frame · dentedFRAME DENTED AT STA 1380 BETWEEN S26L AND S27L. TRIMMED OUT DAMAGES, ACP HEFC INSP, NO CRACK FOUND. FABRICATE, ALODINE, PRIME, AND INSTALL REPAIR PER TIMCO REO-G10819, REV B.SDR 2005UALA00895Frame · dentedFRAME DENTED AT STA 1540 BETWEEN STR 25R AND STR 26R. TRIMMED OUT DAMAGES, ACP HEFC INSP, NO CRACK. FABRICATE, ALODINE, PRIME AND INSTALL REPAIR PER TIMCO REO-G10820, REV B.SDR 2005UALA00894Frame · dentedFRAME DENTED AT STATION 1480 BTWN S25L AND S26L. TRIMMED OUT DAMAGES, ACP HEFC INSP, NO CRACK FOUND. FABRICATE, ALODINE, PRIME, AND INSTALL REPAIR PER TIMCO REO G10824, REV B.SDR SWAA052595Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SRM.SDR SWIA200515550Frame · crackedFRAME FLANGE CRACKED AT FS 605 STR 9L - BELOW STRINGER CRACK EMINATING FROM TOP FASTENER HOLE ABOVE & BELOW. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FLANGE IAW CRJ REO 601R-53-61-1507.SDR SWIA200515549Frame · crackedFRAME FLANGE CRACKED AT FS 605 STR 9L ABOVE STRINGER FROM LOWER FASTENER HOLE TO EDGE OF FLANGE. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FLANGE IAW CRJ REO 601R-53-61-1507.SDR CA050829001Doubler · cracked(CAN) DURING THE CONTINUING AIRWORTHINESS STRUCTURAL INSPECTION A CRACK WAS FOUND IN THE FLOOR LEVEL DOUBLER FOR THE LT FRAME AT FUSELAGE STATION 207.00, THE CRACK MOVED LATERALLY ACROSS THE DOUBLER FROM THE IB SIDE THOUGH 2 RIVET HOLES AND A BEND. THE PROBABLSDR UPS05445290Frame · corrodedFX FRONT BODY FAIRING SUPPORT UPPER SURFACE FOUND SURFACE CORROSION AT STA 880 RBL 0 TO RBL 1". CORROSION BLEND OUT 0.080" BY 1" BY 1" EXCEED SRM 53-50-01 FIG 5 LIMITS, FRAME WEB REPAIRED AT BS 880 BL 0" TO RBL 1" FWD SIDE AREA AS PER SRM 53-50-04 FIG 1.SDR 2005UALA00888Frame · bentSTA 1340 LEFT HAND SIDE FRAME BENT AT STR 25L. REMOVED EXISTING PRODUCTION SPLICE AND FABRICATED A NEW PRODUCTION SPLICE ANGLE PER TIMCO REO(EVA) G10831, REV C.SDR 2005UALA00887Frame · dentedFRAME HAS A DENT AT STA 1400 BETWEEN STR 26L AND STR 27L, AFT PIT, INBOARD FLANGE. REPAIRED FRAME FLANGE WITH NESTED J-ANGLE TO EXISTING CHORD PER TIMCO REO (EVA) G10828, REV B.SDR 2005UALA00886Frame · dentedFRAME DENTED AT STA 1540 AT STR 26L, AFT PIT, INBOARD FLANGE. REPAIRED FRAME WITH NESTED J-ANGLE REPAIR TO EXISTING CHORD PER TIMCO REO (EVA) G10818, REV BSDR SWAA052567Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, LT SIDE, WL 208. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA052557Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA052556Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA052550Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 328 R1 DOOR CUTOUT FUSELAGE FRAME CRACKED AT NR 4 STOP FITTING. REPAIRED FRAME PER SRM.SDR 05FDEA02603Frame · wornAIR COND COMPT LT SIDE FOUND WORN FRAME AT STA 588 X=64. TRIMMED WORN AREA AND REPAIR IAW SRM.SDR 1050617009Frame · crackedCENTER CANTED FRAME AT FS 588. LEFT FLANGE CRACKED AT NUT PLATE AND RIVET, STRINGER 7L AND 8L. MORE INFORMATION WILL BE AVAILABLE AT A LATER DATE.SDR 05FDEA02601Frame · damagedN01449, WHILE WORKING EA 7-5330-72293B PT 2, FOUND DOUBLE HOLE IN FRAME AT 620 LBL 21 WL 302. REPAIRED DOUBLE HOLE IN FRAME, BS 620, LBL 21 PER FED-EX EA 7-5330-92327.SDR 05FDEA02600Frame · damagedPILOT HOLES NEXT TO FASTENER HOLES IN STUB FRAME BS 610 STR3L. REPAIRED FRAME PER FED-EX EA 7-5330-92328. [CLOSED]SDR 05FDEA02593Frame · crackedN01510 WHILE WORKING FED EX NON ROUTINE CARD 5184, FOUND THE FRAME TO BE CRACKED AT BODY STATION 420 STRINGER 20R ** SD ** COMING REPAIRED CRACK PER SRM 51-40-3, THIS IS A MAJOR REPAIR.SDR SWAA052539Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA052538Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, STR 24R. REPAIRED FRAME PER BFG ER.SDR 05FDEA02596Frame · damagedWHILE WORKING FED EX EA 7-5330-72293B PT2, FOUND FASTENER HOLES ON EDGE OF FRAME WITH NO EDGE DISTANCE, BS 620 LBL-9 W/L 302 AND 303 2 EA. REPAIRED FRAME BS 620, LBL 9 PER FED-EX EA 7-5330-92323.SDR SWAA052528Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 616, RBL 65, WL 200. REPAIRED FRAME CHORD PER BFG ER.SDR 10506017007Frame · corrodedCORROSION FOUND ON INSPECTION FOR ABC STRUCTURAL FS 213.25. MORE INFORMATION TO BE ADDED AT A LATER DATE.SDR ASAA0540421Frame · crackedFRAME AT BSTA 500, RBL 1, WL 154 CRACKED. REPAIRED FRAME IAW SRM. (K)SDR ASOA05674Frame · crackedDURING A C-CHECK IN MCN, THE FS 280 FRAME AT LBL 10 AND RBL 10 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE FS 280 FRAME AT LBL 10 AND RBL 10 IAW ASA EO 600-53-0309. (M)
Back to JASC 5311