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 SWAA094707Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA094701Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094700Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR AALA20090730TUL04Frame · damagedTUL - GUSSET AT G5 GALLEY UPPER BAYONET STATION 1287 LEFT SIDE BELOW LONG NUMBER FIVE L HAS FOUR MISDRILLED HOLES. INSTALLED NEW GUSSET AT G5 GALLEY UPPER / BAYONET STATION 1287 LEFT SIDE BELOW LONG NUMBER FIVE L UNDER SRM 51-30-05.SDR AALA20090724TUL23Frame · crackedAFT ACCESS 1497 CANT FRAME CRACKED BELOW RIGHT LOUVER BOX. INSTALLED DOUBLER AND FILLER UNDER AARD 53-10-00-17.SDR AALA20090724TUL20Frame · damagedTUL - UNUSED RIVET HOLES IN FRAME STATION 1287 BETWEEN L4R AND L5R. INSTALLED DOUBLER UNDER SRM 53-03-00.SDR SWAA094685Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094684Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA094683Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA094677Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER ACO.SDR SWAA094676Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER ACO.SDR SWAA094675Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ACO.SDR CALA2009072200386Frame · crackedFRAME CRACKED AT STATION 400 BETWEEN S8L AND S9L AT RIVET ON PSU BRACKET. INSTALLED ANGLE REPAIR PER ECRA 5310-04980.SDR AALA20090721TUL14Frame · crackedFRAME CRACKED AT RAIL BRACKET. INSTALLED REPAIR PER ECO J1159AC.SDR AALA20090721TUL13Frame · crackedFRAME CRACKED AT RAIL BRACKET. INSTALLED REPAIR PER ECO J1159AC.SDR AALA20090721TUL10Frame · crackedFRAME CRACKED AT RAIL BRACKET. INSTALLED REPAIR PER ECO J1159AC.SDR AALA20090721TUL09Frame · crackedFRAME CRACKED AT RAIL BRACKET. INSTALLED REPAIR PER ECO J1159AC.SDR AALA20090721TUL08Frame · crackedFRAME CRACKED AT RAIL BRACKET. INSTALLED REPAIR PER ECO J1159AC.SDR USAA2009081992180Frame · corrodedMCN - C22 - MAJOR REPAIR - CORROSION ON FUSELAGE FRAME AT BS 847, WL 146, RBL 25. REPLACED FUSELAGE FRAME AT BS 847 BETWEEN S17R TO S26R, WL 146, RBL 25 IAW B737 SRM 51-40-02-08.SDR CA090723007Frame · cracked(CAN) DURING FUSELAGE DETAILED INSP, THERE WAS A CRACK NOTED AT THE LWR END OF FRAME 207.125 WHERE A RELIEF HAD BEN CUT OUT FOR A STR DURING MFG. THE CRACK PROPOGATED FROM THE RADIUS OF THE RELIEF. REPAIR WAS CONDUCTED IAW WITH SIRM INSTRUCTIONS.SDR C2XA09SH207Fitting · corrodedSHV - DURING C-CHECK CORROSION FOUND AT FRAME 65 CLIP. MAINTENANCE PERFORMED AND COMPLETED REPAIR TO FRAME CLIP AT FR 65 IAW EC5330-01458 ORIG. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH205Rivet · looseSHV - DURING C-CHECK 3 WORKING RIVETS FOUND AT FRAME 79 STRINGER 3R-6R. MAINTENANCE REMOVED AND REPLACED RIVETS AT FRAME 79 STRINGER 3R-6R IAW EC5330-01941 ORIG. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR FDEA200907202672Frame · crackedAIR CONDIT COMPT NR 2 LT/1LT FOUND CRACK ON FWD JAMB FRAME. REPAIRED FRAME IAW SRM 53-00-01 VOL I FIG 8.SDR SWAA094577Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 807, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA094564Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 291.5, RT 6 HOLES DOWN FROM THE TOP. REPAIRED FRAME PER EA.SDR CALA2009072100379Frame · crackedBELT FRAME CRACKED AT FASTENER HOLE STATION 827 AND STR 8R. REMOVED DAMAGED MATERIAL, INSTALLED REPAIR DOUBLERS "A" AND "B" PER ECRA5310-04980.SDR USAA2009082692255Frame · crackedMCN - C22 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 794.3 BETWEEN S19R & S20R. REPAIRED FUSELAGE FRAME AT BS 794.3 BETWEEN S19R & S20R IAW EA 130294.SDR AALA20090723TUL19Frame · corrodedCORROSION ON AFT SIDE OF FRAME 1250 L27L-L28R. REMOVED CORROSION AND INSTALLED J-ANGLE. REPAIRED UNDER AARD 53-10-00-14.SDR COMA2009072050168Frame · crackedFS 640 FRAME CRACKED RT SIDE. REPAIRED PER REO 601R-53-61-506 AND REO 601R-53-61-569.SDR C2XA09SH202Frame · corrodedDURING C-CHECK SERVICE DOOR CUT-OUT LWR NUT PLATE HOLE AT FRAME 22 HAS CORROSION. MX REPAIRED SERVICE DOOR CUT-OUT LOWER NUT PLATE HOLE AT FRAME 22 IAW EC5310-01373. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR USAA2009072791916Frame · crackedCLT - Q-4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME LOWER INBOARD FLANGE AT BS 601, S17R. REPAIRED FUSELAGE FRAME LOWER INBOARD FLANGE AT BS 601, S17R IAW US AIRWAYS EA 101272.SDR AALA20090723TUL25Frame · corrodedCORROSION AFT SIDE OF FRAME LONGERON 28L-27R STATION 1271. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-14.SDR ASOA200900798Frame · crackedFS 559.00 FRAME CAP ANGLE BEND RADIUS CRACKED AT LBL 18.00 AND RBL 18.00. COMPLIED WITH EC/TC 601R-53-41-260 AND EC/TC REO 601R-53-41-1023 FOR REPAIR. REFER TO WORK ORDER 124177 EC/TC 601R-53-41-260, EC/TC REO 601R-53-41-1023, EC/TC ISEIL 0907231445 AND THESDR ASOA200900797Frame · corrodedFRAME BACK FOR FLOOR AT FS 319.7 STR 18 CORRODED. REMOVED OUTBOARD SEAL PLATE AT FRAME IAW SRM 51-42-06, 51-42-21. REMOVED THE CORRODED RT BRACKET IAW SRM 51-42-21. LOCATED AND INSTALLED NEW SERVICEABLE RT BRACKET IAW SRM 51-42-21. REINSTALLED OUTBOARD RT SDR ASOA200900789Frame · corrodedRT 280 FRAME HAS MULTIPLE AREAS OF CORROSION. REPAIRED IAW ALL APPLICABLE SRM INFORMATION.SDR ASOA200900788Frame · corrodedLT 280 FRAME HAS MULTIPLE AREAS OF CORROSION. REMOVED & REPLACED LT 280 FRAME , DOUBLERS, & T-BRACKET.SDR FDEA200907172650Frame · damagedFOUND ON FRAME C69, P 49 AREA TOOLING MARKS. REPAIR PERFORMED BY REPLACEMENT OF PART IAW. SRM 51-72-10SDR USAA2009072791913Frame · crackedCLT - Q-4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500D BETWEEN S20L & S21L. REPAIRED FUSELAGE FRAME AT BS 500D BETWEEN S20L & S21L IAW B737 SRM 53-00-07 REPAIR 13 & US AIRWAYS EA 101281.SDR AALA20090723TUL22Frame · corrodedCORROSION ON LOWER AFT FLANGE OF FRAME 1231 28L-27R. REPAIRED IN ACCORDANCE WITH AARD 53-10-00-14 FIG 1.SDR USAA2009071791872Frame · crackedCLT - Q4 - MAJOR REPAIR - NR 03C10753006/001 - CRACK ON FUSELAGE FRAME WEB AT BS277, S14R. REPLACED FUSELAGE FRAME WEB AT BS277, S14R IAW B737 SRM 52-10-02.SDR K11A2009071672301Frame · corrodedLOWER NOSE W/W T-CHORD BELOW STRINGER HAS AREAS OF CORROSION, 2X2 INCH CORROSION.SDR ASAA0946240Frame · corrodedAFT PIT FRAME CORRODED STA 787 BETWEEN 26L AND 25L. CUT OUT DAMAGED AREA, RECEIVED PART FROM HEAT TREAT, LOCATED, DRILLED, PRIMED, TOP COATED AND INSTALLED FRAME CHANNEL REPAIR.SDR ASAA0946239Frame · corrodedAFT PIT FRAME STA 807 CORRODED BETWEEN 26L AND 25L. CUT OUT DAMAGED AREA, RECEIVED PART FROM HEAT TREAT, LOCATED, DRILLED, PRIMED, TOP COATED AND INSTALLED FRAME CHANNEL REPAIR.SDR USAA2009071691843Frame · crackedCLT - Q-4 - MAJOR REPAIR - NR 03C20853011/007 - CRACK ON FUSELAGE FRAME AT BS540 BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS540 BETWEEN S20L TO S21L IAW B737 SRM 53-00-07.SDR FDEA200907152624Frame · crackedFOUND IN UPPER FRAME FOOT C 42 LT AFTER FASTENER REMOVAL A CRACK. REPAIR PERFORMED BY OVERSIZING THE HOLE UNTIL CRACK REMOVAL IAW. RAS 018309/010/2009 ISSA. , APPROVED BY EA 6-5310-131257.SDR ASAA0946302Frame · crackedFWD CABIN FRAME STA 440 CRACKED AT FASTENER ABOVE STR 9R. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLERS IAW EA.SDR ASAA0946299Frame · crackedAFT CABIN FRAME STA 747 CRACKED AT FASTENER ABOVE STR 9L. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLERS IAW EA.SDR ASAA0946298Frame · crackedFWD CABIN FRAME STA 380 CRACKED AT FASTENER ABOVE STR 9R. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLERS IAW EA.SDR SWAA094483Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA094475Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311