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 EVGR20120326001Skin · corrodedCORROSION WAS FOUND UNDER THE BLACK SOUND DEADENING PATCHES ON THE INSIDE OF THE ACFT SKIN, AND WAS NOT DETECTED UNTIL THE PATCHES WERE REMOVED.SDR IPXA2172602Skin · damagedFUSELAGE SKIN DAMAGED AFT OF FR 85, S44 - 45R 2 DENTS. REPAIRED IAW EO A300-5330-46196-C.SDR ABXA20120326313Skin · damagedPREVIOUS REPAIR AT LEFT FUSELAGE STATION 1439 AT S-36L AND S-39L NEAR DENTS. REMOVED REPAIR TRIMMED OUT SKIN AND INSTALLED AN EXTERNAL DOUBLERS PER REA B653-59754MR, ACFT WAS GROUNDED.SDR MASA2012032734627Skin · chafedLOWER FUSELAGE SKIN IS CHAFED JUST FORWARD OF FS 913.00 AT STRINGER 27. DAMAGE IS APPROX .500 LONG BY .300 WIDE, AND .022 DEEP. PERFORMED A MAJOR REPAIR TO THE FUSELAGE SKIN AT FS 913.00 ON STRINGER 27 BY BLENDING OUT THE DAMAGE IAW BOMBARDIER INC (REO) 670-SDR SWAA2012032702624Skin · crackedSKIN CRACKED AT BS 374, STR 15L. REPAIRED SKIN PER SRM.SDR QXEA2012032600256Skin · corrodedSKIN STRAP AND SPLICE PLATE AT STATION 94.8-116 IS CORRODED AT STRINGER 31P-32P. BLENDED AND REMOVED CORROSION IAW SRM 51-21-00-00-02. REMAINING MATERIAL WITHIN LIMITS AND CONFIRMED TO BE CRACK FREE. ALODINED PRIMED AND PAINTED EFFECTED AREA.SDR ALGA2012032602Panel · corrodedPANEL HAS CORROSION AND SEPARATION BEYOND LIMITS.SDR FDEA201203261097Skin · scratchedFUSELAGE SKIN, UNDER SHORING BS 540 - 560 BETWEEN STR 26L - 26R HAS SCRATCHES. SKIN REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR 16, REV 105. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201203261096Skin · scratchedFUSELAGE SKIN UNDER SHORING BS 500 -520 BETWEEN STR 26L - 26R HAS SCRATCHES. DAMAGED SKIN REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR 16, REV. 105. REPAIR IS CLASSIFIED AS MAJOR.SDR C77A20130502012Skin · dentedON APPROACH, CREW REPORTED A BIRD STRIKE ON THE UPPER FUSELAGE SKIN JUST AFT OF THE RADOME. INSPECTION, MX FOUND DAMAGE ON FRAME 1, AN 8 INCH LONG DENT, .2187" DEEP AND 1.8" IN HEIGHT DENT DAMAGE.SDR SWAA2012041603148Skin · crackedL2 DOOR FUSELAGE SKIN CRACKED AT BS 947.5. REPLACED SKIN IAW SRM AND DWG.SDR DALA1221730908Skin · corrodedTWO RIVETS DAMAGE, LOCATED ON FUSELAGE EXTERIOR SKIN BS 229 LONGERON 23 RIGHT. REMOVED RIVETS, FOUND CORROSION ON SPLICE AND LONGERON, CORROSION FOUND TO BE OUT OF LIMITS, REMOVED DAMAGED SECTION AND SPLICE, FABRICATED AND INSTALLED NEW LONGERON AND SPLICE ISDR RAIA201203250001Skin · damagedAIRCRAFT WAS PARKED ON C-PAD IN STL WHEN DURING THE NIGHT AN UNKNOWN PERSON STRUCK THE AIRCRAFT WITH AN UNKNOWN PIECE OF GROUND EQUIPMENT. DURING THE EARLY MORNING WALK AROUND OF THE AIRCRAFT MAINTENANCE DISCOVERED THE DAMAGE. THE LEFT SIDE AFT OF THE PASSENSDR SWAA2012050403697Skin · crackedSKIN CRACKED AT BS 800, STR 18L. REPAIRED SKIN IAW SRM.SDR SWAA2012050403696Skin · crackedFUSELAGE SKIN CRACKED AT BS 787-3, STR 23L. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012050403695Skin · crackedFUSELAGE SKIN CRACKED BS 787-7, STR 19L. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012050303665Skin · crackedSKIN CRACKED AT BS 807, STR 23L. REPAIRED SKIN IAW SRM & EA.SDR SWAA2012040202762Skin · crackedSKIN CRACKED BETWEEN BS 664 TO BS 672, LBL 31. REPAIRED SKIN IAW SRM & AMM.SDR USAA2012032800007Skin · crackedCDFI VISIT - .5 INCH CRACK IN FUSELAGE SKIN AT RADIO ALTIMETER ANTENNA CUTOUT AT BS 430 BETWEEN S28L TO S28R. REPAIRED FUSELAGE SKIN AT RADIO ALTIMETER ANTENNA CUTOUT AT BS 430 BETWEEN S28L TO S28R IAW EA 202102.SDR DALA1218140678Skin · damagedSTATIC DISCHARGE ON SKIN SEAM AT STA 1335 STR 4R- REPAIR REF 53-00-01. THIS IS A DISCOVERY- FINAL REPAIR TO BE DETERMINED.SDR DALA1218130678Skin · damagedSTATIC DISCHARGE ON SKIN SEAM AT STA 1264 STR 4R REF SRM 53-00-01 FOR REPAIR. THIS IS A DISCOVERY- FINAL REPAIR TO BE DETERMINED.SDR DALA1218120678Skin · damagedSTATIC DISCHARGE ON SKIN SEAM AT STA 1297 STR 4R REPAIR REFERENCE 53-00-01. THIS IS A DISCOVERY- FINAL REPAIR TO BE DETERMINED.SDR USAA2012032700002Skin · crackedC5 CHECK - 2 CRACKS ON LOWER FUSELAGE SKIN AT EXHAUST PORT DUCT AT BS 380, LBL 3. REPAIRED LOWER FUSELAGE SKIN AT EXHAUST PORT DUCT AT BS 380, LBL 3 IAW EA 103809.SDR SWAA2012032602562Skin · crackedSKIN CRACKED AT BS 727 E + 10, STR 10L. REPAIRED SKIN PER EA.SDR SWAA2012041903259Skin · crackedFUSELAGE SKIN CRACKED AT BS 324, ABOVE STR 17R, LOWER AFT CORNER OF R1 DOOR CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA2012041803193Skin · crackedRT FUSELAGE SKIN AT BS 887C+10 UPPER AFT WINDOW CORNER CRACKED. REPAIRED SKIN PER EA.SDR SWAA2012041203073Skin · crackedFIRST OFFICERS WINDOW FRAME SKIN UPPER OUTBOARD CORNER CRACKED. REPAIRED SKIN PER SRM AND BAC DWG.SDR SWAA2012041203072Skin · crackedCAPTAINS WINDOW FRAME SKIN UPPER OUTBOARD CORNER CRACKED. REPAIRED SKIN IAW SRM & BAC DWG.SDR SWAA2012041002965Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 887+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002964Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002963Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002962Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012040902868Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012040902867Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012040902865Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012040902864Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR FXGA20120323001Skin · corrodedDURING HEAVY MX, FOUND LOWER BELLY SKIN, CORRODED IN SEVERAL SPOTS. SKIN WAS REPLACED.SDR REXA2012033000379Skin · dentedFOUND THE FUSELAGE SKIN TO BE DENTED BETWEEN FS 625 AND FS 640 AND BETWEEN S-20L AND S-21L. THE DENT WAS MEASURED TO BE 9.375 X 5.25 X 0.255 DEEP. REPAIRED IAW EA CRJ253-00427B AS AUTHORIZED BY 8110-3 DATED 3/23/12.SDR DALA1217890678Skin · damagedSTATIC DISCHARGE ON EXTERNAL FUSELAGE SKIN AT STA 947 AND STR 3R DISCOVERY- REPAIR TO BE DETERMINED REF: SRM 53-00-01.SDR DALA1217840678Skin · damagedSTATIC DISCHARGE ON EXTERNAL SKIN AT STA 1025 BETWEEN STR 3R AND 4R DISCOVERY- FINAL REPAIR TO BE DETERMINED REF: SRM 53-00-01.SDR SWAA2012032702622Skin · crackedSKIN CRACKED AT BS 517, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA2012032702621Skin · crackedSKIN CRACKED AT BS 487, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA2012032702620Skin · crackedSKIN CRACKED AT BS 424, STR 16R. REPAIRED SKIN PER SRM.SDR FDEA201203231085Skin · misrepairedFUSELAGE SKIN MISREPAIRED AT BS 760-780 BETWEEN S16-17L. REPAIRED ON STAM 47461010001 AND STAM EA 757- 5331-16 -F3678, REV. MAJOR REPAIR.SDR FDEA201203231084Skin · dentedLEFT LOWER EXTERNAL FUSELAGE AT BS 760 S18L DENTED. REPAIRED STAM 47461000001 AND STAM EA 757-5331-16-F3678. MAJOR REPAIR.SDR NSVA20120323487Skin · dentedFORWARD FUSELAGE BOTTOM SKIN FROM STA - 54 TO - 84.2, BETWEEN STRINGERS 31S AND 32P HAS MULTIPLE DENTS. REFERENCE RD 8/4-53-4383 AND TD 400-53-12-28 FOR CORRECTIVE ACTION.SDR UHLA2003220300434Skin · dentedDENT IN SKIN BETWEEN FR3-FR4 AND STGR 17L-18L. REPAIRED SKIN. MAJOR REPAIR.SDR DALA1217676304Skin · crackedDURING HFEC SURFACE INSPECTION ON RT NR 3 DOOR CUTOUT UPPER AFT CORNER, CRACK INDICATION FOUND ON FUSELAGE SKIN AREA AS MARKED. REPAIRED PER PRI 501578-14.SDR DALA1217656304Skin · crackedDURING HFEC SURFACE INSPECTION ON LT NR 3 DOOR CUTOUT UPPER AFT CORNER, CRACK INDICATION FOUND ON FUSELAGE SKIN AREA AS MARKED. REPAIRED PER PRI 501583-14. (LP 0443605)
SDR SWAA2012042003284Skin · crackedCRACK ON FUSELAGE SKIN CUTOUT OF GROUND SERVICE DOOR, BS 520+2", STR 28L TO STR 28R. REPAIRED FUSELAGE SKIN PER SRM AND EO.
Back to JASC 5330