N824AS, cancelled Nov 13, 2017
Service difficulty reports · 226
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 = 'N824AS' AND deregistration_id = 'N824AS-2017-11-13' 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 = 'N824AS' AND deregistration_id = 'N824AS-2017-11-13' 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 ASOA201000714Floorbeam · crackedFLOOR SUPPORT ANGLE AFT OF FS 280 IS CRACKED AT LBL 9.0. C/W EC/TC 601R-53-11-171 AND MET ALL REQUIREMENTS OF REO 601R-53-11-171. EC/TC REQUIRED FOR REO 601R-53-11-1901. COMPLIED WITH EC/TC REO 601R-53-11-1901 AND REO 601R-53-11-1901 REV A.SDR ASOA201000703Skin · crackedLEFT LOWER WING PLANK AFT SPAR AREA AT WS 148.019 HAS VISUAL CRACK INDICATION, APPROX .5". C/W EC/TC EO 600-57-134 C/W. REO 601R-57-21-1294 REQUIRES A EC/TC. LT WING LOWER WING PLANK AT WS 148.019 REQUIRES FUEL LEAK CHECK. FUEL LEAK CHECK GOOD IAW MM 28-11-SDR ASOA201000686Flashlight · weakCAPTAINS & F/O FLASHLIGHTS DIM. REPLACED BOTH FLASHLIGHT BATTERIES IAW 200 AMM 25-61-00. (CLOSED)SDR ASOA20100060Inverter · failedR & R NR 3 INVERTOR IAW AMM 33-51-07. OPS CHK GOOD. R & R NR 3 INVERTOR IAW AMM 33-51-07. OPS CHECKED GOOD.SDR ASOA201000060Light · inoperativeRIGHT OVERWING EMERGENCY FLOOR LIGHT INOP.SDR ASOA20100004Bulb · failedR & R LT FWD (FS 302.40L) EXTERNAL LIGHT BULB IAW AMM 33-51-21 OPS CK GOOD. 01-01-2010, ITEM: 1 R & R LT FWD (FS 302.40L) EXTERNAL LIGHT BULB IAW AMM 33-51-21, OPS CK GOOD 01-01-2010. (CLOSED)SDR ASOA201000004Light · inoperativeLT FWD MOST EXTERNAL EMERGENCY LIGHT INOP.SDR ASOA200901340Placard · deterioratedPAX DOOR EXIT, OPEN AND ARROW PLACARD DETERIORATED.SDR ASOA200901188Door · stuckF/A REPORTS THAT THE MAIN PASSENGER DOOR IS DIFFICULT TO OPEN.SDR ASOA200900913Warning System · activatedAFTER TAKEOFF, PULLED GEAR HANDLE UP, RECEIVED "GEAR DISAGREE" RED WARNING MSSG, COMPLIED WITH QRH, RETURNED TO ATL. UPON LANDING CLEARING 27R RECEIVED "HYD3 HI TEMP" MSSG AND LOSS OF NOSE WHEEL STEERING. COMPLIED WITH QRH, TOW TEAM PULLED AIRCRAFT INTO GATESDR ASOA200900704Placard · deterioratedPAX DOOR EXIT PLACARD DETERIORATED.SDR ASOA200900575Warning System · activatedAFTER TO NOSE DISAGREE WARNING FOLLOWED QRH LANDED BACK ATL [EMERGENCY DECLARED]. FLT 5616 DEL 133 MINSSDR ASOA200900416Light · inoperativeSIDE WALL CABIN RT SIDE EMERGENCY LIGHT BURNED OUT BY OVERWING EXIT.SDR ASOA200801441Door · stuckPAX DOOR COULD NOT BE OPENED BY F/A AT THE END OF THE FLIGHT.SDR ASOA200801437Door · bindingCATERING REPORTS GALLEY SERVICE DOOR WILL NOT OPEN FROM OUTSIDE.SDR ASOA200801433Door · jammedPASSENGER BOARDING DOOR JAMS CLOSED AND LOCKED AT TIMES IS TO UNLOCK AND OPEN FROM BOTH INSIDE AND OUTSIDE. FLT 5276 DEL 59 MINS.SDR ASOA200801412Mechanism · faultyPASSENGER AIRSTAIR DOOR LATCHING MECHANISM IS EXTREMELY HARD TO ACTUATE.SDR ASOA200801360Door · bindingCABIN ENTRY DOOR DIFFICULT TO OPEN FROM INSIDE.SDR ASOA200801335Warning System · activatedPAX DOOR OUT HANDLE CAUTION DOOR VERY DIFFICULT TO OPEN. FLT 4919 DEL 26 MINS.SDR TRAX200800904Cam · lack of lubeMAIN CABIN DOOR WILL NOT OPEN FROM INSIDE. FLT 4251 DEL 37 MINS LUBED MAIN CABIN DOOR CAMS IAW AMM 12-20-52 OPS CHECK GOOD. (B)SDR TRAX200800892Handle · lack of lubeDOOR HANDLE RELEASE BUTTON ON SERVICE LUBE DOOR HANDLE IAW AMM 52-00 AC OK FOR SERVICE (B)SDR TRAX200800891Handle · lack of lubePAX DOOR NOT CLOSING PROPERLY. GREEN ALIGNMENT MARKS WILL NOT ALIGN WITHOUT MOVING HANDLE WITH GREAT FORCE LUBE DOOR HANDLE IAW AMM 52-00 AC OK FOR SERVICE.SDR TRAX200800839Door · stuckCATERING ADVISED, CANNOT OPEN SERVICE DOOR FROM OUTSIDE. CLEANED AND LUBED SERVICE DOOR HANDLE. OPS CHECK AFTER SEVERAL CYCLES. REF CRJ200 AMM 52-41-03. (S)SDR TRAX200800837Latch · out of rigPASSENGER DOOR WILL NOT CLOSE WHILE UTILIZING OUTER HANDLE. INSPECTED PASSENGER DOOR AND FOUND THE FWD PULL IN LEVER TO BE HITTING THE FACE OF THE FWD DOOR CAM. REMOVED DOOR PANEL 832AL, REMOVED FWD PULL IN LEVER P/N 600-31689-36. INSTALLED NEW SERVICEABLE SDR TRAX200800796Arm · corrodedPANEL 196AR BOTTOM HINGE ARM CORRODED SEVERELY. REMOVED BOTTOM HINGE ARM IAW ASA SRM 51-42-21 AND ASSEMBLED NEW HINGE ARM USING P/N 601R35323-279 IAW ASA SRM 51-42-06. INSTALLED NEW HINGE ARM ON PANEL 196AR IAW CRJ 200.SDR TRAX200800795Bulkhead · crackedFS 559 BULKHEAD WEB AND CAP ANGLE HAS INDICATIONS NOTED IN WEB RBL 9.00 WL 58.70 APPROX .4 INCH IN LENGTH. RBL 18.0 WL 58.70 APPROX 1.7 INCH IN LENGTH, AND CAP ANGLE LBL 18.00 AND RBL 18.0 IN RADIUS APPROX .5 INCH IN LENGTH FAILED NDT INSP. REPAIRED FS 559 BSDR TRAX200800754Seat Track · corrodedSEAT RAIL AT RBL 9 F.S. 290 TO 559 HAS AREAS OF CORROSION. OPEN (B)SDR TRAC200800754Seat Track · corrodedSEAT RAIL AT RBL 9 FS 290 TO 559 HAS AREAS OF CORROSION. BLENDED CORROSION TO REMOVAL IAW CRJ200 SRM 51-21-06. DEPTH OF BLEND RANGED FROM 0.001" TO 0.008". 390 AND 409+128 AREAS STILL NEED CORROSION REMOVED. REMOVED CORROSION FROM FS 390 TO 409+128. DEPTHSDR TRAX200800766Channel · crackedCARGO DOOR FWD TRACK BOTTOM U CHANNEL IS CRACKED 1/4" LONG AT BOTTOM I/B RIVET. REMOVED CRACKED IAW SRM 51-42-06. LOCATED FASTENER HOLES IN NEW PART AND INSTALLED IAW SRM 51-40-11 AND 51-42-06. J. (B)SDR TRAX20800735Vertical Beam · crackedFS 409.0+128 BULKHEAD VERTICAL STIFFENER BEAM AT LBL 18 CRACKED AT OUTBOARD SIDE LOWER RADIUS APPROX .5 INCH LONG. REMOVED BRACKET ASSY P/N 601R96611-057 FROM LBL 18 TO LBL 27 POST TO GAIN ACCESS TO AREA CRACKS IAW SRM 51-42-06. VERTICAL POST REQUIRES REPAIRSDR TRAX200800735Stiffener · crackedFS 409.0+128 BULKHEAD VERTICAL STIFFENER BEAM AT LBL 18 CRACKED AT OUTBOARD SIDE LOWER RADIUS APPROX 1/2" LONG. (B) REPAIRED BULKHEAD VERTICAL STIFFENER IAW REO 601R-53-41-056 & REO 601R-53-41-056. (A)SDR TRAX200800734Stiffener · crackedFS 409.0+128 BULKHEAD VERTICAL STIFFENER BEAM AT LBL 27 AT INBOARD SIDE CRACKED APPROX 1/4" LONG AT BOTTOM FASTENER. (B) COMPLIED WITH REPAIR IAW REO 601R-53-41-056 AND REO 601R-53-41-056. (A)SDR TRAX200800737Stiffener · crackedFS 406+128 BULKHEAD VERTICAL STIFFENER BEAM AT RBL 36 CRACKED AT INBOARD SIDE BOTTOM FASTENER APPROX 1/4" LONG. PERFORMED REPAIR IAW REO 601R-53-41-189 AND REO 601R-53-41-476. (A)SDR TRAX200800741Seat Track · corrodedSEAT RAIL AT RBL 9 FS 290 TO 559 HAS AREAS OF CORROSION. BLENDED CORROSION TO REMOVAL IAW SRM 51-21-06. DEPTH OF BLEND RANGED FROM 0.001" TO 0.008". 390 AND 406+128 AREAS STILL NEED CORROSION REMOVED. REMOVED CORROSION FROM FS 390 TO 406+128. DEPTH RANGED FROSDR TRAX200800740Support Beam · crackedCARGO DOOR SUPPORT BEAM LOWER ANGLE IS CRACKED APPROX 1.5" IN LENGTH. REMOVED CRACKED ANGLE AND INSTALLED NEW SERVICEABLE PART IAW SRM 51-42-21. (B)SDR TRAX200800739Stiffener · crackedFS 409.0+128 BULKHEAD VERTICAL STIFFENER BEAM AT RBL 18 CRACKED AT OUTBOARD SIDE BOTTOM FASTENER APPROX .25 INCH LONG. COMPLIED WITH REPAIR OF FS 409 + 128 BULKHEAD VERTICAL STIFFENER AT RBL 27 IAW ASA CARD: REO 601R-53-41-056 AND BOMBARDIER REO601R-53-41-0SDR TRAX200800738Stiffener · crackedFS 409.0+128 BULKHEAD VERTICAL STIFFENER BEAM AT RBL 27 CRACKED AT INBOARD SIDE AT BOTTOM RADIUS APPROX 1/4" LONG. COMPLIED WITH REPAIR OF BULKHEAD VERTICAL STIFFENER AT RBL 27 IAW REO 601R-53-41-056 AND REO 601R-53-41-056.SDR TRAX200800794Bulkhead · crackedREAR PRESSURE BULKHEAD WEB THAT SURROUNDS THE LINTEL ATTACHMENT FITTING HAS AN INDICATION NOTED APPROX .2 INCH IN LENGTH 100PERCENT. FAILED NDT INSPECTION. REPAIR REAR PRESSURE BULKHEAD IAW REO 601R-53-61-1230, REV D. REPAIR PER EC/TC REO 601R-53-61-1230 HASDR TRAX200800793Bulkhead · crackedREAR PRESSURE BULKHEAD WEB HAS AN INDICATION NOTED APPROX 1.1 INCH IN LENGTH AT WL 108 RBL 36.20. FAILED NDT INSPECTION 50 PERCENT. REPAIRED REAR PRESSURE BULKHEAD WEB AT WL 108 AND RBL 36.20 IAW REO 601R-53-61-2678. COMPLIED WITH EC/TC REO 601R-53-61-2678 SDR TRAX200800736Stiffener · crackedFS 409+128 BULKHEAD VERTICAL STIFFENER BEAM AT LBL 9 CRACKED AT OUTBOARD SIDE LOWER RADIUS APPROX 1/4" LONG. REMOVED 2 CLAMPS FROM HYD LINES AT LBL 9 OUTBD TO ACCESS FOR REPAIR IAW SRM 51-41-02. REPAIRED IAW REO 601R-53-41-237 AND REO 601R-53-41-237. REINSTASDR TRAX200800728Skin · crackedFUSELAGE SKIN IS CRACKED AT RT FS 732 2.5L BETWEEN STR 10 &11 AND CHAFING DAMAGE FROM CONTACT WITH T/E PYLON BETWEEN FS 700.00 AND FS 755.00 BETWEEN S9-12. (B) REPAIRED SKIN IAW REO 601R-53-61-268 REV A NOTES 1-16. COMPLIED WITH REO 601R-53-61-268 AND COMPSDR TRAX200800729Bulkhead · cracked202.75 PRESSURE BULKHEAD IS CRACKED AT LOWER LT CORNER 1.0" ABOVE AND 1.0" BELOW CUTOUT FOR PARKING BRAKE CABLE. COMPLIED WITH REO 601R-53-11-1412, INSTALLED SERVICEABLE INSULATION BLANKETS IAW AMM 25-81-01-400-801. COMPLIED WITH EC/TC REO 601R-53-11-1412 ISDR TRAX200800674Fitting · lack of lubePSG DOOR STUCK AND WOULD NOT OPEN UPON ARRIVAL INTO SHV. LUBED AND CLEANED SHOOT DOOR FITTINGS AND PERFORMED OPS CK ON ASD IAW CRJ200 AMM 12-20-52 AND CRJ200 AMM 52-11-00. OPS CK GOOD A/C OK FOR SERVICE. [SDR CLOSED]SDR TRAX200800661Bpsu · inoperativeFLAPS FAIL MSG WHEN SELECTING FLAPS FROM 20 DEG TO 30 DEG FLAPS FAILED AND 20 DEG. REMOVED AND REPLACED RT FLAPS BPSU ASSY AND FECU ASSY IAW AMM 21-51-10 AND 21-51-05. OPS CHECK GOOD. (B)SDR TRAX200800537Door · bindingSERVICE DOOR HARD TO OPEN FROM OUTSIDE.SDR TRAX200800523Plate · brokenFORWARD EMERGENCY FLOODLIGHTS BASE PLATE BROKEN AT ENTRYWAY.SDR TRAX200800480Light · brokenEMERGENCY LIGHT ON LEFT WALL ENTRANCE IS BROKEN. FLT 4247 DEL 84 MINS.SDR TRAX200800246Pump · malfunctionedHYD PUMP 2B FAILED ON SHORT FINAL INTO ATL. SWITCH WAS CYCLED AND 2B PUMP STARTED WORKING. EMERGENCY DECLARED.SDR TRAX200701782Handle · stuckMAIN PAX DOOR WILL NOT LATCH FROM INSIDE OR OUTSIDE A/C. JAMMED ITSELF TRYING TO STOW OUTER HANDLE.SDR TRAX200701756Door · stuckMAIN CABIN DOOR VERY DIFFICULT TO OPEN FROM THE OUTSIDE.
Back to N824AS, cancelled Nov 13, 2017