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 SWAA084555Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084554Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084553Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084552Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084551Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084550Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084549Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR 2008UALA04319Frame · dentedAFT PIT STA 1520, STR 25L, FRAME IS DENTED. *S/D* MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE & INSTALLED DOUBLER REPAIR.SDR 2008UALA04318Frame · damagedFWD CARGO PIT, DENT ON FUSELAGE FRAME UPPER FLANGE AT STA 580, STR 23L TO 24L. *S/D* MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE ON FRAME & INSTALLED DOUBLER REPAIR.SDR 2008UALA04317Frame · dentedAFT PIT STA 1480 BETWEEN STR 27L AND 26L FRAME IS DENTED. *S/D* MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE & INSTALLED DOUBLER REPAIR.SDR 2008UALA04316Frame · dentedAFT PIT STA 1440 STR 25L, FRAME DENTED. *S/D* MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE & INSTALLED DOUBLER REPAIR.SDR 2008UALA04315Frame · dentedAFT PIT STA 1400 BETWEEN STR 27L AND 26L, FRAME IS DENTED. *S/D* MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE & INSTALLED DOUBLER REPAIR.SDR 2008UALA04314Frame · dentedAFT PIT STA 1420 BETWEEN STR 27L AND 26L FRAME IS DENTED. *S/D* MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE & INSTALLED DOUBLER REPAIR.SDR UPS08553310Frame · damagedINSPECTION TYPE:C3 MAIN CARGO HAS 8 EA AREAS OF MECH DAMAGE ON FRAME BS 365 STR 5L-14L WL 263 OUT OF LIMITS. INSTALLED DOUBLER IAW EO.SDR UIEA200800287Frame · crackedBS 380 FRAME WEB AT STRINGER 17L & 17R CRACKED. REPAIRED IAW SERVICE REQUEST 1911068869 APPROVED BY FAA FORM 8100-9 DATED 6 AUG 2008, DETAILS OF WORK KEPT AT ENGINEERING ORDER EO 4753B184. (S)SDR 08FDEA03445Frame · corrodedFRAME P/N AEA 0273-3 REQUIRES FABRICATION DUE TO BEING CORRODED BEYOND LIMITS. FABRICATED A NEW FRAME SECTION AND SHEAR TIE IAW DWG AEA 0273; REV "G". LOCATED AND DRILLED AEA 0273-3 FRAME AND AEA 0273-5 SHEAR TIE. ALODINED AND PRIMED IAW SRM 51-21-01; PGSSDR UIEA200800288Frame · crackedBS 360 FRAME WEB NEAR STRINGER 14L CRACKED. REPAIRED IAW BOEING SERVICE REQUEST 1911055155 APPROVED BY FAA FORM 8100-9 DATED 6 AUG 2008, DETAILS OF WORK KEPT AT ATLAS ENGINEERING ORDER EO4753B183. (S)SDR UPS08553321Frame · damagedINSPECTION TYPE:3C PREVIOUS REPAIR ARE OF THE BS 1640 FRAME STR 23R TO STR 24R EO REPAIR B757-5310-27668A REQUIRED. REPORT FINDINGS TO CUSTOMER. REMOVE PREVIOUS REPAIR REPORTED FINDING AND REPAIR BS 1640 FRAME FROM STR 23R TO 24R PER EO B757-5310-27668-B.SDR UPS08553315Frame · damagedINSPECTION TYPE:C3 CUSTOMER REQUEST REPAIR AREA OF BS 1640 FRAME STR 25L TO 26L PER EO B757-5310-27669-B REPORT FINDINGS TO CUSTOMER. REPORTED FINDING TO CUSTOMER AND REPAIR 1640 FRAME & CHORD PER EO B757-5310-27669-C.SDR MAS2008F00057Frame · dentedRIB ON RT SIDE OF CARGO BAY IS DENTED AT STATION 677 JUST ABOVE WL 73.5. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLER IAW EOS53476 AND SRM 51-20-00 AND 51-40-00. (S)SDR CALA0800792Frame · crackedFUSELAGE FRAME CRACKED AT STATION 360 S9L. REPAIRED FUSELAGE FRAME STATION 360 BETWEEN S8L AND S9L PER ECRA5311-01416. INITIATED DIP ITEM 53-DIP, CONTROL NR 089838 AS FOLLOWS: BEFORE THE ACCUMULATION OF 79,104 TOTAL AIRCRAFT FLIGHT CYCLES AND AT INTERVALS NSDR UPS08553284Frame · gougedINSPECTION TYPE:C3 BS 940 FRAME INNER CHORD IS GOUGED ON THE AFT SIDE AT STR 15R. BLENDED OUT GOUGED PER ATS ER 08-2721 DATED AUG 28 08.SDR UPS08553283Frame · gougedINSPECTION TYPE:C3 BS 440 FRAME GOUGED STR 12L FWD SIDE. REPAIRED BS 440 FRAME WITH CHANNELS & FILLER IAW SRM 53-00-07-2R.SDR UPS08553282Frame · dentedINSPECTION TYPE:C3 FRAME DENTED BS 560 4 INCHES ABOVE STR 7R. ACCOMPLISHED REPAIR PER SRM 53-00-07-2R1.SDR UPS08553281Frame · dentedINSPECTION TYPE:C3 FRAME DENTED BS 540 4 INCHES ABOVE STR 7R. REPAIRED DAMAGED FRAME PER SRM 51-70-11-0G, SRM 51-40-02, SRM 53-00-07-2R.SDR CALA0800793Frame · crackedFRAME CRACKED AT STATION 500A S-9R. FABRICATED AND INSTALLED REPAIR PER ECRA 5310-04819.SDR CALA0800788Frame · crackedFRAME CRACKED STATION 400 AT STR 9LT. TRIMMED OUT CRACKED AREA AND INSTALLED REPAIR DOUBLERS PER EA 5310-04498 OP 2.SDR CALA0800787Frame · crackedFRAME CRACKED STATION 480 AT S9R. FABRICATED AND INSTALLED REPAIR PER ECRA 5310-04819.SDR CALA0800786Frame · crackedFRAME CRACKED STATION 440 AT S-9L. FABRICATED AND INSTALLED REPAIR PER ECRA 5310-04819.SDR CALA0800785Frame · crackedFRAME CRACKED STATION 400 AT S-9L. FABRICATED AND INSTALLED REPAIR PER ECRA 5310-04819.SDR CALA0800784Frame · crackedFRAME CRACKED STATION 400 AT S-9R. FABRICATED AND INSTALLED REPAIR PER ECRA 5310-04819.SDR SWAA084503Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084502Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084501Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084500Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA084499Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA084493Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084487Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084486Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 21R. REPAIRED FRAME PER SRM.SDR SWAA084485Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, STR 16L. REPAIRED FRAME PER SRM.SDR KCSA081380Frame · corrodedCORROSION ON DOUBLER ON TOP OF RT OVERWING LONGERON AT BS 1315, RBL 123, WL 158. (S)SDR KCSA081379Frame · corrodedCORROSION ON FRAME ABOVE RT OVERWING LONGERON AT BS 1297, RBL 121, WL 160. (S)SDR FDEA200808123380Frame · crackedRT AIR COND COMPT FOUND CRACK ON CAP OF FRAME, SEE NRC N00755 AND N00756. REPAIRED AREA IAW SRM 53-30-00 FIG 5 VOL I.SDR K11A2008111272201Frame · corrodedEVIDENCE OF CORROSION ON LOWER WEB OF SUB FLOOR FRAME ON AFT SIDE BETWEEN STRINGERS 26L AND 27L BY NOSE GEAR WELL BULKHEAD AT STA 304, LBL 16, WL 146.SDR ASAA0843415Frame · crackedFRAME INNER CHORD BS 616 RT BELOW FLOOR IS CRACKED FROM BOTTOM TIP TO THE LWR HOLE. REPAIRED IAW ERO 8605 AND EA 5310 028114SDR SWAA084454Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20L. REPAIRED FRAME PER SRM.SDR SWAA084453Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 3R. REPAIRED FRAME PER SRM.SDR SWAA084452Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, BETWEEN STR 2R AND STR 3R. REPAIRED FRAME PER SRM.SDR 08FDEA03380Frame · crackedRT AIR COND COMPT FOUND CRACK ON CAP OF FRAME.SDR KCSA081390Frame · crackedBS 440 S10R FRAME OUTBOARD FLANGE CRACKED IN RADIUS .375 INCH. CRACK MARKED. UPPER DECK. (S)
Back to JASC 5311