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 FDEA200906242281Frame · activatedUPON REMOVAL OF FASTENERS FROM FRAME SPLICE 640, AT STR'S 8- 9L TO FOM. UNABLE TO INSTALL DUE TO FASTENERS, HOLES DO NOT ALIGN. AT STA 640, STR'S 8- 9L, A MAJOR ALTERATION WAS ACCOMPLISHED DUE TO THE DISCREPANCY AFFECTING THE P TO F CONVERSION, ON MAE MOD CARSDR FDEA200906242274Frame · corrodedCORROSION FOUND ON FWD SIDE OF FRAME WEB STA 310.5 BETWEEN WL 206 AND 209 AT RBL 4 INCH AND BETWEEN LBL 16 INCH TO 19 INCH. REPAIRED IAW EA NR F-5310-131071 REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100.SDR 2009FA0000569Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET AT BS 867 STRINGER 9 LT.SDR 2009FA0000568Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET AT BS 500A STRINGER 9 LT.SDR 2009FA0000567Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 787 STRINGER 9 RT.SDR 2009FA0000566Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET AT BS 480 STRINGER 9 RIGHT.SDR 2009FA0000565Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET AT BS 440, STRINGER 9 RT.SDR HNAA2009090300273Frame Splice · crackedSPLICE IS CRACKED ON LT SIDE OF FLIGHT COMPARTMENT FRAME JOINT AT STA X136.8 AND STR. 15P. ON LT SIDE OF FLIGHT COMPARTMENT FRAME JOINT AT STA. 136.8 AND STR 15P SPLICE REMOVED AND REPLACED IAW SRM 51-40-00 PD 1777.SDR AALA20090708TUL21Frame · crackedTHE 1510 CANT FRAME CRACKED AT LOWER LT ALIGNMENT PIN. INSTALLED REPAIR DOUBLER IAW EA NR MD 80-53-006585.SDR FDEA200906232248Frame · damagedFRAME STA 1440, STR- 3L- 3R, HAVE MISDRILLED HOLES. REMOVED FRAME IAW SRM 53-00-07. FABED NEW FRAME ON MAE TRAV NR T9/794374, INSTALLED FRAME REPAIR PARTS STA 1440, STR- 5L- 5R, IAW SRM 53-00-07, 51-20-01. REAPIR NR 1, CATEGORY "A", MAJOR REPAIR.SDR FDEA200906232247Frame · damagedFRAME STA 377, STR 3L TO 3R, HAVE MISDRILLED HOLES. AT BS 377, S3L- S3R, FRAME REPAIR WAS ACCOMPLISHED, DUE TO DISCREPANCY EFFECTING THE PTF CONVERSION, ON MAE W/C, 118350472RCBR07, AND MAE EA 757- 5332- 16- F2030 REV -. DATED JUNE 5, 2009. THIS NON ROUTINE SDR 2009FA0000551Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 827 STRINGER 9 LT.SDR 2009FA0000550Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 827 STRINGER 9 RT.SDR 2009FA0000547Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 500C STRINGER 9 RT.SDR USAA2009070991767Support · corrodedSAL - C7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FRAME SUPPORT BETWEEN FR69 TO FR70, Y1732. REPLACED FRAME SUPPORT BETWEEN FR69 TO FR70, Y1732 IAW SRM 51-72-11.SDR USAA2009062991628Frame · corrodedSAL - MAJOR REPAIR - Q3 CHECK - LEVEL 2 CORROSION ON FWD FACE OF FRAME AT BS 767, S27L - S27R, AFT CARGO COMPARTMENT. REPAIRED CORROSION ON FWD FACE OF FRAME AT BS 767, S27L - S27R, AFT CARGO COMPARTMENT IAW B737-400 SRM 53-00-07, REPAIR 5, PAGE 201, FIG 201,SDR USAA2009062991627Frame · corrodedSAL - MAJOR REPAIR - Q3 CHECK - LEVEL 2 CORROSION ON LOWER FLANGE OF FRAME AT BS 807, S27R - S27L, AFT CARGO COMPARTMENT. REPAIRED CORROSION ON LOWER FLANGE OF FRAME AT BS 807, S27L - S27R, AFT CARGO COMPARTMENT IAW B737-400 SRM 53-00-07, REPAIR 5, PAGE 201, SDR USAA2009062991626Frame · corrodedSAL - MAJOR REPAIR - Q3 CHECK - LEVEL 2 CORROSION ON LOWER FLANGE OF FRAME AT BS 787, STR 27L - STR 27R IN AFT CARGO COMPARTMENT. REPAIRED CORROSION ON LOWER FLANGE OF FRAME AT BS 787, STR 27L - STR 27R IN AFT CARGO COMPARTMENT IAW B737-400 SRM 53-00-07.SDR SWAA094077Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR FDEA200906222205Frame · misalignedSTA 1640 RT, THERE ARE 5EA EXISTING FASTENERS HOLES THAT WILL INTERFERE WITH INSTALLATION OF MOD AT STA 1640, FRMAE RT SIDE , WL 200-208, REPAIR WAS ACCOMPLISHED DUE TO DISCREPANCY EFFECTING THE PTF CONVERSION, ON MAE MOD W/C NR 118350400EZ2R02, AND MAE EA NR SDR SWAA094064Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727, STR 14L. REPAIRED FRAME PER AAR EA.SDR SWAA094063Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, STR 13L. REPAIRED FRAME PER AAR EA.SDR SWAA094051Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500, STR 8R. REPAIRED FRAME PER SWA EA.SDR DLM88091203Support · corrodedAFT CARGO STA 1147, BETWEEN LEFT LONGERON 29 AND RIGHT LONGERON 29, FRAME SUPPORT HAS CORROSION ON FWD AND AFT SIDE (TASK 57-53301). FRAME SUPPORT CORROSION OUT OF LIMITS. REPLACED FRAME SUPPORT ON NRC M00/101 1758N01492.SDR DLM88091201Support · corrodedAFT CARGO STA 1147 BETWEEN LT LONG 29 AND RT LONG 29, FRAME SUPPORT HAS CORROSION ON FWD AND AFT SIDE (TASK 57-53301). FRAME SUPPORT CORROSION IS OUT OF LIMITS. REPLACED SUPPORT ON NRC M00/101 1758N01492.SDR USAA2009062991630Frame · corrodedSAL - MAJOR REPAIR - Q3 CHECK - LEVEL 2 CORROSION ON FWD FACE OF FRAME AT BS 767, S26L - S27L, AFT CARGO COMPARTMENT. REPAIRED CORROSION ON FWD FACE OF FRAME AT BS 767, S26L - S27L, AFT CARGO COMPARTMENT IAW B737-400 SRM 53-00-01, REPAIR 5.SDR QXEA2009062400475Frame · corrodedPDX - C5 CHECK, SUSPECT CORROSION ON SKIN FRAME LOWER FLANGE BETWEEN THE CAPTAIN'S ELEVATOR TENSION REGULATOR AND THE STICK PUSHER CAPSTAN. REMOVED THE RIVETS AND PAINT AND BLENDED AREA IAW RD 8/4-53-2344 PARAGRAPH 1. HFEC FOR CRACKS, NONE FOUND. BLENDED ARSDR SWAA094085Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 13L. REPAIRED FRAME PER ER.SDR SWAA094027Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094026Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094021Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA094020Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA094019Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094018Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094017Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094016Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094007Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 420, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER ER.SDR SWAA094006Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 578, STR 14L. REPAIRED FRAME PER ER.SDR 2009FA0000543Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET, BS787, STRINGER 9L.SDR 2009FA0000542Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 727D, STRINGER 9L.SDR 2009FA0000541Frame · crackedFRAME CRACKED AT A/C ATTACH BRACKET, BS 747, STRINGER 9R.SDR 2009FA0000539Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 727B STRINGER 9R.SDR 2009FA0000537Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 500A, STRINGER 9R.SDR 2009FA0000536Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 400 STRINGER 9LSDR 2009FA0000535Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET, BS 867, STRINGER 9R.SDR 2009FA0000534Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 360 STRINGER 9L.SDR 2009FA0000533Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 747 ABOVE STRINGER 9L.SDR 2009FA0000532Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 400 ABOVE STRINGER 9R.SDR USAA2009062291548Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 727B BETWEEN S8R & S9R. REPAIRED FUSELAGE FRAME AT BS 727B BETWEEN S8R & S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA2009062291547Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 747 BETWEEN S8L & S9L. REPAIRED FUSELAGE FRAME AT BS 747 BETWEEN S8L & S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.
Back to JASC 5311