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 MALA090073Frame · chafedFRAME STA 608 INNER FLANGE WAS FOUND CHAFED AT SL 1601, MEASURING .375 BY .018 DEEP AND AT FRAME STA 677 INNER FLANGE WAS FOUND DENTED AT SL 1620, MEASURING 1 BY .75 BY .042 DEEP. REPAIRED IAW S53695 AND S53152.SDR FDEA200905151671Frame · damagedFRAME 47 NDT INSPECTION REVEALS INDICATION AT HOLE "Q" LT SIDE. REAMED HOLE "Q", COLD WORKED, REAMED TO .6532 INCH AND INSTALLED FASTENER IAW EA NR 6-5710-127960.SDR FDEA200905151669Frame · damagedFRAME 47 NDT INSPECTION REVEALS INDICATION AT HOLE "F" LT SIDE REAMED HOLE "F", COLD WORKED, REAMED TO .559 INCH AND INSTALLED FASTENER IAW EA NR 6-5710-127960.SDR QXEA2009051500342Frame · crackedPDX - C5 - SUSPECT FRAME LEG IS CRACKED AT FRAME 6 APPROX X950.268 AND STR 3R. HFEC INSPECTED AT SUSPECTED AREAS FOR CRACK IAW NDTM PART 6 51-00-01. CRACK CONFIRMED. REMOVED SOLID RIVETS AND REMOVED CRACKED FRAME 6 APPROX X950.268 AND STR 3R IAW SRM 51-42-SDR ASAA0945611Frame · misrepairedPREVIOUS REPAIR ON FRAME WITH DEVIATIONS IAW EA 5310-02439. REMOVED PREVIOUS REPAIR, FABRICATED NEW REPAIR PARTS AND INSTALLED.SDR ASAA0945610Frame · crackedFRAME STA 747, STR 8L CRACK NOTED AT IB FASTENER HOLE REQUIRES REPAIR IAW EA NR 400-53EA-01028. REPAIRED.SDR ASAA0945609Frame · crackedFRAME CRACKED AT AIR CONDITIONING BRACKET. REMOVED DAMAGE FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945608Frame · crackedFRAME CRACKED AT IB FASTENER HOLE FOR AIR CONDITIONING BRACKET. REMOVED DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945607Frame · crackedFOUND STA 500 FRAME CRACKED AT NUTPLATE HOLES WL 156 RBL 24.5. REMOVED DAMAGE FROME FRAME FABRICATED REPAIR PARTS AND INSTALLED.SDR SWAA093198Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR 2009FA0000416Attach Fitting · crackedFRAME ATTACH CLIP CRACKED AT BS 500E STRINGER 25 RT.SDR USAA2009060591414Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK AT FORWARD CARGO FUSELAGE FRAME BS 500, RBL 1. REPAIRED FORWARD CARGO FUSELAGE FRAME BS 500, RBL 1 IAW US AIRWAYS EA 101184.SDR USAA2009052991335Frame · crackedSAL - C19 - MAJOR REPAIR - NR 6175807 - CRACK IN FUSELAGE FRAME AT BS360 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS360 BETWEEN S8L TO S9L IAW US AIRWAYS ENGINEERING CARD M1C53002.SDR USAA2009052891329Frame · crackedSAL - C19 - MAJOR REPAIR - NR 6175810 - CRACK ON FUSELAGE FRAME AT BS907 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS907, BETWEEN S8R TO S9R IAW US AIRWAYS TASK CARD M1C53002. SAL - C19 - MAJOR REPAIR - NR 6175810 - CRACK ON FUSELAGE FRAME AT BS907, BETWESDR USAA2009052891328Frame · crackedSAL - C19 - MAJOR REPAIR - NR 6175809 - CRACK ON FUSELAGE FRAME AT BS907, BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS907, BETWEEN S8L TO S9L IAW US AIRWAYS TASK CARD M1C53002.SDR USAA2009052891327Frame · crackedSAL - C19 - MAJOR REPAIR - NR 6175808 - CRACK ON FUSELAGE FRAME AT BS400, BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS400, BETWEEN S8R TO S9R IAW US AIRWAYS TASK CARD M1C53002.SDR MALA090071Frame · chafedRT CABIN FRAME STA 339 INNER FLANGE REINFORCEMENT ANGLE WAS FOUND TO HAVE 6 CHAFES FROM SL 1616 -1617 AND RT CABIN FRAME STA 363 INNER FLANGE REINFORCEMENT ANGLE WAS FOUND TO HAVE A CHAFE AT SL 1605. REPAIRED IAW S53694, S53696 AND S53152.SDR ASAA0945606Frame · crackedFRAME AT BS 827, STR 8R CRACKED. REPAIRED FRAME AT BS 827 STR 8R.SDR ASAA0945604Frame · crackedFRAME AT STR 8L BS 727F CRACKED AT FASTENER HOLE. REPAIRED.SDR SWAA093193Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CHORD CORRODED AT BS 727, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA093180Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA093179Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR 2009FA0000412Attach Fitting · crackedFRAME ATTACH CLIP CRACKED AT BS 500C STRINGER 25 RT.SDR 2009FA0000411Attach Fitting · crackedFRAME ATTACH CLIP CRACKED AT BS 500D STRINGER 25 RT.SDR FDEA200905121758Frame · crackedNR 1 CARGO DOORWAY FRAME, FWD STA 560 STR 25, TWO CRACKS ON FRAME WEB. REMOVED WEB IAW SRM 51-30-2. CUT OUT DAMAGED AREA & FABRICATED DOUBLER REPAIR IAW SRM 51-40-2 FIG 1 AND 51-10-3. TREATED & PRIMED PARTS IAW SRM 51-10-2. INSTALLED DOUBLER REPAIR IAW SRM SDR ASAA0945581Frame · misrepairedFRAME 787 S8R HAS PREVIOUS REPAIR WITH DEVIATIONS. REMOVED PREVIOUS, FABRICATED NEW REPAIR PARTS AND INSTALLED.SDR ASAA0945579Frame · misrepairedFRAME AT 907 STR 8R HAS PREVIOUS REPAIR ACCOMPLISHED WITH DEVIATION. REMOVED EXISTING REPAIR, FABRICATED NEW REPAIR PARTS AND INSTALLED.SDR ASAA0945574Frame · crackedFRAME AT 747 CRACKED AT FASTENER HOLE STR 8R. REPAIRED.SDR SWAA093150Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA093149Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA093144Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FAIL SAFE CHORD FRAME CORRODED AT BS 927, STR 19L. REPAIRED FRAME PER SRM.SDR SWAA093136Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 303. REPAIRED FRAME PER ACO.SDR SWAA093114Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 360, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA093104Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 827, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA093103Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 767, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA093102Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA093101Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA093100Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 460, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA093099Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA093098Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 807, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA093097Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 767, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA093096Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA093095Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 380, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA093088Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 887, STR 8R. REPAIRED WEB PER SWA EA.SDR SWAA093087Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 867, STR 8R. REPAIRED WEB PER SWA EA.SDR SWAA093086Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 847, STR 8R. REPAIRED WEB PER SWA EA.SDR SWAA093085Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 727E, STR 8R. REPAIRED WEB PER SWA EA.SDR SWAA093084Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 727D, STR 8R. REPAIRED WEB PER SWA EA.SDR SWAA093083Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 500C, STR 8R. REPAIRED WEB PER SWA EA.SDR SWAA093082Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 480, STR 8R. REPAIRED WEB PER SWA EA.
Back to JASC 5311