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 SWAA081950Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT LEFT BS 616 INBOARD LOWER END. REPAIRED FRAME PER SRM.SDR SWAA081949Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT RIGHT BS 616 INBOARD LOWER END. REPAIRED FRAME PER SRM.SDR SWAA081980Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081987Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081986Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081985Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081984Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081983Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081982Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081981Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081988Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081979Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081989Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8R. REPAIRED FRAME PER SWA EA.SDR C2XA08SH064Frame · damagedSHV - DURING C-CHECK FR 15 DAMAGE AT STR 2R FROM COCKPIT DOOR HINGE PIN. MX REPAIRED FR 15 AT STR 2R IAW EMB 145 SRM 53-00-04 FIG 206. THE AIRCRAFT WAS APPROVED TO RETURN FOR SERVICE.SDR A6WA200840344Frame · crackedCRACK FOUND ON FRAME FS 280 RBL 9 WL 73. FRAME AT FS 280, RBL 9, WL 73 REPAIRED IAW RWO 601R-53-11-171 REV "D" SCHEME "B". .SDR A6WA200840343Frame · crackedCRACK FOUND ON FRAME 280, LBL 9 WL 73.00. - - FRAME AT FS 280 LBL 9 WL 73.00 REPAIRED IAW REO 601R-53-11-171 REV "D" SCHEME B. .SDR UPS08852098Frame · bentINSPECTION TYPE:C1 MAIN CARGO COMPT STA 1580 RT SIDEWALL STRUCTURE FRAME IS BENT 10" ABOVE CUSP. REMOVED FRAME SECTION FABRICATED FRAME SECTION AND 2 SPLICES. INSTALLED FRAME SECTION AND 2 SPLICES.SDR CALA0800347Frame · crackedLEFT SIDE STA 400 BETWEEN S-8 AND AC BRACKET FASTENER HOLE CRACKED. REPAIRED LEFT FRAME 400 BETWEEN S-8 AND S-9 PER EA 5310-04498, OP 02.SDR 2008UALA02135Frame · gougedAFT CABIN FRAME 69 GOUGED RT SIDE AT -Y1162. MAJOR REPAIR ACCOMPLISHED: INSTALLED ANGLE REPAIR.SDR K11A2008112072305Frame · corrodedFRAME, CORROSION OUT OF LIMITS STA 227R 16 INCHES OFF CABIN FLOOR.SDR 2008UALA02115Frame · damagedRT FUSELAGE FRAME BS 440 HAS MISDRILLED HOLES AT STR'S 14-15-16. MAJOR REPAIR ACCOMPLISHED: REPLACED FWD FRAME.SDR 2008UALA02095Frame · crackedBS 616 LT OVERWING FRAME IS CRACKED AT INNER CHORD. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE AND VERIFIED REMOVAL WITH HFEC. INSTALLED REPAIR ANGLE AND FILLER.SDR 2008UALA02084Frame · dentedDENTED FUSELAGE FRAME, INBOARD FLANGE AT BS 540 BETWEEN STR 24L AND 25L. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGED FRAME FLANGE. FABRICATED & INSTALLED A REPAIR ANGLE J-SECTION, STRINGER CLIP (P/N 140N2001-80) & SHEAR TIE (P/N 140N2002-664).SDR SWAA081922Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081926Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081923Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081924Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081925Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR K11A2008112072302Frame · corrodedFRAME, CORROSION TO BE OUT OF LIMITS STA 211 APPROX 19 INCH FROM CABIN FLOOR.SDR ASAA0842883Frame · misrepairedAFT PIT REPAIR FOR FRAME AT STA 767 BETWEEN STR 25 26R HAS IMPROPER EDGE DISTANCE. REMOVED IMPROPER REPAIR AND INSTALLED NEW FRAME REPAIR IAW B737 400 SRM 51 70 11 FIG 1 AND 51 40 02.SDR ASAA0842882Frame · corrodedCORROSION ON BACKSIDE OF FRAME AT STR 25R AT SKIN ATTACH ANGLE STA 767. CUT OUT DAMAGED SECTION OF ATTACH ANGLE AND INSTALLED REPAIR SHEAR TIE AND DOUBLER IAW B737 400 SRM 53 00 07 FIG 201 AND 51 40 02.SDR USAA920080970Frame · corrodedMCN - MAJOR REPAIR - C21 CHECK - CORROSION ON FRAME, BS 800, S25R. REPLACED FRAME, BS 800, S25R IAW B737 SRM 51-40-02.SDR 2008UALA02072Frame · puncturedAFT PIT STA 1263 FRAME WEB HAS A PUNCTURE ABOVE STR 39L AND 39R. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW SRM 51-70-13 AND SRM 51-40-02. AC OK FOR SERVICE.SDR SWAA081898Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 21L. REPAIRED FRAME PER SRM.SDR SWAA081899Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 420, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA081903Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER ER.SDR KCSA081221Frame · damagedBS 1760 FUSELAGE FRAME LOWER CHORD DAMAGED BETWEEN STR-39R AND STR-40R.SDR CALA0800378Frame · crackedSTATION 440 LT SIDE BETWEEN S8LT AND S9LT AT AC BRACKET I/B FASTENER HOLE IS CRACKED. CUT OUT DAMAGED HOLE AT STATION 440 LT BETWEEN S9LT & S8LT, REPAIRED DAMAGED FRAME PER EA5310-04498.SDR CALA0800377Frame · crackedSTATION 827 LT BETWEEN S8LT AND S9LT AT AC BRACKET I/B FASTENER HOLE IS CRACKED. REMOVED AC BRACKET IAW B737 SRM 51-40-02, CUT OUT DAMAGED HOLES IAW EA5310-04498, MATERIAL ID FOR REPAIR ANGLES "A" & "B" 7075-0 .040 IAW B73753-60-07 AND EA5310-04498, HEAT TREASDR CALA0800376Frame · crackedSTATION 400 LT BETWEEN S8LT & S9LT AT AC BRACKET I/B FASTENERS ARE CRACKED. REPAIRED CRACKED FRAME AT STATION 400 BETWEEN S8LT AND S9LT AT AC BRACKET IAW EA5310-04498.SDR CALA0800375Frame · crackedSTATION 867 LT SIDE BETWEEN S8LT AND S9LT AT AC BRACKET I/B FASTENER HOLE IS CRACKED. REMOVED A/C BRACKET IAW B737 SRM 51-40-02. MADE ID FOR REPAIR ANGLES "A" & "B" 7075-0 040 IAW EA5310-04498, HEAT TREATED ANGLES TO 7075T6 IAW BAC5602. ALODINED & PRIMED IASDR CALA0800374Frame · crackedCRACK IN FRAME AT STATION 360 ABOVE S8LT. REPAIRED CRACKED FRAME AT STATION 360 ABOVE S8LT IAW EA 5310-0 498 CAL EC/RA5310-04752.SDR CALA0800373Frame · crackedSTATION 787 LT SIDE BETWEEN S8LT AND S9LT AT AC BRACKET I/B FASTENER HOLE IS CRACKED. REPAIRED CRACKED FRAME AT STA 787 LT SIDE BETWEEN S8LT AND S9LT AT AC BRACKET IAW EA 5310-04498.SDR CALA0800372Frame · crackedSTATION 787 RT SIDE BETWEEN S8RT AND S9RT AT AC BRACKET I/B FASTENER HOLE IS CRACKED. ACCOMPLISHED REPAIR AT STA 787 RT SIDE BETWEEN S8RT & S9RT AC BRACKET I/B FASTENER HOLE PER EA 5310-04498.SDR CALA0800371Frame · crackedSTATION 747 LT SIDE BETWEEN S8LT AND S9LT AT AC BRACKET I/B FASTENER CRACKED. REPAIRED CRACKED FRAME AT STATION 747 LT SIDE BETWEEN S8LT & S9LT AT AC BRACKET IAW EA 5310-04498.SDR CALA0800370Frame · crackedSTATION 869 RT SIDE BETWEEN S8RT AND S9RT AT AC BRACKET I/B FASTENER CRACKED. ACCOMPLISHED FRAME REPAIR PER CAL EC/RA 5310-04755.SDR UIEA200800144Frame · deformedMAIN DECK STA 1780 STRINGER 15R FRAME FOUND DEFORMED. FRAME REPAIRED PER ATLAS EO NR 4753B141.SDR UIEA200800143Frame · deformedMAIN DECK STA 1860 STRINGER 12R FRAME FOUND DEFORMED. FRAME REPAIRED PER ATLAS EO NR 4753B141.SDR UIEA200800142Frame · deformedMAIN DECK STA 1840 STRINGER 12R - 13R FRAME FOUND DEFORMED. FRAME REPAIRED PER ATLAS EO NR 4753A141.SDR UIEA200800145Frame · crackedMAIN DECK STA 1980 STRINGER 11R FRAME FOUND CRACKED. FRAME REPAIRED PER ATLAS EO NR 4753A141.
Back to JASC 5311