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 ASAA0995099Frame · corrodedCORROSION FWD CARGO BAY FRAME 500I AT STRINGER 25L. REPAIRED PER EA 900-53EA-01172.SDR SWAA092376Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 616, LBL 64. REPAIRED FRAME PER ER.SDR FDEA200904131280Frame · dentedCABIN, LT STA 1741 LONGERON 12 FRAME FOUND DENT. REPAIRED AS PER SRM 53-30-00 FIG. I VOL. I REV 40. REPETITIVE INSPECTION REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00 FIG. I VOL. I REV. 40SDR FDEA200904131279Frame · dentedCABIN, RT STA 1641 LONGERON 12 FRAME FOUND DENT. REPAIRED AS PER SRM 53-30-00 FIG. I VOL. I REV 40. REPETITIVE INSPECTION REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00 FIG. I VOL. I REV. 4SDR ASAA0945425Frame · corrodedFWD FRAME STA 500A CORRODED BETWEEN STR 28L 28L. REMOVED DAMAGED SECTION OF FRAME, FABRICATED, TREATED, PRIMED, TOP COATED AND INSTALLED DOUBLER AND TRIPLER IAW ASA EA 400 53 EA 01205.SDR USAA2009042390962Frame · crackedSAL - C19 - MAJOR REPAIR - CRACK ON UPPER FRAME FLANGE AT BS 344.2 BETWEEN S23L TO S24L. REPAIRED UPPER FRAME FLANGE AT BS 344.2 BETWEEN S23L TO S24L IAW B737 SRM 51-70-11.SDR DLM88090663Frame · corrodedFRAME CORRODED IN AFT PIT STA 1098 L29L-L30. REMOVED AND REPLACED FRAME IAW SRM 51-30-5.SDR DLM88090661Frame · corrodedCORROSION ON FRAME AT FASTENER HOLES STA 1041 29L-30. REMOVED AND REPLACED FRAME STA 1041 L18L TO L18R IAW SRM 51-30-5 AND 51-30-2.SDR ASAA0945113Frame · dentedFRAME DENTED STA 727C BETWEEN STR 24 25R. CUT OUT DAMAGE, FABRICATED AND INSTALLED ANGLE IAW B737 400 SRM 51 70 11.SDR SWAA092362Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, STR 13L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA092361Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA092360Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA092357Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092350Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 887, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092349Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092348Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 727E, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092347Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092346Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092337Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 270, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092334Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092333Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092332Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092331Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092330Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092329Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092328Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092327Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092326Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092325Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092324Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092312Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS BS 867, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092311Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 727B, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092310Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 597, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092323Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092322Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092314Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME WEB CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR ASAA0945314Frame · corrodedAFT PIT FRAME 787 CORRODED BETWEEN STR 26R 27R. REMOVED DAMAGED AREA, FABRICATED, TREATED, PRIMED, TOP COATED AND INSTALLED SHEAR TIE FRAME REPAIR IAW B737 400 SRM 53 00 07.SDR C2XA09SH109Frame · corrodedSHV-DURING C-CHECK CORROSION AROUND RIVETS AT FR 61 STR 16L-15L. MAINTENANCE REMOVED CORROSION IAW EMB-145 CPM 51-21-04 AND CPM 51-21-05. MAINTENACE COMPLETED INSTALLATION OF CARBON SUPPORT DOUBLER AT FR 61 IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVESDR IPXA09555779Frame · dentedINSPECTION TYPE:C DENT AT BULK CARGO COMPARTMENT FUSELAGE FRAME STA 1480, BETWEEN S-26R + S-27R. DENT AT STA 1480 FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A FIG 101. REMOVED TRANSIT PANEL IAW 51-40-02. CUT OUT DAMAGE IAW SRM 53-00-07-2R5. HFEC AT CUTOUTSDR IPXA09555760Frame · dentedINSPECTION TYPE:C DENT AT BULK CARGO COMPARTMENT FUSELAGE FRAME STA 1520, S23L. DENT AT STA 1520 FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A FIG 101. REMOVED CLIP IAW SRM 51-40-02. CUT OUT DAMAGE IAW SRM 53-00-07-2R5. HFEC AT CUTOUT IAW NTM51-00-19PT6, NSDR IPXA09555759Frame · dentedINSPECTION TYPE:C DENT AT BULK CARGO COMPARTMENT FUSELAGE FRAME STA 1500, S-25R TO S- 27R. DENT AT STA 1500 FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A FIG 101. CUT OUT DAMAGE IAW 53-00-07-2R5. HFEC AT CUTOUT + HOLES IAW NTM51- 00-19PT6, NO CRACKS FOUND. SDR IPXA09555758Frame · dentedINSPECTION TYPE:C DENT AT BULK CARGO COMPARTMENT FUSELAGE FRAME STA 1500, S-25R+S-26R. DENT AT STA 1500 FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A FIG 101. CUT OUT DAMAGE IAW SRM 53-00-07-2R5. HFEC AT CUTOUT + HOLES IAW 757 NTM 51-00-19PT6. FAB PARTS ONSDR IPXA09555754Frame · dentedINSPECTION TYPE:C DENT AT BULK CARGO COMPARTMENT FUSELAGE FRAME, STA1500, S-25L. DENT AT STA 1500 WAS FOUND TO BE OUT OF LIMITS PER SRM 53-00-07-1A FIG 101. REMOVED SPLICE IAW SRM 53-40-02 AND EA757-5362-27-A1862. CUT OUT DAMAGE AREA IAW EA757-5362-27-A1862SDR IPXA09555753Frame · dentedINSPECTION TYPE:C DENT AT BULK CARGO COMPARTMENT FUSELAGE FRAME STA 1500, S25L &26L. DENT FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A FIG 101 SHT 1. REMOVED 2 STRINGER CLIPS STA 1500 LT S25L & 26L IAW SRM 53-40-02. CUT OUT DENT AREA IAW EA 757-53-A1862. SDR IPXA09555761Frame · dentedINSPECTION TYPE:C DENT AT BULK CARGO COMPARTMENT FUSELAGE FRAME STA 1520, S-25L + S-26L. DENT AT STA 1520 FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A FIG 101. CUT OUT DAMAGE IAW SRM 53-00-07-2R5. HFEC AT CUT OUT IAW NTM51 -00-19PT6, NO CRACKS FOUND. FAB SDR CALA2009040900185Frame · crackedFRAME CRACKED STA 400 BETWEEN S8L AND S9L. REPAIRED PER ECRA 5310-04926, DIP GENERATED ON L/P 9705989 - 53 -DIP CNT NR 09354.SDR CALA2009040900184Frame · crackedFRAME REPAIR AT PSU RAIL STA 480 DOES NOT EXTEND FAR ENOUGH PER L/P 9705631. REPAIRED PER ECRA 5310-04926, DIP GENERATED ON L/P 9705989 CNT NR 09354.SDR CALA2009040900183Frame · crackedFRAME CRACKED STA 400 BETWEEN S-8-RT AND S-9-RT. REPAIRED PER ECRA 5310-04926, DIP GENERATED ON L/P 9705989 - 53 -DIP CNT 09354.SDR AALA20090422TUL07Frame · crackedAFT ACCESSORY LEFT SIDE CANTED FRAME 1463 HAS A CRACKED DOUBLER AT LONGERON 18L. INSTALLED DOUBLER PER SRM 53-01-00 FIGURE 2, SHEET 4 AND AARD 51-00-00-014.SDR IPXA09M55557Frame · corrodedINSPECTION TYPE:C REFERENCE TO NRC MD037457, TO CARRY OUT FRAME TRIM OFF TO FACILITATE REMOVAL OF CORRODED LONGERONS 52 AT STA 959-979. FRAME AT STA 1039 TRIM-OUT BETWEEN L52-L51R. HFEC INSPECTION C/O ON TRIM-OUT AREA, FOUND NO CRACK EVDNT. REPAIR LOWER FRA
Back to JASC 5311