JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, 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 = '5310' 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 = '5310' 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 HALA2014040400043Structure · damagedFOUND DAMAGE NOSE GEAR AREA BETWEEN FRAME 18, BETWEEN STRINGERS 51 AND 52. REMOVED DAMAGE, HFEC AREA, NO CRACKS INDICATIONS NOTED.SDR DALA14020875804Door Frame · gougedTWO SMALL GOUGES ON L1 DOOR CUT OUT UPPER FRAME AT BS 358 AND 368. BLENDED GOUGES AND FOUND OUT OF LIMITS IAW SRM. R & R STRAPS IAW SRM.SDR SWIA201437755Window Frame · crackedCO-PILOT WINDSHIELD SIDE POST LOWER AFT FITTING IS CRACKED AT RADIUS. C-CHECK. LOCATED, DRILLED AND INSTALLED A NEW/SERVICEABLE CO-PILOT'S SIDE POST LOWER/AFT FITTING IAW SRM.SDR SWIA201437754Window Frame · crackedPILOT WINDSHIELD SIDE POST LOWER AFT FITTING IS CRACKED AT RADIUS. C-CHECK, REMOVED CRACKED PILOT WINDSHIELD SIDE POST LOWER AFT FITTING AND INSTALLED NEW SERVICEABLE FITTING IAW SRM.SDR FDEA201404020614Rib · crackedCENTER WING JOINING AT FRAME 40 RT CRACKED. REAM THROUGH ALL LAYERS IAW SRM 51-40-44. PERFORM ROTOTEST INSPECTION IAW NTM51-10-01 AND NO CRACK FOUND. FABRICATE BUSHES & TWO CRUSH WASHERS AND INSTALLED IAW EA6-5710-T0307761.SDR SWAA2014042827413Window Frame · crackedLEFT NR 1 WINDOW FRAME CRACKED IN UPPER AFT CORNER. REPAIRED FRAME IAW ACO, ER, & EA.SDR DALA14020569203Door Frame · corrodedAFT CARGO LOWER FRAME CORRODED. REMOVED CORROSION. FABRICATED AND INSTALLED DOUBLER REPAIR BS 1212 - 1226 IAW SRM 53-60-02.SDR DALA14020456810Failsafe · corrodedFRAME FAILSAFE IN AFT CARGO BAY AT BS 1280 CORRODED BETWEEN STRINGERS 20-24L. CUT OUT DAMAGED SECTION OF FAILSAFE, 16.6" LONG, FABRICATED NEW FAILSAFE SECTION AND FILLER. INSTALLED REPAIR ALL IAW ER/A 523955-14.SDR RAIA201404020003Beam · corrodedCENTER BEAM GUSSET HAS CORROSION AT FRAME 20. MAINTENANCE REPLACED CENTER BEAM GUSSET.SDR SWIA201438009Track · corrodedFWD CARGO BAY RETRIEVAL SYSTEM, AFT CENTER TRACK FOUND TO BE CORRODED. C-CHECK, REPLACED WITH NEW FWD CARGO, AFT CENTER TRACK IAW AMM.SDR SWIA201438008Track · corrodedFWD CARGO BAY RETRIEVAL SYSTEM FWD RT INBD TRACK FOUND TO BE CORRODED. C-CHECK, REPLACED WITH NEW FWD RT INBD TRACK IAW AMM.SDR SWAA2014042827412Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED AT BS 727E+2, WL 208. REPAIRED WEB IAW DWG & SRM.SDR SWAA2014042127256Window Frame · crackedLEFT NR 1 WINDOW FRAME AT UPPER AFT CORNER CRACKED AT INNER SURFACE EDGE. REPAIRED FRAME IAW ACO.SDR SWAA2014041427106Crease Beam · corrodedFORWARD ENTRY DOOR UNDER CREASE BEAM WEB CORRODED. R & R WEB IAW SRM & DWG.SDR ASAA2014033107432Stop Fitting · crackedL1 DOOR UPPER AFT STOP PIN FITTING CRACKED, NDT VERIFIED, FOUND DURING LINER INSTALL. ACFT GROUNDED. R & R L1 DOOR UPPER AFT STOP IN FITTING IAW EA 400-52, EA-124 32.SDR SPUY201403310029Window Frame · corrodedFUSELAGE EXTERIOR LT SIDE, PLUGGED WINDOWS AREA SHOWS CORROSION BETWEEN BS 720F AND 740.SDR SPUY201403310028Window Frame · corrodedFUSELAGE EXTERIOR, POINTS OF CORROSION AROUND PASSENGERS WINDOW FRAME BETWEEN 804.5-825.95, RT SIDE.SDR SPUY201403310027Window Frame · corrodedFUSELAGE EXTERIOR, POINTS OF CORROSION AROUND PASSENGERS WINDOW FRAME BETWEEN BS 848.5 AND 870, RT SIDE.SDR SPUY201403310026Window Frame · corrodedFUSELAGE EXTERIOR, POINTS OF CORROSION AROUND PASSENGERS WINDOW FRAME BETWEEN 870 AND 890, RT SIDE.SDR SPUY201403310025Window Frame · corrodedFUSELAGE EXTERIOR, POINTS OF CORROSION AROUND PASSENGERS WINDOW FRAME BETWEEN BS 890 AND 910 RT SIDE.SDR SPUY201403310024Window Frame · corrodedFUSELAGE EXTERIOR, POINTS OF CORROSION AROUND PASSENGERS WINDOW FRAME BETWEEN BS 910-930 RT SIDE.SDR SPUY201403310023Window Frame · corrodedFUSELAGE EXTERIOR, POINTS OF CORROSION AROUND PASSENGERS WINDOW FRAME BETWEEN BS 930-950, RT SIDE.SDR SPUY201403310021Door Frame · corrodedMAIN CARGO EMERGENCY EXIT HATCH RT FWD DOOR FRAME INFERIOR LOWER PART SHOWS CORROSION AT BS 760.95.SDR UHLA2014033000294Beam · corrodedCORROSION FOUND ON RT CF III BEAM. REMOVED OLD RT CFIII EXTENDED BEAM AND MATCH DRILLED NEW BEAM AND INSTALLED.SDR SWAA2014051327905Crease Beam · corrodedRIGHT CREASE BEAM CORRODED AT STATION 540 TO STATION 550. REPAIRED CREASE BEAM IAW EA.SDR SWIA201437098Door Frame · corrodedAFT CARGO DOOR LOWER SURROUND STRUCTURE HAS SURFACE CORROSION. C-CHECK, AFT CARGO DOOR LOWER SURROUND STRUCTURE REPAIRED IAW REO.SDR FDEA201403290599Crease Beam · corrodedMAIN CARGO DECK BETWEEN BS 940 - 960, RT CREASE BEAM CORRODED. R & R IAW SRM 53-40-13, SRM 51-40-02, & DWG 144N5150.SDR USAA2014033100007Crease Beam · corrodedC4 CHECK, LEVEL 2 GALVANIC CORROSION ON CREASE BEAM INNER CHORD BETWEEN BS 640 TO BS 660, LBL 58.22. REPAIRED CREASE BEAM INNER CHORD BETWEEN BS 640 TO BS 660, LBL 58.22 IAW EA 505975.SDR DALA14019805805Crease Beam · corrodedMAIN CABIN CREASE BEAM INBD ANGLE HAS AREAS OF CORROSION BETWEEN BS 680 - 740. REMOVED CORROSION FROM CREASE BEAM ANGLE IAW SRM 53-00-51. REMAINING MATERIAL THICKNESS AFTER CORROSION REMOVAL FOUND TO BE WITHIN LIMITS IAW SRM.SDR DALA14020490680Structure · crackedCRACK IN L1 DOOR SURROUND.SDR DALA14020049212Structure · crackedCRACK FOUND JUST AFT L1 DOOR, BS 210, L15L ON DOOR SURROUNDING STRUCTURE. CUTOUT DAMAGE. FABRICATED AND INSTALLED FILLER AND STRAP IAW SRM 51-30-02 ADN 53-60-02.SDR SPUY201403280001Stop Fitting · corrodedFUSELAGE RT AFT EMERGENCY WINDOW STOP SHOWS CORROSION BETWEEN BS 825.95-848.9.SDR SWAA2014041427105Crease Beam · crackedFORWARD ENTRY DOOR CREASE BEAM CRACKED AT BS 351 AT FLOOR LEVEL. R & R BEAM IAW DWG & SRM.SDR SWIA201437046Door Frame · dentedPAX DOOR SURROUND STRUCTURE HAS A DENT IN THE FRAME WHERE THE SEAL REST AGAINST THE ACFT IN THE CLOSED POSITION, UPPER AREA AFT SIDE. C-CHECK, REPAIRED DENT ON PAX DOOR SURROUND STRUCTURE, UPPER AFT SIDE IAW REO.SDR SWIA201437045Door Frame · dentedPAX DOOR SURROUND STRUCTURE HAS A DENT IN THE FRAME WHERE THE SEAL RESTS AGAINST THE ACFT IN THE CLOSED POSITION, UPPER AREA FWD SIDE. C-CHECK, REPAIRED DENT ON PAX DOOR SURROUND STRUCTURE, UPPER FWD SIDE, IAW REO.SDR WX0A071893Door Frame · crackedFORWARD ACCESSORY COMPARTMENT DOOR PAN CRACKED AT 7 O' CLOCK POSITION. REMOVED DAMAGE AREA, FABRICATED REPAIR PARTS & INSTALLED IAW SRM 53-01 FOG 2 SHEET 4.SDR 2014FA0000196Rib · crackedRIGHT AND LT BULKHEAD RIBS WHICH SUPPORT NLG ATTACHMENT, AFT OF FIREWALL, WERE FOUND TO BE CRACKED DURING ANNUAL INSPECTION. NOTE THAT THE ACFT HAS BEEN PREVIOUSLY MODIFIED MY ANOTHER SHOP WITH MODIFIED NLG ASSEMBLY, INSTALLED IAW STC SA02069AK AND ENLARGED NSDR SWAA2014040226771Window Frame · crackedRIGHT NR 3 WINDOW FRAME POST CRACKED IN SECOND FROM BOTTOM HOLE. REPAIRED IAW SRM.SDR FDEA201403250571Support Beam · crackedCENTER CARGO DOOR ACTUATOR SUPPORT BEAM FOUND CRACKED AT BS 1747. REPAIRED IAW EA 1-5310-T0306921 PART 1. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 120.SDR UHLA2014032500247Beam · corrodedCORROSION FOUND ON FWD CARGO DOOR LOWER SILL BEAM. R & R FWD CARGO DOOR LOWER SILL BEAMSDR SWAA2014033126684Window Frame · crackedLEFT NR 1 WINDOW FRAME NR 4 FASTENER HOLE CRACKED. REPAIRED FRAME IAW ACO.SDR DALA14018891812Failsafe · crackedREAR SPAR BULKHEAD FITTING AREA AT ONE FASTENER HOLE FOUND CRACKED AT FAIL SAFE STRAP THROUGH THICKNESS IN 5 O/C POSITION. BS 955 REAR SPAR BULKHEAD FAILSAFE STRAP REPAIR AND TEE FITTING REPLACEMENT ACCOMPLISHED IAW ER/A 521600-14AD, REV ORIG.SDR UHLA2014032400268Door Frame · corrodedFWD SERVICE DOOR, AT FRAME 15 LOWER PORTION OF THE DOOR. PERFORMED PERMANENT REPAIR OF FWD SERVICE DOOR GUSSET IAW ETD170-025880, REV1. MAJOR REPAIR.SDR SWAA2014040126737Window Frame · crackedLEFT NR 3 WINDOW FRAME E F POST CRACKED AT 1ST & 2ND FASTENER HOLES FROM BOTTOM. REPAIRED POST IAW ACO.SDR SWAA2014040126735Window Frame · crackedRIGHT NR 3 WINDOW FRAME E F POST CRACKED AT 2ND FASTENER HOLE FROM BOTTOM. REPAIRED POST IAW ACO.SDR USAA2014032700012Crease Beam · corrodedSY6 C11 CHECK, LEVEL 2 GALVANIC CORROSION ON CREASE BEAM INNER CHORD BETWEEN BS 730 TO BS 760, LBL 63. REPAIRED CREASE BEAM INNER CHORD BETWEEN BS 730 TO BS 760, LBL 63 IAW SRM 53-30-1A-1, FIG 101, 51-40-02 & 51-20-01.SDR DALA14018845804Seal Depressor · gougedL4 DOOR CUTOUT SEAL DEPRESSOR UPPER INNER EDGE GOUGED. BLENDED GOUGE IAW SRM. FOUND TO BE OUT OF LIMITS IAW SRM. R & R SEAL DEPRESSOR IAW SRM.SDR ASOA2014041410347Arm · corrodedFWD, PAX DOOR HAND RAIL HINGE ARM "CUP" AT PAX DOOR SILL CORRODED. RIGHT FS310 CORRODED ALONG AFT EDGE AT BOTTOM FWD CORNER OF SERVICE DOOR CUT-OUT, JUST AT FLOOR SILL LEVEL. REMOVED FWD PAX DOOR HAND RAIL HINGE ARM CUP DRILLED UP ATTACH HOLES & HOLES FOR NUSDR DALA2016041502928Panel · corrodedFOUND SEVERAL CORROSION SPOTS, 5 E/A ON DIFFERENT PARTS OF THE NLG BAY, SIDE PANEL. THE CORROSION REMOVED IAW SRM AND REPAIR ACCOMPLISHED IAW 522877-14, SECTION I.SDR SWIA201436965Fitting · corrodedSERVICE DOOR FWD FRAME TO STRUCTURE FITTING AT FS 319.70 THAT ATTACHES SERVICE DOOR SILL AND SIDE SILL FWD OF SERVICE DOOR TO MAIN STRUCTURE. AT FLOOR, HAS CORROSION. C-CHECK, R & R FRAME TO STRUCTURE FITTING THAT ATTACHES SERVICE DOOR SILL AND SIDE SILL FWD
Back to JASC 5310