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 SWAA2012051604076Frame · damagedFRAME CREASED AT BS 908, BETWEEN STR 27R TO STR 30R. REPAIRED FRAME PER SRM.SDR SWAA2012051604074Frame · damagedL1 DOOR FRAME CREASED AT BS 237, BETWEEN STR 16L TO STR 17L. REPAIRED FRAME PER SRM.SDR HYIA20120516001Spar · crackedON SCHEDULED INSPECTION, DISCOVERED AFT SPAR WEB FLANGE CRACKED UNDER CENTER FLOORBOARDS AT FS 186.15. OPENSDR IPXA2M73905Frame · corrodedINSPECTION TYPE: 4C, FUSELAGE FRAME AT FS 1801 AND LONGERON 26L HAS EXFOLIATION CORROSION. REPAIRED IAW EA 011-5310-01-A3905 REV I/R AND EO MD11-5310-47487-A.SDR IPXA12573795Frame · dentedINSPECTION TYPE: C11, FWD CARGO BAY FRAME DENTED AT BS 820, S24-25R. REPAIRED IAW SRM 53-00-07, 2R 5, FIG 201, DETAIL 3.SDR CALA2012051600355Frame · crackedFUSELAGE RT FRAME CRACKED ST 482 BETWEEN STR 8 AND AMP; 9. REMOVED DAMAGE FROM FRAME, REPAIRED REF EA 5310-04498, REV B.SDR SWAA2012051504030Frame · puncturedFRAME PUNCTURED AT BS 851, STRL 29L. REPAIRED FRAME IAW SRM.SDR IPXA12573802Frame · dentedINSPECTION TYPE: C11, FWD CARGO BAY FRAME DENTED AT BS 780, S23 - 24L. REPAIRED IAW SRM 53-00-07 2R 5, FIG 201, DETAIL 1.SDR IPXA12573801Frame · dentedINSPECTION TYPE: C11, FWD CARGO BAY LT SIDE FRAME DENTED AT BS 680 S23 - 24L. REPAIRED IAW SRM 53-00-07, 2R 5, FIG 201, DETAIL 2.SDR IPXA12573800Frame · dentedINSPECTION TYPE: C11 FWD CARGO BAY FRAME DENTED AT BS 800 S24-25L. REPAIRED IAW SRM 53-00-07 2R 5, FIG 201, DETAIL 1.SDR IPXA12573799Frame · dentedINSPECTION TYPE: C11, FWD CARGO BAY FRAME DENTED AT BS 760, S24-25L. REPAIRED IAW SRM 53-00-07 2R 5, FIG 201, DETAIL 1.SDR IPXA12573798Frame · dentedINSPECTION TYPE: C11, FWD CARGO BAY FRAME DENTED AT BS 700 S23-24L. REPAIRED IAW SRM 53-00-07 2R 5, FIG 201, DETAIL 1.SDR IPXA12573796Frame · dentedINSPECTION TYPE: C11, FWD CARGO BAY FRAME DENTED AT BS 700, S24-25R. REPAIRED IAW SRM 53-00-07, 2R 5 FIG 201, DETAIL 3.SDR CHQA20120514170Frame · crackedDURING INSPECTION, THE RIGHT FRAME 10 WAS FOUND TO BE CRACKED. THE RIGHT FRAME 10 WAS REPLACED. THE NEW PART WAS INSTALLED WITH A SOLID RIVET IN ACCORDANCE WITH SRM 51-40-02.SDR CHQA20120514169Frame · crackedDURING INSPECTION, THE LEFT FRAME 10 WAS FOUND TO BE CRACKED. THE LEFT FRAME 10 WAS REPLACED. THE NEW PART WAS INSTALLED WITH A SOLID RIVET IN ACCORDANCE WITH SRM 51-40-02.SDR SWAA2012052304270Frame · crackedFRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2012052104226Frame · crackedFRAME WEB CRACKED AT BS 500D, STR 28L. REPAIR WEB IAW EA.SDR DALA1231400931Frame · damagedDURING HMV, NICKS WERE FOUND ON RT WINDOW BELT FRAME AT AFT/UPPER CORNER BTW STA Y=1250-1271. NICKS WERE BLENDED OUT IAW ERA 503255-14 REV ORIG.SDR SWAA2012060604704Frame · crackedFRAME CRACKED AT BS 787, BETWEEN STR 8R AND STR 9R. REPAIRED FRAME IAW EA AND SOPM.SDR ASAA12911641Frame Splice · corrodedAFT CARGO PIT STATION 787 AT STRINGER 25R, FRAME SPLICE CORRODED. ACFT GROUNDED. R & R FRAME SPLICE, REF SRM 51-40-02.SDR SWAA2012052904404Frame · crackedFRAME CRACKED AT BS 480, STR 4H. REPAIRED FRAME IAW EA.SDR SWAA2012052504330Frame · crackedFRAME IS CRACKED AT BS 380, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012052504329Frame · crackedFRAME IS CRACKED AT BS 440, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012052504328Frame · crackedFRAME IS CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012052504327Frame · crackedFRAME IS CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR DALA1232216818Frame · dentedFOUND DENT, ON FRAME BS 1460. REMOVED DAMAGE AREA PER SRM 53-00-07 REPAIR 5. PERFORMED HFEC INSPECTION OF CUTOUT PER SRM 53-00-07 REPAIR 5. COMPLIED WITH HFEC INSPECTION OF EXITING HOLES PER SRM 53-00-07 FIG 201. NO CRACKS FOUND, COLD WORKED END FASTENER HSDR DALA1232196818Frame · dentedFOUND DENT ON CARGO BAY FRAME BS 1480. REMOVED DAMAGE AREA PER SRM 53-00-07 REPAIR 5. PERFORMED HFEC INSPECTION OF CUTOUT PER SRM 53-00-07 REPAIR 5. COMPLIED WITH BHEC IN EXITING HOLES COMMON TO REPAIR IAW NDT MANUAL PT 6 51-00-16. FABRICATED REPAIR PER SDR CALA2012051400352Frame · crackedPERFORMED MFEC IAW EA 5310-04716 REV C CRACK INDICATION NOTED AT STA 380R. REPAIRED FRAME 380R IAW ECRA 5310-05509.SDR CALA2012051400351Frame · crackedPERFORMED HFEC IAW EA 5310-04716. CRACK INDICATION NOTED AT STA 380L IN RADIUS REPAIRED FRAME 380L IAW ECRA 5310-05509.SDR CALA2012051400350Frame · crackedMFEC INSPECTION SHOWS A CRACK INDICATION AT FRAME 400L REPAIRED FRAME AT STA 400L IAW ECRA 5310-05509.SDR CALA2012051400349Frame · crackedLEFT FRAME AT BS 440L CRACKED IN RADIUS REPAIRED FRAME AT STA 440L IAW ECRA 5310-05509.SDR CALA2012051400347Frame · crackedCRACK INDICATION IN RADIUS AT BS 480L. REPAIRED FRAME 480L IAW ECRA 5310-05509.SDR ASOA201201682Frame · damagedFRAME DAMAGED, REPAIRED IAW REO 670-53-61-816.SDR SWAA2012052504325Frame · crackedFRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME IAW EA.SDR ASOA201201663Frame · corrodedCORROSION AT FS 364 STRINGER 26 L/R. REPAIRED.SDR SWAA2012051704104Frame · crackedFRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME IAW EA.SDR ASOA201201637Frame · corrodedCORROSION AT FS 349 FRAME STRINGER 26L. APPLIED CIC IAW SRM 51-21-11-001-001-A01.SDR DALA1232266818Frame · dentedFOUND DENT ON FRAME BS 720. REMOVED DAMAGE PER SRM 53-00-07 REPAIR 5. FORMED REPAIR ANGLE PER SRM 53-00-07 REPAIR 5. HFEC INSPECTION OF DAMAGE CUT OUT OK IAW SRM 53-00-07. COMPLIED WITH HFEC OF HOLES COMMON TO THE REPAIR PER SRM 53-00-07 REPAIR 5. NO INDISDR DALA1232246818Frame · dentedFOUND DENT ON FRAME BS 1580. REMOVED DAMAGED AREA PER SRM 53-00-07 REPAIR 5. PERFOMED HFEC INSPECTION OF CUTOUT PER SRM 53-00-07 REPAIR 5. FABRICATED REPAIR PER SRM 53-00-07 REPAIR 5. PERFORMED HFEC INSPECTION OF ALL INITIAL FASTENER HOLES PER SRM 53-00-0SDR DALA1232236818Frame · dentedFOUND DENT ON FRAME BS 1500. REMOVED DAMAGED AREA PER SRM 53-00-07 REPAIR 5. PERFOMED HFEC INSPECTION OF CUTOUT PER SRM 53-00-07 REPAIR 5. COMPLIED WITH BHEC IN HOLES EXISTING COMMON TO REPAIR IAW NDT MANUAL PT 6 51-00-16, INSTALLED REPAIR PER SRM 53-00-07 SDR DALA1232226818Frame · dentedFOUND DENT ON FRAME BS 1340. REMOVED DAMAGED AREA PER SRM 53-00-07 REPAIR 5. PERFORMED HFEC INSPECTION OF CUTOUT PER SRM 53-00-07 REPAIR 5. DRILLED DOUBLER PER SRM 53-00-07 REPAIR 5. INSTALLED REPAIR PER SRM 53-00-07.SDR DALA1232176818Frame · damagedFUSELAGE FRAME HAS TWO MISDRILLED HOLES BELOW STRINGER 2R. NOT WITHIN LIMITS PER SRM 53-00-07 FIG 1 SHEET 1. ROUTED OUT DAMAGE ON FRAME PER SRM 53-00-07 REPAIR 1. HFEC INSPECTED CUTOUT PER SRM 53-00-07 FIG 201. NO CRACKS FOUND MADE INSURANCE CUT TO ROUTEDSDR DALA1232166818Frame · damagedFUSELAGE FRAME HAS TWO HOLES MISDRILLED, BS 1000, RBL 10. ROUTED OUT DAMAGE ON FRAME PER SRM 53-00-07 REPAIR 1. PERFORMED HFEC OF CUTOUT AND HFEC INSPECTION PER SRM 53-00-07 REPAIR 1 FIG 204. NO CRACKS FOUND MADE INSURANCE CUT PER SRM 53-00-07 REPAIR 1. FSDR DALA1232156818Frame · dentedFRAME DENTED, C2 CARGO BAY LT SIDE BS 1400 - INNER "FREE FLANGE". REMOVED DAMAGED AREA PER SRM 53-00-07 REPAIR 5. PERFORMED HFEC INSPECTION OF CUTOUT PER SRM 53-00-07 REPAIR 5. COMPLIED WITH OPEN HOLE EC INSPECTION IAW NDT MANUAL PT 6 51-00-16. FABRICASDR AALA20120512004Frame · crackedTHE 1418 FRAME CRACKED AT LONGERON 2 LEFT. INSTALLED DOUBLER PER SRM 53-03-00 FIGURE 31A.SDR ASAA12911633Frame · corrodedAREA AFT OF AFT CARGO COMPARTMENT FRAME, CORRODED BS 967, STR 18R, STR 19R. ACFT GROUNDED. REMOVED CORROSION, CHECKED LIMITS IAW SRM 53-00-07. ORIG THICKNESS .071. REMOVED .001 AND .070 REMAINS. AREA WITHIN LIMITS IAW SRM 53-00-07. APPLIED ALODINE AND PRIMSDR DALA12000066818Frame · damagedDENT C2, CARGO COMPARTMENT, LT SIDE STA 1320 - INNER FREE FLANGE. REMOVED DAMAGE AREA PER SRM 53-00-07 REPAIR 5. PERFORMED HFEC INSPECTION OF CUTOUT PER SRM 53-00-07 REPAIR 5. NO ITEMS REMOVED OLD DOUBLER AND FASTENERS PERFORMED BHEC INSPECTION PER SRM 53-0SDR ASAA12911547Frame · corrodedAREA AFT OF AFT CARGO COMPARTMENT FRAME CORRODED BS 967, STR 18R, STR 19R. ACFT GROUNDED. REMOVED CORROSION CHECKED LIMITS IAW SRM 53-00-07 ORIG THICKNESS .071. REMOVED .001 AND .070 REMAINS. AREA WITHIN LIMITS IAW SRM 53-00-07.SDR CALA2012051400345Frame · crackedSUPPORT TASK PERFORMED MFEC IAW EA 5310-04716, REV C. CRACK INDICATION NOTED AT STA 907, RT ACCOMPLISHED INTERIM REPAIR IAW ECRA 5310-05508. PLACED ON DIP TO ACCOMPLISH A PERM REPAIR PRIOR TO 50,000 FLT CYCLES. PLANNING TO CONTACT ENGINEERING AFTER 43,000 TSDR FDEA201205111799Frame · dentedBS 1260, STR 26L HAS A DENT IN FRAME AFT BAGGAGE. R & R FRAME STA 1260 S-25L TO S-25R IAW SRM 51-40-02 AND DWG 146N1004. MAJOR REPAIR.
Back to JASC 5311