N846AS, cancelled Jun 1, 2017
Service difficulty reports · 198
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 n_number = 'N846AS' AND deregistration_id = 'N846AS-2017-06-01' 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 n_number = 'N846AS' AND deregistration_id = 'N846AS-2017-06-01' 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 ASOA2012082902125Plate · corrodedSERVICE DOOR STEP PLATE HAS MAJOR CORROSION. NEW SERVICE DOOR STEP PLATE DRILLED IAW SRM 51-41-04. INSTALLED PLATE IAW AMM 25-33-01-400-802, STEP 3A(8).SDR ASOA2012082902124Angle · crackedAFT EQUIPMENT BAY, LT SIDE 621 -625 OBLIQUE ANGLE CRACKED. REMOVED LT SIDE OBLIQUE ANGLE REPLACED WITH SERVICEABLE OBLIQUE ANGLE IAW SRM 51-42-21. PAINT TOUCH UP ANGLE IN AFT EQUIP BAY LT SIDE IAW SRM 51-25-01. SDR CLOSED.SDR ASOA2012080102009Sign · missingLIGHTED EXIT SIGN NEAR SERVICE DOOR MISSING. INSTALLED LIGHTED EXIT SIGN NEAR SERVICE DOOR IAW AMM 33-51-10.SDR ASOA2012071801930Door · lack of lubePAX DOOR WOULD NOT OPEN FROM OUTSIDE. LUBRICATED PASSENGER DOOR IAW AMM 12-20-52. OPS CHECKED DOOR IAW AMM 52-11-00. ACFT OK FOR SERVICE.SDR ASOA2012072301964A/C Pack · malfunctionedEXCESSIVE FOG FROM LT A/C PACK VENTS RESTRICTING VISIBILITY. . PERFORMED OPS CHECK OF LT PACK ,OPS CHECKED GOOD, NO DEFCT NOTED IAW AMM 21-51-00,SDR ASOA2012062901846Handle · lack of lubeUNABLE TO OPEN MAIN PAX DOOR FROM INSIDE OR OUTSIDE. LUBRICATED PAS DOOR HANDLE IAW AMM 12-20-52-640-807. OPS CHECKED GOOD, ACFT OK FOR SERVICE.SDR ASOA201201697Rod · lack of lubeUNABLE TO OPEN MAIN PASSENGER DOOR FROM OUTSIDE. CLEANED AND LUBED OUTER HANDLE ROD. OPS CHECKED PAX DOOR IAW AMM 52-11-00-710-810. NO FAULTS NOTED AT THIS TIME.SDR ASOA201201485Lock · lack of lubeF/A REPORTS PAX DOOR DIFFICULT TO OPEN. LUBRICATED EXT HANDLE LOCK ASSY, OPS CHECKED OF PAX DOOR GOOD IAW AMM 52-11-00.SDR ASOA201200638Battery · inoperativeF/A FLASHLIGHT FOR CABIN INOPERATIVE. REPLACED F/A FLASHLIGHT BATTERIES. OK FOR SERVICE IAW AMM 25-60-00.SDR ASOA201200500Flap System · malfunctionedFLAPS FAIL CAUTION MESSAGE ON TAKEOFF CLIMB. FLAPS FAILED AT 8 DEGREES. ACFT RETURNED TO DEPARTURE, EMERGENCY DECLARED. RESET FLAP SYS IAW AD 2009-06-12.SDR ASOA201200415Pin · unserviceableCABIN DOOR OPENS PARTIALLY AND THEN SPRINGS BACK CLOSED. R & R AFT HANDRAIL QUICK RELEASE PIN AND LANYARD IAW AMM 52-11-00 AND SECURED IAW EO 600-52-53. OPS CHECKED GOOD.SDR ASOA201100788Door · bindingPAX DOOR VERRY DIFFICULT TO OPEN. LUBRICATED DOOR PINS IAW AMM 12-20-52. OPS CK GOOD, ACFT OK FOR SERVICE. (CLOSED)SDR ASOA201100630Handle · dirtyPAX DOOR WILL NOT OPEN FROM THE OUTSIDE AND DIFFICULT TO OPEN FROM THE INSIDE. CLEANED DIRT FROM OUTER HANDLE AND PURGED OUT OUTER HANDLE IAW AMM 52-11-00, OPS CK GOOD AT THIS TIME.SDR ASOA201100258Door · dirtyMAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE. CLEANED EXCESS DIRT AND GREASE FROM ASD OUTER HANDLE PLUNGER ASSY AND OPS CHECKED DOOR IAW AMM 52-11-00. OPENS AND CLOSES EASILY FROM INSIDE AND OUTSIDE ACFT OK FOR SERVICE.SDR ASOA201001968Escape Hatch · unknownCREW ESCAPE HATCH REQUIRES PAINT AND PLACARDS. APPLIED PAINT AND PLACARDS TO THE CREW ESCAPE HATCH IAW SRM 51-25-00, AND 11-20-00.SDR ASOA201001867Light · damagedFLOOR EMERGENCY LIGHT BY PAX ENTRY WAY BACKING/HSG DAMAGED. R & R FLOOR EMERGENCY BY PAX DOOR ENTRY WAY BASE IAW AMM 33-51-19. OPS CHECK GOOD. R & R FLOOR EMERGENCY BY PAX DOOR ENTRY WAY BASE IAW AMM 33-51-19. OPS CHECK GOOD. (CLOSED)SDR ASOA201001845Lens · missingEMERGENCY LIGHT COVER ON THE FLOOR OF MAIN PASSENGER DOOR FELL OFF. REPLACED EMERGENCY LIGHT COVER LENS NEAR ASD IAW AMM 33-60-00. (CLOSED)SDR ASOA201001838Fuse · blownNR 2 LT EXTERIOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED NR 2 EMERGENCY BATTERY CHARGER FUSES PER CRJ 200 CMM 33-21-70. OPS CHECKS GOOD. NO DEFECTS NOTED. PLACARD REMOVED.SDR ASOA201001833Fuse · blownNR 2 LT EXTERIOR EMERGENCY LIGHT INOP, EXTERIOR EMERGENCY LIGHTS - AIRCRAFT NOT OPERATED AT NIGHT ITEM RESOLVE UNDER MDDR: 516560-2. REMOVED AND REPLACED NR 2 EMERGENCY BATTERY CHARGER FUSES PER CRJ 200 CMM 33-21-70. OPS CHECKS GOOD. NO DEFECTS NOTED. PLACSDR ASOA201001455Stringer · corrodedSTRINGER 26L BETWEEN FS 349 AND 333 HAS MATERIAL LOSS OF 50 PERCENT FROM CORROSION. TOP COAT REQUIRES TO BE APPLIED TO EXTERIOR SIDE OF REPAIR AT FS 299.306, STR 26L RIVET HEADS. PAINTED IAW SRM 51-25-01.SDR ASOA201001485Stringer · corrodedSTRINGER 26L BETWEEN FS 349 AND 333 HAS HAS MATERIAL LOSS OF 50 PERCENT FROM CORROSION. RT SPLICE REQUIRES LOCATE/DRILL AND BOTH LT AND RT SPLICE ANGLES REQUIRE INSTALL. PERFORMED EDDY CURRENT INSP ON THE CUT LINES OF STRINGER 26L AT FS 302.5. NO INDICATIONSDR ASOA201001449Support · crackedCARGO DOOR STEP PLATE SUPPORT IS CRACKED. REMOVED CARGO DOOR STEP PLATE SUPPORT FROM FLOORBOARD 281LLF BY REMOVING 13 SCREWS. SUPPORT REQUIRES INSTALL. INSTALLED NEW SERVICEABLE CARGO DOOR STEP PLATE SUPPORT FLOORBOARD 281LLF BY PLACING INTO POSITION AND INSDR ASOA201001420Frame · corrodedFS 605 FRAME CORRODED FWD & AFT SIDE AT STR 26L - 26R. THIS MWC IS A CONTINUATION OF MWC CO 7327210. REPAIRED IAW SRM 51-42-06 AND 51-42-21.SDR ASOA201001347Floorbeam · corrodedJUST FWD OF FS 559+112 RBL 9 OTBD FLOOR SUPPORT ANGLE CORRODED. CONTINUATION OF MWC 8732821, OP 220. INSTALLED NEW SERVICEABLE RBL 9 FLOORBEAM TOP CAP AT FS 559 TO FS 574 IAW REO 601R-53-00-381, REV A AND SRM 51-42-34. INSTALLED SERVICEABLE FLOOR SEAT RAILSSDR ASOA201001289Buttstrap · corrodedBUTT STRAP AT FS 333, STR 25-27L HAS CORROSION. REMOVED FASTENERS COMMON TO CORRODED AREA. BLENDED DAMAGE FOUND TO BE OUT OF LIMITS IAW SRM 53-00-31, FIG 103. REMOVED REMAINING FASTENERS COMMONG TO CUT SPLICE STEP 23L-STR 23R IAW SRM 51-42-06. DRILLED UP NSDR ASOA201001288Floorbeam · corrodedFS 559+80 FLOOR SUPPORT CAP STRIP BETWEEN RBL 27- RBL 36 CORRODED. REMOVED FLOOR SUPPORT CAP STRIP IAW SRM 51-42-06. LOCATED, DRILLED AND INSTALLED A SERVICEABLE CAP STRIP AT FS 559+80 BETWEEN RBL 27 - RBL 36 IAW SRM 51-40-11, 51-42-06 AND 51-42-15.SDR ASOA201001287Floorbeam · corrodedFS 559+80 FLOOR SUPPORT CAP STRIP BET RBL 9 - RBL 27 CORRODED. REMOVED FLOOR SUPPOR TCAP STRIP IAW SRM 51-42-06. INSTALLED NEW CAP STRIP IAW SRM 51-42-06 & 51-45-00.SDR ASOA201001266Pressure Panel · crackedFOUND FS 460 PRESSURE FLOOR HAS INDICATION NOTED BETWEEN BL 0 AND RBL 9.0 3.0" IN LENGTH 50 PERCENT FSH FAILED NDT INSP. AREA MARKED ON ACFT. C/W STEP 1 OF REO 601R-53-41-1276. C/W STEPS 2, 3, AND 5 OF REO 601R-53-41-1276. C/W STEP 4 OF REO 601R-53-41-1276. CSDR ASOA201001259Lamp · inoperative2 AFT CEILING EMERGENCY FLOODLIGHTS INOP. REMOVED LENS FROM CEILING EMERGENCY FLOODLIGHTS 3 AND 4 IAW AMM TASK 33-51-16-000-801, STEP 3A. REMOVED LAMPS FROM FLOODLIGHTS BY PUSHING LAMP IN AND TURNING IN COUNTERCLOCKWISE DIRECTION. INSTALLED SERVICEABLE LAMPSSDR ASOA201001258Bulkhead Web · crackedFOUND REAR PRESSURE BULKHEAD WEB THAT SURROUNDS THE LINTEL ATTACHMENT FITTING HAS INDICATION NOTED .1" IN LENGTH 50 PERCENT FSH. FAILED NDT INSPECTION. REPAIR IAW EC/TC REO 601R53-61-1230 HAS BEEN COMPLETE AND THE REPAIR C/W THE REQUIREMENTS OF EC/TC AND REO SDR ASOA201001229Intercostal · corrodedCORROSION ON 2EA INTERCOSTALS AT FS 349-364, BETWEEN STR 27 AND 26R, STR 27R AND 26L. REMOVED MINOR SURFACE CORROSION ON INTERCOSTAL AT 27L AND 26L IAW SRM 53-21-17, 53-00-00 & 51-21-06. INSTALLED 2 EA INTERCOSTALS BETWEEN STR 26L & STR 27 AND BETWEEN STR 26SDR ASOA201001228Support Beam · crackedCARGO DOOR SUPPORT BEAM AFT LOWER ANGLE IS CRACKED APPROX .3" IN LENGTH. R & R CARGO DOOR SUPPORT BEAM AFT LOWER ANGLE IAW SRM 51-42-21.SDR ASOA201001227Post · crackedFOUND FS 409+128, RBL 18.0, OTBD VERTICAL POST HAS INDICATION NOTED APPROX .2" IN LENGTH 60 PERCENT FSH. FAILED NDT INSP (WL 69.0 AFT FLANGE RADIUS). REMOVED VERTICAL POST ON FS 409+128 RBL 18.0 IAW SRM 51-42-06. LOCATED & DRILLED NEW OTBD VERTICAL POST STSDR ASOA201001226Post · crackedFOUND FS 409+128 BL 0.0 RT SIDE VERTICAL POST HAS INDICATION NOTED APPROX .2" IN LENGTH 50 PERCENT FSH. FAILED NDT INSP (WL 69.0 AFT FLANGE RADIUS). REMOVED POST FS 409+128 BL 0 IAW SRM 51-42-06, 51-42-21. LOCATED AND DRILLED UP NEW FS 409+128 BL 0 VERTICALSDR ASOA201001253Sign · crackedPAX DOOR INNER HANDLE BETA LIGHT EXIT SIGN IS CRACKED. REMOVED DAMAGED BETA LIGHT FROM BAY DOOR INNER HANDLE. INSTALLED A NEW BETA LIGHT IAW AMM 20-21-00-910-801.SDR ASOA201001252Placard · missingCREW ESCAPE HATCH PLACARDS "CLOSED, ARROW, AND EMERGENCY EXIT" ARE MISSING. APPLIED MISSING ARROW, CLOSED, AND EMERGENCY EXIT SILKSCREENS TO CREW ESCAPE HATCH IAW AMM TASK 11-10-03-400-801. (CLOSED)SDR ASOA201001251Post · crackedFS 409+128 VERTICAL BEAM AT LBL 18.0 IS CRACKED ON OTBD BOTTOM CORNER. REMOVED POST ASSY AT FS 409.+128 LBL 18 IAW SRM 51-42-06. R & R OTBD STIFFENER PN 601R32208-155 IAW SRM 51-42-06. C/W EC/TC REO 601R-53-41-889 AND MET ALL THE REQUIREMENTS OF REO 601R-53SDR ASOA201001250Attach Angle · crackedRT FS 449.85 OVERWING ATTACHMENT ANGLE BEHIND PANEL 162EL IS CRACKED. REMOVED ANGLE COMMON TO RT OVERWING ATTACHMENT PANEL 162EL & FS 449.85 IAW SRM 51-42-06. RECEIVED NEW ANGLE FROM STORES. DRILLED & LOCATED HOLES ON ANGLE IAW SRM 51-40-11. OK TO INSTALL. SDR ASOA201001225Intercostal · corrodedINTERCOSTALS AT LBL 3 AND RBL 3 BETWEEN FRAME 364 AND FS 349 HAVE CORROSION.SDR ASOA201001224Stringer · corrodedSTRINGER 26L, BETWEEN FS 349 AND FS 333 HAS MATERIAL LOSS OF 50 PERCENT FROM CORROSION. REMOVED STR 26L FROM FS 280 TO FS 364.0 IAW SRM 51-42-06, 51-42-21. CUT STR 2L AT FS 302.5 FOR SPLICE OF NEW SECTION OF STR FROM FS 302.5 TO FS 364 IAW SRM 53-00-03. REINSSDR ASOA201001223Frame · corrodedFRAME 349 HAS CORROSION WITH 100 PERCENT MATERIAL LOSS BETWEEN STR 26L TO STR 26R AT DEEPEST POINT. REMOVED FRAME AT FS 349 IAW SRM 51-42-06. LOCATED AND DRILLED UP NEW FRAME IAW SRM 51-42-06 AND 51-42-21. INSTALLED ALL RIVETS COMMON TO FRAME THROUGH SKIN ANSDR ASOA201001222Frame · corrodedFRAME 333 HAS CORROSION WITH 100 PERCENT MATERIAL LOSS BETWEEN STR 26L TO STR 26R AT DEEPEST POINT. REMOVED CORRODED FRAME FROM FS 333 BETWEEN STR 26L TO 26R IAW SRM 51-42-06 AND 51-42-21. LOCATED AND DRILLED NEW SERVICEABLE FRAME AT FS 333 BETWEEN STR 26L TSDR ASOA201001221Frame · corrodedFRAME 310, HAS CORROSION WITH 50 PERCENT MATERIAL LOSS AT DEEPEST POINT BETWEEN STR 26L TO 26R. REMOVED FRAME SECTION 310 IAW SRM 51-42-06 AND SRM 51-42-21. LOCATED AND DRILLED UP NEW FRAME SECTION 310 IAW SRM 51-42-06. INSTALLED NEW FRAME SECTION AT FS 310 SDR ASOA201001220Frame · corrodedFRAME 319 HAS CORROSION WITH 100 PERCENT MATERIAL LOSS AT DEEPEST POINT BETWEEN STR 26L TO STR 26R. R & R LT FS 449.85 OVERWING ATTACHMENT ANGLE IAW SRM 51-42-06, 51-40-11, 51-42-15 AND AMM 51-23-00-100-801.SDR ASOA201001219Attach Angle · crackedLT FS 449.85, OVERWING ATTACHMENT ANGLE BEHIND PANEL 161EL IS CRACKED. R & R LT FS 449.85 OVERWING ATTACHMENT ANGLE IAW SRM 51-42-06, 51-40-11, 51-42-15 AND AMM 51-23-00-100-801.SDR ASOA201001218Floorbeam · corrodedFS 559+112 FLOORBEAM ANGLE BETWEEN RBL 27 - RBL 36 CORRODED. REMOVED CORROSION IAW SRM 51-21-06. FLOOR SUPPORT ANGLE CORROSION IS IN LIMITS. REMOVED 1 PERCENT OF THE MATL THICKNESS IAW SRM 53-00-00. PERFORMED LPI ON FS 559+112 FLOOR SUPPORT ANGLE BETWEEN SDR ASOA201001217Floorbeam · corrodedFS 559+112, RBL 9 - RBL 27, FLOORBEAM ANGLE CORRODED. REMOVED CORROSION IAW SRM 51-21-06. FLOOR SUPPORT ANGLE CORROSION IS IN LIMITS. REMOVED 1 PERCENT OF THE MATERIAL THICKNESS IAW SRM 53-00-00. PERFORMED LPI ON FS 559-112 RBL 9 - RBL 27 FLOOR SUPPORT SDR ASOA201001216Floorbeam · corrodedJUST FWD OF FS 559+112, RBL 9, OTBD FLOORBEAM ANGLE CORRODED. CORROSION AT FLOOR SUPPORT ANGLE IS OUT OF LIMIT OF THE ALLOWABLE DAMAGE IAW SRM 53-00-00. REMOVED FLOOR SEAT RAILS AND FILLER STRIPS RBL 9 BETWEEN FS 559.00 AND FS 574.00 TO ACCESS FLOORBEAM TOP SDR ASOA201001214Floorbeam · corrodedFS 589, LBL 9 - LBL 27, FLOORBEAM ANGLE CORRODED. REMOVED FLOOR SUPPORT ANGLE IAW SRM 51-40-11. REQUIRE INSTALLATION. FLOOR SUPPORT ANGLE CORROSION IS OUT OF LIMIT OF THE ALLOWABLE DAMAGE IAW SRM 53-00-00. LOCATED AND DRILLED UP NEW FLOOR CAP STRIP PN 601RSDR ASOA201001215Frame · corrodedFS 605, FRAME CORRODED FWD & AFT SIDE AT STR 26L - 26R. FOUND CORROSION OF FS 605 FROM TO BE OUT OF LIMITS IAW SRM 53-00-00. REMOVED OUT OF LIMITS FROM SECTION AT FS 605.00 FROM STR 21L - STR 21R IAW SRM 51-42-06. INSTALLED FRAME IAW SRM 51-42-06 & 51-42-2
Back to N846AS, cancelled Jun 1, 2017