JASC 5330
Service difficulty reports · 79,365
Reports filed under 5330 · Fuselage Main, Plate/Skin, 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 = '5330' 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 = '5330' 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 ASOA2014032810221Skin · damagedLIGHTNING STRIKE FOUND AT BS 263 S26R. COMPLIED WITH EA 26-2014-030.SDR SWAA2014032426476Skin · crackedFUSELAGE SKIN CRACKED AT BS 211.8+3, STRINGER 9R. REPAIRED SKIN IAW SRM.SDR IPXA2014031982306Skin · damagedINSPECTION SPV, SKIN DAMAGED AT BS 589, 2 INCHES BELOW S23L. REPAIRED IAW SRM 53-00-01-2R, REPAIR 3.SDR SWAA2014031826213Skin · crackedLT NR 3 WINDOW POST 2ND FASTENER HOLE FROM THE BOTTOM CRACKED AT 3 O'CLOCK POSITION. REPAIRED SKIN IAW ACO & EA.SDR REXA2014030500271Skin · chafedTASK CARD 900-53-180-100, AT APPROXIMATELY FS 919.00, STRINGER 27 FOUND A CHAFE ON THE SKIN. REPAIRED CHAFE IAW EO RJ3535. MATERIAL REMOVED .004 INCHES X 1 X .040 INCHES W AT FS 919.00 STRINGER 27.SDR DALA14015331803Skin · damagedFUSELAGE SKIN DAMAGE WAS NOTED FROM BS 315-335, S28R. PERMANENT REPAIR IS ACCOMPLISHED IAW ER/A 523744-14.SDR SWAA2014030725859Post · crackedCAPTAIN`S WINDOW POST C - D CRACKED IN THE UPPER CORNER. REPAIRED POST IAW EA.SDR SWAA2014030725858Doubler · crackedEXT POWER PANEL CUTOUT INTERNAL LIP DOUBLER CRACKED AT LOWER FASTENER. REPAIRED CUTOUT IAW SRM.SDR DALA14023660674Skin · dentedDENT IN LT FUSELAGE SKIN AT BS 215 S26L. DENT WAS CUT OUT AND DOUBLER INSTALLED IAW SECTION I OF ERA 523592-14, REV ORIG.SDR SWAA2014040726909Skin · corrodedAFT PRESS BULKHEAD FWD FACE BULKHEAD SKIN CORRODED AT FS 1053, BETWEEN LONGERON 30R TO LONGERON 29R. REPAIRED SKIN IAW SRM.SDR SWAA2014040326800Skin · crackedSKIN CRACKED AT BS 500D, STRINGER 14R. REPAIRED SKIN IAW EA.SDR IPXA2014032182360Skin · corrodedINSPECTION TYPE:2C, MAIN CABIN SUBFLOOR CENTER TANK UPPER SKIN CORRODED IN LT TUNNEL STA 1266, LBL 106. ACCOMPLISH REPAIR ON CABIN SUBFLOOR CENTER TANK UPPER SKIN IN LT TUNNEL BETWEEN XCW=103.84 AND XCW=81 STRINGER 10 IAW EA 011-5730-01-A5156 AND EO MD11-5730SDR SWIA201436601Skin · burnedSKIN BURNED 5.0 INCHES FWD FS 235, .38 INCHES BELOW STRINGER 24L. C CHECK REPAIRED IAW REO.SDR SWIA201436600Skin · burned3 SKIN BURNED 6.0 INCHES AFT FS 265 1.0 INCH ABOVE STRINGER 25L. C CHECK REPAIRED IAW REO.SDR AALA20140304019Skin · crackedLT HAND FUSELAGE SKIN CRACKED AT FASTENER HOLE JUST BELOW LONGERON NR 2 & STATION 1418. INSTALLED DOUBLER IAW EA MD80-53-033843 & SRM 53-04-00-001 FIGURE 40.SDR USAA2014030600010Blanking Plate · unknownMOD LINE VISIT, R & R IFPC ANTENNA BLANKING PLATE ON FUSELAGE SKIN BETWEEN FRAME 60 TO FRAME 61 & BETWEEN STRINGER 43L TO STRINGER 44 IAW EA 206696A.SDR USAA2014030600009Blanking Plate · unknownMOD LINE VISIT, R & R IFPC ANTENNA BLANKING PLATE ON FUSELAGE SKIN BETWEEN FRAME 62 TO FRAME 63 & BETWEEN STRINGER 43L TO STRINGER 44 IAW EA 206696A.SDR SWAA2014040126723Skin · crackedL1 DOOR SKIN CUT OUT CRACKED AT BS 303.9+6, STRINGER 6L+3. REPAIRED SKIN IAW SRM.SDR ASOA2014032810217Skin · damagedLIGHTNING STRIKE FOUND ON SKIN AT FS 273.8 & S26R. COMPLIED WITH EA 12-2014-059. MAJOR REPAIR .SDR ASOA2014032810216Skin · damagedLIGHTNING STRIKE FOUND ON SKIN AT BS 259.8 & S26R. COMPLIED WITH EA 26-2014-030.SDR ASOA2014032810215Skin · damagedLIGHTNING STRIKES FOUND ON SKIN AT BS 258.2 & S26R. COMPLIED WITH EA 26-2014-030.SDR ASOA2014032810214Skin · damagedLIGHTNING STRIKE FOUND ON SKIN AT BS 257 & S26R. COMPLIED WITH 26-2014-030.SDR ASOA2014032810213Skin · damagedLIGHTNING STRIKE FOUND ON SKIN AT BS 252.6 & S26R. COMPLIED WITH EA 26-2014-030.SDR ASOA2014032810212Skin · damagedLIGHTNING STRIKE FOUND ON SKIN, BS 251.8 & S26R. COMPLIED WITH EA 26-2014-030.SDR SWIA201436752Skin · chafedSKIN CHAFED AT APPROX BS 969, NEAR STR 27. REPAIRED SKIN IAW SRM AND REO.SDR SWIA201436699Skin · chafedLT MLG L/E LOWER INNER SKIN CHAFED AT SECOND BEND. REPAIRED L/E MLG L/E LOWER INNER SKIN CHAFE IAW SRM.SDR IPXA2014031482247Skin · damagedC16 INSPECTION, UPPER EXTERNAL FUSELAGE HAS STATIC DISCHARGE AT BS 1430 BETWEEN S1 - 2R. REPAIRED AREA IAW SRM 53-00-01-2R, REPAIR 2.SDR AALA20140303004Skin · dentedSKIN AT STATION 1522 & STRINGERS 27 TO 29 RT DENTED. REMOVED DAMAGE AREA & INSTALLED DOUBLER IAW SRM 53-00-01 & EA B767-53-033833.SDR UHLA2014030200197Skin · damagedFOUND A CREASE ON FUSELAGE SKIN AFT OF FRAME 18 BETWEEN S23-24R. REPAIRED IAW SRM 53-10-01.SDR SIMA20140302005Skin · crackedFUSELAGE SKIN IS CRACKED AROUND RIVET ON FRAME 75 BETWEEN STRINGERS 1L - 2L. REPAIRED DAMAGED AREA IAW ERS-EM-53MR-281.SDR ASOA20140302034Skin · damagedDURING A LIGHTNING STRIKE INSPECTION, A PENCIL-TIP SIZED HOLE WAS FOUND BURNED IN THE FUSELAGE SKIN BETWEEN FRAMES 22 & 23 STRINGERS 5 & 6L. REPAIRED IAW SRM 53-21-01, AND ACFT APPROVED FOR RETURN TO SERVICE.SDR DALA14027560960Skin · damagedLIGHTNING STRIKE AT WINDOW BELT BS 754.5. BLENDED AREA, HFEC & UT INSPECTED AREA WITH NO CRACKS NOTED, FABRICATED REPAIR, TREATED, PRIMED, INSTALLED, IAW ERA 523926-14, REV "O".SDR IPXA2014032482399Skin · crackedINSPECTION C, BS 980 DRAG SPLICE FITTINGS AT STRINGER 38L FOUND CRACKED AT SKIN. DRAG SPLICE FITTING REPAIRED IAW SRM 53-20-01-2R-2, FIG 201, REV 69. MAJOR REPAIR.SDR IPXA2014032482398Skin · crackedINSPECTION C, BS 980 DRAG SPLICE FITTING AT STRINGER 38R FOUND CRACKED AT SKIN. DRAG SPLICE FITTING REPAIRED IAW SRM 53-20-01-2R-2, FIG 201, REV 69. MAJOR REPAIR.SDR SWAA2014031826180Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 500D & 15.5 TO BS 500D & 16.5, STRINGER 20R. REPAIRED SKIN IAW ER & EA.SDR SWAA2014032426462Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 500C+3 TO BS 500C+5.1, STRINGER 1R. REPAIRED SKIN IAW SRM.SDR SWAA2014032426457Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 372.75 TO BS 374, STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2014032426456Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 372.5 TO BS 374, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2014032426455Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 472 TO BS 475, STRINGER 16R. REPAIRED SKIN IAW EA & ER.SDR SWAA2014032426454Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 365.5 TO BS 366.5, STRINGER 19R. REPAIRED SKIN IAW EA & ER.SDR SWAA2014032426453Skin · crackedFUSELAGE SKIN CRACKED AT BS 500B+14, STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2014032426421Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 500C+14 TO BS 500C+15.5, STRINGER 8R. REPAIRED SKIN IAW EA & ER.SDR IPXA2014032182378Skin · crackedINSPECTION C, NOSE WHEEL WELL RT AFT CORNER SKIN PANEL FOUND CRACK FROM FASTENER, NWW BS 390-415, S42-46R RT AFT CORNER SKIN & PLUG HOLE AREA REPAIRED IAW RI-53-11-10489, REV A & EO B747- 5330-53796-A. MAJOR REPAIR.SDR SWAA2014031826178Skin · crackedFUSELAGE SKIN CRACKED AT BS 361.6, BETWEEN STRINGER 7R TO STRINGER 8R. REPAIRED SKIN IAW EA.SDR SWAA2014031826179Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 572 TO BS 573, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2014031426043Skin · crackedFUSELAGE SKIN CRACKED AT STATION 365.5 TO STATION 368.5, STRINGER 16R. REPAIRED SKIN IAW SWA EA.SDR SWAA2014031326012Skin · crackedFUSELAGE SKIN CRACKED AT STATION 504B TO STATION 506B, STRINGER 15R. REPAIRED SKIN IAW SRM & ER.SDR FDEA201402280424Skin · corrodedFOUND CORROSION RUNNING UNDER THE LAP SEAM AT STRINGER 20R FROM BS 1626 - 1720. ACCOMPLISHED EA F-5330 T0 305370 P1 STEP 1 TO 10.SDR GLBA2014022800390Skin · tornDURING A SCHEDULED INSPECTION MX FOUND THE SKIN TORN ON THE BELLY AT FS 265.750 & STRINGER 14L, APPROXIMATELY 5 INCHES IN LENGTH. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 14-1900-53-020.SDR SWAA2014030625830Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 462.5 TO BS 463, STRINGER 26L. REPAIRED SKIN IAW SRM.
Back to JASC 5330