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 SWAA094474Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA094473Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA094472Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094471Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094470Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094469Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094468Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094467Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094465Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 360, STR 13L. REPAIRED FRAME PER SWA EA.SDR EIAA2009000092Frame · damagedFASTENER MISSING AND HOLE ENLOGATED IN RT FUSELAGE FRAME BS 640 STR. 20 R. REMOVED DAMAGE, FABBED AND INSTALLED REPAIR PER SRM 63-10-04 FIG. 11.SDR EIAA200900091Frame · misrepairedMAIN DECK FRAME REPAIR INCORRECT, BS 320 STR 15L. REMOVED OLD REPAIR, FABBED AND INSTASLL NEW REPAIR PER B747 SRM 51-30-02, 53-10-20 FIG 25 AND 51-40-03 FIG 3 SHT. 1-4SDR FDEA200907142615Frame · crackedFOUND OLD REPAIR ON UPPER FRAME FOOT C 42 LT, C 45 LT AND C 46 RT (FRAME FOOT WAS CUT AND HOLES OVERSIZED). IN HOLE C42 LT AND C 45 LT WRONG FASTENER INSTALLED. AFTER FASTENER REMOVAL WAS FOUND A CRACK IN HOLE C42 LT. REPAIR PERFORMED BY INSTALLING THE COSDR ASAA0946334Frame · dentedAFT CARGO COMPARTMENT FRAME AT STA 727B IS DENTED AT STR 24R. REMOVED DAMAGED AREA, FABRICATED REPAIR PART AND INSTALLED REPAIR.SDR ASAA0946322Frame · damagedFRAME AT STA 887 + STR 21R FASTENER HOLE DAMAGED. REMOVED DAMAGED AREA, FABBED REPAIR PARTS INSTALLED REPAIR.SDR DLM88091243Support · corrodedAFT CARGO FS 1212 LEFT LONGERON 29 TO RIGHT LONGERON 29 FRAME SUPPORT CORRODED. REPLACED SUPPORT IAW SRM 51-30-5.SDR ASAA0946301Frame · crackedFWD CABIN FRAME STA 360 CRACKED AT FASTENER ABOVE STR 9L. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLERS IAW EA.SDR ASAA0946300Frame · crackedFWD CABIN FRAME STA 400 CRACKED AT FASTENER ABOVE STR 9R. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLERS IAW EA.SDR ASAA0946297Frame · crackedAFT CABIN FRAME STA 867 CRACKED AT FASTENER ABOVE STR 9R. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLERS IAW EA.SDR ASAA0946296Frame · crackedAFT CABIN FRAME STA 747 CRACKED AT FASTENER ABOVE STR 9R. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLERS IAW EA.SDR ASAA0946295Frame · crackedFWD CABIN FRAME STA 400 CRACKED AT FASTENER ABOVE STR 9L. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLERS IAW EA.SDR ASAA0946294Frame · crackedAFT CABIN FRAME STA 827 CRACKED AT FASTENER ABOVE STR 9R. ACCOMPLISHED REPAIR OF FRAME AT STA 827 RT IAW EA.SDR ASAA0946293Frame · crackedAFT CABIN FRAME STA 867 CRACKED AT FASTENER ABOVE STR 9L. ACCOMPLISHED REPAIR OF FRAME AT STA 867 LT IAW EA.SDR ASAA0946292Frame · crackedAFT CABIN FRAME STA 787 CRACKED AT FASTENER ABOVE STR 9R. CUT OUT DAMAGED AREA AND INSTALLED REPAIR DOUBLERS IAW EA.SDR ASAA0946291Frame · crackedAFT CABIN FRAME STA 827 CRACKED AT FASTENER ABOVE STR 9L. CUT OUT DAMAGED AREA AND INSTALLED REPAIR DOUBLERS IAW EA.SDR ASAA0946290Frame · crackedFWD CABIN FRAME STA 480 CRACKED AT FASTENER ABOVE STR 9L. CUT OUT DAMAGED AREA AND INSTALLED REPAIR DOUBLERS IAW EA.SDR ASAA0946289Frame · crackedAFT CABIN FRAME STA 907 CRACKED AT FASTENER JUST ABOVE STR 9L MARKED. ACCOMPLISHED REPAIR OF FRAME AT STA 907 LT IAW EA.SDR ASAA0946241Frame · dentedAFT PIT FRAME DENTED STA 727A AT STR 25R. CUT OUT DAMAGED AREA, RECEIVED, LOCATED, DRILLED, PRIMED, TOP COATED AND INSTALLED FRAME REPAIR.SDR ASAA0946238Frame · dentedAFT PIT FRAME DENTED STA 727A BETWEEN STR 24L - 25L. CUT OUT DAMAGED AREA, RECEIVED, TREATED, LOCATED, DRILLED, PRIMED, TOP COATED AND INSTALLED FRAME REPAIR.SDR ASAA0946232Frame · dentedAFT CARGO FRAME AT STA 727F DENTED STR 25L. CUT OUT DAMAGED AREA, LOCATED, DRILLED, TREATED, PRIMED, TOP COATED AND INSTALLED FRAME REPAIR.SDR ASAA0946227Frame · dentedAFT CARGO FRAME AT STA 727C IS DENTED AT STR 24R. CUT OUT DAMAGED AREA, LOCATED AND DRILLED, TREATED, PRIMED, TOP COATED AND INSTALLED FRAME REPAIR ANGLE.SDR ASAA0946225Frame · dentedAFT CARGO FRAME STA 727G DENTED AT STR 25R. CUT OUT DAMAGED AREA, LOCATED AND DRILLED, TREATED PRIMED TOP COATED AND INSTALLED NEW REPAIR DOUBLER.SDR IPXA09556639Frame · damagedINSPECTION TYPE:N/A FRAME DAMAGE AT STA 1640 BETWEEN STR 21 & 22R. REPAIRED PER EO B757-5310-34149-A.SDR SWAA094446Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 807, BETWEEN STR 27R TO STR 26L. REPAIRED FRAME PER SRM.SDR SWAA094445Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 767, BETWEEN STR 25L TO STR 25R. REPAIRED FRAME PER SRM.SDR SWAA094420Frame Splice · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME SPLICE CRACKED AT BS 360, STR 13L. REPAIRED FRAME PER ER.SDR SWAA094419Frame Splice · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME SPLICE CRACKED AT BS 480, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER ER.SDR COMA2009071450167Frame · crackedFS 640 FRAME CRACKED, LT SIDE. REPAIRED PER REO 601R-53-61-506 AND REO 601R-53-61-569.SDR FDEA200907132600Frame · crackedAVIONIC COMPT DURING REMOVAL FRAME WITH OAN J/C SP10530244-7002-5JR FOUND FRAME CRACKED. REPAIRED FRAME IAW SRM 53-00-01 FIG 4 SHT 2 VOL I.SDR TAMF20090034SFrame · corrodedDURING (SC3) CHECKS INSP WAS FOUND BULK CARGO DOOR FWD FUSELAGE FRAME INNER SIDE AT THE STR L25 WITH CORROSION, NR 299, REPAIRED ACCOMPLISHED IAW EWO 767-53-092, SR 1-1363153647.SDR ASAA0946237Attach Angle · crackedFWD PIT FRAME TO INTERCOSTAL ATTACH ANGLE CRACKED STA 380 STR 26L. REMOVED DAMAGED AREA, FABRICATED, TREATED, PRIMED, TOP COATED AND INSTALLED NEW ATTACH ANGLE.SDR ASAA0946236Attach Angle · crackedFWD CARGO PIT FRAME ATTACH ANGLE CRACKED STA 380 STR 26R. REMOVED DAMAGED AREA, FABRICATED, TREATED, PRIMED, TOP COATED AND INSTALLED NEW ATTACH ANGLE.SDR SWAA094361Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FRAME CORRODED AT BS 787, LBL 1 TO LBL 14. REMOVED AND REPLACED FRAME PER SRM.SDR AALA20090714TUL19Frame · cracked1497 CANT FRAME CRACKED AT LINE FITTING BELOW RIGHT HAND LOUVER BOX. REPAIRED PER EA MD80-53-006765 DATED 7-10-09.SDR FDEA200907102568Frame · damagedFOUND DEEP GROOVES UNDER FWD AND AFT FITTINGS AFTER DOOR STOP FITTING REMOVAL AT LT FWD DOOR FRAME. REPAIR PERFORMED BY BLEND OUT DAMAGE , NDT FOR CRACK FREE CONDITION , SPOTFACING THE HOLES AND INSTALLING A FILLER IAW RAS 70522655/009/2009 ISS. A, APPROVESDR FDEA200907102567Frame · damagedFOUND DEEP GROOVES UNDER FWD AND AFT FITTINGS AFTER DOOR STOP FITTING REMOVAL. AT LT FWD DOOR FRAME REPAIR PERFORMED BY BLEND OUT THE DAMAGE, NDT FOR CRACK FREE CONDITION , SPOTFACING THE HOLES AND INSTALLING A FILLER IAW RAS 70522655/009/2009 ISS. A, APPROVSDR DLM88091241Support · corrodedAFT CARGO FS 1231 LONGERON 28 LEFT TO LONGERON 28 RIGHT FRAME SUPPORT CORRODED. REPLACED SUPPORT IAW 51-30-02.SDR USAA2009071691857Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FRAME AT BS 827, S8L TO S9L. REPAIRED CRACK ON FRAME AT BS 827, S8L TO S9L IAW US AIRWAYS TR 53-20-10F.SDR USAA2009071691842Frame · crackedCLT - Q-4 - MAJOR REPAIR - NR 03C20853011/002 - CRACK ON FUSELAGE FRAME AT BS380 BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS380 BETWEEN S20L TO S21L IAW US AIRWAYS TYPICAL REPAIR 53-60-07A.SDR USAA2009071691841Frame · crackedCLT - Q-4 - MAJOR REPAIR - NR 03C10753039/008 - CRACK ON FUSELAGE FRAME AT BS727E BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS727E BETWEEN S8R TO S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR ASAA0996174Strap · corrodedCORROSION FWD CARGO COMPARTMENT CORROSION ON FRAME CAP. REPLACED FAILSAFE STRAP.
Back to JASC 5311