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 SWAA084930Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA084928Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 295, RBL 54. REPAIRED FRAME PER SRM.SDR SWAA084925Frame · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 947, RBL 16. REPAIRED FRAME PER SRM.SDR SWAA084923Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA084914Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CORRODED AT LOWER END. REPAIRED FRAME PER SRM.SDR SWAA084913Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084912Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084911Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084910Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084893Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084892Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR DHLA2008745656Frame · corrodedLOWER FUSELAGE FWD CARGO COMPARTMENT BS 600 BETWEEN S-26R AND S-27R SHEAR TIE AND FRAME WITH CORROSION. REPLACED SHEAR TIE SECTION AT BS 600 BETWEEN S-26R AND S-27R IAW B727 SRM 51-10-1 PARA 7A.SDR DHLA2008745645Frame · corrodedLOWER FUSELAGE FWD CARGO COMPARTMENT AT BS 520 BETWEEN S-25R AND S-26R FRAME WITH DOUBLE HOLES AND CORROSION. REPAIRED FRAME SECTION AT BS 520 BETWEEN S-21R AND S-28R IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2008745644Frame · crackedLOWER FUSELAGE AFT CARGO COMPARTMENT BS 970 BETWEEN S-26L AND 27L FRAME CRACK. REPAIRED FRAME SECTION AT BS 970 BETWEEN S-24L AND S-28L IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2008745624Frame · crackedUPPER FUSELAGE MAIN CABIN AT BS 312 BETWEEN S-13R AND 14R FRAME WITH CRACK. REPAIRED FRAME SECTION AT BS 312 BETWEEN S-10R AND S-14R IAW B727 SRM 53-10-4 FIG 1.SDR 2008UALA05614Frame · damagedAFT PIT STA 1197+66 FRAME CAP HAS FLAKED PAINT AND LIGHT SURFACE CORROSION FROM LBL 48 - RBL 10. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW FRAME CAP.SDR DHLA2008745640Frame · damagedUPPER FUSELAGE MAIN CABIN AT STA 720C BETWEEN S-12L AND S-13L FRAME I/B FLANGE HAS DOUBLE HOLE. REPAIRED FRAME SECTION AT BS 720C BETWEEN S-11L AND S-14L IAW B727 SRM 53-10-4 FIG 1 DETAIL 1.SDR TRAX200801113Frame · corrodedCORROSION AT AFT SIDE OF FS 295 FRAME BETWEEN STR 26L AND 26R. 9/13/2008 SUP-
RESOLVED ON W/O 99022 TASKCARD NR 00165. WORK COMPLETED IAW: REMOVED (6) RIVETS FROM FS 295 BETWEEN STR 26L AND 26R TO GAIN ACCESS TO THE CORROSION. REMOVED .003" OF CORROSION FROSDR TRAX200801114Frame · corrodedCORROSION AT FWD SIDE OF FS 319 FRAME BETWEEN STR 26 AND 27L. 9/15/2008 SUP - W/O 99022 TASKCARD N/R 00164) WORK COMPLETED IAW REMOVED 5 RIVETS FROM THE 319 TO GAIN ACCESS TO THE CORROSION. REMOVED .004 OF CORROSION FROM THE FS 319 WITHIN LIMITS IAW CRJ 700 SSDR USAA920081643Frame · crackedCLT Q1 MAJOR REPAIR NR 03C10753039/007. FRAME CRACKED AT BS727D, BETWEEN S8R AND S9R. REPAIRED FRAME AT BS727D, BETWEEN S8R AND S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR UPS08553303Frame · dentedINSPECTION TYPE:C3 FRAME DENTED BS 520, 4 INCHES ABOVE STR 7R. REPAIRED FRAME PER SRM 53-00-07-2R FIG 201.SDR CALA0800869Frame · crackedBODY STATION 303.9 FRAME WEB P/N 65-17684-107 CRACKED AT S16L. BODY STATION 303.9 FRAME WEB REPLACED PER EC/RA 5310-04826.SDR CALA0800868Frame · crackedCRACK ON STIFFENER WHERE LOWER CASTING FOR L-1 DOORSTOP MOUNTS TO FRAME AT BODY STATION 303.9 AFT OF STRINGER 16 AT DOOR CUTOUT. REPAIRED FRAME AT BODY STATION 303.9 AND S16L PER EC/RA 5310-04826.SDR 08FDEA03746Frame · crackedTHE SUB-FRAME AT STA 755 HAS A CRACK BELOW THE MCD AT LONGERON 29L. MATERIAL ID FOR DOUBLER 7075-T6511, PO 568806.2; SHIM 7075-T6 0.100, PO 584757.3 AND THE FILLER 7075-T6 0.071 PO 629996.2 IAW DAC DWG NR ACA 7230 AND DC/MD-10 SRM 51-10-01; VOL III. REMOVED SDR CALA0800857Frame · crackedCABIN STA 480 FRAME CRACKED BETWEEN S8-9R. INSTALLED REPAIR PER EC/RA 5310-04824 REV A.SDR CALA0800856Frame · crackedCRACK IN BELT FRAME AT STA 827, BETWEEN S8-9R AT FASTENER FOR OVERHEAD BIN MOUNT. INSTALLED REPAIR PER EC/RA 5310-04824 REV A.SDR CALA0800855Frame · crackedCABIN STA 440 FRAME CRACKED BETWEEN S8-9R. INSTALLED REPAIR PER EC/RA 5310-04824 REV A.SDR CALA0800854Frame · crackedCRACK IN BELT FRAME BS 787 S8-9R AT FASTENER FOR OVERHEAD BIN MOUNT. INSTALLED REPAIR PER EC/RA 5310-04824 REV A.SDR CALA0800853Frame · crackedCABIN STA 400 FRAME CRACKED BETWEEN S8-9L. INSTALLED REPAIR PER EC/RA 5310-04824 REV A.SDR CALA0800851Frame · crackedCABIN STA 440 FRAME CRACKED BETWEEN S8-9L. INSTALLED REPAIR PER EC/RA 5310-04824 REV A.SDR DHLA2008745569Frame · damagedUPPER FUSELAGE CABIN BS 720E S-8R FRAME WITH HOLE. REPAIRED FRAME SECTION AT BS 720E BETWEEN S-7R AND S-9R IAW B727 SRM 53-10-4 FIG 2.SDR DHLA080904001Frame · damagedUPPER FUSELAGE PAX CABIN AT BS 700 S-8L FRAME WITH DOUBLE HOLE. REPAIRED FUSELAGE FRAME SECTION AT BS 700 BETWEEN S-6L AND S-9L IAW B727 SRM 53-10-4 FIG 1.SDR USAA920081659Frame · crackedFRAME CRACKED AT BS 500B BETWEEN S20R AND S21R. REPAIRED FRAME AT BS 500B BETWEEN S20R AND S21R IAW EA NR 100623. (K)SDR USAA920081630Frame · crackedCLT Q1 MAJOR REPAIR NR 03C10753039/005 - FRAME CRACKED AT BS380, BETWEEN S8L & S9L. REPAIRED FRAME AT BS380, BETWEEN S8L & S9L. IAW US AIRWAYS TYPICAL REPAIR NR 53-10-20E.SDR SWAA084883Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR DHLA2008745621Frame · damagedCARGO CABIN AT BS 1166 S-6R FRAME DOUBLER WITH HOLE IN RADIUS. REPLACED FRAME DOUBLER AT BS 1166 BETWEEN S-5R AND S-7R IAW B727 SRM 51-10-1 PARA 7A.SDR HNA2008F00056Beltframe · corrodedFWD EMERGENCY DOOR AREA, BELTFRAME AT STA X254 FOUND CORRODED AND SURFACE CORROSION ON DOOR SILL. AT STA X259 BLENDED BELTFRAME IAW SRM 53-00-16. CLEAT, THRESHOLD, STRAP AND BRACKET LOCALLY FABRICATED IAW DRAWINGS 8532075, 85320594, 85321705, 853206070.SDR USAA920081631Frame · crackedCLT Q1 MAJOR REPAIR NR 03C10753039/006 - FRAME CRACKED AT BS747, BETWEEN S7R & S8R. REPAIRED FRAME AT BS747, BETWEEN S7R & S8R IAW US AIRWAYS TYPICAL REPAIR NR 53-10-20E.SDR SWAA084863Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663.75, STR 2L, STR 2R AND STR 3R. REPAIRED FRAME PER SRM.SDR SWAA084858Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084849Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR 08FDEA03716Frame · damagedMAIN CABIN, STA 1540, STR 11-13L FRAME HAS DRILL STOP. REMOVED STANDOFF IAW SRM 51-40-02, REMOVED DAMAGED FRAME IAW SRM 53-00-07 STEP 1 SHEET 1 REPAIR NR 3. RECEIVED NEW CHANNELS ON TRAVELER NR T8/755741 AND T8/755739. INSTALLED NEW REPAIR CHANNELS IAW SRM SDR DHLA2008745643Frame · damagedUPPER FUSELAGE MAIN CABIN AT BS 720A AT S-8R FRAME WITH DOUBLE HOLES. REPAIRED FRAME SECTION AT BS 720A BETWEEN S-7R AND S-9R IAW B727 SRM 53-10-4 FIG 2.SDR DHLA2008745642Frame · damagedUPPER FUSELAGE MAIN CABIN AT BS 720E BETWEEN S-13L AND 14L FRAME WITH DOUBLE HOLES. REPAIRED FRAME SECTION AT BS 720E BETWEEN S-11L AND S-14L IAW B727 SRM 53-10-4 FIG 1 DETAIL 1.SDR DHLA2008745636Frame · dentedUPPER FUSELAGE MAIN CABIN AT BS 460 BETWEEN S-16R AND S-17R FRAME WITH DENT. REPAIRED FRAME SECTION AT BS 460 BETWEEN S-16R AND S-17R IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2008745635Frame · dentedUPPER FUSELAGE MAIN CABIN AT BS 500 BETWEEN S-16R AND S-17R FRAME WITH DENT. REPAIRED FRAME SECTION AT BS 500 BETWEEN S-16R AND S-17R IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2008745634Frame · dentedUPPER FUSELAGE MAIN CABIN AT BS 520 BETWEEN S-16R AND 17R FRAME WITH DENT. REPAIRED FRAME SECTION AT BS 520 BETWEEN S-16R AND S-17R IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2008745633Frame · dentedUPPER FUSELAGE MAIN CABIN AT BS 580 BETWEEN S-16R AND 17R FRAME WITH DENT. REPAIRED FRAME SECTION AT BS 580 BETWEEN S-16R AND S-17R IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2008745632Frame · dentedUPPER FUSELAGE MAIN CABIN AT BS 600 BETWEEN S-16R AND 17R FRAME WITH DENT. REPAIRED FRAME SECTION AT BS 600 BETWEEN 16R AND 17R IAW B727SRM 51-40-3 FIG 1.SDR DHLA2008745631Frame · dentedUPPER FUSELAGE MAIN CABIN AT BS 640 BETWEEN S-16R AND 17R FRAME WITH DENT. REPAIRED FRAME SECTION AT BS 640 BETWEEN S-16R AND S-17R IAW B727 SRM 51-40-3 FIG 1.
Back to JASC 5311