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 SWAA087178Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087177Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087176Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087175Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087174Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087173Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087172Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087167Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 887, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087166Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087165Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087163Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087162Frame · crackedDURING SCHEDULED14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087161Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087160Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087159Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087158Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087157Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087156Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087149Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087190Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME CORRODED AT BS 500D, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME PER ER.SDR 2008F00026Frame · crackedDURING INSP FOUND SPIDER CRACKS AROUND 1 RIVET ON THE DECK UNDER THE TANDEM HYD PACK. FURTHER INSP FOUND 2 FRAMES CRACKED UNDER THE HYD DECK.SDR CNMA20090065Frame · damagedBS 1039, LBL 49 DOUBLE HOLES ON FRAME. FLANGE WITH DOUBLE HOLES TRIMMED. REINFORCEMENT PART INSTALLED AS RQUIRED IAW SRM VOL I, 53-00-01, FIG 7.SDR FDEA200812155172Frame · gougedMAIN CABIN STA. 1280 STR.11-14L FRAME IS GOUGED. CUT, REMOVED, FABRICATE AND INSTALLED REPAIR PARTS AS PER MAE TRAVELER NR T8/769971 AND T8/769950 IAW SRM 53-00-07 FIG 201, SRM 51-40-05 AND AMM 51-21-00-7. REPAIRED GOUGED FRAME IAW SRM 53-00-07, REPAIR NR 1 SDR SWAA087130Support · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME SUPPORT WEB CRACKED AT BS 348, STR 15L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA087128Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087104Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087103Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087102Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087101Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087100Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087099Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 559, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087098Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087092Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR FDEA200812145140Frame · damagedAFT CARGO PIT STA.1540 STR 25R FRAME HAS A MISDRILLED HOLE. REPAIRED AFT CARGO PIT STA 1540 STR 25R FRAME IAW SRM 53-00-07 FIG 201 REPAIR 5 ZONE 1.I INSPECTION THRESHOLD 37500 FLIGHT CYCLES AFTER REPAIR INSTALLATION OR 50000 AIRFRAME FLIGHT CYCLES, WHICHEVSDR FDEA200812145139Frame Splice · gougedAFT CARGO PIT STA 1560 STR 24-25R, FRAME AND FRAME SPLICE ARE GOUGED. BLENDED AND SMOOTHED FRAME FOUND WITHIN LIMITS IAW SRM 53-60-07 AND SRM 53-00-07 FIG 101 DETAIL 2. REMOVED AND FABRICATED NEW SPLICE FRAME WITH MAE TRAVELER NR T8/771003, LOCATED, DRILLED SDR ASAA0874034Frame · gougedFSD CUTOUT FRAME STRUCTURE GOUGED 1.35" FWD OF CUTOUT FED FRAME JUST OTBD OF TOP FWD STOP PAD FTG (MARKED). REPAIRED FRAME IAW EA 700 53EA 00 345SDR UALA2008121506886Frame · dentedFWD PIT BILGE, FRAME AT STA 660 RT SIDE HAS A DENT BETWEEN STR 24R-25R. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR UALA2008121506882Frame · dentedAFT PIT FRAME DENTED BS 1460, STR 26L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR UALA2008121506881Frame · dentedAFT PIT FRAME DENTED BS 1420 AND STR 26L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR UALA2008121506878Frame · dentedAFT PIT FRAME DENTED BS 1400, STR 26L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR UALA2008121506877Frame · dentedAFT CARGO COMPARTMENT, FRAME DENTED BS 1380, STR 25L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR DHLA2009770AT523Frame · crackedLWR FUSELAGE FWD CARGO COMPARTMENT DOOR CUTOUT BS 560 AT STOP FITTING NR 1 WEB WITH CRACK. REPAIRED FRAME WEB SECTION AT BS 560 BETWEEN S-17R AND S-22R IAW SRM 51-40-2 FIG 1.SDR DHLA2009770AT522Frame · crackedLWR FUSELAGE FWD CARGO COMPARTMENT DOOR CUTOUT BS 620 AT STOP FITTING NR 1 WEB WITH CRACK. REPAIRED FUSELAGE FRAME WEB SECTION AT BS 620 BETWEEN S-18R AND S-22R IAW B727 SRM 51-40-2 FIG 1.SDR AALA200910575Former · crackedCRACKED FORMER.SDR DHLA2009770AT505Frame · damagedUPPER FUSELAGE CARGO CABIN FRAME WITH DOUBLE HOLE AT BS 1090 BETWEEN S-16L AND S-17L. REPAIRED FUSELAGE FRAME SECTION AT BS 1090 BETWEEN S-16L AND S-17L IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2009770AT501Failsafe · corrodedUPPER FUSELAGE CARGO CABIN FRAME FAIL SAFE CHORD WITH CORROSION AT BS 1166 BETWEEN S-16R AND S-17R. REPAIRED FUSELAGE FRAME FAIL SAFE CHORD SECTION AT BS 1166 BETWEEN S-16R AND S-18R DUE TO CORROSION IAW B727 SRM 51-40-3 FIG 1.SDR MALA080218Frame · chafedDURING N4K, 2Y INSPECTIONS IN CWA, FOUND FRAME AT STA 363 AT SL1505 CHAFED. REPAIRED CHAFE IAW EO NR S53644 AND S53152.SDR SWAA087060Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND MID CABIN FRAME CRACKED AT BS 639, WL 216 LT SIDE. REPAIRED FRAME PER DWG.SDR SWAA087051Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087050Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 727C, STR 8L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311