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 2006UALA02099Frame · damagedFRAME TO FLOOR Z ANGLE HAS DRILL START IN FRAME BS 747 LT SIDE. MAJOR REPAIR: INSTALLED NESTED ANGLE FILLER DOUBLER FRAME REPAIR PER MM 53-11-99 REPAIR VIII PAGE 812-813 AND 828 AND REINSTLALED Z ANGLE. REFERENCE SRM 51-40-02.SDR USAA061277Frame · crackedFOUND FRAME CRACKED BS 727 STR 15L. INSTALLED DOUBLERS IAW EA 98146, DEFECT SIZE: 1.05".SDR USAA061282Frame · crackedFOUND CRACK, BS 492.4 FWD DOOR FRAME. REMOVED CRACKED FRAME AND INSTALLED NEW FRAME IAW SRM 51-40-02, DEFECT SIZE: .25".SDR TRAX200600959Frame · crackedRIGHT SIDE 640 FRAME IS CRACKED. REPAIRED RT SIDE FRAME 640 BY PERFORMING MODIFICATION TO LEFT AND RIGHT SIDE FRAME 540 BETWEEN STR 9 AND STR 12 REF S.B. 601R-53-061 APPENDIX B. (CLOSED 11/06/06)SDR CALA0600437Beltframe · crackedINSPECTION FOUND A 2 INCH CRACK IN BELTFRAME AT STA 616, S7L. REPAIRED IAW SRM 53-00-07.SDR 06FDEA03802Frame · damagedFOUND FWD CARGO COMPARTMENT, DAMAGE TO STA 580 FRAME BETWEEN STR 22L AND 25L. REMOVED DAMAGE ON FRAME BS 580 STR 22L TO 25L AND REPAIRED IAW SRM 53-10-1, 51-40-3.SDR USAA061268Frame · dentedFRAME DENT IN UPPER FLANGE AT STA 747 S25R. INSTALLED DOUBLER IAW SRM 51-40-02, DEFECT SIZE: .5 INCH.SDR 2006UALA02077Frame · corrodedAFT CARGO COMPARTMENT FRAME INBOARD FLANGE HAS 2 AND 1 MISDRILLED HOLES WITH LIGHT CORROSION AROUND THE HOLES AT THE FOLLOWING LOCATIONS, BS 727E AND BS 727D BETWEEN STR 25R AND 26R. REMOVED CORROSION AND INSTALLED STRAP REPAIR PER MM 53-11-99.SDR 2006UALA02066Frame · crackedLT BS 1265 NR 1 HOLE FRAME WEB AND INNER STRUCTURE CRACKED. REPAIRED FRAME PER ENGINEERING CHANGE ORDER TASK CARD. SUSPECT PRESSURIZATION CYCLE FATIGUE DAMAGE.SDR 06FDEA03794Frame · damagedFWD CARGO COMPARTMENT, DAMAGE TO STA 560 FRAME BETWEEN STR 22L AND 25L. REPAIRED FRAME IAW SRM 51-40-3.SDR 06FDEA03791Frame · damagedL/H INTERIOR FUSELAGE, FRAME REPAIR STA. 930 STRINGER 5L, REPAIR REQUIRES EVALUATION TO DETERMINE IF REPAIR IS MAJOR OR MINOR AND IF THE REPAIR IS IN ACCORDANCE WITH FAA APPROVED DATA. REPAIRED FRAME AT BS 930, STR 5L PER SRM 51-40-3.SDR KCSA061476Frame · damagedDAMAGE ON FORWARD CARGO DOOR OPENING UPPER FRAME AT BS 660, STR 29R.SDR TRAX200600930Frame · crackedRIGHT SIDE FS 640 FRAME DOUBLER SUSPECT CRACKED. FLT 4256 CX. PERFORMED MODIFICATION OF FRAME 640 LEFT AND RIGHT SIDE BETWEEN STR 9 AND STR 12 REF S.B.601R-53-061 APPENDIX B (CLOSED 11/01/06).SDR USAA061257Frame · crackedBS 616 RIGHT FRAME CRACK. FABRICATED 5' REPAIR ANGLE IAW T/R 53-62-01, DEFECT SIZE: .50 INCH.SDR USAA061253Frame · crackedSTA 907R S8R AND S9R CRACKED. FABRICATED TWO FRAME DOUBLERS IAW SRM 53-10-20, DEFECT SIZE: .25 INCH.SDR USAA061252Frame · crackedSTA 380 S9R CRACKED. REMOVED DAMAGE, INSTALLED 11 INCH DOUBLER REPAIR PARTS IAW TR 53-10-20D, DEFECT SIZE: .180 INCH.SDR CALA0600428Frame · crackedINSPECTION FOUND A 1/2" CRACK IN MAIN FRAME AT STA 616 JUST BELOW FLOOR, S18R. REPAIRED IAW ECRA 5311-01158.SDR CALA0600427Frame · crackedINSPECTION FOUND A 0.6" CRACK IN MAIN FRAME AT STA 616 JUST BELOW FLOOR, S17L. REPAIRED IAW ECRA 5311-01158.SDR SWAA064105Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064104Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L AND STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064099Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500, BL 0. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR CALA0600425Frame · corrodedINSPECTION FOUND FRAME IN FORWARD EQUIPMENT BAY CORRODED AT STA 227.8 BETWEEN LBL 8 AND RBL 8, S29L. A REPAIR WAS INSTALLED IAW ECRA 5311-01273.SDR PIDR2006037Frame · crackedCRACKS IN BS663.75 FRAME AT STR 2RT AND STR 3RT. REPAIRED FRAME IAW SRM 53-00-07.SDR TRAX200600918Frame · crackedRIGHT 640.00 FRAME DOUBLER AT BL 45 CRACKED. REPAIRED IAW ALL APPROPRIATE REPAIR MANUALS.SDR SWAA064086Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064085Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064084Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 9L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064083Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR 06FDEA03764Frame · wornLT AIR COND COMPT: WEARS ON FRAME AT STA 588 X = 62. BLENDED OUT WEARS IAW SRM 53-00-01 VOL 1 FIG 1B, PERFORMED INSPECTION IAW NDI SPM 04 MIN THK .054" NOM. .063" MAT IS WITHIN LIMITS IAW SRM 53-00-01 VOL 1 FIG 1B. PROTECTED AREA IAW SRM 51-21-01 VOL 2 PAR 2SDR SWAA064075Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 13R. REPAIRED FRAME SECTION PER SWA EA.SDR QXEA200603438Frame · corrodedPDX C4 - CORROSION ON FRAME DATUM AFT SIDE AT RIGHT STATION X387.350 ABOVE STRINGER 24R. REPAIRED IAW DHC-8-200 SRM 51-20-11, 51-20-16 AND 51-20-36.SDR UPS06448697Frame · crackedINSPECTION TYPE:C LEFT BS 2231 FRAME FOUND CRACKED AT REVEAL AT 3EA LOCATIONS BETWEEN S23L & 25L. CRACK LENGTH .125" & .375" & .625". LEFT BS 2231 FRAME BETWEEN S23L - S25L REVEAL REPAIRED AS PER HX RS R53-00-35672 WORKING DETAIL REF NRC 51422. CONTINUED ISDR UPS06448695Frame · crackedINSPECTION TYPE:C RIGHT BS 2231 FRAME FOUND CRACKED AT CHORD AT 2EA FASTENER LOCATION STR 24R & 25R. CRACK LENGTH 0.040" & 0.060". M/D BS 2231 FRAME CHORD REPAIRED AS PER HX RS R53-60-35673 REFER NRC 51427 FOR WORKING DETAIL. CONTINUED INSPECTION IS REQUIRESDR UPS06448694Frame · crackedINSPECTION TYPE:C RIGHT BS 2231 FRAME FOUND CRACKED AT REVEAL AT 2EA LOCATIONS BETWEEN STR 24R & 25R. CRACK LENGTH .1875" & .5". M/D BS 2231 FRAME ATTACHED REVEAL REPAIRED AS PER HX RS R53-60-35673 REF NRC 51427 FOR WORKING DETAIL. CONTINUED INSPECTION IS RSDR SIMA200631817Frame · corrodedDISC - FOUND FUSELAGE FRAME STATION 225 CORRODED. REMOVED CORRISION WITH CUTOUT, FABRICATED FILLER AND DOUBLER, INSTALLED IAW SAAB SRM 53-70-30. AIRCRAFT RETURNED TO SERVICE.SDR SWAA064076Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME SECTION PER ER.SDR SWAA064070Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, STR 24R. REMOVED AND REPLACED FRAME SECTION PER ACO AND BOEING DRAWING.SDR SWAA064064Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500C, BETWEEN STR 28R AND STR 28L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA064063Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500B, BETWEEN STR 28R AND STR 28L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 06FDEA03734Frame · crackedLWR FUSELAGE CAC AT STA 1159 BTW LONG NR 29 AND LONG NR 30 LT SIDE ON FRAME FOUND CRACK 1" LONG AREA CLEANED IAW SRM 51-31-01 VOL 2 PAR 22. NDI INSP CARRIED OUT (SEE JPF). CRACK REMOVED IAW SRM 53-30-00 VOL 1 FIG 7 P/N'S I015877-3; -5; -13; -15. INSTALLED ISDR UPS06448696Frame · crackedINSPECTION TYPE:C LEFT BS 2231 FRAME BETWEEN S-24L & 25L ONE FASTENER HOLE CRACK FOUND ON REVEAL. CRACK LENGTH 0.030". FRAME REVEAL REPAIRED AS PER HX RS R53-00-35672 AT BS 2231 BETWEEN STR 23L TO STR 25L AREA. CONTINUED INSPECTION IS REQUIRED AS PER HX RS SDR UPS06448693Frame · crackedINSPECTION TYPE:C RT BS 2231 FRAME BETWEEN S24R & S25R ONE FASTENER HOLE CRACK FOUND ON CHORD I/B SURFACE APPROX 0.040" RUNNING FWD. M/D BS 2231 RT FRAME ATTACHED CHORD & REVEAL REPAIRED AS PER HX RS R53-60-35673. CONTINUED INSPECTION IS REQUIRED AS PER HX RSDR UPS06448667Frame · crackedINSPECTION TYPE:C FWD CARGO COMPT LT STA 880 STRINGER 39 FRAME FOUND CRACK. CRACK LENGTH 7 INCH FWD CARGO COMPT BS 880 LEFT STR 36L TO STR 40L FRAME REPAIRED AS PER RS R53-00-35679 AND UPS EO B747-5310-25578-A.SDR UPS06448474Frame · crackedINSPECTION TYPE:C FWD CARGO COMPT RT STA 880 S37 AND S38 FRAME FOUND CRACKED, (2 LOCATION), CRACK LENGTH 4" AND 2.5" FRAME REPAIRED PER SRM 53-10-04 FIG 52.SDR SWAA064055Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 303, STR 17L. REMOVED AND REPLACED FRAME WEB SECTION PER SRM.SDR SWAA064053Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064052Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 908, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064051Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064050Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064049Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME SECTION PER SWA EA.
Back to JASC 5311