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 SWAA070590Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA070588Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA070589Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA070587Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR UPS07549222Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO FUSELAGE FRAME STA 1540, S26L(2EA). FRAME REPAIR STA 1540, S26L HAS (2EA) DENTS, REPAIR HAS BEEN ACCOMPLISHED PER EA 757-5362-27-A1604 WITH NO DEVIATIONS AND PER UPS EO B757-5310-26177-A.SDR UPS07549221Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO FUSELAGE FRAME STA 1560 BETWEEN S25R TO S27R (2EA). FRAME REPAIR AT STA 1560, S25R TO S27R HAS BEEN ACCOMPLISHED PER EA 757-5310-27-A1600 WITH NO DEVIATIONS AND PER UPS EO B757-5310-26178-A.SDR UPS07549214Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1580 S25R TO S26R. FRAME REPAIR AT STA 1580, S25R TO S26R HAS BEEN ACCOMPLISHED PER EA 757-5362-27-A1601, WITH NO DEVIATIONS AND PER UPS EO B757-5310- 26153-A.SDR UPS07549213Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1500. FRAME REPAIR AT STA 1500, S26R HAS BEEN ACCOMPLISHED PER EA 757-5362-27-A1603 WITH NO DEVIATIONS AND PER UPS EO B757-5310-26 9176-A.SDR UPS07549212Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1280, S26L. FRAME REPAIR AT STA 1280, S26L HAS BEEN ACCOMPLISHED PER EA 757-536 2-27-A1602 WITH NO DEVIATIONS AND PER UPS EO B757-5310-26175-A.SDR DL757070071Frame · buckledFRAME DAMAGED FROM IMPACT WITH GSE EQUIP. NEW FRAME SECTION FABRICATED AND SPLICED PER SRM.SDR SWAA070580Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070583Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070582Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070581Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070584Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR 07FDEA00297Frame · tool damageMAIN CABIN BS 620 BETWEEN STR S-3L AND S-4L UPPER SILL TO FRAME SPLICE AREA HAS 2. MISDRILLED HOLES AND 1 OVER CHAMFERED HOLE (VIEW FROM AFT SIDE) COMPLIED WITH EA NR 7-5310-106977 (WRI53108462) AND AAR WO NR 11701/2400/0004 PART 1, ITEM 1 THRU 10 ACCOMPLISHSDR K11A2008112191503Frame · bentSTA 58 FRAME INNER FLANGE BENT LBL 27 10 INCHES UP FROM NOSE GEAR DOOR OPENING.SDR AWXA200700268Frame · crackedMCN - FOUND CRACKED R1 DOOR CUT OUT FORWARD STUB FRAME, BS 294, S16R - S16R. REPLACED R1 DOOR CUT OUT FORWARD STUB FRAME, BS 294, S16R - S16R IAW B737-300 SRM 51-40-02.SDR ASAA0741434Frame · crackedFUSELAGE FRAME CRACKED ON LWR FLANGE. REPAIRED WITH REPAIR PART PER SRM 51-40-02.SDR SWAA070569Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070567Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA070571Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070570Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070568Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA070566Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R AND 8L. REPAIRED FRAME PER SWA EA.SDR SWAA070565Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR DLM88070757Frame · crackedDURING HMV-3 A CRACK WAS FOUND IN THE FS 864 RT OVERWING FRAME JUST BELOW THE FLOOR LINE. A NEW FRAME WAS INSTALLED PERS/B MD80-53A301.SDR UPS07M49373Frame · crackedINSPECTION TYPE:C CTR CARGO BILGE AREA STA 1841 FRAME WEB ABOVE LONGERON 45R FOUND CRACKED AS MARKED. ATTACHED CRACK WEB SUPPORTS & FASTENERS REMOVED FOR ACCESS. NEW WEB P/B AGA7170-4 FAB & FASTENERS HOLE PICKED UP PER SRM 51-31-01V 2 REV38. REWORKED & PAINSDR SWAA070537Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070545Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070546Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070547Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, LBL 63, WL 202. REPAIRED FRAME PER ER.SDR SWAA070544Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R AND 8L. REPAIRED FRAME PER SWA EA.SDR SWAA070527Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA070509Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA070508Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070518Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 21R. REPAIRED FRAME PER SRM.SDR SWAA070507Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070510Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070506Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070503Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 63, WL 202. REPAIRED FRAME SECTION PER ER.SDR SWAA070511Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070505Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR USAA070077Frame · crackedFOUND FRAME WITH TWO CRACKS, .250" AND .750", BS 492 S-24R, WL 160, WL 162. FABRICATED AND INSTALLED REPAIR PARTS AND MACHINED TWO DOOR STOP FITTINGS PER EA 98426, DEFECT SIZE: .250" AND .750".SDR USAA070078Frame · crackedFOUND FRAME WITH TWO CRACKS 1 INCH AND 1/4 INCH, STA 440, WL160 AND WL 162. TRIMMED OUT DAMAGE, FAB'D DOUBLERS AND SHIMS AND INSTALLED PER EA 98425, DEFECT SIZE: 1" AND 1/4".SDR 07FDEA00223Frame · crackedRT MLG W/W FOUND 1 CRACK 2" LONG ON FRAME AT STA 1505 X= 96. REPLACED FRAME IAW SRM 51-35-01 VOL 2 AND DWG AEA0439 WITH NEW P/N AEA0439-4.SDR LR7A07011Frame · crackedDURING SCHEDULED A CHECK PER JOB CARD HA1200, FOUND RING FRAME CRACKED AT FS 386, WL160-174, RBL79. REPAIRED FRAME IAW LAC MEA 382-53-07-009.SDR SWAA070480Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 947.5, STR 3L. REPAIRED FRAME SECTION PER SRM.SDR SWAA070479Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR USAA070073Frame · crackedFOUND FRAME CRACKED, BS 847 S-23R WL 160. REMOVED DAMAGE AND INSTALLED REPAIR ANGLES PER EA 98427 REV A, DEFECT SIZE: .500.
Back to JASC 5311