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 SWAA114436Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER EO AND EA.SDR SWAA114451Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 869 TO BS 870.5, STR 23R. REPAIRED SKIN PER EA.SDR SWAA114411Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER AFT CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA114418Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER AFT CORNER. REPAIRED SKIN PER EO.SDR SWAA114438Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 500-5.5, STR 4L. REPAIRED SKIN PER EA.SDR SWAA114432Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 947+4, STR 21L. REPAIRED SKIN PER EO.SDR SWAA114433Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 947+5, STR 22L. REPAIRED SKIN PER EO.SDR SWAA114434Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 927+7, STR 22L. REPAIRED SKIN PER EO.SDR SWAA114435Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 971, STR 21L. REPAIRED SKIN PER EO.SDR UALA2011061702978Skin · damagedFUSELAGE DAMAGED BY JETWAY, APPROXIMATELY 10FT FROM DOOR 1L AT FLOOR LEVEL, 2.5 TO 3.5 FEET LONG, 8 TO 12 IN WIDE.SDR USAA2011070600021Skin · crackedQ6 - CRACK ON FUSELAGE SKIN AT BS 303.9, WL 259.88. REPAIRED FUSELAGE SKIN AT BS 303.9, WL 259.88 IAW EA EA 1030022.SDR FDEA201106162287Skin · gougedGOUGE LWR FUS. STA 410 BELOW STR 23R. BLENDED AREA AND FOUND OUT OF LIMITS IAW SRM 51-10-1 AND 53-30-1. CUT OUT DAMAGED AREA IAW SRM 53-30-3. FABRICATED DOUBLER AND INSTALLED IAW SRM 53-30-3.SDR DALA1140610627Skin · dentedDENT ON FUSELAGE SKIN STA1630 ABOVE STR 18L. COMPLIED WITH AT SAA/SAT ON NON ROUTINE NR 194995 W/O 87872740001. AS PER ER/A 493036-14 REV ORIGINAL.SDR SWAA114550Skin · crackedDURING SCHEDULED RON CHECK, FOUND SKIN CRACKED AT BS 727C+13, STR 4R. REPAIRED SKIN PER SRM.SDR AALA20110616TUL06Skin · damagedFUSELAGE SKIN ON FORWARD LOWER CORNER OF AFT LAVATORY SERVICE PAN IS SEPARATED FROM TITANIUM HOURGLASS. INSTALLED INTERNAL TITANIUM REPAIR DOUBLER AT THE AFT LAVATORY PAN CUT OUT AREA PER SRM 53-04-00 FIGURE 38 AND EA MD80-53-017519.SDR SWAA114387Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED AT BS 528 LBL 5. REPAIRED SKIN PER EA.SDR SWAA114383Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER FWD CORNER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA114382Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER AFT CORNER OF UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA114381Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 360, BETWEEN STR 5R TO STR 6R. REPAIRED SKIN PER EA.SDR SWAA114376Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 440+15, STR 17L. REPAIRED SKIN PER EA.SDR SWAA114372Skin · crackedDURING SCHEDULED SPV CHECK, FOUND WINDOW FRAME SKIN CRACKED AT BS 500B+10 UPPER FORWARD WINDOW FRAME CORNER. REPAIRED SKIN PER BAC DWG.SDR SWAA114371Skin · crackedDURING SCHEDULED SPV CHECK, FOUND WINDOW FRAME SKIN CRACKED AT BS 380+10, UPPER FORWARD WINDOW FRAME CORNER. REPAIRED SKIN PER EA.SDR FOTR2110409916Skin · dentedDENT AT RT FUSELAGE SKIN BS 213 JUST BELOW LONGERON 18R.SDR SWAA114396Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 500D, STR 3R. REPAIRED SKIN PER EA.SDR SWAA114395Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 380, STR 3R. REPAIRED SKIN PER EA.SDR SWAA114390Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR. REMOVED AND REPLACED DOOR IAW MM.SDR SWAA114386Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 967 STR 24L. REPAIRED SKIN PER SRM.SDR SWAA114369Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED BETWEEN BS 470 TO BS 471, STR 3L. REPAIRED SKIN PER SRM.SDR SWAA114368Skin · crackedDURING SCHEDLED MV1 CHECK, FOUND SKIN CRACKED BETWEEN BS 470 TO BS 471, STR 3R. REPAIRED SKIN PER SRM.SDR SWAA114367Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED BETWEEN BS 500B+6 TO BS 500B+10, STR 1. REPAIRED SKIN PER SRM.SDR SWAA114366Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED BETWEEN BS 775 TO BS 782, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA114365Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED BETWEEN BS 752 TO BS 761, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA114363Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 947, STR 7L. REPAIRED SKIN PER ER AND EA.SDR C2XA11TY087Skin · damagedTYS - A/C WAS EN ROUTE FROM PVD TO IAD WHEN A BIRD STRIKE TO THE LEFT AVIONICS BAY. MAINTENANCE PERFORMED A GVI INSPECTION TYO THE LT AVIONIC AREA AND AVIOIC RACK AND NO DAMAGE FOUND. A/C WAS RELEASED TO FERRY TO TYS (LOGPAGE 2432005). MAINTENACE REPAIRED ASDR FDEA201106142239Skin · misrepairedEXISTING FUSELAGE SKIN EXTERNAL DOUBLER REPAIR AT STA 1710, STR 24L REQUIRES REPLACEMENT DUE TO NOT BEING IN COMPLIANCE WITH KNOWN APPROVED DATA. REMOVED EXISTING DOUBLER, CUT-OUT DAMAGE SKIN AND INSTALLED NEW DOUBLER/ FILLER, BS 1708-1718, S23L-S24L, IAWSDR REXA201100392Skin · damagedFUSELAGE SKIN DAMAGED AT FS 718.00 AND BETWEEN S-22L AND 24L. REPAIRED IAW BOMBARDIER REO 601R-53-61-4084.SDR SWAA114301Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 843, STR 16L. REPAIRED SKIN PER EA.SDR SWAA114302Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT UPPER CORNER. REPAIRED SKIN PER SRM.SDR HEEA131368Skin · crackedRT ROLLOVER SKIN CRACKED DURING MAIN BASE MX ACTIVITY. SKIN WAS BEING MANIPULATED TO GAIN ACCESS TO DRAIN LINES BEHIND SKIN WHEN SKIN ASSY CRACKED IN 2 PLACES. OPENSDR 2011FA0000365Skin · corrodedWHILE COMPLYING WITH AD 2011-09-02 MULTIPLE SPOTS OF CORROSION WERE DISCOVERED BETWEEN THE LOWER TCAS ADAPTOR PLATE AND THE FUSELAGE SKIN. THE CONTOUR PLATE CALLED OUT IN THE STC WAS REPLACED AND THE CORROSION WAS BLENDED AND MAPPED OUT. INFORMATION WAS SENTSDR FDEA201106142233Skin · dentedFUSELAGE EXTERIOR WITH DENT AT BS 1661 (2 IN) TO BS 1681.8 BETWEEN STR 27 TO STR 26L. DENT IS WITHIN LIMITS IAW SRM 53-00-01. COMPLIED EA F-5330-150714, DENT IN FUSELAGE SKIN BETWEEN BS 1661 TO 1681 AND S26L TO S27L. REPAIR IS CLASSIFIED AS MAJOR.SDR SWAA114285Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 787, STR 19L. REPAIRED SKIN PER SRM AND EA.SDR SWAA114284Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 405, STR 17R. REPAIRED SKIN PER SRM AND EA.SDR SWAA114274Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 727D+11, STR 4L. REPAIRED SKIN PER ER AND EA.SDR SWAA114273Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 500B+9, STR 2R. REPAIRED SKIN PER ER AND EA.SDR CA131003001Skin · damaged(CAN) DISCREPANCY FOUND DURING ACFT PAINT STRIPPING. FOUND SCRIBE MARKS/SCORING ON ALL FUSELAGE SKINS AT ALL CABIN WINDOW CUTOUTS. THE SCRIBE MARKS/SCORING OCCURED AT PAINT PROCESS DURING ACFT COMPLETION PHASE. ADJACENT TO ALL CABIN WINDOWS , THE FUSELAGE SSDR DALA1145310922Belt · damagedLIGHTEING STRIKE ON RT WINDOW BELT FRAMES BETWEEN STA Y=256-237, 275-256, 294-275, 313, 294, 332-313, 351-332 AND 465-446. BLENDED AREAS IAW ERA 494034-14 REV A. CONTINUE SERVICE AS-IS.SDR IPXA1M68002Skin · dentedINSPECTION TYPE:4C, REF D-454178 DENT AT LT STA 1823 BETWEEN L39L AND L40L REQUIRES PERMINENT REPAIR. CUT OUT DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED REF STA, SA, EA 011-5330-01-A3240 AND EO MD11-5330-43496-A.SDR FDEA201106132223Skin · misrepairedTHE PREVIOUSLY INSTALLED SKIN REPAIR LOCATED AT BS 1360 S-1 TO S-2R (SKY RADIO ANTENNA CUT OUT ) DOES NOT CONFORM TO CURRENT S/F SRM. ACCOMPLISHED E.A. F-5330-147691.SDR GLBA20110613JSkin · corrodedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION, MX FOUND A CORROSION IN THE BELLY SKIN AT FS 243.25 BETWEEN STRINGER 16 AND 15R. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 11-1900-53-040 MATERIALS UTILIZED ARE INCLUDED
Back to JASC 5330