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 ASOA201001213Fitting · corrodedFS 621, LBL 27, LENTIL FITTING UPPER CORRODED. REMOVED CORRODED FITTING IAW SRM 51-42-21. LOCATED AND INSTALLED IAW EO 601R35031 AND SRM 51-42-22. COMPLIED WITH EC/TC SNIEO 601R35031 S01 AND SNIEO 601R-35031 S01.SDR ASOA201001212Cargo Track · corrodedCARGO BAY, LBL 27, 1 SEAT RAIL & 3 NET TIE DOWNS CORRODED. REMOVED 2 SEAT RAILS AND 2 NET TIE DOWNS IAW SRM 51-41-02. CORROSION ON 3 SEAT RAILS AND 2 NET TIE DOWNS IS OUT OF LIMITS OF THE ALLOWABLE DAMAGE IAW SRM 53-61-49. DRILLED HOLES AND INSTALLED 2 NEW SDR ASOA201001211Cargo Track · corrodedCARGO BAY LBL 9, 3 SEAT RAILS AND 2 NET TIE DOWNS CORRODED. REMOVED 2 SEAT RAILS AND 2 NET TIE DOWNS IAW SRM 51-41-02. CORROSION ON 3 SEAT RAILS AND 2 NET TIE DOWNS IS OUT OF LIMITS OF THE ALLOWABLE DAMAGE IAW SRM 53-61-49. DRILLED HOLES AND INSTALLED 2 NESDR ASOA201001210Cargo Track · corrodedCARGO BAY RBL 9, 1 SEAT RAIL CORRODED. REMOVED RBL 9 SEAT RAIL IAW SRM 51-41-02. REQUIRES DRILLING NEW HOLES AND INSTALLATION. RBL 9 SEAT RAIL CORROSION IS OUT OF LIMITS OF THE ALLOWABLE DAMAGE IAW SRM 53-61-49. DRILLED HOLES AND INSTALLED NEW SEAT RAIL IASDR ASOA201001209Cargo Track · corrodedCARGO BAY RBL 27, 1 SEAT RAIL CORRODED. REMOVED RBL 27 SEAT RAIL IAW SRM 51-41-02. REQUIRES DRILLING NEW HOLES AND INSTALLATION. RBL 27 SEAT RAIL CORROSION IS OUT OF LIMITS OF THE ALLOWABLE DAMAGE IAW SRM 53-61-49. DRILLED HOLES AND INSTALLED NEW SEAT RAILSDR ASOA201001245Placard · damagedPASSENGER DOOR STEP PLACARD (EXIT) IS DAMAGED. REMOVED WORN PLACARD IAW MM 11-30-00-000-801 AND APPLIED NEW PLACARD IAW 200 MM 11-30-00-400-801.SDR ASOA201001198Frame · corrodedFS 364.00 JUST FWD OF AVIONICS CUTOUT FRAME HAS CORROSION FROM STR 25L TO STR 25R. REMOVED 7 FITTINGS AND 2 EA GUSSET PLATES IAW SRM 51-42-06, 51-42-21 AND 51-41-02 LOCATED AND DRILLED UP FRAME SECTION IAW SRM 51-42-06. INSTALLED NEW SERVICEABLE FRAME SECTSDR ASOA201001197Angle · crackedREAR PRESSURE BULKHEAD OBLIQUE ANGLE FS 621 TO 625 STR 15 IS CRACKED. R & R OBLIQUE ANGLE PN 601-35012-52 IAW SRM 51-42-21.SDR ASOA201001195Fairing · crackedLT LOWER STANG FAIRING, 434BB, INBD SIDE IS CRACKED. RECEIVED LT LOWER STANG FAIRING 434BB. REF MASTER PANEL BOOK PAGE 30 OF 49 FOR INSTALLATION.SDR ASOA201001124Bulb · burned outNR3 CEILING EMERGENCY LIGHT INOP. NEW 349 FRAME NEED TO BE DRILLED AND INSTALLED. DRILLED NEW FRAME IAW SRM 22 51-40-11. INTERCOSTALS AT STR 25L & 25R, VERTICAL POST AT FS 349L, DRAIN MAST CHANNEL, SUPPORT BRACKET & GANG CLAMP FS 349 24L AND NEW FRAME NEED TSDR ASOA201000779Placard · peelingPAX DOOR EXIT PLACARD PEELING. REMOVED AND REPLACED PAX DOOR EXIT PLACARD IAW AMM 11-30-00. REMOVED AND REPLACED PAX DOOR EXIT PLACARD IAW AMM 11-30-00.SDR ASOA201000657Landing Gear · malfunctionedRECEIVED NLG DISAGREE MSG, RAN QRH (EMERGENCY DECLARED) INSPECTED NOSE LANDING GEAR PROX SYS HANESS, NLG DOOR SYS AND FWD HYD BAY AREA NO DEFECTS FOUND. CYCLED NOSE LANDING GEAR 25 TIMES- NO FAULTS OBSERVED. NLG AND DOORS OPERATE NORMAL IAW AMM 32-20-00. UNABLSDR ASOA201000344Flashlight · brokenF/A FLASHLIGHT BROKEN. REPLACED FLASHLIGHT IAW AMM 25-60-00.SDR ASOA200901467Warning Message · illuminatedFLAP FAIL MSG AT 30 DEGREES. (EMERGENCY DECLARED - ENROUTE, ACFT DIVERTED TO DUE TO MX)SDR ASOA200901190Anchor Fitting · crackedPAX DOOR, AFT ANCHOR FITTING CRACKED.SDR ASOA200901110Light · inoperativeFLT 5557. EMERG LIGHT SYSTEM INOP WILL NOT TEST.SDR ASOA200900328Step · crackedASD BOTTOM STEP CRACKED.SDR ASOA200801325Attach Angle · crackedAT FS 718.0 BETWEEN STRINGERS 11R AND 12R PREVIOUSLY REPAIRED ATTACH ANGLE CRACKED IN RADIUS. REMOVED PREVIOUS REPAIRS FROM FS 718.0 BETWEEN STRINGERS 11R AND 12R IAW CRJ 200 SRM 51-42-06 AND 51-42-21. LPI CUTLINE AS PER REO 601R-53-61-193 AND CRJ 200 NDTM 5SDR ASOA200801324Attach Angle · crackedAT FS 718.0 BETWEEN STRINGERS 11L AND 13L PREVIOUSLY REPAIRED ATTACH ANGLES ARE CRACKED IN RADIUS (2 EA). REMOVED PREVIOUS REPAIRS FROM FS 718.0 BETWEEN STRINGERS 11L AND 12L IAW CRJ 200 SRM 51-42-06 AND 51-42-21. CUTLINE AS PER REO 601R-53-61-193 AND CRJ 20SDR ASOA200801394Bulkhead · crackedDURING EDDY CURRENT INSPECTION ON THE 621 BULKHEAD FWD FACE, AN INDICATION WAS NOTED AT LBL 48.00, WL 106, .500 IN LENGTH.SDR ASOA200801322Bulkhead · crackedWHILE PERFORMING TASK AWL253-41-201, AN INDICATION WAS NOTED AT THE FS 559 BULKHEAD WEB OUTBOARD OF RBL 9, WL 58.7 APPROX .300 INCH IN LENGTH AND INBOARD OF RBL 18, WL 58.7 APPROX 1.0 INCH IN LENGTH. REMOVED DAMAGED SECTION OF THE RT WEB, REPAIRED IAW REO 610SDR ASOA200801321Angle · crackedWHILE PERFORMING TASK AWL253-41-201, AN INDICATION WAS NOTED AT THE 559 BULKHEAD CAP ANGLE RADIUS LBL 9 AND LBL 18 APPROX .500 INCH IN LENGTH. ACCOMPLISHED REPAIR TO (LT SIDE ONLY) 559 BULKHEAD AND CAP ANGLE IAW REO 601R-53-41-260 REV C. REQUIRES PAINT. PAISDR ASOA200801320Bulkhead · crackedAN INDICATION WAS NOTED ON THE 621 BULKHEAD FWD FACE DURING AN EDDY CURRENT INSPECTION AT LBL 9.50, WL 110 .350 IN LENGTH. COMPLIED WITH REO 601R-53-61-1285, STEPS 1 THRU 33 FOR REPAIR TO AFT PRESS BULKHEAD FS 621 LBL 9.0. INCORPORATED REO 601R-53-61-2880 DISDR TRAX200801170Proximity Sensor · out of rigUPON MAIN GEAR TOUCHDOWN RECEIVED NOSE GEAR YELLOW BOX. INITIATED G.A. AND RECEIVED UNSAFE CAUTION WITH NOSE GEAR RED. 3 GREEN NEXT TIME AROUND. EMERGENCY DECLARED. EMERGENCY VEHICLES ON STANDBY AS PRECAUTION. FOUND NLG DOWNLOCK PROX SENSORS PS1GA AND PS2GSDR TRAX200801064Sill · crackedINTERCOASTAL AT FS 589 BETWEEN LBL 36 AND CARGO DOOR SILL CRACKED AT SILL ATTACHMENT. THIS SDR WILL REMAIN OPEN PENDING MX DETERMINATION OF AN APPROPRIATE CORRECTIVE ACTION.SDR TRAX200801050Seat Track · corrodedRT INBD FLOOR. SHORT SEAT TRACK AT 559.96 CORRODED (RESOLVED ON W/O 96197 TASKCARD N/R 00025) JOB COMPLETE ITEM 1. R&R RT INBD SHORT SEAT TRACK FROM FS559.96. PER CRJ200 SRM 51-41-00 KR17389 JOB COMPLETEDSDR TRAX200801049Seat Track · corrodedRT INBD FLOOR SEAT TRACK CORRODED FROM FS 559+16 TO 559+80 (RESOLVED ON W/O 96197 TASKCARD N/R 00024) R&R RT INBD SEAT TRACK FROM FS559+16 TO 559+80. PER SRM 51-41-00.SDR TRAX200801046Intercostal · crackedINTERCOSTAL AT FS 605 BETWEEN LBL 36 AND CARGO DOOR SILL CRACKED AT SILL ATTACHMENT (RESOLVED ON W/O 96197 TASKCARD: N/R 00021) JOB COMPLETE ITEM 1. REFER TO ATTACHED M-234 FORMS FOR WORK ACCOMPLISHED. ITEM 2.SDR TRAX200801045Fitting · crackedCLIP CRACKED AT FS605 AT CARGO DOOR SILL AND INTERCOSTAL ATTACHMENT (RESOLVED ON W/O 96197 TASKCARD N/R 00022) JOB COMPLETE ITEM 1. DRILLED UP NEW CLIP IAW CRJ 200 51-40-11RAP 7025969. ITEM 2.SDR TRAX200800877Light · brokenESCAPE PATH LIGHTING FWD OF AFT LAV IS CRACKED AND BROKEN REMOVED AND REPLACED EMERGENCY LIGHTING TRACK IAW AMM 33-51-01. OPS CHECK GOOD. (B)SDR TRAX200800648Drain Line · cloggedAFTER T/O WHILE RAISING THE GEAR, THERE WAS A SEVERE RANCID ELECTRICAL SMOKE SMELL WITH A HAZY SMOKE IN THE COCKPIT. AIRCRAFT RETURNED TO ATL AFTER T/O, EMERGENCY DECLARED. UNCLOGGED DRAIN LINES FOR LT WATER SEPERATOR IAW AMM 21-51-13-100-802 AND REPLACED COSDR TRAX200800276Placard · missingEXIT PLACARD MISSING FROM INTERIOR ASD. FLT 4330 DEL 35 MINS.SDR TRAX200800260Battery Pack · dischargedEMERGENCY INTER. LIGHT AT MID CURE CEILING LIGHT AND OVERWING LIGHT AND BATTERY PACK NR 2 INOP.SDR TRAX200800252Light · inoperativeEMERGENCY LIGHTS AT A/S/D ENTRANCE, FWD LT AND RT WING AND CEILING AFT SIDE OUT. FLT 4485 CX.SDR TRAX200800024Step · brokenASD BOTTOM STEP BROKEN.SDR TRAX200701742Sign · looseEXIT SIGN ABOVE SERVICE DOOR IS LOOSE AND ABOUT TO COME OFF.SDR TRAX200701602Smoke Detector · activatedRECEIVED A SMOKE TOILET MESSAGE IN FLIGHT. EN ROUTE TO GRK A/C DIVERTED TO MGM DUE TO MTC. EMERGENCY DECLARED. EMERGENCY EQUIPMENT ON STANDBY. FLT 4549 DEL 63 MINS.SDR TRAX200700838Step · brokenBOTTOM STEP ON DOOR BROKEN.SDR TRAX200700835Light · inoperativeEMERGENCY FLOOR LIGHTING INOP AT 11CD.SDR TRAX200700521Rudder · malfunctionedRIGHT RUDDER 80 PERCENT UNCOMMANDED. EMERGENCY DECLARED. FLTS 4177, 4913, 4888, 4913 CX.SDR TRAX200700503Apu · malfunctionedCREW REPORTED AT 10,000 FT DURING APU START UP FUMES DETECTED IN THE CABIN AND COCKPIT APU WAS SHUT DOWN AND SMOKE AND FUMES PROCEDURES WERE FOLLOWED AND THE FLIGHT LANDED SAFELY. EMERGENCY DECLARED. FLTS 4575, 4710 CX. AUXILIARY POWER UNIT APU - INTAKE DOOSDR TRAX200700466Torque Link · disconnectedON TAKEOFF NLG W/N RETRACT RECEIVED GEAR DISAGREE, WOW INPUT, WOW OUTPUT GEAR DOOR OPEN. FOLLOWED QRH UPON LANDING HAD NO NOSE WHEEL STEERING. FOUND TORQUE LINK DISCONNECTED. A/C RETURNED TO AVP AFTER T/O. EMERGENCY DECLARED.SDR TRAX200700016Flap · stuckFLAPS STUCK AT 43 DEG DURING APPROACH (LEFT SIDE 43 RIGHT SIDE 45) NO FLAP FAIL MESSAGE WAS RECEIVED. EMERGENCY DECLARED.SDR TRAX200601051Unknown · odorSMELL OF JET FUEL AFTER APU START IN THE AIR.SDR TRAX200600688Light · inoperativeEMERGENCY EXIT SIGN BY LT WING EMERGENCY EXIT DOOR AT ROW 8AB IS INOP.SDR TRAX200600618Lamp · brokenEMERGENCY FLOOR LIGHTING STRIP HAS BROKEN LAMP. REMOVED & REPLACED WITH SERVICEABLE LAMP IAW CRJ AMM 33-51-01. JPS1057 OPS CK DEFERRED TO 409 WO 3357 W/C 44. JPS1057 (CLOSED)SDR TRAX200600614Rib · crackedRIGHT AILERON RIB AND ATTACHING ANGLE AT WS 340.481 CRACKED AND CHAFED.SDR TRAX200600609Angle · crackedFS 484 CRACKED LBL 9 OB. REMOVED CRACKED ANGLE AT FS 484, OB SIDE OF LBL 9.0. FABRICATED SERVICEABLE ANGLE FROM 7075.T6 .050 PO 5505-1 IAW CRJ SRM 53-41-43. ALODINED, PRIMED, AND PAINTED SERVICEABLE ANGLE IAW CRJ SRM 51-25-16. INSTALLED REPAIR ANGLE IAW CRSDR TRAX200600588Intercostal · crackedPAX DOOR INTERCOSTAL CRACKED AT 338.9, DATUM 1. REMOVED INTERCOSTAL AT FS 338.9 DATUM 1 ON PAX DOOR IAW CRJ SRM 51-42-06. LOCATED AND DRILLED NEW INTERCOSTAL P/N 601R31902-318 IAW CRJ SRM 51-40-11. OK TO INSTALL. INSTALLED INTERCOSTAL IAW CRJ SRM 51-42-06 SDR TRAX200600586Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED. CUT OUT CRACKED SECTION OF PAX DOOR AFT DRAG ANGLE IAW REO 601R-52-11-513. NDT REQUIRED FOR CUT LINE. NDT PERFORMED ON W/C 350 FABRICATED REPAIR DETAILS FROM NEW ANGLE, 601R31772-5S, OK TO INSTALL. INSTALLED DETAILS IAW RE
Back to N846AS, cancelled Jun 1, 2017