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 SWAA2013100120612Window Post · crackedRT NR 3 FWD WINDOW POST CRACKED FASTENER HOLE NR 2 FROM BOTTOM, AT 3 & 9 O'CLOCK POSITION. REPAIRED POST IAW EA.SDR SWAA2013100120611Window Post · crackedLT NR 3 FWD WINDOW POST CRACKED FASTENER HOLE NR 2 FROM BOTTOM, AT 3 & 9 O'CLOCK POSITION. REPAIRED POST IAW EA.SDR AALA20130923020Skin · corrodedCORROSION ON SKIN AT BS 928 BETWEEN LONGERONS 22 & 21 LT. INSTALLED DOUBLER.SDR AALA20130923019Skin · corrodedCORROSION ON FS SKIN AT BS 928 BETWEEN LONGERONS 22 & 23 LT. INSTALLED DOUBLER.SDR AALA20130923014Skin · dentedFUSELAGE SKIN HAS A LONG DENT ON RT SIDE OF FUSELAGE AT BS 276.5 FROM STRINGERS 24 TO 25 RT. CUT OUT DAMAGE & REPAIRED IAW EA B777-53-031665.SDR CALA2013092491390Skin · dentedDENT IN EXTERIOR SKIN AT BS 1695, ABOVE STRINGER 15R. CUT OUT DAMAGED AREA, INSTALLED REPAIR DOUBLER IAW ECRA 5330-04717.SDR SWAA2013092620551Window Post · crackedLT NR 3 FWD WINDOW POST FASTENER HOLE NR 5 FROM BOTTOM CRACKED AT 3 O'CLOCK POSITION. REPAIRED POST IAW SWA EA.SDR SWAA2013092620550Window Post · crackedLT NR 3 FWD WINDOW POST FASTENER HOLE NR 4 FROM BOTTOM CRACKED AT 3 O'CLOCK POSITION. REPAIRED POST IAW SWA EA.SDR SWAA2013092620549Window Post · crackedLT NR 3 FWD WINDOW POST FASTENER HOLE NR 3 FROM BOTTOM CRACKED AT 3 O'CLOCK & 9 O'CLOCK POSITION. REPAIRED POST IAW SWA EA.SDR TSAA20130923008Skin · corrodedDURING CHECK, CORROSION FOUND ON FUSELAGE SKIN, FORWARD AND BELOW RT SIDE WINDOW.SDR ASOA2013092509088Skin · burned1 BURN ON FASTENER AT FS 295 AND S25L. INSTALLED SOLID RIVET, SRM 51-42-06 AND REO 670-53-00-045, REV G, SECTION B2.SDR DALA13046860971Skin · damagedFUSELAGE SKIN DAMAGED, REPAIRED IAW ER/A 473338-14SDR FDEA201309232287Skin · dentedLOWER FUSELAGE SKIN, FRAME 19- 20, STR 34 -35R DENTED. REPAIRED IAW SRM 53-10-12 FIG 226 (SHEET 2). REPAIR CLASSIFIED AS MAJOR.SDR DALA13046783141Skin · dentedDENT IN FUSELAGE SKIN, BETWEEN FRAMES 9-10, 17 INCHES BELOW THE F/O PITOT TUBE. FOUND WITHIN LIMITS IAW SRM 53-11-11, DIAGRAM 102. PERFORMED DVI IAW SRM 53-11-11 DIA 102. NO ADDITIONAL DAMAGE FOUND. HFEC INTERNAL AND EXTERNAL SURFACE IAW NTM 51-10-08. NO SDR FDEA201309232286Skin · damagedDURING ACCOMPLISHMENT OF STRINGER REPAIR AT FR 72 2 EA HOLES HAVE EXCESSIVE PITCH AT STRINGER 41R. ACCOMPLISHED CATEGORY B SKIN REPAIR AT FR 72 STR 41R IAW SRM 53-10-12, FIG 225SH. REPAIR CLASSIFIED AS MAJOR.SDR KCSA201309230089Doubler · crackedCRACK INDICATIONS ON AFT UPPER CORNER STEEL DOUBLER OF R3 MAIN ENTRY DOOR OPENING BS 1319.SDR SWAA2013101421168Skin · crackedWING TO BODY SKIN CORRODED BETWEEN STATION 846 TO STATION 863, STRINGER 28L TO STRINGER 28R. R &R SKIN IAW SRM.SDR SWAA2013100120646Skin · crackedLT NLG STRUT DOOR AFT HINGE CUTOUT CRACKED. REPAIRED SKIN IAW SRM & EA.SDR SWAA2013100120645Skin · crackedRT NLG STRUT DOOR AFT HINGE CUT OUT CRACKED. REPAIRED SKIN IAW SRM & EA.SDR CALA2013092391368Barrel Nut · damagedCREW REPORTS FASTENER LOOSE & HANGING FROM BELLY PANEL 192KB. REPLACED DAMAGED BARREL NUTS & REINSTALLED PANEL IAW AMM 53-35-13-400-002-A.SDR CALA2013092391326Skin · damagedON INITIAL LIGHTNING STRIKE INSPECTION FOUND FOUR STRIKES ALL INDICATING CRACK USING EDDY CURRENT. TWO EACH STRIKES IN RT FWD FUSELAGE RVSM AREA & TWO EACH IN SKIN LAP BELOW DOOR 1R. BLENDED IAW SRM 53-00-11. ACCOMPLISHED HFEC INSPECTION AT BLEND REPAIR ARSDR ASOA20130925377Skin · dentedTHREE DENTS ON LT FUSELAGE SKIN. CUT-OUT DAMAGED SKIN AND INSTALLED TYPE B1 PATCH.SDR ASOA20130925376Skin · dentedTHREE DENTS ON LT FUSELAGE. CUT-OUT DAMAGED SKIN AND INSTALLED TYPE B1 PATCH.SDR ASOA2013102509251Doubler · corrodedMAIN AVIONIC BAY BETWEEN FRAMES 295-310 CORRODED AROUND ANTENNA CONNECTOR AT STR 27 LOCATION. R & R TCAS DOUBLER IAW SRM 51-42-06-001-001 AND 51-42-21-001-001 AND DWG 5H670-32364.SDR FOTR23176NR62511Skin · dentedDENT FOUND ON FUSELAGE SKIN BS 1136 BETWEEN LONGERONS 8 & 9R. REPAIRED.SDR SWAA2013100921031Skin · corrodedSKIN CORRODED BETWEEN BS 314 TO BS 316. REPAIRED SKIN IAW SRM & DRAWING.SDR CALA2013092391373Skin · damagedON INITIAL LIGHTNING STRIKE INSPECTION FOUND FOUR STRIKES ALL INDICATING CRACK USING EDDY CURRENT. TWO EACH STRIKES IN RT FWD FS RVSM AREA & TWO EACH IN SKIN LAP BELOW DOOR 1R. BLENDED IAW SRM. ACP HFEC INSP AT BLEND REPAIR AREA IAW SRM, NO CRACKS INDICATIOSDR FOTR201309260001Skin · dentedREPAIR DENT ON FUSELAGE SKIN AT BS 1136 BETWEEN LONGERONS 8-9R. REPAIRED ON FAS WO 23176, NR 62511.SDR FDEA201309202263Skin · dentedFUSELAGE SKIN DENTED BS 760-780, S15-16L. REPAIRED IAW SRM 53- 00-01 FIG 201 REPAIR 16 REV 109. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100.SDR SWAA2013101821284Skin · crackedFUSELAGE SKIN CRACKED AT LT BS 420+10, LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2013101521219Skin · crackedLT BS 847+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 3,6,7,8. REPAIRED SKIN IAW EA.SDR SWAA2013101521218Skin · crackedLT BS 380+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 5,6,7. REPAIRED SKIN IAW EA.SDR SWAA2013101521217Skin · crackedLT BS 380+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2 - 6. REPAIRED SKIN IAW EA.SDR SWAA2013101421114Skin · crackedLT BS 400+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 4,8. REPAIRED SKIN IAW EA.SDR SWAA2013101421154Skin · crackedLT BS 460+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE 4. REPAIRED SKIN IAW EA.SDR SWAA2013101421153Skin · crackedLT BS 400+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 3 - 6. REPAIRED SKIN IAW EA.SDR UHLA2013092000483Doubler · corrodedCORROSION FOUND ON DOOR CUTOUT DOUBLER. R & R DOUBLER.SDR SWAA2013100820979Skin · crackedLT BS 480+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 3,4,6,7,8. REPAIRED SKIN IAW SB.SDR SWAA2013100820976Skin · crackedLT BS 500B+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1,3,4,5,7,8.. REPAIRED SKIN IAW SB.SDR SWAA2013100820975Skin · crackedLT BS 500+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3 - 8. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720926Skin · crackedRT BS 767+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720925Skin · crackedLT BS 360+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 4-7. REPAIRED SKIN IAW TC.SDR SWAA2013100720896Skin · crackedLT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW EA & TC.SDR SWAA2013100720895Skin · crackedLT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 1,3,5. REPAIRED SKIN IAW SB &TC.SDR SWAA2013100720894Skin · crackedLT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN EA.SDR SWAA2013100720893Skin · crackedLT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720892Skin · crackedLT BS 867+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 3,12. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720891Skin · crackedLT BS 827+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720890Skin · crackedRT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB &TC.SDR SWAA2013100720889Skin · crackedRT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB & TC.
Back to JASC 5330