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 SWAA087049Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087048Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087047Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087040Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 727B, STR 18R. REPAIRED FRAME PER SRM.SDR SWAA087034Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME STUB BEAM WEB CRACKED AT BS 685, RBL 45, WL 208. REPAIRED WEB PER ER.SDR CALA2008121101139Strap · crackedSTRAP ON BOTTOM OF FRAME CRACKED AT STATION 328 BL-0. FABRICATED REPAIR PARTS AND LOCATED HOLES PER SRM 53-10-51, ALODINED AND PRIMED REPAIR PARTS PER SRM 51-20-01. INSTALLED REPAIR PARTS PER SRM 53-10-51 AND SRM 51-40-02.SDR MALA080219Frame · chafedDURING N4K, 2Y INSPECTIONS IN CWA, FOUND FRAME AT STA363 AT SL1605 CHAFED. REMOVED AND REPLACED INNER FLANGE REINFORCEMENT ANGLE P/N 7253742-111, IAW SAAB 51-40-21 AND EO NR S53644.SDR SWAA087029Frame · crackedDURING SCHEDULED SPV CHECK, FOUND BS 178 BULKHEAD CHORD CRACKED, LBL 17, WL 218. REPAIRED WEB PER SRM.SDR SWAA087015Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND MID CABIN LT FRAME WEB CRACKED AT BS 639, WL 215. REMOVED AND REPLACED WEB PER DWG.SDR SWAA086990Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA086989Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA086988Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND STUB BEAM WEB CRACKED AT BS 685, RBL 45. REPAIRED FRAME PER ER.SDR SWAA086968Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR CALA2008121001135Frame · crackedAIR CONDITIONING SUPPORT BRACKET ATTACHED TO THE FRAME BETWEEN STRINGERS 8 AND 9 IS CRACKED AROUND RIVET AT STA 787L. TRIMMED OUT CRACKED AREA OF FRAME AND INSTALLED REPAIR DOUBLERS AND FILLERS PER ECRA 5311-01439. INITIATED DIP 91636 TO READ AS FOLLOWS, BEFSDR USAA2008121792251Frame · crackedCLT - Q5 - MAJOR REPAIR - FRAME CRACKED BETWEEN BS 480, S8R & S9R. REPAIRED FRAME BETWEEN BS 480, S8R & S9R IAW TYPICAL REPAIR 53-10-20E.SDR AALA200810489Frame · crackedFRAME CRACKED AT STATION 1418 LONGERON 2L. REPAIRED PER SRM 53-01-00 FIGURE 2.SDR USAA2008121092214Bracket · corrodedPIT - C7-C3 BRIDGE - MAJOR REPAIR - GALVANIC CORROSION ON FRAME BRACKET AT FR 365, -Z240. REPLACED FRAME BRACKET AT FR 365, -Z240 IAW SRM 53-11-14. UPON FURTHER EVALUATION, FOUND DISCREPANCY TO BE LEVEL 2 CORROSION.SDR DHLA2009770AT529Frame · corrodedLOWER FUSELAGE AT BS 740 BTWN S-27L AND S-28L FRAME WITH CORROSION. REPLACED FUSELAGE CHORD SECTION AT BS 740 BTWN S-27L AND S-28L IAW B727 SRM 51-10-1 PARA 7A.SDR AALA200810493Frame · crackedCANT FRAME CRACKED STATION 1510 BELOW MAIN LIGHT SWITCH LEFT SIDE AT TAIL CONE ALIGNMENT PIN. INSTALLED DOUBLER PER EA MD80 53-005083.SDR AALA200810492Frame · crackedFRAME CRACKED, STA 1510 BELOW RT LOWER TAIL CONE LATCH AT 2 EACH ALIGNMENT PINS. INSTALLED REPAIR DOUBLER IAW 53-005083.SDR ASAA0873992Frame · corrodedCORROSION ON FRAME BS 947.5 I/B FLANGE. REMOVED CORROSION ON FRAME AND FOUND OUT OF LIMITS AT LBL 12. REPAIRED BS 947 FRAME AT LBL 12.SDR FDEA200812085104Frame · corrodedNOSE WHEEL WELL "T" ANGLE CORRODED STA 280 STR 26R. FABRICATED NEW "T" ANGLE FROM 60-10936 7075-0 EXTRUSION PO NR 8270223 DIMS 19 INCH BY 3 INCH, HEAT TREATED EXTRUSION TO T-6 CONDITION INSTALLED NEW "T" ANGLE AT BS 280 STR 26R IAW MM 51-30-5 AND BOEING DWG 6SDR AALA200810474Frame · crackedCRACK IN DOUBLER REPAIR AT BASE OF ACTUATOR CRADLE AT FRAME STATION 1485. INSTALLED SERVICEABLE DOUBLER PER AARD 53-10-00-33.SDR ASOA200801669Frame · corrodedRT 280 FRAME UPON FURTHER INVESTIGATION FOUND CORROSION TO BE OUT OF LIMITS. REMOVED AND REPLACED RT FS280 BEAM IAW CRJ 700 SRM 51-20-006, 51-24-28, 51-21-00, 51-42-06, 51-42-00, 51-42-21, 51-42-13, IS670531120026 AND IS670531100026, AD KMT ORD 10048994, BAT SDR ASOA200801668Frame · corrodedLT 280 FRAME UPON FURTHER INVESTIGATION FOUND CORROSION TO BE OUT OF LIMITS. LT 280 BEAM REMOVED AND REPLACED PER CRJ700 SRM 51-42-06 AND 51-42-21, PER MODSUM IS67053110026,SRM 51-42-13, SB670BA-53-026, CRJ 700 SRM 51-21-16 AND CRJ 700 SRM 51-21-11.SDR USAA2008121692236Frame · crackedCLT - Q2 - MAJOR REPAIR - FUSELAGE FRAME CRACKED ON UPPER FLANGE AT BS 380, ABOVE S21L & S22L. REPAIRED FUSELAGE FRAME ON UPPER FLANGE AT BS 380, ABOVE S21L & S22L IAW B737 SRM 51-20-01 & US AIRWAYS TYPICAL REPAIR 53-60-07A.SDR ASAA0873997Frame · crackedAFT CARGO BAY DOOR CUTOUT FWD FRAME CLOSEOUT WEB CRACKED. REMOVED AND REPLACED WEB.SDR SWAA086879Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086878Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086872Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 794, BETWEEN STR 24R TO STR 25R. REPAIRED FRAME PER SRM.SDR SWAA086868Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 291, STR 16R. REPAIRED FRAME PER AAR EA.SDR SWAA086865Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SWA EA.SDR SWAA086864Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086858Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR UALA2008120406755Frame · corrodedAFT TRIANGLE SHEAR PLATE ATTACH FRAME TO FUSELAGE CORRODED. REMOVED FRAME, DRILLED NEW FRAME NEEDS INSTALL. FRAME AND PLATE REPLACED COMPLETE. INSPECTED INSTALLATION AFT RT TRIANGLE TO FUSELAGE SHEAR PLATE SUPPORT FRAME.SDR SWAA086854Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 294, BETWEEN STR 2R TO STR 3R. REPAIRED FRAME PER SRM.SDR SWAA086852Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SRM.SDR ASOA200801647Frame · corrodedCORROSION AT AFT SIDE OF THE BELLY FRAME LOWER FLANGE AT FS 349.00 BETWEEN STR 27 AND 26R. REMOVED CORROSION AT AFT SIDE OF THE BELLY FRAME LOWER FLANGE AT FS 349.00 BETWEEN STR 27 AND 26R IAW SRM 51-21-06 SKIN THICKNESS WITHIN LIMITS. ALODINED, PRIMED ANDSDR ASOA200801646Frame · corrodedCORROSION AT FWD SIDE OF THE BELLY FRAME LOWER FLANGE AT FS 317.00 BETWEEN STR 27 AND 26R. REMOVED CORROSION AT FWD SIDE OF THE BELLY FRAME LOWER FLANGE AT FS 317.00 BETWEEN STR 27 AND 26R IAW SRM 51-21-06 SKIN THICKNESS WITHIN LIMITS. ALODINED PRIMED AND PSDR AALA200810451Frame · cracked0.250 CRACK AT RIGHT CANT FRAME STATION 1474, AFT OF ELEVATOR ACCUMULATOR ACCESS. 5.5 INCH BY 3.5 INCH, .040 7075 T6 DOUBLER INSTALLED AFTER END OF CRACK STOP DRILLED.SDR UALA2008120406750Frame · dentedFWD PIT FRAME DENTED STA 520 AT STR 24L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED I/B FLANGE AND INSTALLED J-ANGLE REPAIR.SDR SWAA086813Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 663, STR 3R. REPAIRED FRAME PER SRM.SDR SWAA086812Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086811Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086810Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 807, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM.SDR SWAA086809Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA086808Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 747, BETWEEN STR 26R, TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA086803Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, BETWEEN STR 26R, TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA086800Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086799Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.
Back to JASC 5311