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 07FDEA01791Frame · corrodedBULK CARGO COMPARTMENT RT FRAME 67 PANEL LAND COMMON TO FLOOR PANEL 162HF HAS 1 AREA OF CORROSION. TOTAL 4 SQUARE INCHES REMOVED CORROSION FROM UPPER FLANGE IAW A310 SRM 51-74-10 UPON REMOVAL OF CORROSION FOUND ADDITIONAL CORROSION BEYOND REPAIR BETWEEN MATINSDR NWAA072006739Frame · crackedDURING "M" CHECK, FOUND CRACKS IN FRAME WEB BS 420 AT S15R AND S17R. REPAIRED PER EA 67-29250 SECT I AND II SECTION III TO BE ACCOMPLISHED TO COINCIDE WITH INSPECTIONS PER SB 747-53A2265 UNTIL COMPLETION OF SECTION 41 MOD.SDR USAA070375Frame · crackedBS 277 FRAME WEB AT TIE CLIP S10L INBOARD ATTACH FASTENER HAS CRACK. INSTALLED FABRICATED REPAIR CHANNEL PER SRM 53-00-07, DEFECT SIZE: 1.25 INCH.SDR NWAA072129957Frame · crackedDURING "H" CHECK, FOUND CRACKS IN FRAME AT BS 1004 BETWEEN L28R AND L29R AND L28L AND L30L. REPAIRED PER EA 99-209582.SDR ZZDA070513163Frame · crackedCRACK ON CANTED FRAME STA 1178.225 BETWEEN LONGERON 16 LT AND 18 LT. INSTALLED ANGLE REPAIR 16 X 2 INCHES MAT USED 7075.0 0.80. HEAT TREATMENT TO 7075T6 GENERAL PROCESS SPECIFICATION 98 PMS 247.PS 01 AS PER SRM 51-70-11.SDR UPS07549892Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1460 BETWEEN S25R AND S26R. REPAIRED FRAME PER FINAL EA 757-5360-27-A1673 AND UPS EO B757-5310-26974-A.SDR SIMA200714035Frame · damagedMISDRILLED RIVET HOLE AT FRAME 52 AND STRINGER LH10. INSTALLED OVERSIZE FASTENERS IAW EMB IC2007-145/03228, PARAGRAPH 3.SDR SWAA072397Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20L. REPAIRED FRAME PER SRM.SDR SWAA072396Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER SRM.SDR AWXA200700594Frame · crackedMCN - FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME CRACKED, BS 440, S24R AT LOWER STOP FITTING. REPAIRED FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME, BS 440, S24R AT LOWER STOP FITTING IAW AWA ER 03-5332-07128-SS4.SDR SWIA200718383Frame · crackedSTA 640 RIGHT SIDE FRAME REINFORCEMENT DOUBLER IS CRACKED, DISCOVERED AT C-CHECK. INSTALLED STA640 RIGHT SIDE FRAME DOUBLER PER CRJ200 SRM 51-42-06 AND 51-42-21.SDR SWIA200718382Frame · crackedSTA 640 LEFT FRAME REINFORCEMENT DOUBLER IS CRACKED, DISCOVERED AT C-CHECK. INSTALLED NEW STA640 FRAME DOUBLER PER CRJ SRM 51-42-06/51-42-21.SDR QXEA200700813Frame · corrodedC4 PDX - EXTRUDED FRAME MEMBER CONNECTED TO MAIN CABIN DOOR THRESHOLD AT STATION X24.8 HAS CORROSION AROUND BOLT HOLE TOP. REPAIRED IAW SRM 51-42-05, 51-25-10,A ND 51-20-10.SDR AMWA06033EFrame · chafedAT MULTIPLE FUSELAGE STATIONS FRICTION CHAFING HAS OCCURED, THE DEPTH OF THE CHAFFING RANGES FROM .019 TO .030. REPAIRED IAW ENGINEERING AUTHENTICATION REPAIR DRAWING 1900D142-6 REVASDR SWAA072376Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA072374Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440 ,STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072365Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 277, BL 0, WL 182.1. REPAIRED WEB PER SRM.SDR 07FDEA01743Frame · corrodedAFT CARGO COMPARTMENT AT STA 1942 FROM L51L TO L51R FRAME HAS CORROSION. REMOVED AND REPLACED STIFFENERS IAW DC/MD10 SRM 51-31-01 AND 51-33-01. AFTER CORROSION REMOVAL. FABRICATED AND INSTALLED REPAIR ANGLE IAW DC/MD10 SRM 53-30-00 FIG 8 VOL I.SDR SIMA200714018Frame · damagedFUSELAGE FRAME AT FS 658 DAMAGED. REMOVED AND REPLACED DAMAGED FRAME IAW SAAB SRM 51-40-21 AND 51-40-40. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200714017Frame · damagedFOUND FUSELAGE FRAME AT FS 677 DAMAGED. REMOVED AND REPLACED DAMAGED FRAME IAW SAAB SRM 51-40-21 AND 51-40-40. AIRCARFT RETURNED TO SERVICE.SDR SWAA072320Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072325Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072326Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072311Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA072319Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072344Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072310Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA072343Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072342Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072339Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA072341Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072296Frame · corrodedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 947, STR 17R. REPAIRED FRAME PER SRM.SDR 07FDEA01716Frame · crackedMAIN DECK BODY FRAME IB CHORD IS CRACKED AT BS 930, STR 13R-14R. REPAIRED 2 FRAME BS 930 PER SRM 53-10-4 FIG 1.SDR DHL2007740513Frame · corrodedAFT CARGO BS 1030, BETWEEN STR'S 28R AND 29R, AFT SIDE OF FRAME HAS CORROSION BELOW FAIL SAFE CHORD. CORROSION REMOVAL OUT OF LIMITS PER B727 SRM 53-10-1 FIG 1. CUT OUT SHEAR TIE, FABRICATED NEW SHEAR TIE FROM 7075-T6, .071" BY 6.75" BY 4", PO NR 9004940, TRSDR KNNA200700035Frame Splice · activePASSENGER CABIN/CRACKED FRAME AT BS 767 NEAR STRINGER 14R. PROVIDE INSTRUCTIONS ON REPAIR OF CRACKED FRAME AT BS 767 STR 14R, BOEING SB 737-53A-1261 PART 3 REPAIR.SDR SIMA200714016Frame · corrodedPREVIOUS REPAIR ON FRAME 258 FOUND TO BE CORRODED. REMOVED PREVIOUS REPAIR. FABRICATED AND INSTALLED NEW REPAIR PARTS IAW SAAB SRM 53-70-30. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200714012Frame · corrodedPREVIOUS REPAIR ON FRAME 258.0 FOUND CORRODED. REMOVED PREVIOUS REPAIR, FABRICATED AND INSTALLED REPAIR PARTS IAW SAAB SRM 53-70-30. AIRCRAFT RETURNED TO SERVICE.SDR AWXA200700631Frame · crackedMCN - R2 DOOR CUT OUT FORWARD UPPER STUB FRAME CRACKED, BS 957, S12R. REPLACED R2 DOOR CUT OUT FORWARD UPPER STUB FRAME, BS 957, S12R IAW B737-300 SRM 51-40-02.SDR SWAA072265Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA072272Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072271Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072264Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA072263Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072262Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072266Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 14R. REPAIRED FRAME PER SWA EA.SDR AWXA200700764Frame · crackedMCN - MAJOR REPAIR - AFT CARGO COMPARTMENT DOOR CUT FORWARD FRAME CRACKED, BS 793.4, S24R. REPAIRED AFT CARGO COMPARTMENT DOOR CUT FORWARD FRAME, BS 793.4, S24R IAW AWA ER 03-5362-07163-SS1.SDR AWXA200700632Frame · crackedMCN - MAJOR REPAIR - AFT CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME CRACKED, BS 794, S22R - S26R. REPAIRED AFT CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME CRACKED, BS 794, S22R - S26R IAW AWA ER 03-5361-07130-ES2.SDR CALA0700245Frame · corrodedINSPECTION FOUND FRAME CORRODED AT STA 867, S25L. THE FRAME WAS REPAIRED IAW SRM 51-70-11.SDR C1HA200795006Frame · crackedCOCKPIT FRAME AT STA 277 AND STR 16RT IS CRACKED APPROX 1 INCH LONG, VERIFED BY HFEC (BEHIND FE CONSOLE). REPAIRED COCKPIT FRAME AT STA 277, STR 16RT IAW B727 SRM 53-10-2 AND 51-40-2.SDR C1HA200795029Frame · corrodedFOUND CORROSION STA 351.2 FRAME AT 28R. REMOVED EXISTING TEE CHORD FRAME, FABRICATED AND INSTALLED NEW TEE CHORD IAW B727 SRM 53-10-2 FIG 1.
Back to JASC 5311