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 SWAA076439Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727C, STR 14R. REPAIRED SKIN PER SRM.SDR SWAA076438Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 440, STR 17L. REPAIRED SKIN PER SRM.SDR QXEA200702029Skin · crackedPDX - THERE IS A 2" CRACK IN THE FUSELAGE SKIN AT THE TOP OF THE AIRCRAFT STRUCTURE AT STRINGER 1 STATION X-32.400. MAINTENANCE MAPPED DAMAGE FOR ENGINEERING. HFEC INSPECTED CRACKED AREA TO VERIFY ENDS OF CRACK. CUT OUT DAMAGED AREA OF 4.5" BY 3.2" PER RD 8SDR 2007UALA05215Skin · damagedFUSELAGE EXTERNAL SKIN DENTED & SMALL CRACK, BS 2190 STR 26R. MAJOR REPAIR ACCOMPLISHED: INSTALLED EXTERNAL DOUBLER.SDR DLM90071652Skin · dentedLT FUSELAGE STA 219 LONGERON 17L DENT. REPAIRED DENTS IAW MD-80 SRM 53-14D FIG 12B ON N/R 2000-0040AT HMV-2 IN OKC.SDR DLM88071648Skin · corrodedFUSELAGE SKIN FOUND WITH CORROSION AT STA 620 BETWEEN L-29L AND L-29R. CUTOUT DAMAGED SKIN AND INSTALLED A DOUBLER.SDR NWAA074359946Skin · crackedDURING "H" CHECK, FOUND CRACKS IN SKIN AT FORWARD PASSENGER ENTRY DOOR CUTOUT AT AFT DOOR STOPS NR 3 AND NR 4. REPAIRED PER EA 99-211049.SDR 2007UALA05208Structure · dentedDENT FOUND RUNNING IN A VERTICAL DIRECTION APPROX 3 FT FWD OF DOOR 2L. MAJOR REPAIR ACCOMPLISHED AT DEN.SDR SWAA076471Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 479, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA076443Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 754, STR 25L. REPAIRED SKIN PER SRM.SDR 2007UALA05191Skin · crackedEXTERNAL FUSELAGE SKIN HAS SUB-SURFACE CRACK INDICATION AT STR 10L BETWEEN STA 433-434. MAJOR REPAIR ACCOMPLISH PER AMM 53-31-96 FIG 602. AC OK FOR SERVICE.SDR FDEA200712205107Skin · dentedEXT FUSELAGE LWR SKIN FOUND 2 DEEP DENT, 1) 6 INCH BY 2 INCH THE WIDTH OF THE DENT IS APPROX .09 INCH, 2) 7 INCH BY 2 INCH THE WIDTH OF THE DENT IS APPROX .09 INCH. REPAIRED AREA IAW SRM 53-20-00 FIG 13 SHT 2A VOL I.SDR USAA920080055Skin · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FUSELAGE SKIN, BS 948, S14L - S15L. REPAIRED FUSELAGE SKIN, BS 948, S14L - S15L IAW B737 SRM 53-00-01-10.SDR TRAX200701967Skin · scratchedAAR - A SCRATCH IN SKIN AT FS 645 BETWEEN STR 2R & 3R (MARKED). BLENDED SCRATCH IN SKIN AT FS 645 BETWEEN STR 2R & 3R. BLENDED AREA IS .700 "LX .300" W X .003" D, FOUND TO BE IN LIMITS IAW CRJ 200 SRM 53-00-31. OK TO ALODINE AND PRIME. ALODINED AND PRIMED SDR SWAA076442Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 24R. MX FERRY TO DAL FOR REPAIRS. REPAIRED SKIN PER SRM.SDR SWAA076435Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 20L. REPAIRED SKIN PER SWA EA.SDR TRAX200701968Skin · dentedFS 676 HAS A DENT IN TOP SKIN BETWEEN STR 1 AND 2R (MARKED).
SDR CALA0700776Skin · corrodedTOOLING MARKS AND SURFACE CORROSION AT UPPER ATC ANTENNA MOUNT SURFACE. SHEET METAL REPAIR COMPLETED AS PER ECRA 5331-01375 AND AMM 34-53-11.SDR DL76S071641Skin · damagedMINOR SKIN BLENDS AT FS 1219-1270 ALONG S-21R TO S-26R.SDR 07FDEA05107Skin · dentedEXT FUSELAGE LWR SKIN FOUND 2 EA DEEP DENT: 6 INCH BY 2" THE WIDTH OF THE DENT IS APPROX .09", 7" BY 2" THE WIDTH OF THE DENT IS APPROX 09".SDR SWAA076365Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 1001, STR 5R. REPAIRED SKIN PER SRM.SDR 2007FA0001104Skin · corrodedIAW AD2002-26-02,- CORROSION FROM WATER, DIRT AND ACID FROM BATTERY ATE THROUGH BOTTOM SKINS 415-13058-1,415-13047L AND R, RIBS 415-13016L AND R AND BOTTOMS OF SERVICE ASSEMBLY NR 5. AIRCRAFT HAD SAT SINCE 1977.SDR CALA0700782Skin · crackedTWO INCH CRACKED IN FUSELAGE SKIN, AT THE AFT LOWER CORNER OF R-1 DOOR CUTOUT. REPAIRED PER ECRA 5331-01367.SDR ASAA0782392Skin · dentedFUSELAGE SKIN DENTED BY JETWAY. REPLACED DAMAGED SECTION OF SKIN. INSTALLED REPAIR DOUBLER PER SRM 53-04-12B.SDR ASMF200712003Skin · damagedDURING TRANSIT CHECK THE AIRCRAFT WAS HIT BY A BAGGAGE CONVEYOR IN THE LOWER FUSELAGE SKIN AT STATION 807 BETWEEN STRINGER 26R AND 27R; CAUSING A DAMAGE OUT OF LIMITS OF 1INCH DIAMETER AND 0.066 INCH DEPTH IAW SRM 53-00-01. MAINTENANCE PERSONNEL REPAIRED THE SDR SWAA076387Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 505D, STR 16R. REPAIRED SKIN PER SWA EA.SDR DL764071640Skin · dentedDURING HMV AT TIMCO GSO, THE FUSELAGE SKIN WAS FOUND DENTED OUT OF LIMITS AT STA 1373 BETWEEN S-28R AND S-29R. THE DAMAGE WAS CUT OUT AND REPAIRED PER ER/A 465100-14.SDR DL76S071639Skin · damagedMINOR SKIN BLENDS AT FS 1438 TO 1540, ALONG S-19L TO S-26L. REPAIRED PER ER/A 459229-14ADREVA.SDR DL76S071631Skin · damagedSKIN BLENDS FS 1444 AND S-39R, AND FS 1448 AND S-38L. REPAIRED PER ER/A 459236-14 REV A.SDR USAA920071350Skin · crackedCLT - MAJOR REPAIR - A CRACK FOUND ON FUSELAGE SKIN AT BS 520 S10L. INSTALLED REPAIR ON FUSELAGE SKIN AT BS 520, S10L.SDR SWAA076341Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 487B, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA076334Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 1006, STR 5R. REPAIRED SKIN PER SRM.SDR USAA920071348Skin · crackedMCN - MAJOR REPAIR - C-16 CHECK - A CRACK ON FUSELAGE SKIN AT R1 DOOR LOWER HINGE CUTOUT, BS 291.5, WL 233.5. INSTALLED DOUBLER AND REPAIRED CRACK ON FUSELAGE SKIN AT R1 DOOR LOWER HINGE CUTOUT, BS 291.5, WL 233.5 IAW B737-300 SRM 53-10-01-2R, FIG 201.SDR UPS08M51595Skin · damagedINSPECTION TYPE:C CENTER CARGO DOOR CUTOUT AFT LWR CORNER FOUND PREVIOUS REPAIR AND WITH RUSTY FASTENERS. PREVIOUS REPAIR DOUBLER REMOVED PER SRM 51-31-01 V.II R35. HFEC INSP C/O PER DAC NDTSPM REV 13 06-10-01.001 ON EXISTING TRIMMED OFF AREA (02EA) AND FOUNSDR UPS08M51554Skin · dentedINSPECTION TYPE:C CENTER CARGO DOOR CUTOUT AFT AREA STA 1790.0 RT L36 FOUND DENT AS MARKED DENT AREA SMOOTHED OUT PER SRM 51-21-01 V.II R35. DENT MARK MEASURED FOUND BEYOND LIMIT PER SRM 53-20-00 FIG 6 V.I R35. HFEC INSP CARRIED OUT PER DAC NDTSPM R.13 06-10SDR USAA920071349Skin · crackedPHX - MAJOR REPAIR - A CRACK FOUND ON FUSELAGE SKIN AT BS 380, S28L - S28R. REPAIRED CRACK IAW US AIRWAYS EA 12067.SDR USAA920071338Skin Panel · corrodedMCN - MAJOR REPAIR - CORROSION FOUND BETWEEN SKIN AND INTERNAL DOUBLER AT BS 908 - BS 1006, S27L - S27R. REMOVED AND REPLACED FUSELAGE SKIN AT BS 908 - BS 1006, S27L - S27R IAW B737-300 SRM 51-40-02-0G FIG 3, 8 AND 12.SDR USAA920071337Skin · crackedMCN - MAJOR REPAIR - CRACKS ON FUSELAGE SKIN AT BS 727D - BS 756+5", S19L - S23L. REPAIRED FUSELAGE SKIN AT BS 727D - BS 756+5", S21L - S23L IAW USAIRWAYS EA 100093.SDR UPS08M51763Skin · misrepairedINSPECTION TYPE:C CENTER CARGO/AT STATION 1778 ABOVE AND IN BETWEEN LONGERON 36 TO LONGERON 37 INTERNAL SKIN ON JAMB AREA FOUND WITH UNAPPROVED SRM REPAIR. UNAPPROVED SRM REPAIR DOUBLER REMOVED PER SRM 51-33-01 V.II R35. REPAIR SKIN CRACK TRIMMED AS PER EN NSDR DL764071629Skin · dentedSKIN DENTED AT FS 654A+110 TO FS 654 S29R TO 30R. DAMAGE CUTOUT AND A REPAIR DOUBLER INSTALLED.SDR MZZA0700765Skin · corrodedFOUND IG CORROSION ON R2 DOOR STRAP, AFT CUTOUT, INNER SKIN AREA. REPAIRED PER ECRA 5330-03761.SDR SWAA076249Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 737E, STR 24L. REPAIRED SKIN PER SWA EA.SDR QXEA200802065Skin · corrodedPDX - C4 CHECK - AIRCRAFT EXTERNAL SKIN CORRODED UNDER AFT ANTENNA. BLENDED OUT CORROSION FROM AFFECTED AREA OF SKIN UNDER ADF ANTENNA IAW REO 670-53-31-090. HFEC INSPECTED NO CRACKS NOTED. RESTORED FINISH TO BLENDED AREA.SDR SWAA076358Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 480, STR 16R. REPAIRED SKIN PER SRM.SDR USAA920071334Skin · crackedCLT- MAJOR REPAIR - C-4 CHECK, A CRACK FOUND ON FUSELAGE SKIN AT BS 942, S24R. FABRICATED AND INSTALLED DOUBLER AT BS 942, S24R IAW B737 SRM 53-00-01.SDR DL757071620Skin · corrodedFUSELAGE/SKIN/FS 880/STRG 28L-28R :CORROSION REPAIR. THE FUSELAGE SKIN WAS FOUND WITH AN AREA OF CORROSION AT FS 880 BETWEEN STRINGERS 28L AND 28R. THE CORROSION WAS ADJACENT TO AN AIR CONDITIONING DUCT CUTOUT. THE DAMAGE WAS REMOVED WITH A CUTOUT TO THE SKSDR SWAA076273Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503D, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA076275Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 513B, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA076274Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 934, STR 22R. REPAIRED SKIN PER SRM.SDR 2007UALA05112Skin · dentedFUSELAGE EXT SKIN IS DENTED AT APPROX BS 271, JUST BELOW STR 20L. ACCOMPLISHED MAJOR REPAIR.
Back to JASC 5330