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 CALA0800679Frame · crackedLEFT STATION 827 L FRAME CRACKED AT AIR CONDTIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. CUT OUT CRACKED SECTION OF BS 827 FRAME BETWEEN STR 8 LEFT AND STR 9 LEFT AND INSTALLED REPAIR ANGLES IAW EA 5310-04498.SDR CALA0800678Frame · crackedLEFT STATION 867 FRAME CRACKED AT AIR CONDTIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. CUT OUT DAMAGE AT FRAME STATION 867 LEFTHAND BETWEEN S-8 AND S-9, REPAIRED PER EA 5310-04498.SDR CALA0800677Frame · crackedLEFT STATION 907 FRAME CRACKED AT AIR CONDTIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. CUT OUT DAMAGE AT FRAME STATION 907 LEFTHAND BETWEEN S-8 AND S-9, REPAIRED PER EA 5310-04498.SDR CALA0800676Frame · crackedLEFT STATION 747 FRAME CRACKED AT AIR CONDTIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. CUT OUT DAMAGE AT STATION 747 LEFT S-8 AND S-9 AND REPAIRED PER EA 5310-04498.SDR CALA0800675Frame · crackedLEFT STATION 559 FRAME CRACKED AT AIR CONDTIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. INSTALLED REPAIR ANGLES STATION 559 LEFTHAND BRACKET BETWEEN S-8 AND S-9 PER EA5310-04498.SDR CALA0800674Frame · crackedLEFT STATION 597 FRAME CRACKED AT AIR CONDTIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES AT STATION 597 BETWEEN S-8 AND S-9 PER EA5310-04498.SDR CALA0800673Frame · crackedLEFT STATION 520 FRAME CRACKED AT AIR CONDTIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES PER EA 5310-04498 AT STATION 520 LEFTHAND FRAME BETWEEN S-8 AND S-9.SDR CALA0800672Frame · crackedLEFT STATION 482 FRAME CRACKED AT AIR CONDTIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES AT STATION 482 LEFTHAND BETWEEN S-8 AND S-9 PER EA5310-04498.SDR CALA0800671Frame · crackedLEFT BS 787 FRAME CRACKED AT AIR CONDTIONING (A/C) BRACKET BETWEEN S-8 AND S-9 INBOARD HOLE. CUT OUT CRACKED SECTION OF BS 787 FRAME BETWEEN STR 8 LEFT AND STR 9 LEFT AND INSTALLED REPAIR ANGLES IAW EA 5310-04498.SDR USAA920081295Frame · crackedCLT- Q3 MAJOR REPAIR 03C10753041/006- FRAME CRACKED AT BS 500A BETWEEN S-8L AND S-9L. REPAIRED FRAME AT BS 500A BETWEEN S-8L AND S-9L IAW TYPICAL REPAIR 53-10-20E.(B)SDR 2008UALA03721Frame · dentedAFT PIT FRAME DENTED STA 1400, STR 25-27L. ACCOMPLISHED MAJOR REPAIR AT GSO. CUT OUT DAMAGE AND INSTALLED DOUBLER RPR PER SRM 53-00-07, RPR 5. VERIFIED DAMAGE REMOVAL PER NDT 51-00-19.SDR SWAA083707Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986.5, STR 2L. REPAIRED FRAME PER SRM.SDR SWAA083720Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083701Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 947, STR 11L. REPAIRED FRAME PER SWA EA.SDR SWAA083700Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, STR 17L. REPAIRED FRAME PER SWA EA.SDR SWAA083696Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 15R. REPAIRED FRAME PER SRM.SDR SWAA083691Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 13L. REPAIRED FRAME PER ACO & EA.SDR SWAA083692Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME SWA EA.SDR 08FDEA02700Frame · damagedFOUND MISDRILLED HOLE AT C 75A, P26 LT. REPAIR PERFORMED BY INSTALLING A BUSH IAW RAS/EFW/9000050/2008 ISS B, APPROVED BY EA 6-5318-120121.SDR SWAA083695Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 25L. REPAIRED FRAME PER SRM..SDR SWAA083694Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 13R. REPAIRED FRAME PER SWA EA.SDR ASAA0843210Frame · crackedFOUND CRACK ON LT FUSELAGE FRAME AT STA 601 DIRECTLY ABOVE THE CENTER WING REPAIRED IAW EA 5310 02804. PERFORM 1 STAGE DTA INSPECTION REQUIREMENTS WITHIN 12 MONTH FROM JUL 11 2008.SDR 08FDEA02652Frame · damagedTOOLING DAMAGE AT STA 783 FRAME JUST I/B OF STR 4R REMOVED DAMAGE PER SRM 53-10-4. FABRICATED REPAIR PARTS PER SRM 53-10-4. TREATED AND PRIMED PER SRM 51-30-02. INSTALLED REPAIR PER SRM 51-30-02 PG 1-13 AND 53-10-04. THIS IS CLASSIFIED AS A MAJOR REPAIR.SDR USAA920081370Frame · crackedCLT- Q3 CHECK MAJOR REPAIR NR 03C10753038/002- FRAME INNER CHORD AT BOTTOM FASTENER LEFT HAND SIDE CRACKED AT BS616, S17L. REPAIRED FRAME INNER CHORD AT BOTTOM FASTENER LEFT HAND SIDE AT BS616, S17L IAW US AIRWAYS TYPICAL REPAIR 53-62-01. (B)SDR USAA920081369Frame · crackedCLT-Q3 CHECK MAJOR REPAIR NR 03C10753007/013- FRAME CRACKED AT RADIUS OF CUTOUT BS380, S16R. REPAIRED FRAME AT RADIUS OF CUTOUT BS380, S16R IAW B737 SRM 53-00-07. (B)SDR USAA920081309Frame · crackedCLT - MAJOR REPAIR - Q3 CHECK - CRACKED FRAME, BS 440, S8L-S9L. REPAIRED FRAME, BS 440, S8L-S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20F. (S)SDR CALA0800665Frame · crackedSTATION 178 SIDE CHORD RIGHT-HAND SIDE AT WL 207 IS CRACKED. REMOVED AND REPLACED RIGHT-HAND SIDE CHORD IAW B737 SRM 51-40-02 AND EC/RA 5310-04794, EC/RA 5310-04794.SDR CALA0800663Frame · crackedLEFT SIDE STATION 360 FRAME BETWEEN S-8 AND S-9 AIR CONDITIONING (A/C) BRACKET MOUNT HOLE CRACKED. REPAIRED FRAME AT BODY STATION 360 BETWEEN S-8 AND S-9 PER EA 624-53-002CAL AND EC/RA 5310-04793.SDR SWAA083672Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS BS 616, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA083659Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 927, STR 23L TO STR 23R. REPAIRED FRAME PER SRM.SDR 08FDEA02624Frame · damagedTWO DRILL STARTS AT AFT LIP OF STA 740 FRAME BETWEEN STR 7R AND 8R. REMOVED DAMAGE .197 REMOVED FROM EDGE .200 INCH ALLOWED WITHIN LIMITS REF SRM 53-10-1 FIG 1 DETAIL 7, AND EA NR 7-5310-11400, THIS IS CLASSIFIED AS A MINOR REPAIR.SDR USAA920081368Frame · crackedCLT-Q3 CHECK MAJOR REPAIR NR 03C10753041/001- FRAME 500A CRACKED BETWEEN S8R TO S9R. REPAIRED FRAME AT 500A BETWEEN S8R TO S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20. (B)SDR UIE2008F00003Frame · crackedFRAME CRACKED AT STATION 400 STRINGER 22R. REPLACED DAMAGED FRAME IAW SRM 51-10-01 AND SRM 51-30-02. (K)SDR UIE2008F00001Frame · crackedFRAME CRACKED AT STATION 400, STRINGER 22R. REPLACED DAMAGED FRAME IAW SRM 51-10-01 AND SRM 51-30-02. (K)SDR UPS08852789Frame · gougedINSPECTION TYPE-C2, GOUGED ON THE BS 418 LT FRAME STRAP ABOVE THE UPPER SURFACE OF CUSP EXTRUSION IN MAIN CABIN. REMOVED AND REPLACED FRAME STRAP IAW SRM, 51-1-20D, 51-1-8.SDR UPS08852739Frame · gougedINSPECTION TYPE-C2, GOUGE ON THE STA 360 LT FRAME JUST ABOVE THE UPPER SURFACE OF THE L21. REPAIRED GOUGE IAW SRM 53-02-00-0 FIG 001F.SDR UPS08852738Frame · gougedINSPECTION TYPE-C2, GOUGE ON THE STA 702.875 LT FRAME JUST ABOVE THE UPPER SURFACE OF CUSP EXTRUSION(LONGERON 210 IN MAIN CABIN). DRILLED HOLE TO REMOVE DAMAGE AND PLUGGED HOLE. IAW SRM 53-02-00 FIG 0 01F.SDR 2008UALA03664Frame · dentedAFT PIT FRAME DENTED STA 1440, STR 26L. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. CUT OUT DAMAGE AND NDT INSP PER 51-00-19, DAMAGE REMOVED. INSTALLED DOUBLER REPAIR PER SRM 53-0 0-01, REPAIR 5 AND SRM 51-40-02.SDR SWAA083653Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083651Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083649Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083650Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083631Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR 08FDEA02612Frame · chafedFOUND CHAFING MARKS AT C 32 AND 37 BETWEEN P 14-15 OUT OF LIMIT. INNER FLANGE REPAIR PERFORMED IAW SRM 53-10-13 FIG 202.SDR USAA920081290Frame · crackedCLT - Q3 - MAJOR REPAIR - CRACK IN FRAME AT BS 440 S8-9R. REPAIRED FRAME AT BS 440 S8-9R IAW TYPICAL REPAIR 53-10-20E. (S)SDR 08FDEA02581Frame · damagedMULTIPLE UNFILLED HOLES ON FRAME 804 BETWEEN 4L AND STR 5L INSTALLED DOUBLER ON FRAME REF SRM 51-40-3, THIS IS CLASSIFIED AS A MINOR REPAIR.SDR USAA920081289Frame · crackedCLT - Q3 - MAJOR REPAIR - CRACK IN FRAME AT BS 400, S8-9R. REPAIRED FRAME AT BS 400, S8-9R IAW TYPICAL REPAIR 53-10-20. (S)SDR ASAA0843211Frame · gougedFWD CARGO PIT FWD FRAME HAS GOUGE AT BS 440 RBL 28 REPAIRED IAW SRM.SDR ASAA0843208Frame · corrodedFWD CARGO PIT FRAME UPPER STRAP CORRODED REPAIRED IAW SRM 51-40-02-51-50- 05.SDR SWAA083616Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 25L. REPAIRED FRAME PER SRM.
Back to JASC 5311