JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 IPXA2M74082Frame · dentedINSPECTION TYPE:4C MAIN CABIN STA.735 FRAME DENTED BETWEEN L12R & L13R REPAIRED STA 735, FRAME IAW STASA EA 011-5310-01-A3982 REV IR & EO MD11-5310-47649-A.SDR IPXA2M74080Frame · dentedINSPECTION TYPE:4C, MAIN CABIN STA 675 FRAME DENTED BETWEEN L12R & L13R REPAIRED STA 675, FRAME IAW STASA EA 011-5310-01-A3977, REV IR & EO MD11-5310-47644-A.SDR AALA20120613019Frame · crackedFRAME CRACKED AT BRACKET STATION 480. REMOVED DAMAGE AND INSTALLED DOUBLER/TRIPLER PER ECO J1159AD.SDR FDEA201205302010Frame · deformedFRAME 60 S13 - 14R DEFORMED. REPAIRED THE FRAME IAW SRM 53-10-13-201, PARA 5.SDR FDEA201205302009Frame · deformedFRAME 74 S11 - 12R DEFORMED. REPAIRED THE FRAME IAW SRM 53-10-13-201, PARA 5.SDR FDEA201205302008Frame · chafedFRAME 58 CHAFED & DISTORTED B/W S12-13 L. REPAIRED THE FRAME IAW SRM 53-10-13-201, PARA 5.SDR ASAA12911643Frame · dentedFORWARD CARGO COMPARTMENT AT BS 500J AND STR 25R, STR 24R FRAME DENTED. ACFT GROUNDED. REPAIRED FRAME REF REO G14960, REV A AND ASA EA 900-53EA-08122, REV NEW "FRAME" AT STA 500J BETWEEN STR 24R, 25R, REPAIR.SDR DALA1234670671Frame · dentedAFT CARGO BAY FRAME DENTED BS 1300, STRINGER 26R. REPAIRED IAW ERA 501941-14 REV ORIG.SDR DALA12000596305Floorbeam · crackedDURING INSPECTION FOUND MAIN DECK CABIN FLOORBEAM WEB CRACKED AT BS 1220 AND RBL 109. MAINTENANCE REMOVED AND REPLACED MAIN DECK CABIN FLOORBEAM WEB PER WORKCARD 5313-01014-02H.SDR CHQA20120529188Frame · crackedDURING INSPECTION, FRAME 23 WAS FOUND TO BE CRACKED AT THE RIGHT SILL. A SPLICE REPAIR PART WAS FABRICATED AND THE DAMAGED SECTION ON FRAME 23 WAS REPLACED IN ACCORDANCE WITH ETD2012-145-007840.SDR USAA2012053100009Strap · crackedC6 CHECK - CRACK IN FAILSAFE STRAP ON FRAME AT BS 847, S26R. REPAIRED FAILSAFE STRAP ON FRAME AT BS 847, S26R IAW EA 103984.SDR DALA12000556305Frame · crackedDURING INSPECTION FOUND CRACK AT RIGHT SIDE TENSION TIES BS 1180 ON TOP FASTENER ROW, 5TH FASTENER HOLE FROM OUTBOARD LOOKING FORWARD. MAINTENANCE REPAIRED PER SRM 53-40-30 REPAIR 1 FIG 201.SDR CALA2012052900378Frame · crackedFRAME 440R HAS A CRACK REPAIRED IAW EA 5310-04716, REV C.SDR CALA2012052900377Frame · crackedFRAME 380L HAS A CRACK. INSTALLED FRAME REPAIR DOUBLERS AT STA 380L IAW EA 5310-04716, REV C.SDR CALA2012052900376Frame · crackedFRAME 867R HAS A CRACK. INSTALLED REPAIR ANGLES IAW EA 5310-04716 REV C.SDR CALA2012052900375Frame · crackedFRAME 480L HAS A CRACK. REPAIRED IAW EA 5310-0416 REV C.SDR CALA2012052900374Frame · crackedFRAME 440L, CRACKED, REPAIRED IAW EA5310-04716 REV C.SDR CALA2012052900370Frame · crackedFUSELAGE FRAME RT CRACKED STA 827, BETWEEN STR 8 & AMP; 9. SEE WIPS, ATTACHED FORMS 44.0008 AND HEAT TREAT FORMS 43.0150. TRIMMED OUT DAMAGED AREA AND INSTALLED REPAIR DOUBLERS REF ECRA 5311-01550.SDR SWAA2012061805025Frame · corrodedFRAME CORRODED AT BS 360, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW EA.SDR SWAA2012061504979Frame · crackedFRAME CRACKED AT BS 188, STR 17R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR UALA2012052903012Frame · corrodedAFT CARGO FRAME 65, STR 31R, CORRODED BELOW OUTFLOW VALVE. REMOVED AND REPLACED STR 31 RT FROM FRAME 64 TO 67 BELOW OUTFLOW VALVE IAW SRM 51-42-11.SDR DALA12000576305Frame · crackedDURING INSPECTION FOUND CRACK AT RIGHT SIDE TENSION TIE STA1160 ON LOWEST FASTENER ROW, 1ST FASTENER HOLE FROM OUTBOARD LOOKING FORWARD. MAINTENANCE REMOVED AND REPLACED CRACKED STRINGER CLIP AS PER B747-400 SRM 51-40-02. NEW STRINGER CLIP, P/N 65B04174-44, SDR DALA12000426305Frame · crackedDURING INSPECTION, FOUND CABIN UPPER LOBE TENSION TIES AREA BS 1160 STINGER-9L FRAME WEB AT STRINGER CUTOUT CRACKED. MAINTENANCE REMOVED AND REPLACED CRACKED FRAME WEB WITH NEW WEB AS PER SRM 53-40-07 REPAIR 3 FIG 201 AND 51-40-02.SDR DALA12000566305Frame · crackedDURING INSPECTION FOUND CABIN UPPER LOBE TENSION TIES AREA BS 1140 STRINGER-10L. FOUND FRAME WEB AT STRINGER CUTOUT CRACKED. MAINTENANCE REPAIR CARRIED OUT AS PER SRM 53-40-07 REPAIR 2 FIG 20.SDR DALA12000536305Frame · crackedDURING INSPECTION FOUND CRACK AT LEFT SIDE TENSION TIE AT BS 1180 ON TOP FASTENER ROW, 5TH FASTENER HOLE FROM OUTBOARD LOOKING FORWARD. MAINTENANCE REPAIRED AS PER SRM 53-40-30 REPAIR 1 FIG 201.SDR DALA12000386305Frame · crackedDURING INSPECTION, FOUND CABIN UPPER LOBE TENSION TIES AREA BS 1200 STRINGER-9L FRAME WEB AT STRINGER CUTOUT CRACKED. MAINTENANCE REMOVED AND REPLACED CRACKED DOUBLER FRAME AT CABIN UPPER LOBE TENSION TIES AREA BS 1200 STRINGER-9L WITH NEW DOUBLER FRAME AS PSDR DALA12000376305Frame · crackedDURING INSPECTION FOUND CABIN UPPER LOBE TENSION TIES AREA BS 1120 STRINGER-11R FRAME WEB AT STRINGER CUTOUT CRACKED. MAINTENANCE REPAIRED FRAME PER SRM 53-40-07 REPAIR 1 FIG 201.SDR DALA12000346305Frame · crackedDURING INSPECTION, FOUND CABIN UPPER LOBE TENSION TIES AREA BS 1180 STRINGER-9L, FOUND FRAME WEB AT STRINGER CUTOUT CRACKED. MAINTENANCE REMOVED CRACKED FRAME DOUBLER AND FABRICATED NEW DOUBLER PER P/N: 65B26275-3 AS PER DWG65B26275. REFER TO SMALL CONTROLSDR DALA14028720671Frame · corrodedFUSELAGE FRAME BS 1460, S29-30R CORRODED.SDR DALA1239900679Frame · chafedFRAME CHAFED IN PASSENGER CABIN AT FS 1640, JUST ABOVE R4 DOOR CUTOUT. COMPLIED WITH ERA 504281-14 REV ORIGINAL.SDR SWAA2012061905087Frame · corrodedFRAME CORRODED AT BS 807, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012061905070Frame · crackedFRAME CRACKED AT BS 947.5, STR 25R. REPAIRED FRAME IAW EA AND EO.SDR SWAA2012061805055Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012061805054Frame · corrodedFRAME CORRODED AT BS 947.5, BETWEEN STR 26R TO STR 27L. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR SWAA2012061805053Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STR 24R TO STR 25R. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR SWAA2012061504991Frame · corrodedFRAME CORRODED AT BS 807, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012061504978Frame · corrodedFRAME CORRODED AT BS 807, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA2012061504958Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME IAW SRM.SDR SWAA2012061504957Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012061504956Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STR 26L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012061404934Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA2012061404933Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 26L TO STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA2012061905077Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STR 21L TO STR 22L. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012061805052Frame · corrodedFRAME CORRODED AT BS 727C, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012061805049Frame · corrodedFRAME CORRODED AT BS 497.5, BETWEEN STR 25R TO STR 26R. REMOVED AND REPLACED FRAME PER SRM.SDR AALA20120615011Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET STATION 440L. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120615010Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET STATION 480L. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120615009Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET STATION 400L. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR SWAA2012061404931Frame · corrodedFRAME CORRODED AT BS 927, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME IAW SRM.SDR ASAA12411609Frame · crackedBS 639 STUB BEAM LOWER INNER CHORD CRACKED COMMON TO THE LOWEST FASTENER HOLE. ACFT GROUNDED. REPAIRED INNER CHORD IAW ASA T/C AD20102506-400-53-9.
Back to JASC 5311