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 USAA2009043091034Frame · crackedSAL - Q6 - MAJOR REPAIR - FRAME CRACKED AT BS 400 BETWEEN S8L TO S9L. REPAIRED FRAME AT BS 400 BETWEEN S8L TO S9L IAW US AIRWAYS EA 132382.SDR USAA2009043091033Frame · crackedSAL - Q6 - MAJOR REPAIR - FRAME CRACKED AT BS 400 BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 400 BETWEEN S8R TO S9R IAW US AIRWAYS EA 132382.SDR AALA20090408TUL02Frame · crackedCANT FRAME 1418 CRACKED AT LONGERON 2R. INSTALLED REPAIR DOUBLER ON FRAME 1418 AND SPLICE ON LONGERON 2R PER SRM 51-30-05 AND AARD 53-30-00-2.SDR USAA2009051191150Frame · crackedMCN - C5 - MAJOR REPAIR - CRACKS ON FRAME WEB AT BS 847, S25R. REPLACED FRAME AT BS 847, S25R IAW B737 SRM 51-40-02.SDR CALA2009032900166Frame · wornFRAME AT STA 1640 BETWEEN STR 5RT & AMP; 6RT CHAFED INTO ON I/B FLANGE. REPAIRED DAMAGED FRAME FLANGE REF ECRA 5310-04921. INSTALLATION OF REPAIR ANGLE STEPS 1-12 AND ISSUED DIP FOR PERMANENT REPAIR REF STEP 13. ACCOMPLISH PERM REPAIR WITHIN 12 MONTHS FROM SDR CALA2009032900167Frame · wornFRAME AT STA 1640 BETWEEN STR 5LT & AMP; 6LT CHAFED INTO ON I/B FLANGE. REPAIRED DAMAGED FLANGE REF ECRA 5310-04920. INSTALLATION OF REPAIR ANGLE STEPS 1-12 AND ISSUED DIP FOR PERMANENT REPAIR REF ST EP 13. ACCOMPLISH PERM REPAIR WITHIN 12 MONTHS FROM 3/24/SDR AALA20090406TUL57Frame · corrodedCORROSION ON FRAME AT STATION 1309 LONGERON 30. REMOVED CORROSION AND INSTALLED DOUBLER AND FRAME REPAIR PER AARD 53-10-00-14.SDR FDEA200903261045Frame · dentedDENT, MAIN FRAME STA5-73 BETWEEN S-12R TO S-13R. REPAIRED AS PER SRM 53-30-00 FIGURE 1, VOLUME I, REVISION 40. REPETITIVE INSPECTION REQUIRE. INITIAL AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00 FIGURE 1, VOSDR AALA20090406TUL59Frame · corrodedCORROSION ON FRAME LOWER FLANGE AT STATION 1271 LONGERON 29L- LONGERON 30. INSTALLED J-ANGLE DOUBLER PER AARD 53-10-00-14 REPAIR 1.SDR ASAA0944953Strap · damagedFRAME STRAP BS 794 STR 16 26R HAS ELONGATED HOLES. REPLACED FRAME STRAP PER SRM 51 40 02.SDR C2XA09SH104Frame · corrodedDURING C-CHECK. FR 75 SHOWS SIGNS OF CORROSION BTW STR 2L-2R. REPAIRED FR 75 IAW EC 5310-01317. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH084Frame · crackedSHV - DURING C-CHECK, CRACK IN FR 69 BETWEEN STR 18L-19L. REPAIRED FRAME 69 IAW IC 2009-145/01891. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA20090331TUL53Frame · crackedSTATION 1510 CANT FRAME CRACKED ABOVE LEFT UPPER TAIL CONE LATCH. INSTALLED REPAIR DOUBLER PER EA MD80-53-005820.SDR SWAA091968Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME WEB CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091967Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 908, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091966Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091965Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091964Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091963Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091953Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091952Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091951Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR AALA20090406TUL30Frame · crackedFRAME 1418 CRACKED ON UPPER FLANGE BETWEEN LONGERON 1R AND 2R. INSTALLED DOUBLER PER EA MD80-53-005777.SDR IPXA09555652Frame · dentedINSPECTION TYPE:C DENT ON FRAME STA 1320 BETWEEN STR 26L-27L IN AFT CARGO COMPT LT SIDE. DENT FRAME STA 1320 BETWEEN STR 25L -26L OUT OF LIMITS IAW SRM 53-00-07-1 1A1 FIG 101 SHT 1. REMOVED TRANS PNL STA 1310-1360 LT IAW SRM 51-40-02. REMOVED TIE DOWN FITTISDR IPXA09555651Frame · dentedINSPECTION TYPE:C DENT OF FRAME STA 1320 STR 25L IN AFT CARGO COMPT LT SIDE. DENT FRAME STA 1320 STR 25L OUT OF LIMITS IAW SRM 53-00-07-1A1 FIG 10 1 SHT 1. CUT OUT DAMAGE AREA IAW EA 757-5362-27-A1865 SRM 53-00-07- 2R. REMOVED FAST FOR HIGH FREQ INSP IAW SRSDR USAA2009041590895Frame · corrodedSAL - Q6 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FUSELAGE FRAME WEB AT BS 1006, BETWEEN S27R TO S27L. REPAIRED FUSELAGE FRAME WEB AT BS 1006, BETWEEN S27R TO S27L IAW B737 SRM 53-00-07 REPAIR 1.SDR IPXA09555405Frame · damagedINSPECTION TYPE:C3 SCREW DAMAGE ON BS 1580 FRAME AT STR 14L. REPAIRED FRAME PER SRM 53-00-07-2R.SDR IPXA09555316Frame · damagedINSPECTION TYPE:C3 SCREW DAMAGE ON BS 1540 FRAME, STR 14L IS BEYOND LIMITS. FRAME WAS REPAIRED PER SRM 53-00-07-2R1.SDR CALA2009032400163Failsafe · corrodedSTA 927 FAIL SAFE CHORD CORRODED AT STRINGER 25 RT. REMOVED AND REPLACED FAIL SAFE CHORD FROM S-21R TO FACTORY SLICE AT S-24R, REFERENCE EC/RA 5310-04918, STEP 10. DIP WRITTEN TO ACCOMPLISH A PERMANENT REPAIR WITHIN 12 MONTHS FROM 22 MARCH09. PLANNING TO COSDR SWAA091933Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091932Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091931Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091930Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091929Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091928Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091927Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091926Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091925Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091924Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091923Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091922Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091921Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER AAR EA.SDR SWAA091916Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND R1 DOOR FWD LOWER END CUTOUT FRAME CRACKED. REPAIRED FRAME PER SRM.SDR SWAA091914Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA091912Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME ANGLE CRACKED AT BS 294, STR 11L. REPAIRED ANGLE PER SRM.SDR SWAA091887Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 559, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER AAR EA.SDR IPXA09555662Frame · dentedINSPECTION TYPE:C DENT ON FRAME STA 1340 BETWEEN STR 25R & 26R IN AFT CARGO COMPT. DENT AT FRAME STA 1340, BETWEEN STR 25R & 26R WAS FOUND TO BE OOL IAW SRM 53-00-07-1A1 FIG 101 SHT 1 "NO DENTS ALLOWED ON FLANGE." REMOVED FLANGE BETWEEN STR 25R & 26R, STA 13SDR IPXA09555628Frame · dentedINSPECTION TYPE:C DENT ON FRAME STA 1260 JUST ABOVE STR 26L ON AFT CARGO COMPARTMENT. DENT AT FRAME STA 1260, STR26L FOUND OUT OF LIMITS IAW SRM 53-00-07-1A1, FIG 101, SHT 1. NO DENTS ALLOWED ON FLANGE. REMOVED TRANS PNL STA 1220-1310 LT A ACCESS TO REPAIR SDR IPXA09555571Frame · dentedINSPECTION TYPE:C DENT ON FRAME STA 1220 BET STR 25R AND 26R IN AFT CARGO COMPARTMENT. DENT AT STA 1220, STR 24R AND 25R FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A1, FIG 101, SHT 1. NO DENTS ALLOWED ON FLANGE. DENT MEASURE .859 INCH BY 0.903 INCH BY .010SDR IPXA09555541Frame · dentedINSPECTION TYPE:C DENT ON FRAME STA 1320 JUST ABOVE STR 26R IN AFT CARGO COMPT. DENT L=1.12 W=.89 D=.052 LOCATION STA 1320 STR 26 7.75 FRM PROD SPL 5.95 FRM TRANS PNL TRIMMED AREA IAW SRM 53-00-07-2R5 SHT 1 PG 1 STEP 1 FIG 201. HFEC INSP CUTOUT PER NTM 51-00
Back to JASC 5311