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 SWAA2014121735119Skin · crackedRIGHT FUSELAGE SKIN LOWER BULKHEAD AFT UPPER FASTENER HOLE CRACKED AT BS 540. REPAIRED SKIN IAW EA.SDR SWAA2014121735118Skin · crackedRIGHT FUSELAGE SKIN LOWER BULKHEAD AFT UPPER FASTENER SECOND FROM TOP HOLE CRACKED AT BS 540. REPAIRED SKIN IAW EA.SDR SWAA2014121735117Skin · crackedLEFT FUSELAGE SKIN LOWER BULKHEAD AFT UPPER FASTENER HOLE CRACKED AT BS 540. REPAIRED SKIN IAW EA.SDR DALA2014121306576Skin · crackedFUSELAGE SKIN CRACKED AT FASTENER, RT SIDE, BS 1437, 12 INCHES ABOVE RT PYLON. REPAIRED IAW PRI 531221-14, REV O.SDR ASOA20141217118Skin · crackedLEFT REAR FUSELAGE SKIN CRACKED FRAMES 77, 78 AND 79. REPAIRED IAW ETD2014-145-101077-A.SDR FDEA201412124114Angle · corrodedFOUND FOUR DOME NUTS BROKEN AT AFT FUSELAGE LOWER AUX FUEL CELL BLADDER PANEL. REPAIRED IAW EA 8-5730-T0313783 REV . MAJOR REPAIR.SDR FDEA201412124113Skin · corrodedFOUND CORROSION AT BS 1368 ON TOP SIDE OF LOWER AUX FUEL CELL BLADDER PANEL LANDING. REPAIRED IAW EA 8-5730-T0313685 REV.SDR DALA2014121506540Skin · corrodedDURING INSPECTION, FOUND CORROSION ON FUSELAGE SKIN AFT LAVATORY VENT SURROUND STRUCTURE. MAINTENANCE REPAIRED IAW ERA 521636-14.SDR SWAA2015012135927Skin · crackedCAPTAIN'S NR 1 WINDOW C - D POST FUSELAGE SKIN CRACKED AT UPPER END SIDE. REPAIRED SKIN IAW SRM.SDR SWAA2015011435727Skin · crackedFIRST OFFICER'S NR 1 WINDOW C - D WINDOW POST UPPER END SIDE FUSELAGE SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR ASOA2015010912037Skin · dentedDENT ON FUSELAGE RT SIDE BETWEEN BS 169-173 STR 1R. REPLACED THE SKIN IAW SRM 51-42-06-001-001-A01.SDR SIMA20141211005Skin · crackedLEFT REAR FUSELAGE SKIN NR 2 HAS CRACKS BY THE RIVET AT FRAME 78 BETWEEN STRINGERS 3L - 4L. REPAIRED DAMAGE AT FRAME 78, STRINGER 3L - 4L IAW ERS-EM-5300-960.SDR SIMA20141211006Skin · crackedRIGHT REAR FUSELAGE SKIN NR 2 HAS CRACK BY THE RIVET AT FRAME 79 JUST BELOW STRINGER 6R. COMPLETED DOUBLER REPAIR TO SKIN AT FRAME 79 RT IAW ERS-EM-5300-959.SDR QXEA2014121701096Skin · damagedLIGHTNING STRIKE DAMAGE ON LT FUSELAGE SKIN. REPAIRED IAW RD 8/4-53-5721.SDR FDEA201412114103Skin · dentedFUSELAGE DENTED AT BS 761 JUST BELOW STRINGER 17L. REPAIRED IAW SRM 53-00-01 REPAIR 16. MAJOR REPAIR.SDR DALA2014121606560Skin · dentedDENT FOUND AT BS 618 S23R. REPAIRED IAW ERA 530452-14AD, REV.0.SDR DALA2014121606545Skin · dentedDENT ON EXTERNAL FUSELAGE SKIN REPAIR DOUBLER BS 402-403 BETWEEN LONGERONS 25 -26L. AREA REPAIRED IAW ER/A 365087-14, REV C.SDR SWAA2015011535776Skin · corrodedAFT CARGO COMPARTMENT SKIN CORRODED BETWEEN BS 794.3 TO 807, BETWEEN STRINGER 25R TO 26R. REPAIRED SKIN IAW EO & EA.SDR SWIA201440444Skin · chafedFUSELAGE SKIN CHAFED AT BS 977, S27. REMOVED THE CHAFE IAW EA.SDR SWAA2014121735102Post · crackedNUMBER 1 WINDOW POST CRACKED AT 2ND FASTENER HOLE FROM BOTTOM. REPAIRED POST IAW ACO.SDR FDEA201412104093Skin · damagedCENTER CARGO DOOR AFT LOWER CUT OUT CORNER, REPAIR HAS DAMAGE. REPLACED DAMAGED AREA IAW SRM 53-00-01. REMOVED DOUBLERS TWO EACH IAW SRM 51-31-01. FABRICATED NEW ANGLE & REPAIR ANGLE. FABRICATED NEW DOUBLERS THREE EACH. INSTALLED ANGLE, REPAIR ANGLE & NEW SDR DALA2014121206520Skin · gougedAFT FUSELAGE SKIN GOUGED JUST AFT OF LT HORIZONTAL. BLENDED DAMAGE AND FOUND TO BE OUT OF LIMITS. FABRICATED REPAIR AND INSTALLED IAW SRM.SDR QXEA2014121101050Skin · dentedMULTIPLE DENTS ON THE RT FUSELAGE SKIN BETWEEN BS 281 - 341, STRINGERS 16 - 22R. DENTS ARE WITHIN THE ALLOWABLE LIMITS OF RD8/4-53-4598, ISSUE 3 11-26-14.SDR QXEA2014121101049Skin · dentedDENTS ON FUSELAGE SKIN BETWEEN BS 341 STRINGERS 16 - 22R. DENT WITHIN THE ALLOWABLE LIMITS OF RD8/4-53-4598, REV 3 11/26/14.SDR FDEA201412104094Skin · corrodedSURFACE CORROSION ON SKIN. CORROSION REMOVED IAW SRM 53-00-01 & FOUND TO BE WITH IN SRM LIMITS.SDR SWAA2015021836698Skin · crackedSKIN CRACKED AT BS 540, STRINGER 22L. REPAIRED SKIN IAW EA.SDR SWAA2015012936178Skin · crackedLOWER FUSELAGE SKIN CRACKED AT OPENING FOR GND SERVICE AIR CONDITIONING ACCESS DOOR. REPAIRED CUT OUT IAW SRM.SDR SWAA2015011335718Skin · brokenRIGHT SIDE GND SERVICE AIR CONDITIONING ACCESS DOOR CUT OUT FUSELAGE SKIN BROKEN. REPAIRED CUT OUT IAW SRM.SDR SIMA20141209009Skin · crackedFRAME 75 SKIN AT FASTENER AREA CRACKED ABOVE STRINGER 2R. ACCOMPLISHED FRAME 75 ABOVE STRINGER 2R SKIN REPAIR IAW ERS-EM-53MR-984.SDR SIMA20141209006Skin · crackedFRAME 75 FASTENER SKIN AREA CRACKED BELOW STRINGER 2L. ACCOMPLISHED FRAME 75 BELOW STRINGER 2L SKIN REPAIR IAW ERS-EM-53MR-984.SDR SWIA201440445Skin · dentedSKIN DENTED AT BS 248 S26R. REPAIRED THE SKIN IAW EA.SDR SWIA201440442Skin · dentedSKIN AT BS 280 S26R. REPAIR THE SKIN IAW EA.SDR SWIA201440441Skin · dentedSKIN DENTED AT BS 275 S26R. REPAIRED THE SKIN IAW EA.SDR SWAA2014122335243Skin · crackedFUSELAGE SKIN CRACKED AT STATION 540, STRINGER 22L. REPAIRED SKIN IAW EA.SDR SWAA2015011635824Skin · crackedSKIN CRACKED AT BS 327, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2015011235647Skin · crackedSKIN CRACKED AT BS 947+11, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2015011235680Skin · crackedBEAR STRAP SKIN CRACKED AT BS 947+10.5", STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2015010735536Post · crackedLEFT NR 3 E - F WINDOW POST SECOND LOWER FASTENER HOLE CRACKED. REPAIRED POST IAW EO.SDR SWAA2015010735535Post · crackedRIGHT NR 3 E - F WINDOW POST, SECOND LOWER FASTENER HOLE CRACKED. REPAIRED POST IAW EO.SDR WRNA20140027Skin · dentedDURING POSTFLIGHT WALKAROUND, FOUND A DENT ON FUSELAGE FWD OF THE FWD CARGO DOOR. REPAIRED IAW STS EO 100-2014-114. ALL WORK DOCUMENTED ON NR 26850, 002651, 003002.SDR SWAA2014121935169Forging · crackedLEFT FUSELAGE WINDOW FORGING CRACKED AT STATION 807+10. R & R FORGING IAW DWG.SDR SWAA2015011535775Skin · crackedR1 DOOR OUTER SKIN UPPER CORNER OF LOWER HINGE CUT OUT CRACKED. REPAIRED CUT OUT IAW EO & EA.SDR SWAA2015010835555Skin · crackedRIGHT LOWER BULKHEAD CHORD SKIN CRACKED AT BS 540. REPAIRED SKIN IAW EA.SDR SWAA2014122335249Skin · crackedFUSELAGE SKIN CRACKED AT STATION 799, STRINGER 25R. REPAIRED SKIN IAW SRM.SDR SWAA2014121935165Skin · crackedFUSELAGE SKIN CRACKED AT STATION 798 TO 800, STRINGER 25R. REPAIRED SKIN IAW SRM.SDR ASAA2014120709895Skin · crackedFUSELAGE SKIN IS CRACKED S25L AT LAP JOINT BETWEEN BS 747 AND 767. ACFT GROUNDED. REPAIRED FUSELAGE SKIN IAW SRM 53-00-01-2R-31, REPAIR 31, FIG 201 DETAIL XV.SDR DALA2014120906451Skin · dentedDENT ON EXTERNAL FUSELAGE SKIN REPAIR DOUBLER BS 402-403 BETWEEN LONGERONS 25 -26L. REPAIRED IAW ER/A 365087-14, REV C.SDR AALA20141207004Skin · crackedNOSE LANDING GEAR RT AFT DOOR HINGE CUT OUT SKIN IS CRACKED AT FUSELAGE STATION 101.5. REPAIRED SKIN IAW SRM 53-05-00 FIG 62.SDR REXA2014120800919Skin · dentedTHE FUSELAGE SKIN BETWEEN FS 290 & 295 AT STRINGER 17L WAS FOUND DENTED. THE DENT MEASURES 6.5 INCHES X 2.25 INCHES X 0.018 INCHES DEEP. REPAIRED IAW EA CRJ253-03119.SDR WVER1203201400006Skin · crackedSKIN CORRODED BETWEEN BS 986 - 987 S26L-26R.
Back to JASC 5330