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 USAA2012052900020Skin · crackedRON VISIT - CRACK IN FUSELAGE SKIN AT BS 884, S25R. REPAIRED FUSELAGE SKIN AT BS 884, S25R IAW SRM 53-00-01-2R-31 DETAIL X & XIX.SDR DALA1234100671Skin · dentedDENT AT BS 1720 STR 29 - 30L, OUT OF LIMITS. REPAIRED PER ER/A 501964-14.SDR DALA1234090671Skin · dentedLEFT SIDE OF THE FUSELAGE FWD OF THE L2 DOOR FIVE DENTS LOCATED BETWEEN BS 635-660 STRINGERS 14L AND 19L. REPAIRED PER ERA 503144-14.SDR FDEA201205251963Skin · misrepairedSKIN BS 313, LONGERON 52 MISREPAIRED. REPAIRED CARRIED OUT IAW SRM 53-00-01, FIG 201. REPAIR 1, REV 49 EO E1-5100-7- 5001B-PT1. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 114.SDR SWAA2012061104833Skin · crackedSKIN CRACKED AT BS 767 +15.5, STR 23L. REPAIRED SKIN IAW ER AND EA.SDR FDEA201205251969Skin · puncturedDURING SURVEILLANCE INSPECTION, FOUND OUTWARD PUNCTURE (2 LOCATIONS 2.75 APART) ON FUSELAGE SKIN AT BS 1493 AND 1494, BETWEEN S24R AND S25R. REMOVED DAMAGE PER SRM 53-00-01, REPAIR 16, STEPS 1-3 AND SRM 51-40-02. INSTALLED REPAIR DOUBLER AND COMPLETED REPASDR FDEA201205251968Skin · misrepairedEXTERNAL FUSELAGE SKIN AT BS 1380-1400, BETWEEN S27R - S30R. DOES NOT COMPLY WITH SRM. ACCOMPLISHED EA F-5330-160580. MAJOR REPAIR.SDR DALA13023059213Skin · crackedFUSELAGE SKIN SPLICE AND DORSAL FIN INNER ATTACH ANGLE, BS 1486 L2R FOUND CRACKED. MAJOR REPAIR.SDR R61A201205240647Skin · dentedHAIL DENTS/DAMAGE TO TOP SKIN P/N 85360111-111 THAT GOES UNDER WING. MX BTAC REMOVED AND REPLACED FUSELAGE SKIN THAT GOES UNDER WING IAW DER RD # 8/4-53-4632 DATED 5 JULY 2012. A/C REMAINS IN TUS FOR A/C COMPLETION.SDR R61A201205240627Skin · dented***MAJOR*** A/C HAS HAIL DAMAGE TO TOP FUSELAGE SKIN THAT GOES UNDER WING BETWEEN STN X234.475 - X301.00, BETWEEN STR 8S AND STR 8P. P/N 85360111-111. MX SPLICED SKIN AT X301.00 AND REMOVED AND REPLACED WITH NEW SKIN IAW BOMBARDIER RD 8/4-53-4632. DATED 5-JUSDR SWAA2012061805026Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012061805020Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 360+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012061805019Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012061805018Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012061504982Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012061504977Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012061504976Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 887+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012061404884Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 360+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012061404883Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012061104790Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500B+10 UPPER FORWARD CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012060704742Skin · crackedFUSELAGE SKIN CRACKED AT LEFT BS 480+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER SERVICE BULLETIN.SDR SWAA2012060704741Skin · crackedFUSELAGE SKIN CRACKED AT LEFT BS 460+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER SERVICE BULLETIN.SDR SWAA2012060704740Skin · crackedFUSELAGE SKIN CRACKED AT LEFT BS 440+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER SERVICE BULLETIN.SDR SWAA2012060704739Skin · crackedFUSELAGE SKIN CRACKED AT LEFT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER SERVICE BULLETIN.SDR SWAA2012060704738Skin · crackedFUSELAGE SKIN CRACKED AT RIGHT BS 500C+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER SERVICE BULLETIN.SDR SWAA2012060704737Skin · crackedFUSELAGE SKIN CRACKED AT RIGHT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER SERVICE BULLETIN.SDR SWAA2012060704736Skin · crackedFUSELAGE SKIN CRACKED AT RIGHT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER SERVICE BULLETIN.SDR SWAA2012060704735Skin · crackedFUSELAGE SKIN CRACKED AT RIGHT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER SERVICE BULLETIN.SDR SWAA2012060704734Skin · crackedFUSELAGE SKIN CRACKED AT RIGHT BS 807+10 FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER SERVICE BULLETIN.SDR SWAA2012060704733Skin · crackedFUSELAGE SKIN CRACKED AT RIGHT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER SERVICE BULLETIN.SDR SWAA2012060604727Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012060604726Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 420+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW S/B.SDR SWAA2012060604725Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 460+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW S/B.SDR SWAA2012060604724Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 420+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW S/B.SDR SWAA2012060604723Skin · crackedRIGHT FUSELAGE WINDOW CRACKED AT BS 400+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012060604722Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 480+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW S/B.SDR SWAA2012060604715Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 460+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012060604714Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012060604713Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012060504679Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500B+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012060504671Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW S/B.SDR SWAA2012060504670Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW S/B.SDR DALA1234880926Skin · corrodedAFT CARGO COMPARTMENT BILGE AREA BETWEEN STA 1155 AND 1174 LONGERON 29 L HAS POCKETS OF MATERIAL MISSING AT FASTENER LOCATIONS ON LOWER INTERIOR OF CHANNEL FOUND AFTER REMOVAL OF VHF ANTENNA MOUNT FITTINGS. BLENDED AREAS OF CORROSION, FOUND TO BE OUT OF LIMITSDR C77A20120601027Finger Doubler · corrodedRT FWD CARGO BAY AFT FINGER DOUBLER CORRODED. REMOVED CORROSION BY BLENDING AND TREATING IAW SRM 51-10-03 & 51-12-01 ON WO 490404-120 IAW ETD 2012-170-007333-A AND EO E175-5300-062 REV. IR WO 568561.SDR SWAA2012052904426Skin · crackedSKIN CRACKED AT BS 394, STR 16L. REPAIRED SKIN IAW EA.SDR AALA20120524015Skin · corrodedCORROSION ON INNER SKIN UNDER STRINGER 36 RIGHT FROM STATIONS 414 TO 430. INSTALLED EXTERNAL DOUBLER PER SRM 53-00-01-2R.SDR DALA1234046703Skin · damagedMAINTENANCE DISCOVERED A BURNED LOCK FASTENER AT BS 268 JUST FWD OF NLG DOORS. REMOVED DAMAGED LOCK FASTENER AND INSPECTED, NO DAMAGE FOUND. REPLACED FASTENER REFERENCE SRM 53-00-01.SDR DALA1234036703Skin · damagedMAINTENANCE PERFORMED INSPECTION, DUE TO LIGHTNING STRIKE ON THE GROUND. MAINTENANCE DISCOVERED AND REPAIRED DAMAGE PER SRM 53-00-01.SDR DALA1234026703Skin · damagedDURING INSPECTION MAINTENANCE DISCOVERED A BURN MARK AT BS 520 BETWEEN STR 6 AND 7. MAINTENANCE REMOVED THE DAMAGE, INSPECTED. NO FAULTS NOTED AND INSTALLED BLIND FASTENERS.SDR SWAA2012061104772Skin · crackedR2 DOOR FUSELAGE SKIN CRACKED AT LOWER FWD CORNER. REPAIRED SKIN PER SRM.
Back to JASC 5330