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 AALA20120625004Strap · corrodedFORWARD CARGO FAILSAFE STRAP CORRODED. REMOVED AND REPLACED FAILSAFE STRAP PER SRM 51-10-02.SDR SWAA2012072306097Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STR 24R TO STR 25R. REPAIRED FRAME IAW EA.SDR SWAA2012070205453Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STR 20R AND STR 21R. REPAIRED FRAME PER SRM.SDR IPXA2574085Frame · dentedINSPECTION TYPE: C, FRAME STA 820, STR 23R IS DENTED. REPAIRED FRAME IAW RCD 145614 AND SRM 53-00-07-2R.SDR SWAA2012071805940Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012071805939Frame · corrodedFRAME CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012071705907Frame · corrodedFRAME CORRODED AT BS 727D, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012071705906Frame · corrodedFRAME CORRODED AT BS 727D, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012070905644Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR CHQA20120623203Frame · corrodedDURING INSPECTION, RIGHT FRAME 23 WAS FOUND TO BE CRACKED AT THE OUTBOARD EDGE AND BELOW THE FLOORBOARD. FRAME 23 WAS REPLACED IN ACCORDANCE WITH ETD 2012-145-008993.SDR SWAA2012070505550Frame · crackedSTUB FRAME CRACKED AT STA 294.5, BETWEEN STR 7R & STR 8R. REMOVED AND REPLACED STUB FRAME PER SRM.SDR DALA1238461504Frame · crackedMAIN DECK FS 903 LT BETWEEN STR 20L AND 21L FRAME INNER CHORD CRACKED. THE INNER CHORD CRACK REMOVED AND REPAIRED AS PER ERA 502721-14AD REV ORG.SDR SWAA2012071605835Frame · crackedFRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW IR AND EA.SDR IPXA2M74369Frame · dentedINSPECTION TYPE:4C, FRAME 685, DENTED BETWEEN L12R AND L13R. REPAIRED FS 695 FRAME BETWEEN L12R AND L13R REF EA011-5310-01-A4 041 REV I/R, EO MD11-5310-47852-A.SDR DALA1241149264Frame · corrodedAFT CARGO BAY BS 1307 FRAME CORRODED BETWEEN LONGERON 28 RT AND LONG 28 LT. REMOVED CORROSION FOUND OUT OF LIMITS CUTOUT DAMAGED AREA. FABRICATED FRAME REPAIR TREATED PRIMED AND TOP COAT ALL PARTS. INSTALLED FRAME REPAIR. REF DWG SR09530057.SDR QXEA2012062200571Frame · corrodedFRAME AT STA 94.8 BETWEEN STR 33 AND 28S IS CORRODED. REMOVED JOINT SPLICE IAW SRM 51-42-05-2-01. MATCH DRILLED NEW FRAME MEMBER TO EXISTING STRUCTURE IAW SRM 51-40-07-02-01. ALODINED, PRIMED AND PAINTED AND REAPPLIED SURFACE PROTECTION IAW SRM 51-21-10-02-SDR SWAA2012070905672Frame · crackedCABIN FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012070905671Frame · crackedFRAME CRACKED AT BS 867, BETWEEN STR 8R AND STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012070905670Frame · crackedFRAME CRACKED AT BS 727D, BETWEEN STR 8R AND STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012070905661Frame · crackedFRAME CRACKED AT BS 727D, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012070905660Frame · crackedFRAME CRACKED AT BS 747, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012070905659Frame · crackedFRAME CRACKED AT BS 827, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012070905638Frame · crackedFRAME CRACKED AT BS 867, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012070205500Frame · crackedFRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012070205496Frame · crackedFRAME CRACKED AT BS 867, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012070205495Frame · crackedFRAME CRACKED AT BS 787, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR DALA1238650633Frame · dentedDENT ON FRAME BS 660 S26L. REPAIRED IAW SRM 53-00-07 FIG 201 REPAIR 5.SDR SWAA2012072306090Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW EA.SDR USAA2012072300031Frame · crackedQ1 CHECK - CRACK IN FUSELAGE FRAME AT BS 500C, S9L. REPAIRED FUSELAGE FRAME AT BS 500C, S9L IAW TYPICAL REPAIR #TR737-5310-0287.SDR USAA2012072300030Frame · crackedQ1 CHECK - CRACK IN FUSELAGE FRAME AT BS 907, S9L. REPAIRED FUSELAGE FRAME AT BS 907, S9L IAW TYPICAL REPAIR #TR737-5310-0287.SDR FDEA201206212289Frame · chafedCABIN, STA 1280, STR 11R HAS CHAFING ON FRAME. REPAIRED IAW SRM 53-00-07 REV. 106, REPAIR 3, FIG. 201. REPAIR IS MAJOR.SDR SWAA2012070505541Frame · crackedFUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER EA.SDR SWAA2012070505540Frame · crackedFUSELAGE FRAME CRACKED AT BS 500B, STR 19R TO STR 22R. REPAIRED FRAME PER EA.SDR SWAA2012070505539Frame · crackedFUSELAGE FRAME CRACKED AT BS 500B, STR 20L TO STR 21L. REPAIRED FRAME PER EA.SDR USAA2012070300003Frame · crackedFORWARD PRESSURE BULKHEAD INSPECTION FUSELAGE FRAME CRACKED AT BS 500G, BETWEEN S20R & S21R. REPAIRED FRAME IAW B737 SRM 53-00-07-2R-13.SDR USAA2012062900004Frame · crackedFPBH INSPECTION - FRAME CRACKED AT BS 500F BETWEEN S20L AND S21L. REPAIRED FRAME AT BS 500F BETWEEN S20L AND S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2012062500012Frame · crackedFORWARD PRESSURE BULKHEAD INSPECTION, FRAME CRACKED AT BS 500D, BETWEEN S20L & S21L. REPAIRED FRAME IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2012062500011Frame · crackedFORWARD PRESSURE BULKHEAD INSPECTION, FRAME CRACKED AT BS 500C, BETWEEN S20R & S21R. REPAIRED FRAME IAW B737 SRM 53-00-07 REPAIR 13.SDR SWAA2012070505538Frame · crackedFUSELAGE FRAME CRACKED AT BS 639, STR 17L. REPAIRED FRAME PER EA.SDR SWAA2012070205459Frame · crackedFRAME INNER CHORD CRACKED AT BS 616, RBL 60.5. REPAIRED CHORD IAW EA.SDR SPUY20120620018Frame · deformedMAIN CARGO BAY FRAME DEFORMED, BS 380.SDR FDEA201206202283Frame Splice · corrodedBS 1560, FRAME SPLICE CORRODED BETWEEN STR 24R AND 25R. REMOVED CORROSION AT FRAME SPLICE STA 1560 AT STR. 24 & 25R IAW-SRM-51-10-02. BLENDED AREA ORIG MAT .071, MAT REMAINING .034, NO ALLOWED DAMAGE ON SRM. R & R SPLICE IAW-SRM-51-40-02, FABRICATED SPLICE SDR SPUY20120620003Frame · deformedFWD CARGO BAY FRAME DEFORMED BS 560, STRINGER 24L TO 25L.SDR SPUY20120620001Frame · crackedFWD CARGO BAY FRAME CRACKED .5" BS 580, STRINGER 23L TO 25L.SDR SPUY20120620002Frame · deformedFWD CARGO BAY FRAME DEFORMED BS 520, S22-26L.SDR DALA1240680918Frame · corrodedUPON REMOVAL OF FORMERS FOUND FRAME BS 1322 BETWEEN L27L-28R HAS CORROSION 90 PERCENT LOSS OF MATERIAL. CUT OUT DAMAGED FRAME SECTION. FABRICATED AND INSTALLED NEW SECTION AT BS 1322 L25L- L29R IAW SRM 51-30-2.SDR SWAA2012070205423Frame · crackedFRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012070205422Frame · crackedFRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012070205421Frame · crackedFRAME CRACKED AT BS 867, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012070205420Frame · crackedCABIN FRAME CRACKED AT BS 787, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.
Back to JASC 5311