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 QXEA2013022000399Frame · corrodedFRAME FLANGES AT FR 196 STR 32-30P HAVE CORROSION. REMOVED 10 RIVETS AND REMOVED CORROSION IAW SRM 53-00-00-02-09, REV 12. VERIFIED AFFECTED AREAS TO BE CRACK FREE REF NDTM PART 6, TASK 51-00-01-250-801, REV 8. MINIMUM THICKNESS REMAINING NOTED BETWEEN STRISDR QXEA2013022000397Frame · corrodedFRAME FLANGES AT FR 155 STR 32-30P HAVE CORROSION. REMOVED 1 EA RIVET TO FOM AND REMOVED CORROSION IAW 51-42-05-02-01 AND 53-00-00-02-09, REV 12. REMOVED ADDITIONAL RIVETS TO FOM IAW SRM 51-42-05-02-01, REV 12. VERIFIED AFFECTED AREAS TO BE CRACK FREE NDTM SDR FDEA201302200380Frame · failedEXISTING FUSELAGE FRAME REPAIR AT BS 1460, RBL 24 REQUIRES REPLACEMENT DUE TO NOT COMPLYING WITH APPROVED DATA. REMOVED FRAME IAW SRM 51-40-02, FABRICATED NEW FRAME. LOCATED AND DRILLED IAW SRM 51-10-02, AND INSTALLED IAW SRM 51-40-02 AND DWG 146N1014 SH-SDR DALA13009255650Frame · dentedFRAME DENTED IN AFT CARGO BS 1340, BETWEEN S26-27R. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07.SDR DALA13009245650Frame · dentedDENT IN FRAME, BS 1420 AT S26L IN AFT CARGO. FABRICATED AND INSTALLED REPAIR ON FRAME IAW SRM 53-00-07.SDR DALA13009235650Frame · dentedAFT CARGO FRAME IS DENTED IN TWO PLACES AT BS 1400 BETWEEN L25-26L. FABRICATED AND INSTALLED REPAIR ON FRAME IAW SRM 53-00-07.SDR DALA13009225650Frame · dentedAFT CARGO FRAME HAS A DENT AT BS 1520 BETWEEN L25-26L. FABRICATED AND INSTALLED REPAIR ON FRAME IAW SRM 53-00-07.SDR DALA13009215650Frame · dentedAFT CARGO FRAME IS DENTED AT BS 1320 BETWEEN L25-26L. FABRICATED AND INSTALLED REPAIR ON FRAME IAW SRM 53-00-07.SDR ASOA20130220262Gusset · corrodedDURING C-CHECK, CORROSION FOUND IN CENTER GUSSET AFT OF FRAME 59 AROUND SCREW HOLES. MX R & R GUSSET IAW SRM 51-40-02.SDR SWAA2013031913835Frame · crackedFRAME WEB CRACKED AT BS 328, BETWEEN STR 20R TO STR 21R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR QXEA2013021900401Frame · corrodedFRAME WEB AREA OF FR 236, STR 30P HAS CORROSION. REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 12. VERIFIED AFFECTED TO BE CRACK FREE REF NDTM PART 6, TASK 51-00-01-250-801, REV 8. MINIMUM THICKNESS NOTED, .043 REF NDTM PART 1, TASK 51-00-04-910-801, REV 8.SDR DALA13008510939Frame · corrodedCORROSION OUT OF LIMITS ON FRAME BS 1193 LONGERON 30L. FRAME WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR FDEA201302190374Frame · corrodedFUSELAGE AFT PRESSURE BULKHEAD FWD FACE LWR RIM FR 80/82 HAS 3 EA AREAS OF EXFOLIATED CORROSION & 1 EA AREA OF CORROSION EXTENDING INTO THE CLEAT PROFILE. DEFECT MEASURES 15"SQ. AFTER REMOVAL OF LEVEL 1 CORROSION, FOUND ANGLES TO BE OUT OF LIMITS IAW SRMSDR SWAA2013032013874Frame · corrodedFRAME CORRODED AT BS 908, LONG 30. REPAIRED FRAME PER SRM.SDR SWAA2013022613102Frame · corrodedBS 767 FRAME INNER FLANGE HAS CORROSION STR 25LT. REPAIRED FRAME PER EA & ER.SDR SWAA2013022613101Frame · corrodedBS 787 FRAME INNER FLANGE HAS CORROSION STR 25LT. REPAIRED FRAME PER EA & ER.SDR SWAA2013022613100Frame · corrodedBS 787 FRAME INNER FLANGE HAS CORROSION STR 25LT. REPAIRED FRAME PER EA & ER.SDR SWAA2013022613099Frame · corrodedBS 807 FRAME INNER FLANGE HAS CORROSION STR 25LT. REPAIRED FRAME PER EA & ER.SDR SWAA2013040114268Frame · crackedFRAME CRACKED AT BS 360, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME IAW EO AND EA.SDR SWAA2013032514028Frame · crackedWEB CRACKED STUB FRAME BS 277, BETWEEN STR 15L AND STR 16L. REPAIRED WEB IAW EA.SDR SWAA2013032113947Frame · crackedSTUB FRAME CRACKED AT BS 294.5, STR 17R. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013031313601Frame · crackedFRAME CRACKED AT STA 277, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA2013022012929Attach Fitting · crackedPASSENGER CABIN STATION 294.5 S13L FRAME ATTACH CLIP IS CRACKED ON FWD SIDE OF 294 FRAME. NEW CLIP WAS ORDERED, DRILLED AND INSTALLED IAW SRM 51-40-02 AND BOEING DWG.SDR ASOA2013031303191Frame · corrodedMAIN AVIONIC COMPARTMENT FUSELAGE FRAME BS 333 IS CORRODED AT STR 26R. REMOVED CORRODED FRAME SEGMENT & SERVICEABLE REINFORCING ANGLE IAW SRM 51-42-06 & 51-42-21. INSTALLED NEW FRAME SECTOR AND REINSTALLED SERVICEABLE REINFORCING ANGLE IAW SRM 51-42-06 & 51SDR ASOA2013031303190Frame · corrodedMAIN AVIONIC COMPARTMENT FUSELAGE FRAME 319 IS CORRODED AT STR 26L. REMOVED FRAME SECTOR IAW SRM 51-42-06. LOCATED & DRILLED NEW FRAME SECTOR IAW 51-40-11. INSTALLED NEW FRAME SEGMENT IAW SRM 51-42-06 & 51-42-21.SDR ASOA2013031303189Frame · corrodedMAIN AVIONIC COMPARTMENT FUSELAGE FRAME BS 310 CORRODED AT STR 26R. REMOVED FRAME SECTOR IAW SRM 51-42-06 & 51-42-21. TRIMMED FRAME SECTOR TO FIT AND LOCATED DRILL DEBURR IAW SRM 51-40-11 & 51-42-06 & 51-21-11. INSTALLED FRAME SEGMENT IAW SRM 51-42-06 & 5SDR SWAA2013022713134Frame · crackedCRACK ON FRAME LOCATED BS 294.5 AND BETWEEN STR 2R TO STR 3R. REPAIRED FRAME PER SRM.SDR AALA20130215008Frame · cracked1474 CANT FRAME CRACKED AFT OF LONGERON 18 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-15.SDR AALA20130215003Frame · crackedFRAME AT STATION 727B RIGHT IS CRACKED AT AIR CONDITIONING SUPPORT RAIL BRACKET. ACCOMPLISHED FRAME REPAIR PER ECO J1159AE.SDR ASOA20130214073Frame · crackedDURING C-CHECK FRAME 10L CRACKED. MX R & R FRAME 10L IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20130214072Frame · crackedDURING C-CHECK FRAME 10R CRACKED. MX R & R FRAME 10R IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2013032214025Frame · crackedFRAME CRACKED AT BS 360, STR 16R. REPAIRED FRAME IAW SRM.SDR IPXA3M77460Frame · dentedINSPECTION TYPE:4C, FRAME IS DENTED IN MAIN CABIN AT BS 715 JUST ABOVE L12R. REPAIRED ZEE FRAME IAW EA 011-5310-01 -50073-A REV I/R AND EO MD11-5310-50073-A.SDR SWAA2013022713154Frame · crackedFUSELAGE INTERNAL STA 907 BELOW STR 8L CRACK INDICATION ON FRAME INBD FASTENER FOR DISTRIBUTION DUCT ATTACH BRACKET. REPAIRED BRACKET PER ACO.SDR SWAA2013022613118Bracket · crackedFUSELAGE FRAME BRACKET CRACKED AT BS 400, STR 8R. REPAIRED BRACKET PER EA.SDR SWAA2013022513014Frame · crackedFRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013022513013Frame · crackedFRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013022513012Frame · crackedFRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013022513011Frame · crackedFRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013022513010Frame · crackedFRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013022513009Frame · crackedFRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013022513017Frame · crackedFRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013022513016Frame · crackedFRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013022513015Frame · crackedFRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013032614164Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013030413270Frame · crackedCRACK ON FRAME LOCATED AT BS 277 AND BETWEEN STR 2L TO STR 3L. REPAIRED FRAME PER SRM.SDR REXA2013021300306Frame · corroded900-53-140-300, FRAME 349 HAS CORROSION BETWEEN STGR 25L AND 25R, IN THE FWD E & E BAY. REMOVED CORROSION FRAME 349 STGR 25 L & 25R. FOUND WITHIN LIMITS IAW CRJ 900 SRM 51-21-06 AND EO R53277.SDR REXA2013021300048Frame · corroded900-53-140-300, FRAME 310 HAS CORROSION BETWEEN STGR 26L AND 26R, IN THE FWD E & E BAY. REMOVED CORROSION FRAME 310 STGR 26L & 26R. FOUND TO BE WITHIN LIMITS IAW CRJ 900 SRM 51-21-06 AND EO R53277.SDR REXA2013021300047Frame · corroded900-53-140-300, FRAME 295 HAS CORROSION BETWEEN STGR 26L AND 26R, IN THE FWD E & E BAY. REMOVED CORROSION FRAME 295 BETWEEN STGR 26L & 26R. FOUND WITHIN LIMITS IAW CRJ 900 SRM 51-21-06. EO R53277.SDR SWAA2013022713129Frame · crackedCRACK INDICATION FOUND AT BS 500B IN THE FRAME BETWEEN STR 20R AND STR 21R. REPAIRED FRAME PER SRM.
Back to JASC 5311