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 SWAA100687Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR SWAA100686Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER EA.SDR SWAA100663Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 787, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR FOTR20006NR1842Frame · dentedMAIN CABIN FRAME BS 280 FLANGE IS DENTED AT STR 6R. REPAIRED ON FASI W/ONR 20006, NR 01842. INTALLED REPAIR DOUBLER TO FRAME AT BS 380, STR 6R, DUE TO DENT, IAW B727 SRM 53-10-2 FIG 3 AND 53-10-4 FIG 2, REV 102. MATERIAL USED: DOUBLER 7075-O, HEAT TREATED TSDR FOTR20006NR1841Frame · dentedMAIN CABIN FRAME BS.400 FLANGE IS DENTED AT STR 6R. REPAIRED ON FASI W/O 20006,NR 01841 INSTALLED REPAIR DOUBLER TO FRAME AT BS 400, STR 6R, DUE TO DENT, IAW SRM 53-10-2 FIG 3 AND 53-10-4 FIG 2, REV 102. MATERIAL USED: DOUBLER 7075-O, HEAT TREATED TO T6 CONDISDR ASAA1047461Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE AT 747. REPAIRED FRAMES, INSTALLED REINFORCEMENT ANGLES.SDR ASAA1047460Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE AT BS 727D. REPAIRED FRAMES, INSTALLED REINFORCEMENT ANGLES.SDR ASAA1047459Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE AT 787. CUT OUT CRACK AND REPAIRED WITH DOUBLERS.SDR ASAA1047458Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE AT 867. CUT OUT CRACK AND REPAIRED WITH DOUBLERS.SDR ASAA1047457Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE. CUT OUT CRACK AND REPAIRED WITH DOUBLERS.SDR ASAA1047456Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE BS 400. CUT OUT CRACK AND REPAIRED WITH DOUBLERS.SDR ASAA1047455Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE BS 500A. CUT OUT CRACK AND REPAIRED WITH DOUBLERS.SDR ASAA1047454Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE BS 827. CUT OUT CRACK AND REPAIRED WITH DOUBLERS.SDR ASAA1047453Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE BS 747. CUT OUT CRACK AND REPAIRED WITH DOUBLERS.SDR DL76G100427Failsafe · corrodedWHILE ACCOMPLISHING INSPECTIONS OF THE FS955 REAR SPAR BULKHEAD SIDEFRAME AND FAILSAFE STRAP FOR AND CORROSION AND FATIQUE CRACKS IAW DAL DI 01-086393-12-AD ON 2/2/10, A CRACK INDICATION AND CORROSION WERE FOUND ON THE LT SIDE FAILSAFE STRAP AND CORROSION ON TSDR UALA2010020300431Frame · crackedFOUND LT BS 1265 FRAME WEB & INTERCOSTAL CRACKED AT THE NR 1 FASTENER HOLE. MAJOR REPAIR ACCOMPLISHED: REPLACED THE FRAME CHORD, FRAME WEB, INTERCOSTAL WEB & CHORD.SDR DL76G100428Failsafe · corrodedWHILE ACCOMPLISHING INSPECTIONS OF FS955 REAR SPAR BULKHEAD SIDE FRAME AND FAILSAFE STRAP FOR CORROSION AND FATIGUE CRACKS IAW S.I. 01-086393-12AD, A CRACK INDICATION AND CORROSION WERE FOUND ON THE RT SIDE FAILSAFE STRAP AND CORROSION WAS FOUND ON THE SKIN.SDR SWAA100628Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 559, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SRM.SDR DALA102609876Frame · crackedDURING "H" CHECK FOUND CRACK IN FRAME AT BS 465 L26R. REPAIRED IAW 53-03-02 AND SRM 51-30-05.SDR CALA2010020200023Frame · crackedFRAME CRACKED AT STA 440 LEFT SIDE WHERE PSU RAIL TIES TO FRAME. INSTALLED FRAME REPAIR AND NEW MODIFIED SUPPORT FITTING REF ECRA 5310-05094 PART B AND C.SDR CALA2010020200022Frame · crackedFRAME CRACKED AT STA 400 LEFT SIDE WHERE PSU RAIL TIES TO FRAME. INSTALLED FRAME REPAIR AND NEW MODIFIED SUPPORT FITTING REF ECRA 5310-05094 PART B AND C.SDR CALA2010020200024Frame · crackedFRAME CRACKED AT STA 480 RIGHT SIDE WHERE PSU RAIL TIES TO FRAME. INSTALLED FRAME REPAIR AND NEW MODIFIED SUPPORT FITTING REF ECRA 5310-05094 PART B AND C.SDR FOTR20006NR5443Frame · puncturedAFT PIT FRAME PUNCTURED STR 27L BS 1130. REPAIRED ON FASI WO 20006, N/R 05443. REPAIRED AFT CARGO COMPARTMENT FRAME AT STR 27L, STA 1130 IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: ANGLE DOUBLER; 7075-T6, 0.063, DIM: 12.25 BY 4.125SDR FOTR20006NR5604Frame · dentedFWD CARGO COPT FRAME 720A HAS 2 DENTS IN THE UPPER FLANGE BETWEEN STR 24L-25L. REPAIRED ON FASI WO20006. N/R 05604- REPAIRED FRAME AT STA 720A BETWEEN STR 24L AND 25L IAW SRM 51-30-2 AND 51-40-3 FIG. 1, REV 102. MATERIAL USED: DOUBLER; 7075-T6, 0.050", DIM: 3SDR FOTR20006NR5600Frame · dentedFWD CARGO COMPT FRAME BS 680 UPPER FLANGE IS DENTED AND WEB IS BENT BETWEEN STR 23L-24L. REPAIRED ON FASI WO20006. N/R 05600- REPAIRED FRAME AT STA 680 BETWEEN STR 23L AND 24L IAW B727 SRM 53-10-2 FIG. 3 AND 51-40-3 FIG. 1, REV. 102. MATERIAL USED: DOUBLER; 70SDR FOTR20006NR5599Frame · dentedFWD CARGO COMPT FRAME BS 680 HAS 4 DENTS IN THE UPPER FLANGE BETWEEN STR 23R-25R, WEB IS BENT. REPAIRED ON FASI WO20006, N/R 05599. REPAIRED FRAME AT STA 680 BETWEEN STR 23R AND 25R IAW B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLSDR FOTR20006NR5598Frame · dentedFWD CARGO COMPT FRAME BS 660 HAS 4 DENTS IN THE UPPER FLANGE BETWEEN STR 23R-25R. REPAIRED ON FASI WO20006, N/R 05598. REPAIRED FRAME AT STA 660 BETWEEN STR 23R AND 25R IAW B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER; 7075-T6, SDR FOTR20006NR5586Frame · dentedFWD CARGO COMPT, FRAME BS 520 HAS 2 DENTS IN UPPER FLANGE ABOVE STR 24R. REPAIRED ON FASI WO20006, N/R 05586. REPAIRED FRAME AT STA 520 BETWEEN STR 23R AND 24R IAW B727 SRM 51-30-5 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER; 7075-T6, 0.050, DIM: 13.SDR FOTR20006NR5585Frame · dentedFWD CARGO COMPT FRAME BS 500 HAS DENT IN UPPER FLANGE ABOVE STR 23R. REPAIRED ON FASI WO20006, N/R 05585. REPAIRED FRAME AT STA 500 BETWEEN STR 22R AND 23R IAW B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER; 7075-T6, 0.063, DIM: 9SDR FOTR20006NR5562Frame · dentedAFT PIT FRAME DENTED AT BS 1030 JUST ABOVE STR 27L. REPAIRED ON FASI WO20006 N/R 05562. REPAIRED FRAME AT STA 1030 BETWEEN STR 26L AND 27L IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER; 7075-T6, 0.063, DIM: 11.50 BY 4.20. CUSDR FOTR20006NR5554Frame · dentedAFT PIT FRAME IS DENTED AT BS 950C BETWEEN ST 25L-26L. REPAIRED ON FASI WO20006, N/R 05554. REPAIRED AFT CARGO COMPARTMENT FRAME AT STA 950C BETWEEN STR 25L AND 26L IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER; 7075-T6, 0.06SDR FOTR20006NR5548Frame · damagedSTA 970 FRAME DOUBLER DRILLED BELOW STR 7R. REPAIRED ON FASI WO20006 N/R 05548. REPAIRED FRAME AT STA 970 BETWEEN STR 7R AND 8R IAW B727 SRM 53-10-2 FIG 5 AND 53-10-4 FIG 2, REV 102. MATERIAL USED: DOUBLER; 7075-T6, 0.063, DIM: 8.0 BY 3.375. CUT OUT DIM: 1SDR FOTR20006NR5542Frame · damagedSTA 950F RIVET HEAD NOT FLUSH STR 7R, REPAIRED ON FASI WO20006, N/R 05542. REPAIRED FRAME AT STA 950F STR 7R IAW B727 SRM 53-10-2 FIG 5 AND 53-10-4 FIG 2, REV 102. MATERIAL USED: DOUBLER; 7075-T6, 0.071, DIM: 11.750 BY 3.50, FILLER; 7075-T6, 0.071, DIM: 2.75SDR FOTR20006NR5501Frame · damagedMISDRILLED HOLE ON UPPER FLANGE OF BS 1070 FRAME BETWEEN STR 27R-28R. REPAIRED ON FASI WO NR 20006, N/R 05501. REPAIRED FRAME AT STA 1070 BETWEEN STR 27R AND 28R IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER; 7075-T6, 0.063, SDR FOTR20006NR5500Frame · damaged2 MISDRILLED HOLES ON UPPER FLANGE OF BS 1090 FRAME BETWEEN STR 27R-28R. REPAIRED ON FASI WO NR 20006, N/R 05500. REPAIRED FRAME AT STA 1090 BETWEEN STR 27R AND 28R IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER; 7075-T6, 0.06SDR FOTR20006NR5499Frame · damaged2 MISDRILLED HOLES ON UPPER FLANGE OF BS 1110 FRAME BETWEEN STR 27R-28R. REPAIRED ON FASI WO NR 20006, N/R 05499. REPAIRED FRAME AT STA 1110 BETWEEN STR 27R AND 28R IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER; 7075-T6, 0.06SDR FOTR20006NR5498Frame · damagedMISDRILLED HOLE ON UPPER FLANGE OF BS 1130 FRAME BETWEEN STR 27R-28R. REPAIRED ON FASI WO NR 20006, N/R 05498. REPAIRED FRAME AT STA 1130 BETWEEN STR 27R AND 28R IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER; 7075-T6, 0.063, SDR FOTR20006NR5495Frame · damagedMISDRILLED HOLE ON UPPER FLANGE OF BS 1050 FRAME BETWEEN STR 27L-28L. REPAIRED ON FASI WO NR 20006, N/R 05495. REPAIRED FRAME AT STA 1050 BETWEEN STR 27L AND 28L IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER; 7075-T6, 0.063, SDR FOTR20006NR5460Frame · dentedAFT PIT FRAME BS 1090 IS DENTED, JUST ABOVE STR 26L. REPAIRED ON FASI WO NR 20006 N/R 05460. REPAIRED AFT CARGO COMPARTMENT FRAME AT STA 1090 BETWEEN STR 25L AND 26L IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER; 7075-T6, 0.SDR FOTR20006NR5458Frame · dentedAFT PIT HAS FRAME DENTED AT BS 1010 BETWEEN STR 26L AND 25L. REPAIRED ON FASI WO NR 20006 N/R 05458. REPAIRED AFT CARGO COMPARTMENT FRAME AT STA 1010 BETWEEN STR 25L AND 26L IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER; 7075SDR FOTR20006NR5457Frame · dentedAFT PIT HAS FRAME DENTED AT BS 970 BETWEEN STR 26L AND 25L. REPAIRED ON FASI WO NR 20006, N/R 05457. REPAIRED AFT CARGO COMPARTMENT FRAME AT STA 970 BETWEEN STR 25L AND 26L IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER; 7075-SDR FOTR20006NR5451Frame · dentedAFT PIT RT FRAME BS 950C IS DENTED, BETWEEN STR 26R AND SR 25R. REPAIRED ON FASI W/O NR 20006, N/R 05451. REPAIRED AFT CARGO COMPARTMENT FRAME AT STA 950C BETWEEN STR 25R AND 26R IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1, REV 102. MATERIAL USED: DOUBLER;SDR FOTR20006NR5450Frame · dentedUPPER FLANGE OF AFT PIT FRAME DENTED AT BS950F STR 25L-27L. REPAIRED ON FASI W/O 20006 REPAIRED AFT CARGO COMPARTMENT FRAME AT STA 950F BETWEEN STR 25L AND 27L IAW SRM 53-10-2 FIG. 5 AND 51-40-3 FIG. 1, REV. 102. MATERIAL USED: DOUBLER; 7075-T6, 0.063, DIM: SDR ASAA1047452Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE. CUT OUT CRACK AND REPAIRED WITH DOUBLERS.SDR ASAA1047348Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE AT BS 400 JUST BELOW STRINGER 8R. CUT OUT CRACK AND REPAIRED WITH DOUBLERS.SDR ASAA1047321Frame · crackedFRAME CRACKED AT FASTENER BS 727F STR 8L. CUT OUT CRACK AND REPAIRED WITH DOUBLERS.SDR ASAA1047320Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE AT BS 440 JUST BELOW STRINGER 8L. CUT OUT CRACK AND REPAIRED WITH DOUBLERS.SDR ASAA1047319Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE AT BS 480 BELOW STR 8R. CUT OUT CRACK AND REPAIRED WITH DOUBLERS.SDR ASAA1047318Frame · crackedFRAME CRACKED AT FASTENER. REPAIRED FRAME, CUT OUT CRACKED AREA AND INSTALLED REINFORCEMENT ANGLES.SDR SWAA100607Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 320, STR 20L. REMOVED AND REPLACED FRAME PER SRM.
Back to JASC 5311