N834AS, cancelled Jul 7, 2015
Service difficulty reports · 170
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 = 'N834AS' AND deregistration_id = 'N834AS-2015-07-07' 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 = 'N834AS' AND deregistration_id = 'N834AS-2015-07-07' 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 ASOA201101687Floorbeam · corrodedFLOORBEAM HAS CORROSION AT FS 349.00 NEAR AFT END OF SERVICE DOOR CUTOUT. REMOVED CORROSION AND FOUND TO BE BEYOND ACCEPTABLE LIMITS IAW SRM 51-21-06 AND 53-00-00. CORROISON DAMAGE IS THROUGH ENTIRE THICKNESS OF FLOORBEAM. REPAIRED IAW REO 601R-53-21-1361.SDR ASOA201101686Frame · crackedBS 280 FRAME APPEARS TO BE CRACKED AFT LOWER SIDE NEAR LBL 9.00. PERFORMED ET INSPECTION IAW MAC NDT INSPECTION PROCEDURE ET-2. VERIFIED FRAME CRACKED. REPAIRED IAW REO 601R-53-11-171. PERFORMED NDT IAW NDTM 51-20-06. NO INDICATIONS NOTED.SDR ASOA201101702Attach Fitting · corrodedAFT FITTINGS CORRODED BY ASD HINGE . REMOVED IAW SRM 51-42-06. FABRICATED IAW SRM 52-10-14 AND 51-40-11. INSTALLED IAW SRM 51-42-06.SDR ASOA201101701Structure · corrodedAFT CORNER ON PAX DOOR BY HINGE FOUND BADLY CORRODED. REMOVED AFT CORNER ON PAX DOOR BY HINGE IAW SRM 51-42-21 AND 51-42-06. DRILLED UP AND INSTALLED AFT CORNER IAW SRM 51-42-21 AND 51-42-06.SDR ASOA201101700Structure · corrodedFWD CORNER ON PAX DOOR BY HINGE FOUND CORRODED AND PITTED. REMOVED FWD CORNER ON PAX DOOR BY HINGE IAW SRM 51-42-21 AND 51-42-06. DRILLED AND INSTALLED FWD CORNER ON PAX DOOR BY HINGE IAW SRM 51-42-21 AND 51-42-06.SDR ASOA201101699Seat Track · corrodedCARGO COMPARTMENT NET ATTACHMENT SEAT TRACK FROM APPROX FS 559.00+80 TO FS 559.00+96 AT LBL 27.00 HAS SURFACE CORROSION. REMOVED DEFECTIVE SEAT TRACK IAW AMM 53-01-11-000-802. DRILLED AND INSTALLED NEW TRACKS IAW AMM 53-01-11-000-802 IAW AMM 53-01-11-000-80SDR ASOA201101698Seat Track · corrodedCARGO COMPARTMENT NET ATTACHMENT SEAT TRACK FROM APPOX. FS 559.00 + 80 TO FS 559.00 + 96 AT LBL 9.00 HAS SURFACE CORROSION. REMOVED DEFECTIVE SEAT TRACK IAW AMM 53-01-11-000-802. DRILLED AND INSTALLED NEW TRACKS IAW AMM 53-01-11-000-802 IAW AMM 53-01-11-000SDR ASOA201101697Seat Track · corrodedCARGO COMPARTMENT NET ATTACHMENT SEAT TRACK FROM APPROX FS 559.00+80 TO FS 559.00+96 AT RBL 9.00 HAS SURFACE CORROSION. REMOVED DEFECTIVE SEAT TRACK IAW AMM 53-01-11-000-802. DRILLED AND INSTALLED NEW TRACKS IAW AMM 53-01-11-000-802 IAW AMM 53-01-11-000-802SDR ASOA201101696Seat Track · corrodedCARGO COMPARTMENT NET ATTACHMENT SEAT TRACK FROM APPROX. FS 559.00 + 80 TO FS 559.00 + 96 AT RBL 27.00 HAS SURFACE CORROSION. REMOVED DEFECTIVE SEAT TRACK, DRILLED & INSTALLED NEW TRACKS IAW AMM 53-01-11-000-802 IAW AMM 53-01-11-000-802 AND SRM 51-41-02. MINOSDR ASOA201101695Seat Track · corrodedCARGO COMPARTMENT NET ATTACHMENT SEAT RAIL FROM FS 559.00 + 112 TO FS 574.00 AT LBL 9.00 HAS SURFACE CORROSION. REMOVE SEAT TRACK AND FABRICATED NEW SEAT TRACK IAW SRM CH 51-40-11. OK TO INSTALL. INSTALLED NEW TRACKS IAW AMM 53-01-11-000-802, IAW AMM 53-0SDR ASOA201101694Seat Track · corrodedCARGO COMPARTMENT NET ATTACHMENT SEAT RAIL FROM FS 559.00+112 TO FS 574.00 AT RBL 9.00 HAS SURFACE CORROSION. REMOVE SEAT TRACK AND FABRICATED NEW SEAT TRACK IAW SRM 51-40-11. INSTALLED NEW TRACKS IAW AMM 53-01-11-000-802 AND SRM 51-41-02. MINOR REPAIR. (CLOSDR ASOA201101680Structure · crackedPOSSIBLE CRACK FOUND AT FASTENER LOCATION ON PAX DOOR UNDER AFT DRAG ANGLE. PERFORMED EDDY CURRENT INSPECTION OF PAX DOOR INNER SKIN IAW MAC NDT INSP PROCEDURE ET-2. CRACK INDICATION CONFIRMED ON SKIN. CUTOUT DAMAGED AREA IAW REO 601R-52-11-1991 P1. PERFOSDR ASOA201101679Skin · crackedPAX DOOR SKIN CRACKED AT ONE FASTERNER LOCATION NEAR WEATHER STRIP. CUTOUT DAMAGED AREA IAW P1 REO 601R-52-11-1992 STEPS 1 AND 2. NDT AREA COMPLIED WITH STEP 3 OF REP 601R-52-11-1992 IAW NDTM PART , 51-20-06. NO INDICATIONS NOTED. REPAIRED IAW REO 601R-52-SDR ASOA201101678Attach Fitting · corrodedCENTER ATTACH FITTING CORRODED ON PAX DOOR BY ASD HINGE. REMOVED CENTER ATTACH FITTING IAW SRM 51-42-06. FABRICATED IAW SRM 52-10-14 AND 51-40-11 AND INSTALLED IAW SRM 51-42-06.SDR ASOA201101677Attach Fitting · corrodedFWD ATTACH FITTING CORRODED BY ASD HINGE. REMOVED FWD ATTACH FITTING IAW SRM 51-42-06. FABRICATED IAW SRM 52-10-14 AND 51-40-11 AND INSTALLED IAW SRM 51-42-06.SDR ASOA201101676Isolator · brokenISOLATOR AT 18LBL 21.5 " FROM FLOOR IS BROKEN ON CABIN SIDE OF PRESSURE BULKHEAD. R & R ISOLATOR IAW SRM CH 51-42-13. R & R ISOLATOR IAW SRM 51-42-13. THIS IS A MINOR REPAIR.SDR ASOA201101675Angle · corrodedPRESSURE FLOOR SKIN ANGLES HAVE CORROSION BETWEEN FS 409.00 + 128 AND FS 559.00 LT SIDE. REMOVED CORROSION FROM PRESSURE FLOOR SKIN ANGLES IAW GRO 601R-53-41-666 AND SRM 51-21-06. PERFORMED UT INSPECTIONS OF BLEND AREAS IAW MAC NDT INSP PROCEDURE UT-3 MIN SDR ASOA201101674Angle · corrodedPRESSURE FLOOR SKIN ANGLES HAVE CORROSION BETWEEN FS 409.00 +128 AND FS 559.00. RT SIDE. REMOVED CORROSION FROM PRESSURE FLOOR ANGLES IAW GREO 601R-53-41-666 & SRM 51-21-06. PERFORMED UT THICKNESS INSPECTION OF BLEND AREAS IAW MAC NDT INSP PROCEDURE UT-3 MINSDR ASOA201101615Connector · unsecureWING A/ICE SENSOR CAUTION MESSAGE FOLLOWED BY WING OVERHEAT WARNING. FOLLOWED QRH, MESSAGE PERSISTED THROUGHOUT FLIGHT. EMERGENCY DECLARED AND EQUIPMENT ROLLED AS A PRECAUTION. RESECURED ANTI-ICE TEMP CONTROL UNIT CONNECTOR PLUG IAW AMM 30-12-19. PERFORMED OSDR ASOA201101015Strut · failedCREW REPORTED NLG DISAGREE MSG IN FLT, AFTER TAKEOFF. ENROUTE TO IAD ACFT DIVERTED DUE TO MX -- EMERGENCY DELARED AS A PRECUATION. REMOVED AND REPLACED NLG STRUT ASSY IAW AMM 32-21-01. OPS CHECK GOOD. LEAK CHECK GOOD.
(CLOSED)SDR ASOA201100108Proximity Sensor · out of adjustGEAR DISAGREE AND NOSE DOOR OPEN MESSAGES UPON GEAR RETRACTION, PERFORMED QRH PROCEDURE AND RECEIVED 3 GEAR DOWN AND LOCKED INDICATIONS. (ACFT RETURNED TO DEPARTURE) SENSOR TO TARGET ADJUSTMENT OF NLG. CENTERED EXTENDED PROX SENSOR REF AMM 32-61-01.SDR ASOA201001844Bracket · damagedGEAR DISAGREE MESSAGE AFTER TAKEOFF, MAIN GEAR UP, NOSE GEAR DOWN. RAN QRH, ALL GEAR DOWN AND LOCKED. (ACFT RETURNED TO DEPARTURE AFTER T/O -- EMERGENCY DECLARED AS A PRECAUTION) FLT 7103 CX, R & R BRACKET FOR NLG CENTERING PROX-SWITCH, RIGGED SWITCH & SERVICSDR ASOA201001737Proximity Sensor · bentNOSE GEAR DISAGREE (ACFT RETURNED TO DEPARTURE AFTER T/O -- EMERGENCY DECLARED - EMERGENCY VEHICLES STANDING BY AS A PRECAUTION) FOUND PROX SENSOR AND TARGET BENT ON NLG, (CREW INFORMED US THAT RAMP HAD PROBLEMS GETTING STRAP RELEASED AFTER PUSH-BACK) ADJUSTEDSDR ASOA201001814Exhaust Duct · fireFLT 7128 - FIRE IN APU EXHAUST VISUALLY INSPECTED APU COMPARTMENT AND CONTAINMENT NO DISCREPANCIES NOTED. OPERATED APU AS PER MAINTENANCE MANUAL CRJ 200 AMM 49-10-00 . OPS CHECK GOOD.SDR ASOA201001279Oil System · lowLT ENGINE OIL PRESSURE SHOULD 47-55 PSI ON TAKEOFF ROLL, ON CLIMB OUT THRU 9000 FT OIL PRESSURE DROPPED BELOW 30 PSI, IN CONJUNCTION WITH "LOW OIL PRESSURE" TRIPLE CHIME. FOLLOWED QRH. AT IDLE, OIL PRESSURE STABILIZED AT 39 PSI .LT IT AT IDLE. (ACFT RETURNED SDR ASOA201001039Lamp · inoperativeON TAKEOFF FROM IAD WE RECEIVED A GEAR DISAGREE MESSAGE. THE NOSE GEAR FAILED TO RETRACT. EMERGENCY DECLARED -- ACFT RETURNED AFTER T/O. RELAMPED LT AFT EXT EMERGENCY LIGHT IAW AMM 33-51-15, OPS CHECK GOOD. RELAMPED LT AFT EXT EMERGENCY LIGHT IAW AMM 33-51-SDR ASOA201000958Sensor · out of positionNOSE GEAR DISAGREE WARNING MSG WITH NOSE DOOR. OPEN WARNING WARNING MSG AFTER GEAR RETRACTED. (EMERGENCY DECLARED - ACFT RETURNED TO IAD AFTER T/O) UPON INSP, FOUND NLG PROX SENSOR S23 OUT OF LIMITS. REPOSITIONED S23 IAW AMM 32-61-00 AND SWUNG NLG IAW 32-33-SDR ASOA201000656Inverter · inoperativeEMERGENCEY LIGHT AT LT OVER WING ER EXIT INOP. R & R NR 3 INVERTOR IAW AMM 33-51-07. OPS CK GOOD. ITEM: 1 / R & R NR 3 INVERTOR IAW AMM 33-51-07. OPS CK GOOD.SDR ASOA20100452Bypass Valve · failedREMOVED DEFECTIVE LT DUAL BYPASS VALVE AND INSTALLED REPAIRED UNIT. LEAK AND OPS CHECK GOOD AT THIS TIME WORK DONE IAW AMM 21-61-31 PACK NOW OPERATES IN MANUAL MODE ONLY DEFER CLEARED PLACARD REMOVED REF AFDL 527321-1 FOR OPERATION. (CLOSED)SDR ASOA201000452Valve · failedBURNING ODOR IN MAIN CABIN. (AIR CONDITIONING PACK - LT SIDE)SDR ASOA201000076Anchor Fitting · crackedPAX DOOR AFT ANCHOR FITTING CRACKED. R & R AFT ANCHOR FITTING ON PASSENGER DOOR IAW AMM 52-11-17. OPS CHECK GOOD. PERFORMED RII SATISFACTORY IAW SP 607 ON INSTALLATION OF AFT PASSENGER DOOR ANCHOR. R & R AFT ANCHOR FITTING ON PASSENGER DOOR IAW AMM 52-11-17SDR ASOA20100005Wire · brokenREPAIRED BROKEN WIRES AND OPS CHECK TESTED GOOD IAW ESPM 20-11-00 AND AMM 33-51-00. REPAIRED BROKEN WIRES AND OPS CHECK TESTED GOOD IAW ESPM 20-11-00 AND AMM 33-51-00. (CLOSED)SDR ASOA201000005Sign · inoperativePAX DOOR EMERGENCY EXIT SIGN (ON WARDROBE) INOP.SDR ASOA200901215Light · inoperativeLT EXTERNAL EMERGENCY LIGHT JUST FWD OF EMERGENCY EXIT DOOR INOP.SDR ASOA200901214Light · inoperativeRT EXTERNAL EMERGENCY LIGHT JUST FWD OF EMERGENCY DOOR INOP.SDR ASOA200901192Sign · inoperativeEMERGENCY LIGHTS AT LT AND RT OVERWING EXITS (STA 416.5) CABIN CEILING NR 3 AND CURVED EMERGENCY EXIT SIGN MID CABIN FACING AFT ARE ALL INOPERATIVE.SDR ASOA200901165Frame · crackedCRACKED FRAME AT FS 605.00 S9L. PERFORMED E/T INSP ON FS605.00 STR 9 CUT OUT IAW REO 601R-53-61-3408 AND NDT MANUAL 51-20-06 NO DEFECTS NOTED NDT REPORT ATTACHED. COMPLIED WITH FABRICATION OF REPAIR PARTS -1, -2, -3, SHIM & -4 SHIM FROM 7075-T6 & 2024-T3 P/OSDR ASOA200901164Placard · missing"EMER" PLACARD MISSING ON OUTER ESCAPE HATCH SKIN. INSTALLED SILKSCREEN PRINT TO EMERGENCY ESCAPE HATCH "EMERGENCY EXIT" PER AMM 20-60-11-400-601 1-5.SDR ASOA200901120Frame · corrodedON 559+96 FRAME BETWEEN S26-27L HAS CORROSION LOWER FRAME. REMOVED FRAME PER SRM 51-42-06. INSTALLED NEW FRAME STRINGERS PER SRM 51-42-06.SDR ASOA200901058Skin · corrodedCORROSION ALONG BOTTOM OF BELLY SKIN EXTERNAL SIDE FS 559 AND 93 TO 559 AND 112 AND AT FS 559 AND 45. REMOVED LIGHT SURFACE CORROSION. FOUND TO BE WITHIN LIMITS IAW SRM 53-00-31.SDR ASOA200901060Intercostal · corrodedAT FS 621.0 BULKHEAD INTERCOSTAL RT SIDE HAS ONE SHEARED RIVET AND CORROSION AT NUTPLATE HOLE.SDR ASOA200901059Bulkhead · crackedCRACK NOTED AT FS559.0 AT RBL18.00, WL59.10 (MARKED IN RED). REMOVED AND DISCARDED POSTS, CUTOUT DAMAGED SECTION OF BULKHEAD WEB, PERFORMED OK TO INSTALL ALL FABRICATED PARTS AND INSTALLED POST STRAP IAW REO 601R-53-41-260.SDR ASOA200901057Door Frame · crackedPAX DOOR FWD FRAMES CRACKED AT UPPER RADIUS AT FS319 AND 323. INSTALLED REPLACEMENT FRAME AT FS323.3 IAW SRM 51-42-13 & 51-42-06.SDR ASOA200901056Pressure Blkhd · crackedCRACK IN 702 PRESSURE BULKHEAD LT SIDE LWR WHERE PACKING BREAK CABLE GOES THROUGH. REMOVED -113 BRACKET, WEB STIFFENER AND CHANNEL DOUBLER FROM FS202 BULKHEAD WEB AND CUT OUT DAMAGE AT FS202.75 AT BL23.71 PRESSURE BULKHEAD PER REO 601R-53-11-563. FABRICATED SDR ASOA200900503Sign · brokenPAX DOOR EMERGENCY SIGN BROKE. FLT 5204 DEL 50 MINS.SDR ASOA200900326Cover · missingFLT 5123, EMERGENCY LIGHTS IN CABIN MISSING PLASTIC STRIP AND PHOTO ILLUMINESCENT STRIP IS BROKEN ROWS 9 AND 10. REPLACED EMERGENCY LIGHT FLOOR LENS COVER OPS CHECKS GOOD DONE IAW AMM 33-51-01, THIS CLEARS DEFECT, REMOVED PLACARD.SDR ASOA200900156Feeder Cable · damagedFLT 5590. ELECTROLUMINESCENT FLOOR LEVEL LIGHTING STRIPS FROM ROW 6 TO ROW 7 ARE INOP INTERMITTENTLY. REPLACED FLOOR LIGHTING CABLE ASSY AT 6 AND 7 IAW 33-51-01. DML CLEARED PLACARD REMOVED.SDR ASOA200900052Bulkhead · crackedIN REFERENCE TO TASK CARD AWL 53-61-153 02 W/O 107923. DURING EDDY CURRENT INSPECTION OF AFT PRESSURE BULKHEAD, FOUND THAT BULKHEAD IS CRACKED AT LINTEL ATTACH POINT.SDR ASOA200900043Structure · crackedASD BOTTOM STEP COMPOSITE ATTACHED TO BRACKET CRACKED.SDR ASOA200801421Door · bindingMAIN PAX DOOR HARD TO PULL CLOSE LAST 2 FEET.
Back to N834AS, cancelled Jul 7, 2015