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 AALA20120313006Skin · corrodedFUSELAGE SKIN CORRODED AT LAVATORY VENT AREA. REMOVED CORROSION PER B737-53-022362.SDR SWAA2012031202087Skin · crackedSKIN CRACKED AT BS 305, STR 13L. REPAIRED SKIN IAW SRM.SDR DALA1213500989Skin · corrodedDURING PSV VISIT MSP FOUND AFT LAV SERVICE PAN OUTER SKIN CORRODED. DISCREPANCY REQUIRED REMOVAL OF PAN AND INSTALL A NEW PAN. THE UPPER FLANGE OF LONGERON 22L HAD TO BE REMOVED TRIMMED OFF. TRIM IS BETWEEN FS 1309 AND FS 1322 MEASURING 10.0" LONG.SDR CA120320001Skin · loose(CAN) IN C-CHECK, WHILE PERFORMING OUTGOING PRESSURIZATION/DECAY RATE CHECK THE ACFT PRODUCTION JOINT AT FUSELAGE STATION 245, LEFT HAND, BETWEEN WL 190 AND WL 220 WAS FOUND TO HAVE AN ABOVE NORMAL LEAKAGE RATE. IT WAS ALSO NOTICED THAT THE EXTERIOR SEALANT WSDR FDEA201203050783Skin · damagedSKIN AT BS 1470 AT S28L DAMAGED. CARRIED OUT REPAIR IAW EA F-5310-155885, PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201203050782Skin · damagedSKIN AT BS 1520-1540 S27-28L. REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR 15, REV 105. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201203050780Skin · damagedSKIN AT BS 500-520, S27-29R DAMAGED, REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR 15, REV 105. REPAIR IS CLASSIFIED AS MAJOR.SDR SWAA2012032102455Skin · crackedR2 DOOR SKIN CRACKED, FORWARD LOWER CORNER, UNDER SILL PLATE. REPAIRED SKIN IAW EA.SDR USAA2012031900008Skin · crackedCDFI VISIT - 3/4 INCH LONG CRACK IN FUSELAGE SKIN AT R1 DOOR LOWER HINGE CUTOUT AT BS 291.5 BETWEEN S13R TO S14R. REPAIRED FUSELAGE SKIN AT R1 DOOR LOWER HINGE CUTOUT IAW EA 202007.SDR FDEA201203050784Skin · corrodedCORROSION ON LOWER OUTSIDE SKIN BS 660 S26 - 30L. REMOVED CORROSION IAW SRM 51-10-02 ORIGINAL MATERIAL .063, REMAINING .052. FOUND OUT OF LIMITS IAW SRM 53-00-01 FIG 101 DETIAL II. REPAIRED IAW SRM 51-40-02. MAJOR REPAIRSDR ASOA201200733Skin · corrodedCORROSION ON INNER AND OUTER FUSELAGE SKIN BETWEEN FS 295-310 AND STR 25-26R. BLENDED DAMAGE, FOUND OUT OF LIMITS REF SRM 51-26-00-001-001-A01 & SRM 51-21-06-001-001-A01. REPAIERED IAW REO 670-53-21-824.SDR SWAA2012030701984Skin · crackedFUSELAGE SKIN CRACKED AT BS 305, STR 13L. REPAIRED SKIN PER SRM.SDR EE4Y20120305097Skin · dentedUPPER FUSELAGE EXTERIOR FROM FR-23 TO FR-24 BTW STR-21 LT AND STR-22 SKIN WITH DENT. REPAIRED FUSELAGE SKIN SECTION FROM FR23+9.250 TO FR23+17.250, BETWEEN STR-21LH AND STR-23LH IAW SRM 5311-11, PARA 5H TABLE 202, FIG 211.SDR HNAA2012030500658Skin · damagedLIGHTNING STRIKE TO RT SIDE OF ACFT. COMPLIED WITH LIGHTNING STRIKE INSPECTION IAW MM 05-50-31, STEPS 1-16.SDR C77A20130502011Skin · damagedWHILE ON OVERNIGHT MX AND DURING A TCAS UPPER ANTENNA CHANGE A LIGHTNING STRIKE WAS DISCOVERED ON THE SUBJECT ACFT. THE DAMAGE LOCATION IS ON THE SKIN SPLICE FORWARD OF FR21 AND ON STGR 3L. THE DAMAGE CONSISTS OF A FIGURE 8 SHAPED BURN MARK HALF ON THE RIVET ASDR C77A20130501001Skin · damagedDURING OVERNIGHT MX AND DURING A TCAS UPPER ANTENNA CHANGE A LIGHTNING STRIKE WAS DISCOVERED ON THE SUBJECT ACFT. THE DAMAGE LOCATION IS ON THE SKIN SPLICE FORWARD OF FR21 AND ON STGR 3L. THE DAMAGE CONSISTS OF A FIGURE 8 SHAPED BURN MARK HALF ON THE RIVET ASDR SWAA2012030802007Skin · crackedSKIN CRACKED AT BS 392.5, STR 1L. REPAIRED SKIN PER SRM.SDR UALA2012030501355Skin · damagedSKIN DAMAGED DURING FASTENER REMOVAL AT APPROX STA 570 RBL 5 JUST INBD OF S-1R. MAJOR REPAIR ACCOMPLISHED. RMV'D DAMAGE SECTION OF SKIN FABBED DOUBLER AND INSTALLED REF SRM 53-00-01 REPAIR 3. CF CREATED TO INSPECT AT 25000 CYC AND REPEAT INSPECT EVERY 3000 SDR SWAA2012032902692Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500C+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012032902691Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 360+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012032902690Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 360+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012032802634Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 480+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012032802633Skin · crackedRT FUSELAGE WINDOW SKIN CRACKED AT BS 500+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012032802632Skin · crackedRT FUSELAGE WINDOW SKIN CRACKED AT BS 480+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN EA.SDR SWAA2012032802631Skin · crackedRT FUSELAGE WINDOW SKIN CRACKED AT BS 460+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012032702610Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012032702609Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012032702608Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012032702607Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012032702606Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 520+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW IR AND EA.SDR SWAA2012032702605Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012032702604Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 440+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012032702603Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 420+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012032702602Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 400+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIR SKIN IAW SB.SDR SWAA2012032702601Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR FDEA201203030768Skin · corrodedCARGO BAY BS 1661 - 1681 S24-25R DOUBLER CORRODED.SDR SWAA2012032102454Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 500A+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR QXEA2012030500203Doubler · corrodedT2 RADIO ALTIMETER ANTENNA MOUNT DOUBLER HAS CORROSION. REMOVED CORROSION IAW SRM 51-21-00-00-02. ALODINED IAW SRM 51-21-10-02-01. CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT1 AND 51-00-06-910-801. BLENDS WITHIN LIMITS PER Q400 RD 8/4-53-4370. COMPLIESDR QXEA2012030500202Doubler · corrodedR2 RADIO ALTIMETER ANTENNA MOUNT DOUBLER HAS LIGHT CORROSION AROUND SCREW HOLES. REMOVED CORROSION IAW SRM 51-21-00-00-02. ALODINED IAW SRM 51-21-10-02-01. CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT1 AND 51-00-06-910-801. BLENDS WITHIN LIMITS PER Q400SDR QXEA2012030500201Doubler · corrodedR1 RADIO ALTIMETER ANTENNA MOUNT DOUBLER HAS LIGHT CORROSION AROUND SCREW HOLES. REMOVED CORROSION IAW SRM 51-21-00-00-02. ALODINED IAW SRM 51-21-10-02-01. CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT1. BLENDS WITHIN LIMITS PER Q400 RD 8/4-53-4370. COMPSDR QXEA2012030500200Doubler · corrodedT1 RADIO ALTIMETER ANTENNA MOUNT DOUBLER HAS LIGHT CORROSION AROUND SCREW HOLES. REMOVED CORROSION IAW SRM 51-21-00-00-02. ALODINED IAW SRM 51-21-10-02-01. CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT1. BLENDS WITHIN LIMITS PER RD 8/4-53-4370. COMPLIEDSDR AALA20120303013Skin · dentedDENT WITH SCRATCHES BETWEEN STATIONS 500A TO 500C BETWEEN STRINGERS 21 TO 23 LEFT. INSTALLED DOUBLER PER SRM 53-00-01-2R 3.SDR FXGA201203021216Skin · damagedFUSELAGE SKIN & DOOR FRAME CLOSE OUT ANGLES AT AFT EDGE OF MAIN CARGO DOOR BS 794. REPAIRED.SDR DALA1318540171Skin · dentedFOUND SKIN DENT AT BS 1629 AND S-36L. REPAIR IAW ERA 498625-14. TO 498625-14.SDR DALA1224520930Skin · scratchedSCRATCHES TO UPPER AFT CORNER OF LT WINDOW BELT. REPAIR BQ AND BR ACCOMLISHED IAW ERA 501110-14 REV ORIG.SDR SWAA2012032902689Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012032902687Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 727B+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012030902688Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 727C+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012032902676Skin · crackedRT FUSELAGE WINDOW SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012032902675Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB & EA.
Back to JASC 5330