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 AALA20090402TUL16Skin · damagedDENT IN FUSELAGE LEFT SIDE STATION 237, LONGERON 17L TO 18L. INSTALLED DOUBLER PER SRM 53-04 FIGURE 12B.SDR DL757090748Skin · dentedACCOMPLISH PERM REPAIR PER ERA468725-14REV ORIG ACTL LINE 2300 REF OMI LOG CN C06028120 FUSELAGE SKIN AND STRINGER STA620 STR16L DENTS C/W ERA468725-14REV ORIG DURING HMV AT SAT ON NRC120363.SDR SWAA091721Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 500B, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA091705Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED BETWEEN BS 868 TO BS 872, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA091690Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 727, STR 4R. REPAIRED SKIN PER SWA EA.SDR SWAA091689Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RADIO ALTIMETER BELLY SKIN CUTOUT CRACKED AT BS 413, BETWEEN LBL 3 TO RBL 3. REPAIRED SKIN PER ER.SDR SWAA091675Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BETWEEN BS 868 TO BS 872, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA091667Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727, STR 20L. REPAIRED SKIN PER ER.SDR SWAA091665Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BS 292, WL 230. REPAIRED SKIN PER SRM.SDR SWAA091664Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT, BS 292, WL 255. REPAIRED SKIN PER SRM.SDR DLM88090401Skin · damagedLIGHTNING STRIKE ON SKIN AT WINDOW CUTOUT BETWEEN FS 484-FS 503. COMPLETED TEMPORARY BLEND OUT REPAIR.SDR DL757090399Strap · corrodedDURING CURRENT HMV, CORROSION WAS FOUND ON THE OVERWING ESCAPE HATCH REINFORCEMENT STRAP. THE SUBJECT AREA WAS BLENDED AND A REPAIR DOUBLER INSTALLED PER BOEING INSTRUCTIONS. DETAILS OF THE REPAIR ARE DOCUMENTED IN 472309-14.SDR DL757090388Skin · dentedDURING CURRENT HMV, DENTS WERE FOUND AT STA 600- STA 640 BETWEEN S-16L AND S-18L. BOEING WAS CONTACTED FOR PREFERRED REPAIR. DENT AT FS 600 WAS ACCEPTABLE AS IS, AND THE DENTS BETWEEN 620 AND 640 WERE REPAIRED WITH AN EXTERNAL DOUBLER. THE REPAIR AREA HAD ASDR UALA2009031200766Skin · damagedLWR AFT FUSELAGE LEFT AND RIGHT ANTENNA CUTOUTS. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED NEW DOUBLERS.SDR UALA2009031200763Skin · dentedSKIN DENT STA 520, BETWEEN STR 29R AND 30R. MAJOR REPAIR ACCOMPLISHED, CUT OUT DAMAGED SKIN, INSTALLED DOUBLER REPAIR.SDR SWAA091685Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 500D, STR 12L. REPAIRED SKIN PER ER.SDR SWAA091684Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 470, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA091660Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 774, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA091618Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED BETWEEN BS 727B TO BS 727C, STR 24L. REPAIRED SKIN PER EA.SDR AALA20090317TUL11Skin · damagedKNIFE EDGE FASTENER HOLES COMMON TO THE RIGHT SKIN, STATION 1338, LONGERON 12R-14R. REPAIRED FASTENER HOLES IN ACCORDANCE WITH EA MD80-53-005666 DATED 03/06/09.SDR IPXA09M55288Skin · damagedINSPECTION TYPE:C4 LOWER CENTER CARGO DOOR AFT DOOR JAMB GOUGED / DENTED AT LOWER CORNER. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR DOUBLER, TRIPLER, AND FILLER IAW MD-11 SRM 53-50-00 FIG 17 SHEETS 3-5 AND NOTE 14.A.SDR UALA2009031200761Skin · crackedMED 1R CRACK AT LWR AFT CORNER. STARTED DOUBLER/TRIPLER REPAIR. MAJOR REPAIR ACCOMPLISHED. COMPLETED DOUBLER, TRIPLER, QUADRUPLE REPAIR.SDR SWAA091640Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 440, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA091639Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 445, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA091638Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 747, STR 20L. REPAIRED SKIN PER SWA EA.SDR SWAA091637Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 779, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA091636Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 779, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA091635Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 763, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA091634Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 760, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA091633Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 749, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA091632Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 727D, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA091631Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 759, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA091630Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 500D, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA091629Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 750, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA091628Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 500D, STR 16R. REPAIRED SKIN PER SWA EA.SDR FDEA200903100880Skin · corrodedCABIN - R/H STA 1229, X= -70 CENTER WING UPPER PANEL FOUND CORROSION. REPAIR CARRIED OUT AS PER FEDEX EA 1-5710-127463: WINGS, CENTER WING UPPER AUXILIARY FUEL TANK SKIN CORROSION, REPAIR.SDR SWAA091601Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 291, WL 254, RT SIDE. REPAIRED SKIN PER ER.SDR SWAA091568Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT E&E EQUIPT COMPT EXHAUST CUTOUT, BETWEEN BS 360 TO BS 380. REPAIRED SKIN PER SWA EA.SDR ASAA0944674Skin · damagedFUSELAGE SKIN PREVIOUSLY BLENDED AREAS OUT OF LIMITS. REMOVED DAMAGED SKIN AND INSTALLED REPAIR.SDR DLM88090385Skin · wornTHE CROWN SKIN AT FS 1019 HAD ELONGATED NUTPLATE HOLES BETWEEN L-1 AND L-2R. DAMAGE WAS CUTOUT TO A 1 INCH HOLE DIAMETER. A 0.063 INCH REPAIR DOUBLER AND TRIPLER, WITH AN 0.100 INCH STRUCTURAL SHIM WAS INSTALLED.SDR DL757090384Strap · damagedWHILE PERFORMING A SKIN REPAIR AT FS 288 AT L-18L, PER SRM 53-00-01-2R-2, MX TRIMMED THE 141N3850-23 STRAP. PROVIDED AN APPROVED SKIN AND STRAP REPAIR. THE SKIN CUTOUT MEASURED APPROXIMATELY 6 BY 5 INCHES.SDR ASAA0944672Bear Strap · crackedHOLE CRACKED IN BEAR STRAP AT FWD ENTRY DOOR CUTOUT UPPER HINGE CUTOUT. REPAIRED BEAR STRAP.SDR ASAA0944671Bear Strap · crackedHOLE CRACKED IN BEAR STRAP AT FWD ENTRY DOOR CUTOUT LOWER HINGE CUTOUT. REPAIRED PER EA 400-53EA-0093.SDR SWAA091558Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA091553Skin · crackedDURING SCHEDULED SPV CHECK, FOUND GALLEY DOOR SKIN CUTOUT CRACKED AT BS 291, WL 254. REPAIRED SKIN PER ER.SDR SWAA091534Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BS 291, BETWEEN WL 233 TO WL 234. REPAIRED SKIN PER AAR EA.SDR HALA2009030800136Doubler · crackedOPEN - FUSELAGE, FS 1178 LT AND RT, DOUBLER AND SKIN, HAS A 2 INCH CRACK ON DOUBLER, AND A 2 INCH CRACK ON THE FUSELAGE SKIN PANEL AT CANTED STA 1178.225, LONGERON 3 LEFT AND 3 RIGHT. REPAIR IN WORK.SDR DL738090383Skin · misrepairedHOLES COMMON TO MINOR REPAIR WERE MIS-COUNTERSUNK, REQUIRING SKIN CUTOUT AND DOUBLER/TRIPLER SKIN REPAIR. REFERENCE ERA 473452-14.SDR GUUA92753030809ASkin · corrodedDURING SCHEDULED ROUTINE INSP DISCOVERED CORROSION ON THE FUSELAGE BELLY UNDER BEACON LIGHT MOUNTING PLATE AT FS 370.750. REMOVED CORROSION AT BEACON LIGHT CUTOUT AND INSTALLED EXTERNAL DOUBLER REPAIR.SDR SWAA091515Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND L2 DOOR LOWER FWD CORNER FUSELAGE SKIN CUTOUT CRACKED. REPAIRED SKIN PER SRM.
Back to JASC 5330