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 DALA1139559861Former · crackedCRACK ON FUSELAGE FORMER AT STA 1151, BELOW LONGERON 14L. REMOVED FORMER ON STA 1151 BELOW LONGERON 14L, REMOVED 4 ANGLES STA 1151, LONGERONS 13,14,15,16, & 1 EA SPLICE PER DC9 SRM 51-30 -5, PG 30, 29. LOCATED AND DRILLED NEW FORMER PER DC9 SRM 51-10-4, PSDR FOTR2104615056Frame · damagedPAX CABIN STA 783.95, STR 8R FRAME SPLICE HAS DRILL START. REPAIRED ON FASI WO 21046, NR 15056.SDR FOTR2104615055Frame Splice · damagedPAX CABIN STA 760.95, STR 8R FRAME SPLICE HAS DRILL START. REPAIRED ON FASI WO 21046, NR 15055.SDR FOTR2104615208Frame · damagedPAX CABIN STA 848.95, STR 8R FRAME HAS DOUBLE HOLES. REPAIRED ON FASI WO 21046, NR 15208.SDR FOTR2104615207Frame · damagedPAX CABIN FRAME AT STA 826.95, STR 8R HAS DOUBLE HOLES. REPAIRED ON FASI WO 21046, NR 15207.SDR FOTR2104615164Frame · dentedFWD CARGO PIT-DENTS ON FRAME 520 BETWEEN STR 25R AND 22R. REPAIRED ON FASI WO 21046.SDR USAA2011060800027Frame · crackedCLT - Q4 - CRACK IN FUSELAGE FRAME AT BS 827 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 827 BETWEEN S8R TO S9R IAW EA 102981.SDR FDEA201105201910Frame · corrodedAFT CARGO FRAME BS 1400 HAS CORROSION UNDER DOOR SILL AREA. CORROSION FOUND OUT OF LIMITS IAW 53-00-07, PG 104, FIG 101, DET V, RECEIVED NEW FRAME & SPLICE. R & R FRAME IAW SRM 51-40-02 & DWG 146N1028. MAJOR REPAIR.SDR IPXA11567301Frame · dentedINSPECTION TYPE:S1C9, FWD CARGO PIT STA 660 BETWEEN STR 23R & 24R FRAME IS DENTED. J-SECTION FRAME REPAIR IAW EA 110567.SDR IPXA11567300Frame · dentedINSPECTION TYPE:S1C9, MAIN CARGO COMPARTMENT STA 520 FRAME DENTED AT STRINGER 16R BEHIND ISOLATOR. J-SECTION FRAME REPAIR IAW EA110575 IR.SDR IPXA11567298Frame · dentedINSPECTION TYPE:S1C9, MAIN CARGO COMPARTMENT STA 540 FRAME DENTED AT STRINGER 16R BEHIND ISOLATOR. REPAIRED DAMAGED FRAME IAW EO B757-5310-43135-A.SDR IPXA11567243Frame · gougedINSPECTION TYPE:S1C9, MAIN CARGO FRAME HAS GOUGE FROM FASTENER AT STA 880 BETWEEN S15L AND S 16L. REPAIRED MAIN CARGO FRAME STA 880 BETWEEN S15L AND S16L IAW EA 110718.SDR IPXA11567115Frame · dentedINSPECTION TYPE:S1C9, FWD CARGO PIT STA 800 BETWEEN STR 23R AND 24R FRAME IS DENTED. FABRICATED REPAIR PARTS AND INSTALLED IAW SRM 53-00-07-2R5 DETAIL 2. INSTALLED FASTENERS COMMON TO NEW CLIP AND STRONGER IAW EA110580/IR/ EO B757-5310-43008-A. THIS IS A CATSDR FOTR2104615144Frame · corrodedFWD PIT FRAME, BS 720E IS CORRODED ON FWD SIDE BETWEEN STRINGER 26R-25R ABOVE SHEAR TIE. REPAIRED ON FASI WO 21046.SDR FDEA201105191922Frame · damagedAFTER FRAME REMOVAL AND CLEAN UP FOUND DOUBLE DRILL HOLES STA 620 BETWEEN STR 10L TO STR 13L. CUTOUT DAMAGED AREAS (3) AT BS 620 STR 10L, STR 11L, AND STR 13L AND FABRICATED FILLERS (3). INSTALLED FILLERS (3) AND FABRICATED REPAIR DOUBLER AND REPAIR TRSDR FDEA201105191921Frame · damagedDOUBLE DRILLED HOLES FOUND UPON REMOVAL OF INNER SKIN GOING THROUGH SHIM AND FRAME STA 620, STR 9L AT 2 EACH LOCATIONS.SDR SWAA113581Frame · crackedDURING SCHEDULED 24Y CHECK FOUND, FRAME CRACKED AT BS 663.75, S-3R. REPAIRED FRAME IAW EA.SDR SWAA113580Frame · crackedDURING SCHEDULED 24Y CHECK FOUND, FRAME CRACKED AT BS 663.75, S-2L. REPAIRED FRAME IAW EA.SDR SWAA113579Frame · crackedDURING SCHEDULED 24Y CHECK FOUND, FRAME CRACKED AT BS 663.75, S-3L. REPAIRED FRAME IAW EA.SDR SWAA113472Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 747, BETWEEN STR 26R TOP STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA113471Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 727D BETWEEN S-26R AND S-27R. REPAIRED FRAME PER SRM.SDR SWAA113470Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 727D BETWEEN S-25L AND S-26L. REPAIRED FRAME PER SRM.SDR SWAA113458Frame · crackedDURING SCHEDULED 26Y CHECK FOUND, FRAME CRACKED STA 440 AT STRINGER 17R. REMOVED AND REPLACED FRAME PER SRM.SDR AALA20110519TUL04Frame · crackedAFT ACCS 1485 CANT FRAME CRACKED AT STAIR RETRACT ACTUATOR. REMOVED DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR AARD 53-10-00-33.SDR IPXA1567340Frame · dentedINSPECTION TYPE:C, CK AFT CARGO COMPARTMENT STA 1260 FRAME DENTED JUST BELOW STRINGER 23L. REPAIRED AFT CARGO COMPARTMENT FRAME 1260 IAW EA 110560 IR.SDR IPXA11567315Frame · dentedINSPECTION TYPE:C, CK AFT CARGO COMPARTMENT STA 1340 FRAME DENTED BETWEEN STR 23L AND 24L. REPAIRED AFT CARGO FRAME STA 1340 BETWEEN S-23L AND S-24L IAW SRM 53-00-07-2R-5 AND EA 110563.SDR IPXA11567175Frame · dentedINSPECTION TYPE:S1C9, AFT PIT FUSELAGE UPPER FLANGE HAS A DENT BS-1620 JUST BELOW STR 25R. REPAIRED AFT PIT FRAME STA 1620 JUST BELOW S-25R IAW SRM 53-00-07-2R, REPAIR 5 AND EA 110565.SDR IPXA11567174Frame · dentedINSPECTION TYPE:S1C9, AFT CARGO COMPARTMENT STA 1220 FRAME DENTED AT STR 26R. REPAIRED AFT CARGO COMPARTMENT FRAME STA 1220 IAE EA 110558.SDR IPXA1567057Frame · dentedINSPECTION TYPE:S1C9, AFT PIT FUSELAGE FRAME INNER FLANGE HAS A DENT AT BS 1540, JUST BELOW STRINGER 26L. REPAIRED FRAME STA 1540 AT STRINGER 26L IAW SRM 53-00-07-2R 5.SDR IPXA1567055Frame Splice · gougedINSPECTION TYPE:S1C9, AFT CARGO COMP STA 1300 FRAME SPLICE AT S-24L IS GOUGED. REPLACED FRAME SPLICE AT STA 1300 S-24L IAW DWG 146N1006 AND SRM 51-40 -02.SDR FDEA201105181865Frame · dentedBS 1701 L11L FRAME FOUND DENT. REPAIRED AS PER SRM 53-00-07 FIG 201 REVISION 46. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REVISION 112.SDR FDEA201105181864Frame · dentedBS 1681 L11L FRAME FOUND DENTED. REPAIRED AS PER SRM 53-00-07 FIG 201 REVISION 46. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REVISION 112. INITIAL INSPECTION AT 14500 AND REPETITIVE INSPECTION AT 9500 USING HFEC METHOD.SDR FDEA201105181863Frame · dentedBS 1741 L11L FRAME FOUND DENT. REPAIRED AS PER SRM 53-00-07 FIG 201 REVISION 46. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REVISION 112.SDR FDEA201105181862Frame · dentedBS 1661 L11L FRAME FOUND DENT. REPAIRED AS PER SRM 53-00-07 FIG 201 REV 46. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REV 112.SDR SWAA113446Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, FRAME CORRODED AT BS 727E, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA113432Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, FRAME CORRODED AT BS 727E AND BETWEEN STR 27R TO STR 27L AFT CARGO COMPARTMENT. REPAIRED FRAME IAW SRM.SDR SWAA113429Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, FRAME CORRODED AT BS 500C, BETWEEN S-26R TO S-27R FWD CARGO COMPARTMENT. REPAIRED FRAME PER SRM.SDR SWAA113425Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, FRAME CORRODED AT STA 767 BETWEEN STR 25R TO STR 26R. REPAIRED FRAME IAW SRM.SDR SWAA113424Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, FRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R AFT CARGO COMPARTMENT. REPAIRED FRAME IAW SRM.SDR SWAA113408Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, CORROSION ON FRAME, LOCATED BS 827 BETWEEN STR 27L TO STR 27R IN AFT CARGO COMPARTMENT. REPAIRED FRAME PER SRM.SDR SWAA113407Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, CORROSION ON FRAME LOCATED AT BS 807, BETWEEN STR 27R TO STR 27L AFT CARGO COMPARTMENT. REPAIRED FRAME PER SRM.SDR IPXA11567161Frame · dentedINSPECTION TYPE:S1C9, AFT CARGO COMPARTMENT STA 1240, FRAME INBD FLANGE DENTED AT STR 26L. REPAIRED AFT CARGO COMPARTMENT FRAME STA 1240 IAW EA 110559.SDR IPXA11567160Frame · dentedINSPECTION TYPE:S1C9, AFT CARGO COMPARTMENT STA 1240 FRAME INBD FLANGE DENTED JUST ABOVE STR 24L. REPAIRED AFT CARGO COMPARTMENT FRAME STA 1240 IAW EA 110559.SDR IPXA11567159Frame · dentedINSPECTION TYPE:S1C9, AFT CARGO COMPARTMENT STA 1240 FRAME DENTED AT STR 25L . REPAIRED AFT CARGO COMPARTMENT FRAME STA 1240 IAW EA 10559.SDR DALA1135069866Web · crackedMAIN CABIN OVER WING RBL-44 BETWEEN STA 740 AND 770 WEB TO CENTER TANK ANGLE CRACKED. NDT MARKED ENDS OF CRACK PER NDT SPM 06-10-01. GAINED ACCESS AND REMOVED DAMAGED SECTION OF ANGLE FROM STA 700-780 RBL 44. RECEIVED NEW ANGLE. INSTALLED NEW ANGLE IAW SRMSDR IPXA11567286Frame · dentedINSPECTION TYPE:C, CK FWD CARGO COMP FRAME DENTED AND CRACKED AT BS 700, BETWEEN S22R AND S23R. REPAIRED FWD CARGO COMP FRAME STA 700 BETWEEN S-22R AND S-23R IAW SRM 53-00-07-2R-5 AND EA 110541.SDR USAA2011061000011Frame · crackedMCN - C21 CHECK - CRACK ON FRAME FASTENER HOLE AT BS 360, BETWEEN STR 13R TO 14R. REPAIRED FRAME AT BS 360, BETWEEN STR 13R TO 14R IAW EA 130583.SDR FOTR2104615163Frame · dentedFWD CARGO PIT- DENTS ON FRAME 500 AT STR 25R TO STR 20R. REPAIRED ON FASI WO 21046.SDR FOTR2104615150Frame · dentedFWD PIT FRAME BS 720C UPPER FLANGE IS DENTED BETWEEN STR 25R-24R. REPAIRED ON FASI WO 21046.SDR IPXA11566922Frame · dentedINSPECTION TYPE:C1, FWD CARGO COMP FRAME DENTED AT BS 720 BETWEEN S23R AND S24R. REPAIRED FRAME STA 720 BETWEEN S-23R AND S-24R IAW SRM 53-00-07-2R REP AIR 5, DETAIL 1.
Back to JASC 5311