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 ASOA20140805245Door Frame · corrodedDURING C-CHECK, CORROSION FOUND AROUND AFT TWO NUTPLATES ON INSIDE AND OUTSIDE OF PAX DOOR BOTTOM FRAME. MAINTENANCE R & R PAX DOOR BOTTOM AFT FRAME WITH NEW FRAME IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2014082831381Repair · crackedFORWARD SERVICE DOOR FWD FRAME REPAIR ANGLE CRACKED AT BS 294 RBL. REPAIRED FRAME IAW ER & EA.SDR CALA2014080401066Door Frame · crackedPOSSIBLE CRACK R1 DOOR CUT OUT FWD FRAME LOWER INBD EDGE AT CABIN FLOOR LEVEL. ACCOMPLISHED REPAIR 6/24/14 FOR THE PERMANENT REPAIR. 53-DIP CONTROL 28678. WORK CABIN FLOOR LEVEL IAW SRM 51-70-11 FG 4. ECRA 5311-01711. INITIATED DIP TO READ AS FOLLOWS ON OR BSDR SWAA2014081530919Window Frame · crackedRIGHT NR 1 WINDOW FRAME CRACKED IN THE UPPER OTBD CORNER. REPAIRED FRAME IAW ACO.SDR DALA2014080304440Receptacle · crackedCRACKED EXTERNAL POWER RECEPTACLE. RECEPTACLE WAS FABRICATED IAW DWG 5957232, REV CM.SDR FDEA201408022039Door Frame · gougedAFT CARGO DOOR CUT OUT FWD JAMB HAS MULTIPLE GOUGES LOCATION 14 INCHES TO 26 INCHES FROM LOWER FWD CORNER. COMPLIED WITH EA 6-5317-T0310177, FUSELAGE AFT INT 58T072 AFT CARGO DOOR CUT OUT GOUGED, CAT B MAJOR REPAIR AT FRAME 59A BETWEEN STRINGER 39R - 41R.SDR DALA2014080804476Beam · crackedCRACK ON NR 1 BEAM AT FWD SERVICE DOOR. NR 1 BEAM WAS REMOVED AND A NEW BEAM WAS DRILLED, TREATED, PAINTED AND INSTALLED IAW SRM 51-30-2, 51-10-4, SRM 51-10-3, PAR 14 AND 21.SDR CALA2014080691758Failsafe · crackedLEFT STATION 955 FAIL SAFE STRAP LOWER FASTENER HOLE HAS CRACK INDICATION. ACCOMPLISHED EA 5340-01478, REV A, OPS 03 AS REQUIRED ON JC COA-691845003.SDR IPXA2014081583983Rod · corrodedINSPECTION C-16, AFT KEELBEAM AFT DOOR SUPPORT ROD CORRODED. REPLACED ROD IAW SRM 51-40-02.SDR IPXA2014081583982Support · corrodedINSPECTION C-16, SUPPORT ROD CORRODED. REPLACED IAW SRM 51-40-02.SDR SWAA2014082631237Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 827 TO 847 WL 208. R & R WEB IAW DWG & SRM.SDR SWAA2014082631234Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 847 TO 867 WL 208. R & R WEB IAW SRM.SDR SWAA2014082631233Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 807 TO 827 WL 208. REPAIRED BEAM IAW SRM & DWG.SDR SWAA2014082631232Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 482 TO 482A WL 208. R & R WEB IAW SRM.SDR SWAA2014082631231Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 360 TO 380 WL 208. R & R WEB IAW SRM.SDR SWAA2014082631230Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 887 TO 907, WL 208. R & R WEB IAW SRM.SDR SWAA2014082531157Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 847 TO 867, WL 208. R & R WEB IAW DWG & SRM.SDR SWAA2014082531156Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 727B TO 727C, WL 208. R & R WEB IAW DWG & SRM.SDR SWAA2014082531155Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 380 TO 400, WL 208. R & R WEB IAW SRM.SDR SWAA2014082531154Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 360 TO 380 WL 208. R & R WEB IAW SRM.SDR DALA2014073104327Spacer · corrodedCORROSION ON REPAIR SPACER ON MID CARGO BAY DOOR FRAME BS 655-674. SPACER REPLACED IAW SRM 53-05, FIG 123, SRM 51-10-3 14, 21-38, SRM 51-30-5.SDR DALA2014073004304Pan · crackedCRACK ON PAN AT FWD UPPER CORNER OF RT FWD EMERGENCY EXIT DOOR. FWD UPPER CORNER PAN WAS REPAIRED IAW SRM 52-05D, FIG 51.SDR DALA2014073004282Doubler · corrodedAFT CARGO BEAM INNER DOUBLER, BS 1231 CORRODED. REPAIRED IAW ERA 527788-14, REV O.SDR K11A2014092291502Retainer · crackedCRACK INDICATION FOUND DURING X-RAY INSPECTION, RT OUTER LOWER WINDOW RETAINER.SDR ASOA2014082211117Door Frame · corrodedLT COCKPIT DOOR POST LOWER SECTION CORRODED AT LBL 12. REMOVED CORROSION DAMAGE IAW SRM 51-21-06-001-001-A01. REMOVED 8EA RIVETS AND CLIP IAW SRM 51-2-13-001-001-A01 & SRM 51-42-06-001-001-A01. INSTALLED, 8 EA, RIVETS AND CLIP IAW SRM 51-42-13-001-001-A01 ASDR COEA2014081812921Crease Beam · corrodedHEAVY CHECK COE, MAJOR REPAIR. RT CREASE BEAM INNER CHORD IS CORRODED BETWEEN FRAMES 23 & 24. REPAIRED IAW SRM.SDR COEA2014081301921Crease Beam · corrodedHEAVY CHECK COE, MINOR REPAIR. CORRODED RT CREASE BEAM SHEAR WEB BETWEEN FRAMES 17 - 18. REPLACED PART IAW SRM.SDR SWIA201439044Support Frame · crackedSUPPORT FRAME BS 909 BELOW EXTERNAL SKIN CRACKED. C-CHECK REPAIRED SUPPORT FRAME IAW EA.SDR DALA2014072804250Door Frame · corrodedCENTER CARGO DOOR CUTOUT LOWER DOOR FRAME SURFACE HAS CORROSION , BS 636 - 693. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 53-01, FABRICATED AND INSTALLED PERMANENT REPAIR IAW SRM 53-05, FIG 123, OPTION 1.SDR DALA2014072804261Door Frame · corrodedAFT CARGO DOOR LOWER FRAME CORRODED AND PAINT CHIPPED. REPAIRED IAW SRM 53-60-02, FIG 9. RII QC1981.SDR ASOA2014082211103Fitting · corrodedCORROSION ON FLOOR SUPPORT FITTING, RT FWD OF SERVICE DOOR, BS 319. REMOVED FLOOR SUPPORT FITTING IAW SRM 51-42-20-001-001-A01. INSTALLED NEW FLOOR SUPPORT FITTING IAW SRM 51-42-21-001-001-A01 & DWG SH670-31950.SDR UHLA2014072600550Beam · corrodedCORROSION FOUND ON LT BEAM, Y-10.748, FRAMES 86-89. R & R BEAM.SDR UHLA2014072600549Beam · corrodedCORROSION FOUND ON RT BEAM Y+10.748, FRAMES 86-89. R & R BEAM.SDR UHLA2014072600545Crossbeam · corrodedCORROSION FOUND ON FRAME 84 CROSSBEAM. R & R CROSSBEAM.SDR DALA2014072604260Structure · corrodedFOUND NR 2 TRANSMIT RADAR LANDING CORRODED. R & R DOUBLER IAW SRM 51-20-011, 51-30-02 AND DWG 5936004.SDR SIMA20140725005Roller · lack of lubeFLIGHT ATTENDANT REPORTS THE MAIN CABIN DOOR IS HARD TO OPEN. LUBRICATED MAIN CABIN DOOR ROLLERS IAW AMM 53-21-02. OPERATIONS CHECKED GOOD.SDR SWAA2014080430552Window Frame · crackedFLIGHT DECK RT NR 1 WINDOW FRAME CRACKED NEAR UPPER CORNER. REPAIRED IAW ACO.SDR ASOA20140724228Door Frame · corrodedDURING C-CHECK THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MAINTENANCE R & R THE BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20140724227Door Frame · corrodedDURING C-CHECK, THE CARGO DOOR LOWER FRAME WAS FOUND TO BE CORRODED. MAINTENANCE R & R THE FRAME IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR 2014FA0000571Retainer · chafedPERIMETER EDGE OF CABIN WINDOWS HAVE CHAFED INTO CABIN WINDOW RETAINERS ON RT CABIN WINDOWS. THIS DISCREPANCY OCCURRED UNDER NORMAL WEAR AND UTILIZATION, MATERIAL IS 0.040 THICK. DEEPEST CHAFE DAMAGE MEASURES 0.020 THICK.SDR SWAA2014082531190Door Frame · crackedFORWARD PAX DOOR FRAME INNER CHORD CRACKED BS 348 AT FLOOR LEVEL FASTENER HOLE. R & R CHORD IAW EA.SDR ASAA2014072308752Reveal · crackedAFT CARGO BAY DOOR SURROUND REVEAL PANEL 142KW HAS EDGE NICKS AND BARE METAL. ACFT GROUNDED. REMOVED THE EDGE DAMAGE; FOUND OUT OF LIMITS IAW SRM 53-60-15-01-1, FIG 103, SHEET 4. REPLACED THE NEW REVEAL PANEL 142-KW PN 146A9403-237, PO 810374.2 IAW SRM 51-10SDR ASAA2014072308751Reveal · crackedFWD CARGO BAY AFT DOOR SURROUND REVEAL PANEL 122DW HAS AN EDGE CRACK. ACFT GROUNDED. REPLACED THE REVEAL PANEL NR 122-DW, PN 143A9403-188, PO 817402.1 IAW SRM 53-30-15-01-1 AND 51-10-02-06-0.SDR SWAA2014073030468Window Frame · crackedRIGHT FLIGHT DECK E - F POST WINDOW FRAME AT APPROX 9:00 POSITION TO .297 INCHES CRACKED. REPAIRED FRAME IAW SI.SDR SWAA2014073030467Window Frame · crackedLEFT FLIGHT DECK WINDOW FRAME APPROX AT 4:00 POSITION TO .297 INCHES CRACKED. REPAIRED FRAME IAW SI.SDR CALA2014072591517Crease Beam · corrodedCABIN FLOOR STRUCTURE BS 940 - 960 STRINGER 17L LT CREASE BEAM INTERCOSTAL UPPER SURFACE CORRODED. R & R CREASE BEAM.SDR SWAA2014072530312Window Frame · crackedLEFT NR 3 FLIGHT DECK WINDOW FRAME CRACKED, NR 4 HOLE FROM BOTTOM. REPAIRED WINDOW IAW EA.SDR SWAA2014072530304Window Frame · crackedRIGHT NR 3 FLIGHT DECK WINDOW FRAME CRACKED NR 2 HOLE FROM BOTTOM. REPAIRED WINDOW IAW EA.SDR SWAA2014081930988Door Frame · crackedAFT ENTRY DOOR STUB FRAME CRACKED AT BS 950 STRINGER 17L. REPAIRED FRAME IAW EA.SDR SWIA201439027Rib · crackedLEFT UPPER FUSELAGE BEHIND CAPTAIN`S DV WINDOW RIB IS CRACKED. C-CHECK, R & R RIB AT LT UPPER FUSELAGE BEHIND CAPTS DV WINDOW IAW SRM.
Back to JASC 5310