N839AS, cancelled Jun 8, 2017
Service difficulty reports · 185
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 = 'N839AS' AND deregistration_id = 'N839AS-2017-06-08' 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 = 'N839AS' AND deregistration_id = 'N839AS-2017-06-08' 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 ASOA201100467Cover · missingEMERGENCY LIGHT COVER AT PX BOARDING DOOR IS MIISSING. REPLACED EMERGENCY LIGHT COVER AND PLACARD. OPS CHECK GOOD. (CLOSED)SDR ASOA201100217Lens · missingEMERGENCY LIGHT AT MAIN PAX DOOR ENTRANCE MISSING COVER. REPLACE MISSING EMERGENCY COVER AT MAIN DOOR ENTRANCE. REF AMM 33-51-19. (CLOSED)SDR ASOA201100180Flashlight · inoperativeCAPT'S FLASHLIGHT IS BROKE. R & R CAPT'S PORTABLE FLASHLIGHT IAW AMM 25-61-00. OP'S CHECKED GOOD. R & R CAPT'S PORTABLE FLASHLIGHT IAW AMM 25-61-00. OP'S CHECKED GOOD.SDR ASOA201100104Steering Unit · failed"STEERING INOP" CAUTION MESSAGE IN FLIGHT. RAN QRH BUT WAS UNABLE TO RESET OR EXTINGUISH MSG. (EMERGENCY DECLARED) R & R ECU IAW AMM 32-51-10. OPS CHECK GOOD.SDR ASOA201001688Pdu · unserviceableFLAPS FAIL CAUTION MSG ON APPROACH AT 22 DEG (EMERGENCY DECLARED -- EMERGENCY VEHICLES WERE STANDING BY AS A PRECAUTION) COMPLIED WITH AD 2009-06-12. ACFT RETURNED TO SERVICE. CLEARED, PLACARD REMOVED. R & R FLAP PDU IAW AMM 27-52-01,OPS CK GOOD. (CLOSED)SDR ASOA201001510Light · brokenF/A WARDROBE EMERGENCY LIGHT BASE BROKEN. REPLACED EMERGENCY LIGHT BASE IAW AMM 25-61-02 , OPS CHECK GOOD.SDR ASOA201000444Door · lack of lubeSERVICE DOOR COULD NOT BE OPENED FROM OUTSIDE HANDLE, JAMS HALF-WAY THROUGH TRAVEL. LUBED OUTER HANDLE IAW AMM 52-40-01. OPS GOOD.SDR ASOA201000185Anchor Fitting · out of adjustPAX DOOR HARD TO OPEN THEN MADE POPPING SOUNDS WHEN FINALLY OPENED. ADJUSTED PAX DOOR AFT ANCHOR FITTING IAW AMM 52-11-00.SDR ASOA201000150Pressure Valve · out of adjustPAX DOOR HANDLE DIFFICULT TO OPEN. ADJUSTED AND TESTED PAX DOOR PRESSURE VALVE IAW AMM 52-11-15 OPS CK NORMAL.SDR ASOA201000081Cylinder · out of rigCREW REPORTED PAX DOOR HARD TO OPEN. TROUBLESHOT PAX DOOR FOUND FWD GAS SPRING OUT OF RIG AND SUPPORT WHEEL DRAGGING ON DOOR FRAME. RIGGED PAX DOOR FWD GAS SPRING AND SUPPORT WHEEL IAW AMM 52-11-17 AND 52-11-13.SDR ASOA201000080Door · stuckUPON REACHING GATE MAIN PAX DOOR WOULD NOT OPEN. AFTER SEVERAL ATTEMPS WE WERE ABLE TO OPEN DOOR. LUBE PAX DOOR HANDLE TRACKS, OPS CHECK GOOD, OK FOR SERVICE IAW AMM 52-10-00.SDR ASOA201000026Door · stuckF/A HAD TROUBLE OPENING PAX DOOR FROME INSIDE ACFT, SAYS HANDLE ONLY MOVES ABOUT HALFWAY. OPS CHECK GOOD IAW AMM 52-10-01.SDR ASOA20100011Door · stiffR & R PAX DOOR ASSY IAS AMM OF CHECK GOOD 52-11-03. (CLOSED)SDR ASOA201000011Door · stiffMAIN PASSENGER DOOR HANDLE DIFFICULT TO OPEN. REPEAT WRITE-UP.SDR ASOA200901456Door · stuckF/A REPORTS DIFFICULTY OPENING PAX DOOR.SDR ASOA200901450Door · stuckPAX CABIN DOOR WILL NOT OPEN FROM INSIDE. LEVER WILL ONLY RAISE 1/3 OF THE NORMAL TRAVEL. DOOR HAD TO BE OPEN FROM OUTSIDE TWICE.SDR ASOA200901422Door · stickingMAIN PAX DOOR STICKING DURING OPEN/CLOSING NOT OPERATING 1ST ATTEMPT.SDR ASOA200901378Door · sticksPASSENGER DOOR STICKS IN CLOSED POSITION.SDR ASOA200901318Handle · bindingF/A SAYS PAX DOOR INNER HANDLE IS DIFFICULT TO OPERATE WHEN OPENING THE DOOR.SDR ASOA200901314Door · bindingPASSENGER DOOR HARD TO OPEN FROM INSIDE.SDR ASOA200901135Seat Track · corrodedRIGHT SEAT TRACKS (2 SECTIONS) FORWARD OF THE FS 409 CORRODED. REMOVED AND REPLACED NEW SEAT RAIL ON RIGHT SIDE AND INSTALLED RT SIDE SEAT TRACK AT FS 409+18.02 IAW AMM 53-01-11-04.SDR ASOA200901134Seat Track · corrodedLEFT SEAT TRACKS (2 SECTIONS) FORWARD OF THE F.S. 409 ARE CORRODED. REMOVED AND REPLACED SEAT RAIL ON LEFT HAND SIDE AND INSTALLED LT SIDE SEAT TRACK AT FS 409+18.02 IAW AMM 53-07-11-04.SDR ASOA200901085Structure · corrodedFS 349.00 FRAME BETWEEN ST23L AND 23R HAS CORROSION ON FWD AND AFT SIDES. REMOVED AND REPLACED IAW SRM 51-42-06.SDR ASOA200901084Frame · corrodedFS 333.00 BETWEEN ST23L AND 23R HAS CORROSION ON FWD AND AFT SIDES. REMOVED AND REPLACED DAMAGED FRAME SECTION AT FS 333 STGR 23L AND 23 RT. ALL WORK PERFORMED IAW SRM 53-21-15.SDR ASOA200901083Frame · corrodedFS319.00 BETWEEN ST23L AND 23R HAS CORROSION ON FWD AND AFT SIDES. REMOVED AND REPLACED DAMAGED FRAME SECTION AFT FS 319 BETWEEN STGR 23L AND 23RT. ALL WORK PERFORMED IAW SRM 53-21-15.SDR ASOA200901065Channel · crackedAT FS 409+128 THE INBD AND OTBD VERTICAL U CHANNELS AT BL 0 UPPER AFT REINFORCEMENT L ANGLES ARE CRACKED IN RADIUS. REMOVED AND REPLACED L ANGLES ON 409+128 INBD & OTBD POST BLO UPPER SIDE IAW SRM CH 51-42-06.SDR ASOA200901064Channel · crackedAT FS 409+128 THE VERTICAL INBD U CHANNEL AT RBL 27 IS CRACKED IN THE AFT LOWER RADIUS AT EDGE. FABRICATED REPAIR ANGLE (-2) IN ANNEALED CONDITION IAW REO 601R-53-41-056. HEAT TREATED REPAIR ANGLE PER SRM 51-24-06. REMOVED FASTENERS IN REPAIR AREA PER REO 6SDR ASOA200901063Channel · crackedAT FS 409+128 THE VERTICAL OTBD U CHANNEL AT RBL 18 IS CRACKED IN THE AFT LWR RADIUS AT EDGE. REPAIRED VERTICAL U CHANNEL AT FS 409+128 RBL18 IAW REO 601R-53-41-056.SDR ASOA200901051Floorbeam · corrodedFLOORBEAM STRUCTURE AT FS621.0 AND BETWEEN LBL9.00 AND LBL 27.00 HAS CORROSION IN AREA OF NUTPLATES. BLENDED CORRODED AREA IAW SRM 51-12-00. DAMAGED AREA WAS FOUND TO BE .007 DEEP WITHIN ALLOWABLE DAMAGED LIMITS IAW SRM 53-61-43 AND 53-00-00 RESTORED FINISH ANSDR ASOA200901050Frame · crackedFRAME CAP ANGLE CRACKED IN RADIUS AT FS 559.00, LBL18. COMPLIED WITH N/R-00274. REPAIRED ON E/C REO 601R-53-41-260 W/O 132389.SDR ASOA200901040Light · damagedFLOOR EMERGENCY FLOOR TRACK LIGHT IS DAMAGED. REPAIRED IAW EO 600-33-0015.SDR ASOA200901039Skin · crackedLT WING PLANK IS CRACKED AT THE AFT SPAR ON WS 148.019. REPAIRED LT WING PLANK AT THE AFT SPAR IAW EC/TC 600-57-134 C/W LK CK GOOD IAW CRJ 200 AMM 28-11-00.SDR ASOA200901037Sign · crackedEXIT PLASTIC SIGN ON FWD CABIN CEILING PANEL CRACKED. REMOVED AND REPLACED NEW EXIT PLASTIC SIGN ON FWD CABIN CEILING PANEL IAW AMM 33-51-14-04SDR ASOA200901035Frame · crackedRT FS718.00 FRAME CRACKED BETWEEN STRINGERS 10 AND 11. REPAIRED BOTH LT & RT 718.00 FRAME PER S/B 601R-53-055.SDR ASOA200901032Door · stuckUPON GATE RETURN PAX DOOR WOULD NOT OPEN. REPEAT WRITEUP.SDR ASOA200900929Door · bindsPAX DOOR DIFFICULT TO OPEN.SDR ASOA200900927Door · bindsMAIN PAX DOOR DIFFICULT TO OPEN FROM INSIDE.SDR ASOA200900404Warning System · activatedGEAR DISAGREE (NOSE GEAR DOWN) MSG IN FLT WITH NW STRNG INOP MSG. RETURNED TO ATL. NORMAL LANDING. RESET NWS, TAXIED TO GATE. EMERGENCY DECLARED.SDR ASOA200900393Intercostal · crackedINTERCOSTAL AT WS 130 ON LT WING HAS A CRACK.SDR ASOA200900163Flap System · failedFLAPS FAIL AT ZERO ON TURN TO FINAL.SDR ASOA200900119Door · bindsPAX WILL NOT CLOSE. PAX DOOR POWER ASSIST SYSTEM.SDR ASOA200801313Door · stuckUNABLE TO OPEN PAX DOOR FROM OUTSIDE. -REPEAT-SDR ASOA200801312Door · stuckPAX DOOR STUCK CLOSED, WILL NOT OPEN FROM OUTSIDE.SDR TRAX200800939A/C Pack · seizedAFTER LANDING DURING TAXI IN HAD A RT PACK HIGH TEMP CAUTION MESSAGE (FROM DEFECT 423741-1; STRONG SMELL IN CABIN AFTER TAKEOFF. SMELL RESEMBLED SMOKE AND STARTED DISSIPATING. CHECKED ALL SYSTEMS AND RETURNED FOR PRECAUTIONARY OVERWEIGHT LANDING. (AIR RETURSDR TRAX200800359Flap System · failedFLAP FAIL MSG WHEN SELECTING 8. FLAPS FAILED AT ZERO, EMERGENCY DECLARED, FLT 4218 CX.SDR TRAX200800338Flap System · failedFLAPS FAIL AT ZERO DEGREE'S, FLT 4709 CX, FLT 4472 DEL 19 MINS.SDR TRAX200800321Door · unknownPAX DOOR WILL NOT CLOSE PROPERLY.SDR TRAX200701689Warning Message · illuminatedR THRUST REVERSER UNLOCK MESSAGE IN FLIGHT EMER STOW BUTTON WAS USED, NO INDICATION CHANGE TOOK PLACE. EN ROUTE TO ATL A/C DIVERTED TO CVG DUE TO MTC. EMERGENCY DECLARED. THRUST REVERSER SYSTEMS.SDR TRAX200701308Handle · sticksMAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE, MAIN DOOR HANDLE IS STICKING.SDR TRAX200701267Door · stuckMAIN ASD JAMMED SHUT.
Back to N839AS, cancelled Jun 8, 2017