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 SWAA071682Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071681Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071680Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071679Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071676Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071694Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, RBL 58, WL 207. REPAIRED FRAME PER ER.SDR SWAA071678Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071677Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071673Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0700160Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FORWARD CARGO DOOR CUTOUT AFT FRAME WEB AT LOWER DOORSTOP FITTING, STA 482, WL 160, S24L. THE FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR SWAA071666Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 19L. REPAIRED FRAME PER SWA EA.SDR SWAA071665Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071664Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071663Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071662Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071661Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071640Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 291.5, STR 16R. REPAIRED FRAME PER SWA EA.SDR KNNA200700019Frame · cracked3 INCH CRACK OVER BODY STATION 360 FRAME BETWEEN STRINGERS 23 TO 22. REPAIR IS IN PROGRESS IN ACCORDANCE WITH SERVICE BULLETIN B737-53A1064 AND DRAWING NUMBER 65C23267.SDR KCSA071105Frame · damagedFORWARD BILGE FUSELAGE FRAME UPPER CHORD IS DAMAGED AT STA 560, LBL 55.SDR NWAA071619993Frame · crackedDURING "H" CHECK, FOUND CRACKS IN FRAME AT APU DOOR CUTOUT BS 1005 RBL 30-LBL 30. REPAIRED PER EA 98-208491.SDR USAA070251Frame · corrodedBS 900, WL 138.5 ON FRAME HAS CORROSION. FAB'D REPAIR ANGLES, T-CHORDS, INSTALLED ALL PARTS PER SRM 51-70-12, 51-40-02; DEFECT SIZE: 12"L X 1.70"W X .041"D.SDR DLM88070455Frame · corrodedCORROSION ON FRAME AT STA 1380 BETWEEN LONGERON 28R-28L. CORROSION REMOVED AND NEW FRAME INSTALLED PER SRM 51-10-23 AND 51-10-30.SDR SWAA071634Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071622Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 1040, STR 25L. REPAIRED WEB PER SWA EA.SDR SWAA071635Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071632Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071633Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071616Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500, STR 26R. REPAIRED FRAME PER SRM.SDR KCSA071100Frame · chafedSTA 1720 RBL 46 BOTTOM OF FRAME WEB HAS 2 SMALL HOLES FROM CHAFING.SDR 07FDEA01176Frame · damagedMISDRILLED HOLE AT FRAME 13A DURING ACCOMPLISHMENT OF DR 179. REPAIR PERFORMED BY REAM UP AND COLD WORKING IAW EA 6-5312-106395 A AND RAS/AS/010/2007 ISS. CSDR UPS07549654Frame · dentedINSPECTION TYPE:C DENT IN FWD CARGO FUSELAGE FRAME STA 680, S23L. COMPLIED WITH EA 757-5332-27-A1633 & UPS EO B757-5310-26602-A.SDR UPS07549653Frame · dentedINSPECTION TYPE:C DENT IN FWD CARGO FUSELAGE FRAME STA 720 BETWEEN S23R AND S24R. COMPLIED WITH EA 757-5332-27-A1631 & UPS EO B757-5310-26595-A.SDR UPS07549651Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1850, S26R. COMPLIED WITH EA 757-5362-A1635 & UPS EO B757-5310-26623-A.SDR UPS07549650Frame · dentedINSPECTION TYPE:C DENT IN FWD CARGO FUSELAGE FRAME STA 680, BETWEEN S24R TO S25R. COMPLIED WITH EA 757-5332-27-A1630 & UPS EO B757-5310-26604-A.SDR UPS07549648Frame · dentedINSPECTION TYPE:C DENT IN FWD CARGO FUSELAGE FRAME STA 760,S24R. COMPLIED WITH EA 757-5332-A1632 & UPS EO NO B757-5310-26600-A.SDR UPS07549634Frame · dentedINSPECTION TYPE:C DENTS IN FT CARGO FUSELAGE FRAME STA 1480, BETWEEN S25L AND S26L (2EA). FRAME REPAIR AT STA 1480 BETWEEN S25L & S26L (2EA) ACCOMPLISHED PER EA 757-5362-27-A1636, WITH NO DEVIATIONS AND PER UPS EO B757-5310-26570-A.SDR UPS07549633Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1560, S26R. FRAME REPAIR AT STA 1560, S26R HAS BEEN ACCOMPLISHED PER EA 757-5362-27-A1634 WITH NO DEVIATIONS AND PER UPS EO B757-5310-26562-A.SDR NWAA071269956Frame · crackedDURING "H" CHECK FOUND, CRACK IN RT FUSELAGE FRAME AT BS 1087 L10R. REPAIRED PER EA 99-208472.SDR 2007UALA00929Frame · dentedAFT PIT STA 1440 AT STR 26L FRAME DENTED. *S/D* MAJOR REPAIR ACCOMPLISHED: TRIMMED OUT DAMAGED INBOARD FLANGE. INSTALLED A NESTED J-ANGLE DOUBLER.SDR 2007UALA00917Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED IN FWD RADIUS AT BS 727B BETWEEN STR S25R & STR S26R. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED EXTERNAL DOUBLER REPAIR.SDR A6WA200740159Frame · crackedFOUND FRAME CLIP AT FS 617 AT LBL 9 IS CRACKED .25 INCH CRACK IN RADIUS. MAINTENANCE REMOVED AND REPLACED ANGLE IAW CRJ 200 SRM 51-42-06 AND 51-42-21. (M)SDR UPS07549652Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1340 S26R. COMPLIED WITH WA 757-5362-27-A1627 & UPS EO B757-5310-23593-A.SDR UPS07549649Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1220 BETWEEN S25L TO S26L. COMPLIED WITH EA 757-5362-27-A1628 UPS EO B757-5310-26601-A.SDR UPS07549632Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1340, S26L. FRAME REPAIR AT STA 1340, S26L, ACCOMPLISHED PER FINAL EA 757-5362-27-A1629, WITH NO DEVIATIONS AND PER UPS EO B757-5310-26558-A.SDR SWAA071594Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663.75, STR 1. REPAIRED FRAME PER ER.SDR SWAA071595Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 15R TO STR 16R. REPAIRED FRAME PER ER.SDR SWAA071596Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, WL 204 RT SIDE. REPAIRED FRAME PER SRM.SDR SWAA071597Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, WL 204 LT SIDE. REPAIRED FRAME PER SRM.SDR SWAA071589Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 420, STR 26R. REPAIRED FRAME PER SRM.SDR USAA070238Frame · crackedBS 907 BETWEEN S-8L AND S-9L HAS CRACK. INSTALLED REPAIR ANGLES PER TYP REP 53-10-20E, DEFECT SIZE: .5 INCH.
Back to JASC 5311