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 PIDA06108Frame · crackedFRAME CRACKED AT STA 907 BETWEEN STR 8&9L. REPAIRED PER SRM 51-70-11.SDR USAA061109Frame · crackedFOUND FRAME CRACKED, STA 480 STR 9R. INSTALLED DOUBLERS IAW SRM 53-10-20D, DEFECT SIZE: .250".SDR AWXA200601581Frame · crackedMCN - FOUND FLOOR FRAME CRACKED BS 328 BETWEEN STR 22 - STR 21 RT. REPAIRED FLOOR FRAME AT BS 328, BETWEEN STR 22 -STR 21 RT, IAW B737-300, SRM 51-70-11-06, FIG 1.SDR 06FDEA03146Frame · dentedCARGO FRAME AT LT STA 1761, L12 FOUND DENT. REPAIR CARRIED OUT AT MAIN DECK CARGO FRAME LT STA 1761 L12 AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 06FDEA03145Frame · bentCARGO FRAME AT LT STA 1701, L12 FOUND BENT. REPAIR CARRIED OUT AT MAIN DECK CARGO FRAME LH STA 1701 L12 AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 06FDEA03144Frame · bentM/D CARGO FRAME AT LT STA 1681, L12 FOUND BENT. REPAIR CARRIED OUT AT MAIN DECK CARGO FRAME LT STA 1681 L12 AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR UPS06548030Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1540 BET S25L TO S26L (1EA). ACCOMPLISHED REPAIR PER FINAL EA 757-5362-27-A1523 AND UPS EO B757 -5310-25116-A, WITH NO DEVIATIONS.SDR UPS06548002Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO FUSELAGE FRAME STA 1480, BET S23L TO S26L. REPAIR ACCOMPLISHED PER FINAL EA 757-5362-27-A1526, AND UPS EO NO: B7 57-5310-25133-A, WITH NO DEVIATIONS.SDR UPS06547988Frame · dentedINSPECTION TYPE-C DENT IN AFT CARGO FUSELAGE FRAME STA. 1580, BET S25L TO S26L REPAIR ACCOMPLISHED IAW EA 757-5367-27-A1525 AND UPS E.O. NR B757-5310-2 5093-A. NO DEVIATIONS NOTED.SDR DHL2006745535Frame · dentedREF ASTAR N/R 56426. DISCREPANCY: FWD CARGO COMPT, FRAME AT STA 660 IS DENTED AT UPPER FLANGE ABOVE STR 23R. CORRECTIVE ACTION: CUT OUT DAMAGED AREA APPROX DIM 3.7 INCH X 1 INCH IAW SRM 51-40-3 FIG 1, FAB REPAIR DOUBLER FROM P/N 7075-0, .071, PO NR 9003189SDR DHL2006745510Frame · dentedAFT CARGO COMP BS 950B ABOVE STR 25R HAS FRAME INNER FRAME CHORD DENTED. CUT OUT DAMAGED AREA APPROX DIM 1" BY 1.5" AND 1" BY .75" IAW B727 SRM 51-40-3, FIG 1. FABRICATED DOUBLER FROM 7075-0 .071, PO NR 9003110, APPROX DIM 28" BY 4" IAW B727 SRM 51-40-3 FIG SDR ASAA0680918Frame · corrodedFRAME CORRODED. REPLACED DAMAGED FRAME SECTION PER SRM 51-10-3 AND 51-30-2.SDR DHL2006745519Frame · dentedAFT CARGO COMPARTMENT BS 950C LT HAS 3 DENTS IN RADIUS OF FRAME. CUT OUT DAMAGED SECTION 2" BY 1" AT AFT CARGO FRAME BS 950C LT STR 26L IAW B727 SRM 51-40-3 FIG 1. REMOVED FASTENERS FOR FRAME REPAIR IAW B727 SRM 51-30-2. FAB REPAIR DOUBLER FROM P/N 7075-0 .SDR DHL2006745518Frame · dentedAFT CARGO COMP BS 950C ABOVE STR 25RT, HAS FRAME INNER CHORD DENTED. REMOVED FASTENERS FOR FRAME REPAIR AT BS 950C, STR 25R IAW B727 SRM 51-30-2. CUT OUT DAMAGED AREA APPROX DIM 1" BY 1 1/4" IAW B727 SRM 51-40-3 FIG 1. FAB REPAIR DOUBLER FROM P/N 7075-0 .07SDR 06FDEA03135Frame · dentedAFT CARGO BAY FRAME DENTED AT BS 1070 BETWEEN STR 26L AND 27L UPPER SURFACE. CUT OUT DAMAGE ON FRAME AT BS 1070 BETWEEN STR 26L & 27L LOWER SURFACE AND INSTALLED REPAIR DOUBLER PER SRM 51-40-3.SDR USAA061091Frame · crackedFOUND FRAME CRACKED, STA 500A S8L S9L. REMOVED DAMAGE, INSTALLED DOUBLERS IAW SRM 53-10-20D, DEFECT SIZE: .5".SDR USAA061092Frame · crackedFOUND FRAME CRACKED, STA 480 S8R, S9R. REMOVED DAMAGE, INSTALL DOUBLERS IAW SRM 53-10-20D, DEFECT SIZE: .5".SDR USAA061093Frame · crackedFOUND FRAME CRACKED, STA 440 S8L S9L. REMOVED DAMAGE, INSTALLED DOUBLER IAW SRM 53-10-20D, DEFECT SIZE: .5".SDR USAA061094Frame · crackedFOUND FRAME CRACKED, STA 440 S8R, S9R. REMOVED DAMAGE, INSTALLED DOUBLER IAW SRM 53-10-20D, DEFECT SIZE: .5".SDR USAA061088Frame · crackedFOUND FRAME CRACKED, STA 747 S8R-S9R. REMOVED DAMAGE, INSTALLED DOUBLERS IAW SRM 53-10-20D, DEFECT SIZE: .5".SDR USAA061083Frame · crackedFOUND FRAME CRACKED, STA 787 S8L - S9L. REMOVED DAMAGE, INSTALLED DOUBLERS IAW SRM 53-10-20D, DEFECT SIZE: .5".SDR USAA061077Frame · crackedFOUND FRAME CRACKED, STA 827 3" ABOVE S-10L. CUT OUT DAMAGE, INSTALLED DOUBLER IAW TR 53-10-20D, DEFECT SIZE: .30".SDR USAA061080Frame · crackedFOUND FRAME CRACKED, STA 827 S8L, S9L. REMOVED DAMAGE, INSTALLED DOUBLER IAW SRM 53-10-20D, DEFECT SIZE: .5".SDR USAA061090Frame · crackedFOUND FRAME CRACKED STA 500A S8R, S9R. REMOVED DAMAGE, INSTALLED DOUBLERS IAW SRM 53-10-20D, DEFECT SIZE: .5".SDR USAA061082Frame · crackedFOUND FRAME CRACKED, STA 867 S8L S9L. REMOVED DAMAGE, INSTALLED DOUBLERS IAW SRM 53-10-20D, DEFECT SIZE: .5".SDR USAA061089Frame · crackedFOUND CRACK STA 727D, S8R-S9R. REMOVED DAMAGE, INSTALLED DOUBLERS IAW SRM 53-10-20D, DEFECT SIZE: .5".SDR USAA061084Frame · crackedFOUND CRACK STA 747 S8L-S9L . REMOVED DAMAGE, INSTALLED DOUBLERS IAW SRM 53-10-20D, DEFECT SIZE: .5".SDR USAA061085Frame · crackedFOUND FRAME CRACKED, STA 827 S8R S9R. REMOVED DAMAGE, INSTALLED DOUBLERS IAW SRM 53-10-20D, DEFECT SIZE: .5".SDR USAA061086Frame · crackedFOUND FRAME CRACKED STA 867 S8R S9R. REMOVED DAMAGE, INSTALLED DOUBLERS IAW SRM 53-10-20D, DEFECT SIZE: .5".SDR USAA061087Frame · crackedFOUND CRACK STA 787 S8R, S9R. REMOVE DAMAGE, INSTALL DOUBLERS IAW SRM 53-10-20D DEFECT SIZE: .5".SDR SWAA063215Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR KCSA061269Frame · crackedCRACK INDICATION AT FASTENER HOLE AT BS 2598 BULKHEAD LT SIDE AFT INNER CHORD WL 314.SDR 06FDEA03129Frame · chafedFOUND MAIN CABIN 1130 FRAME IS CHAFED AT STR 5L. REPAIRED FRAME AT BS 1130 STR 5L IAW SRM 51-40-3.SDR 06FDEA03124Frame · dentedFOUND FWD CARGO BAY FRAME IS DENTED 2 PLACES BS 680 STR 23L AND STR 24L. REMOVED DAMAGE AND REPAIRED DENTED FRAME AT BS 680 STR 23L AND 24L IAW SRM 51-40- 3.SDR 06FDEA03123Frame · gougedAFT CARGO BAY FRAME GOUGED AT BS 950E STR 25L UPPER SURFACE. REMOVED AND REPLACED GOUGED FRAME SPLICE AT BS 950E STR 25L IAW SRM 51-20-1 AND 51-30-2.SDR CALA0600315Frame · corrodedINSPECTION FOUND HEAVY INTERGRANULAR CORROSION ON FORWARD SIDE OF FRAME AT STA 219.8, S27R, RBL 17, O/B LOWER CHORD. A NEW CHORD WAS INSTALLED IAW SRM 51-2-02 AND 51-40-02.SDR SWAA063168Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, STR 11L. REPAIRED FRAME SECTION PER SRM.SDR USAA061069Frame · crackedSTA 887 S9R CRACKED. INSTALLED DOUBLER IAW TR 53-10-20D, DEFECT SIZE: .25 INCH.SDR 06FDEA03084Frame · dentedMAIN DECK CARGO COMPT, MAIN FRAME AT STA 1721 LONGERON 12L FOUND DENT. MAIN DECK CARGO COMPT, DENT MAIN FRAME AT STA 1721 LONGERON 12L REPAIRED AS PER SRM 53-30-00 VOLUME I, FIGURE 1. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100. INITIAL REPEAT INSPECTION RESDR 06FDEA03083Frame · dentedMAIN DECK CARGO COMPT, MAIN FRAME AT STA 1581 LONGERON 12L FOUND DENT SNRM NO.: N00660, MAIN DECK CARGO COMPT, DENT MAIN FRAME AT STA 1581 LONGERON 12L REPAIRED AS PER SRM 53-30-00 VOLUME I, FIGURE 1. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100. INITIAL REPEASDR 06FDEA03082Frame · dentedMAIN DECK CARGO COMPT, MAIN FRAME AT STA 1641 LONGERON 12R FOUND DENT SNRM NO.: N00659, MAIN DECK CARGO COMPT, DENT MAIN FRAME AT STA 1641 LONGERON 12R REPAIRED AS PER SRM 53-30-00 VOLUME I, FIGURE 1. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100. INITIAL REPEASDR TRAX200600660Frame · corrodedFRAME 349 CORRODED ON R/H SIDE. AFT OF SERVICE DOOR. REMOVED 2 SERVICE DOOR SILL PLATE BRACKETS, 2 LOWER SERVICE DOOR LOCK BRACKETS, 1 SERVICE DOOR ANGLE AND STARTED REMOVING FIBERGLAS DOUBLER AND AFT ANGLE ON FRAME 349 R/H SIDE AFT OF SERVICE DOOR TO GAINSDR 06FDEA3084Frame · dentedMAIN DECK CARGO COMPT, MAIN FRAME AT STA 1721 LONGERON 12L FOUND DENT AFA7799-1.SDR 06FDEA3083Frame · dentedMAIN DECK CARGO COMPT, MAIN FRAME AT STA 1581 LONGERON 12L FOUND DENT AFA7819-1.SDR 06FDEA3082Frame · dentedMAIN DECK CARGO COMPT, MAIN FRAME AT STA 1641 LONGERON 12R FOUND DENT AFA7817-1.SDR TRAX200600656Frame · crackedPOSSIBLE CRACK ON THE LT 640 FRAME BETWEEN 9 AND 12 STR. PERFORMED EDDY CURRENT INSPECTION OF REPAIR DOUBLER AT F.S. 640.00 FRAME, LEFT SIDE, BETWEEN STR. 9 AND STR. 12 I/A/W CRJ 200 NDTM 51-20-06. REPAIR DOUBLER IS CRACKED. REMOVED 640 DOUBLER. STARTED REMSDR 06FDEA03065Frame · dentedAFT CARGO BAY FRAME DENTED AT BS 1050 BETWEEN STR 25L UPPER SURFACE. COMING CUT OUT DAMAGE ON FRAME AT BS 1050 BETWEEN STR 25L AND INSTALLED REPAIR DOUBLER IAW SRM 51-40-3.SDR 06FDEA03064Frame · dentedAFT CARGO BAY FRAME DENTED AT BS 950F STR 26L UPPER SURFACE. COMING DUPLICATE ENTRY, SEE 06-3063 CUT OUT DAMAGE ON FRAME AT BS 950F STR 26L AND INSTALLED REPAIR DOUBLER IAW SRM 51-40-2.SDR 06FDEA03063Frame · dentedFOUND AFT CARGO BAY FRAME DENTED AT BS 950F STR 26L UPPER SURFACE. COMING CUT OUT DAMAGE ON FRAME AT BS 950F STR 26L AND INSTALLED REPAIR DOUBLER IAW SRM 51-40-2.SDR CALA0600308Frame · crackedINSPECTION FOUND A 1 INCH CRACK IN LT MAIN FRAME AT STA 616 JUST BELOW FLOOR, S17L. A REPAIR ANGLE AND FILLER WERE INSTALLED IAW ECRA 5311-01158.
Back to JASC 5311