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 VNAA2014061000007Beam · corrodedDURING SCHEDULED MAINTENANCE, CORROSION WAS FOUND ON TRASVERSE BEAM PLATE BETWEEN LBL 9 AND LBL 27 AT FS 589. THE AREA WAS INSPECTED, R & R TRANSVERSE BEAM PLATE USING AMM. ACFT WAS RELEASED FOR SERVICE.SDR SWAA2014072230183Door Frame · corrodedAFT CARGO DOOR JAM CORRODED AT LOWER SECTION BETWEEN BS 954 TO 963. REPAIRED JAM IAW SRM & DWG.SDR DALA2014061903698Door Frame · crackedCRACKED NLG WW RT DOOR FRAME AT BS 46. DAMAGE REMOVED, REPAIR FABRICATED AND INSTALLED IAW SRM 53-05, FIG 110.SDR ASOA20140608124Door Frame · corrodedDURING C-CHECK, CORROSION FOUND AROUND AFT TWO NUTPLATES ON INSIDE OF MAIN DOOR BOTTOM FRAME. REMOVED CORRODED LOWER AFT DOOR FRAME. LOCATED, DRILLED AND INSTALLED NEW FRAME IAW SRM 51-40-02. ACFT APPROVED FOR RETURN TO SERVICE.SDR ASOA20140608119Crossbeam · corrodedDURING C-CHECK, CROSSBEAM AT FRAME 61 CORRODED BETWEEN RT OMEGA BEAM AND RT OTBD FLOOR SUPPORT 100 PERCENT MATERIAL LOSS. R & R CROSSBEAM IAW SRM 51-40-02. ACFT APPROVED FOR RETURN TO SERVICE.SDR SWAA2014061829143Window Frame · crackedFLIGHT DECK LT NR 1 WINDOW FRAME CRACKED OTBD UPPER CORNER COMMON TO INNER SURFACE & INNER EDGE. REPAIRED FRAME IAW ACO.SDR FDEA201406071325Crease Beam · chafedCABIN STATION 790 - 800 RT CREASE BEAM INBD CHORD FOUND CHAFED. COMPLIED WITH EA F- 5310- T0309882 A PART 1 TITLE FUSELAGE MAINFRAME REPAIR FOR RT CREASE BEAM CHORD AT STATION 790 TO 800. REPAIR CLASSIFIED AS MAJOR.SDR ASOA20140607107Beam · corrodedDURING C-CHECK THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MAINTENANCE R & R THE BEAM IAW SRM 51-40-02. ACFT APPROVED FOR RETURN TO SERVICE.SDR UHLA2014060600459Finger Doubler · chafedCHAFE FOUND ON FWD CARGO BAY AFT FINGER DOUBLER. REMOVED, REPAIRED AND REPLACED AFT FINGER DOUBLER IAW SRM 51-23-04, 51-23-05, 54-40-04, 51-40-02, 51-41-02, 51-43-02, 51-23-05, 51-23-06. MAJOR REPAIRSDR UHLA2014060600458Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM AT FRAME 84, RT Y=+10.748. CUTOUT DAMAGE SECTION, REPAIRED IAW ETD 2014-170-048295. MAJOR REPAIRSDR UHLA2014060600456Finger Doubler · corrodedCORROSION ON FWD CARGO AFT FINGER DOUBLER. R & R AFT FINGER DOUBLER. MAJOR REPAIRSDR UHLA2014060600439Splice · corrodedCORROSION FOUND ON LT CENTER SPLICE FRAME 90. R & R SPLICE.SDR UHLA2014060600438Splice · corrodedCORROSION FOUND ON CENTER SPLICE, FRAME 90. R & R CENTER SPLICE.SDR UHLA2014060600435Beam · corrodedCORROSION FOUND ON RT BEAM Y+10.748, FRAMES 86-89. R & R DAMAGED BEAM.SDR UHLA2014060600434Beam · corrodedCORROSION ON LT BEAM Y -10.748, FRAMES 86-89. R & R DAMAGED BEAM.SDR UHLA2014060600430Finger Doubler · corrodedCORROSION FOUND ON FWD CARGO AFT FINGER DOUBLER. R & R FINGER DOUBLER.SDR SWIA201438239Window Frame · crackedCRACK NOTED AND MARKED IN UPPER RADIUS OF LT WINDSHIELD CENTER POST. C-CHECK, R & R LT WINDSHIELD CENTER POST IAW SRM.SDR SWAA2014061128960Window Frame · crackedLEFT NR 3 CONTROL CABIN WINDOW FRAME EF CRACKED ON NR 8 FASTENER HOLE. REPAIRED FRAME IAW SI.SDR ASOA2014062410747Unknown · corrodedCORROSION FOUND ON LBL 9 AT FS 661 & FS 645. BLENDED AND EVALUATED FOUND TO BE OUT OF LIMITS IAW SRM 53-31-43-101-001-A01 & 51-21-06-0014-001-A01. RECEIVED AND COMPLIED WITH REO 670-53-31-325, REV DATE 2014-06-05.SDR FDEA201406051319Door Frame · crackedMAIN DECK CARGO BAY BS 1256, LONGERON 26 RT FWD R3 DOOR FRAME FOUND CRACKED. REPAIRED IAW SRM 53-40-15, FIGURE 201, REPAIR 3, REVISION 55. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100 REVISION 121.SDR SWAA2014061929214Window Frame · crackedLEFT NR 3 WINDOW FRAME E - F POST 2ND FASTENER HOLE FROM BOTTOM CRACKED. REPAIRED FRAME.SDR QXEA2014061200468Rib · corrodedRIBS CORRODED AT AFT SERVICE DOOR SILL BS 669.3- 697. REMOVED CORRODED RIB IAW SRM 53-40-21. INSTALLED RIB IAW SRM 51-42-05, PG 201-205.SDR QXEA2014061200465Beam · corrodedOUTER EDGE BEAM, CORRODED ON AFT AIRSTAIR DOOR. FABRICATED NEW OUTER EDGE BEAM IAW DWG 85339542. COMPLIED WITH ET INSPECTION ON FABRICATED PART IAW NDTM PT 1, 51-00-06. NO DEFECTS NOTED. INSTALLED IAW SRM 51-40-07-02-01.SDR SWAA2014060928878Window Frame · crackedLEFT NR 3 WINDOW FRAME E - F POST 3RD FASTENER HOLE FROM BOTTOM CRACKED. REPAIRED FRAME IAW SI.SDR SWAA2014060928877Window Frame · crackedRIGHT NR 3 WINDOW FRAME E - F POST 4TH FASTENER HOLE FROM BOTTOM CRACKED. REPAIRED FRAME IAW SRM.SDR SWAA2014060928876Window Frame · crackedRIGHT NR 3 WINDOW FRAME E - F POST 3RD FASTENER HOLE FROM BOTTOM CRACKED. REPAIRED FRAME IAW SRM.SDR SWAA2014060928875Window Frame · crackedRIGHT NR 3 WINDOW FRAME E - F POST 2ND FASTENER HOLE FROM BOTTOM CRACKED. REPAIRED FRAME IAW SI.SDR SWAA2014060928870Window Frame · crackedWINDOW FRAMES 1L & 6L CRACKED. R & R FRAME IAW AMM.SDR ASOA2014063010776Structure · corrodedSHIMS AND TOP PLATE CORRODED AT RBL 9 AND BS 349. R & R PACKER IAW SRM 51-42-06-001-001, 51-23-00-001-001, 51-40-11-001-001, 51-25-16 AND DWG SH670-32167, 53-21-43-101-001.SDR SWAA2014061028903Frame · crackedLEFT MLG FWD CUT OUT FRAME CRACKED AT UPPER OTBD END. REPAIRED FRAME IAW SRM.SDR SIMA20140604007Door Frame · corrodedFRAME 22 CORRODED AROUND SERVICE DOOR LOWER DOOR STOP IN TWO AREAS. PERFORMED PERMANENT REPAIR OF FRAME 22 CORROSION AROUND SERVICE DOOR LOWER DOOR STOP IAW ERS-EM-53MR-495.SDR GTIA2014060401331Crossbeam · crackedDURING REMOVAL OF RIGHT ROLLER TRACK FOUND CROSSBEAM SECTION OF FRAME 48 FLANGE CRACKED. REPAIRED IAW EO 5341-1405, REV-00.SDR DALA14033743230Fitting · corrodedCORROSION ON AFT LOWER CORNER FITTING ON L1 DOOR, FRAME 20. REPLACED CORNER FITTING IAW SRM 51-72-11 AND DWG D53112109.SDR DALA14033723221Structure · corrodedCORROSION ON SECTION OF INTERNAL STRUCTURE STRINGER 29L, FRAME 67. REPLACE SECTION IAW SRM 51-72-11 AND DWG D53480009.SDR SWAA2014061229008Window Frame · crackedLEFT NR 3 WINDOW FRAME E-F POST CRACKED AT 2ND HOLE FROM THE BOTTOM. REPAIRED FRAME IAW SRM & ACO.SDR SWAA2014060928867Window Frame · crackedNUMBER 3 RT WINDOW FRAME CRACKED AT THE SECOND FASTENER HOLE. REPAIRED FRAME ASSEMBLY IAW EA.SDR DALA14033800934Door Frame · crackedRIGHT OVERWING FRAME INSPECTION, BS 886, FOUND CRACKED. REPAIRED IAW AMDS 5310-01415-0202.SDR DALA14033233221Fitting · corrodedCORROSION ON CENTER FITTING AT FRAMES 17-19 S23L PAX DOORWAY. REPLACED FITTING IAW SRM 51-72-11, DWG D53112198 AND D53112109.SDR QXEA2014061300479Rib · corrodedTWO RIBS CORRODED AT AFT PAX DOOR SILL AT FS X669.30 AND FS X697.600. REMOVED CORRODED RIB AT FS 669.30 COMMON TO AFT PAX DOOR SILL IAW SRM 51-42-05, PAR 4.E. CORRODED RIB OUT OF LIMITS IAW TC 6-53-1160-AFT PAX DOOR, FLT ITEM 5. INSTALLED NEW FABRICATED RIB ASDR UHLA2014060200410Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM AT FRAME 84. INSTALLED ANGLE REPAIR ON CENTER SECTION OF CROSSFRAME. MAJOR REPAIR.SDR UHLA2014060200409Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM AT FRAME 84. INSTALLED ANGLE REPAIR ON CENTER SECTION OF CROSSBEAM. MAJOR REPAIR.SDR ASOA2014063010773Door Frame · corrodedRT FS 280 DOOR FRAME CORRODED AT BOTTOM AFT CORNER. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. COMPLIED WITH REO 670-53-11-950.SDR ASOA2014063010772Door Frame · corrodedLT BS 280, DOOR FRAME CORRODED AT BOTTOM AFT CORNER. . COMPLIED WITH ECTC REO 670-53-11-951. MAJOR REPAIRSDR LR7A2014053100724Tee Fitting · crackedDURING SCHEDULED B-2 CHECK, FOUND BS 946 UPPER BULKHEAD ASSY LOWER TEE EXTRUSION, LOWER CAP CRACKED AT LBL 54, WL 265. LS 4343. REPAIRED IAW MEA 382-53-14-013. NR N-27.SDR DALA14032929222Beam · damagedAFT CARGO DOOR BEAM, FOUND OUT OF LIMITS AND R & R IAW DWG 591104.SDR AALA20140530003Crease Beam · corrodedLEFT NR 1 CREASE CHORD FROM STATIONS 945 TO 1005 & LBL 54 CORRODED. REPLACED CREASE ANGLE IAW AARD 51-10-05-1.SDR DALA14032775807Crease Beam · damagedCREASE BEAM DAMAGED BS 1610-1630. REPAIRED RT CREASE BEAM IAW ER/A 524466-14, REV ORIGINAL.SDR ASOA2014063010763Track · dentedCARGO DOOR FWD TRACK DENTED UPPER OUTER RAIL AFT. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. RECEIVED AND COMPLIED WITH EC/TC REO 670-53-62-0102.SDR CALA2014060291185Door Frame · crackedFRAME 68 WEB CRACKED AT DOOR 2L AFT LOWER STOP FITTING LOWER INBD HOLE. HOLE ENLARGED TO 0.510 INCHES & FREEZE PLUG REPAIR ACCOMPLISHED IAW SRM 53-41-12 PARA 5 C & PARA 5 F FIG 205. REQUIRES INSPECTION IAW SRI53-41-12-2-005-00 PARA 3 E TABLE 206, FIG 201. FISDR DALA14032585806Door Frame · wornL1 DOOR FRAME UPPER FWD LATCH CAM BASE PLATE WORN FROM CONTACT WITH EXCESSIVELY LONG SCREW IN DOOR REVEAL/BULB SEAL SUPPORT ANGLE. BLENDED DAMAGE OUT OF LIMITS IAW SRM. FABRICATED AND INSTALLED NEW BASE PLATE IAW DWG 141N8315 AND SRM.
Back to JASC 5310