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 SWAA091872Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER AAR EA.SDR SWAA091861Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME WEB CRACKED AT BS 787, STR 8R. REPAIRED WEB PER SWA EA.SDR SWAA091860Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME WEB CRACKED AT BS 747, STR 8R. REPAIRED WEB PER SWA EA.SDR SWAA091859Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME WEB CRACKED AT BS 500C, STR 8R. REPAIRED WEB PER SWA EA.SDR SWAA091858Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091857Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091845Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 13L. REPAIRED FRAME PER EA.SDR USAA2009043091032Doubler · crackedSAL - Q6 - MAJOR REPAIR - DOUBLER CRACKED ON FRAME AT FORWARD ENTRY LOWER DOOR STOP AT BS 303.9, S16L. REPAIRED DOUBLER ON FRAME AT FORWARD ENTRY LOWER DOOR STOP AT BS 303.9, S16L IAW US AIRWAYS TASK CARD M1L53001.SDR USAA2009032690695Frame · crackedCLT - MAJOR REPAIR - FRAME CRACKED, BS 440, S-9R. REPAIRED FRAME AT BS 440, S9R IAW EA 130232.SDR AALA20090406TUL25Frame · gougedWEB GOUGED IN CANTED FRAME AT STATION 1338. INSTALLED DOUBLER PER SRM 51-70-04 FIGURE 2 SHEET 2.SDR AALA20090409TUL01Stiffener · wornSTIFFENER WORN ON CANTED FRAME AT STATION 1338. REMOVED AND REPLACED STIFFENER PER SRM 51-30-05.SDR IPXA09555524Frame · gougedINSPECTION TYPE:C3 BS 365 FRAME HAS ONE GOUGE AT STR 15L. DRILLED OUT DAMAGE ON FRAME TO .193 INCH DIAMETER HOLE AND INSTALLED RIVET.SDR IPXA09555445Frame · damagedINSPECTION TYPE:C3 BS 395 FRAME STR 12-13L HAS 2 AREAS WITH SCREW DAMAGE. REPAIRED PER ATS ER 09-2074 DATED 06APR09.SDR ASOA200900308Doubler · crackedRT SIDE FS 718.00 (BETWEEN STR 10 AND 11R) FRAME INTERNAL DOUBLER IS CRACKED IN THE LOWER RADIUS. REMOVED CRACKED INTERNAL DOUBLER OUT AIRCRAFT IAW SRM 51-42-21. FABRICATED AND DRILLED NEW AFT INTERNAL DOUBLER FROM 600-36030-32 PER REO 601-53-61-243 SG 7020SDR AALA20090406TUL17Frame · corrodedCORROSION ON FRAME 1250 LOWER FLANGE LONGERON 29L-29R IN AFT CARGO. INSTALLED REPAIR SPLICE PER SRM 53-03-02A SHEET 5.SDR IPXA09555444Frame · gougedINSPECTION TYPE:C3 BS 395 STR 16L-7L FRAME HAS NINE SCREW GOUGES. REPAIRED PER ATS ER 09-2074 DATED 06APR09.SDR IPXA09555246Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED ON I/B FLANGE BS 1300 LBL 69 WL 222.5. REPAIRED PER B757-5310-19952-C.SDR IPXA09555245Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED ON I/B FLANGE BS 1260 LBL 69 WL 222.5. REPAIRED PER B757-5310-19952-C.SDR IPXA09555244Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE ON I/B FLANGE BS 1220 LBL 69 WL 222.5. REPAIRED PER B757-5310-19952-C.SDR IPXA09555242Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED ON I/B FLANGE BS 1220 RBL 69 WL 222.5. REPAIRED PER B757-5310-19952-C.SDR IPXA09555241Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED ON I/B FLANGE BS 1260 RBL 69 WL 222.5. REPAIRED PER B757-5310-19952-C.SDR IPXA09555239Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED ON I/B FLANGE BS 1300 RBL 69 WL 222.5. REPAIRED PER B757-5310-19952-C.SDR IPXA09555238Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED ON I/B FLANGE BS 1340 RBL 69 WL 222.5. REPAIRED PER B757-5310-19952-C.SDR IPXA09555237Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED ON I/B FLANGE BS 1460 RBL 69 WL 222.5. REPAIRED PER B757-5310-19952-C.SDR IPXA09555236Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED ON I/B FLANGE BS 1500 RBL 69 WL 222.5. REPAIRED PER B757-5310-19952-C.SDR IPXA09555235Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED ON I/B FLANGE BS 1580 RBL 69 WL 222.5. REPAIRED PER B757-5310-19952-C.SDR IPXA09555234Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED ON I/B FLANGE BS 1580 RBL 69 WL 226. REPAIRED PER B757-5310-19952-C.SDR IPXA09555232Frame · damagedINSPECTION TYPE:C3 FRAMED DAMAGED ON I/B FLANGE BS 1620 RBL 69 WL 222.5. REPAIRED PER B757-5310-19952-C.SDR IPXA09555231Frame · damagedINSPECTION TYPE:C3 FRAME STA 900 FLANGE HAS DAMAGE AT STRINGER 15R. REPLACED PER B757-5310-19952.SDR IPXA09555230Frame · damagedINSPECTION TYPE:C3 FRAME STA 440 HAS DAMAGE AT STRINGER 8R TO 11R AND 15R. REPAIRED PER B757-5310-19952.SDR IPXA09555228Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED ON I/B FLANGE OF FRAME BS 1180 RBL 69 WL 222.5. REPLACED PER B757-5310-19953-C.SDR IPXA09555227Frame · damagedINSPECTION TYPE:C3 SCREW DAMAGE ON FRAME AT BS 1380 STR 15R. REPAIRED PER B757-5310-19952-C.SDR IPXA09555219Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED AT BS 1580 FROM STR 6R THRU 15R. REPAIRED PER B757-5310-19952.SDR IPXA09555218Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE AT BS 1540 FROM 6R THRU 15R. REPAIRED PER B757-5310-19952-C.SDR IPXA09555214Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED ON I/B FLANGE OF FRAME BS 1060 RBL 69 WL 222.5. REPAIRED PER B757-5310-19952-C.SDR USAA2009032590681Frame · crackedCLT - MAJOR REPAIR - Q4 CHECK - CRACKED FRAME AT BS 500E, S20R - S21R. REPAIRED FRAME AT BS 500E, S20R - S21R IAW US AIRWAYS EA 100963.SDR FDEA200903190973Frame · damagedFOUND DAMAGED HOLES IN FRAME C 71, P49 LT REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR IPXA09555226Frame · damagedINSPECTION TYPE:C3 SCREW DAMAGE IN FRAME AT BS 1340 STR 15L. REPAIRED PER B757-5310-19952-C.SDR IPXA09555225Frame · damagedINSPECTION TYPE:C3 SCREW DAMAGE IN FRAME AT BS 1380 STR 15L. REPAIRED PER B757-5310-19952-C.SDR IPXA09555224Frame · damagedINSPECTION TYPE:C3 SCREW DAMAGE IN FRAME AT 1420 STR 15L. REPAIRED PER B757-5310-19952-C.SDR IPXA09555223Frame · damagedINSPECTION TYPE:C3 SCREW DAMAGE IN FRAME AT BS 1460 STR 15L. REPAIRED PER B757-5310-19952-C.SDR IPXA09555221Frame · damagedINSPECTION TYPE:C3 SCREW DAMAGE IN FRAME AT BS 1500 STR 15L. REPAIRED PER B757-5310-19952-C.SDR IPXA09555220Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED I/B FLANGE BS 1620 LBL 69 WL 222.5. REPAIRED PER B757-5310-19952-C.SDR IPXA09555216Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGED 10 AREAS ON FRAME AT BS 1580 BETWEEN STR 6L AND 15L. REPAIRED PER B757-5310-19952-C.SDR IPXA09555215Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE 9 AREAS AT BS 1540 BETWEEN STR 6L AND 15L. REPAIRED PER B757-5310-19952-C.SDR DL76L090448Frame · crackedDURING CURRENT HMV, LT AND RT 903.5 FRAME CHORDS WERE FOUND CRACKED IN TYPICAL LOCATIONS. MANUFACTURER APPROVED REPAIRS INSTALLED, AND ARE DOCUMENTED IN 473030-14SDR ASAA0944810Frame · activatedOUT OF ROUND HOLE ON FRAME UPPER FLANGE. REMOVED DAMAGE FROM FRAME, FABRICATED REPAIR PARTS AND INSTALLED.SDR FDEA200903180946Frame · dentedCABIN, LT STA 1701 LONGERON FRAME DOUBLER FOUND DENTED. REPAIRED AS PER SRM 53-30-00 FIG. I VOL. I REV. 40. REPETITIVE INSPECTION REQUIRED INITIAL AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00 FIG. I VOL. I SDR FDEA200903180945Frame · dentedCABIN, RT STA 1741 LONGERON 12 FRAME FOUND DENTED. REPAIRED AS PER SRM 53-30-00 FIGURE 1 VOLUME I REVISION 40. REPETITIVE INSPECTION REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00 FIGURE 1 SDR FDEA200903180944Frame · dentedCABIN, RT STA 1661 LONGERON 12 FOUND DENTED. REPAIRED AS PER SRM 53-30-00 FIGURE 1 VOLUME I REVISION 40. REPETITIVE INSPECTION REQUIRED, INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00 FIGU
Back to JASC 5311