N843AS, cancelled Jun 1, 2017
Service difficulty reports · 148
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 = 'N843AS' AND deregistration_id = 'N843AS-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 = 'N843AS' AND deregistration_id = 'N843AS-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 ASOA201000130Post · crackedFOUND FS 409.0+128 VERTICAL POST RBL 18.00 INBD AND OTBD SIDES HAVE INDICATIONS NOTED AFT FLANGE RADIUS WL 69 APPROX .2" IN LEGNTH 60 PERCENT FSH AND 70 PERCENT FSH FAILED NDT INSP. REMOVED 409+128 INBD & OTBD RBL 18 POSTS IAW SRM 51-42-06 STEP 11 A & B 1-6.SDR ASOA201000138Plate · corroded2 EA ANCHOR PLATES CORRODED AT LBL 27 BETWEEN FS 559+90 AND FS 567. REMOVED AND REPLACED 2EA ANCHOR PLATES AT LBL 27 BETWEEN F.S. 509+90 AND F.S. 567.00 IAW SRM 51-41-00 AND 51-41-04 STEP 3.SDR ASOA201000137Plate · corroded2 EA ANCHOR PLATES CORRODED AT LBL 9 BETWEEN FS 574 AND FS 605. RECEIVED TWO NEW SERVICEABLE ANCHOR PLATES. REMOVED AND INSTALLED TWO NEW SERVICEABLE ANCHOR PLATES IAW SRM 51-41-02.SDR ASOA201000129Sill · corrodedFS 559.00+80 - FS 621.00 RT FLOOR SILL HAS CORROSION. REMOVED NUTPLATES FROM RT CARGO SILL PLATE IAW SRM 51-42-15 STEP 10 AND 51-42-10 FIGURE 4. REMOVED CORROSION FROM RT CARGO SILL IAW SRM 51-21-06 STEP 3. INSTALLED NEW NUTPLATES IAW SRM 51-45-00 STEP 9 ASDR ASOA201000128Sill · corrodedFS 559.00+80 - FS 559.00+95.01 LT FLOOR SILL HAS CORROSION. REMOVED 9 EA NUTPLATES FROM LT FLOOR SILL IAW SRM 51-45-00 STEP 8 AND 51-42-10 FIG 4 AND REMOVED CORROSION IAW SRM 51-21-06 STEP 3E. REMOVED APPROX .003 MAX. TREATED & PRIMED AREA IAW SRM 51-21-11 SDR ASOA201000127Floor Support · corrodedFS 567.00-FS 621.00 LBL 27 HAS CORROSION AROUND NUTPLATE HOLES ON FLOOR SUPPORT CAP. REMOVED FLOOR BEAM CAP IAW SRM 51-42-06 STEP 11 AND 51-42-21 STEP 11 AND LOCATED AND DRILLED NEW FLOOR BEAM CAP IAW SRM 51-40-11 AND INSTALLED FLOOR PANEL NUTPLATES IAW SRM SDR ASOA201000126Floorbeam · corrodedFLOOR SUPPORT ANGLE HAS CORROSION AROUND NUTPLATE HOLES AT FS 589 BETWEEN RBL 9 AND RBL 27. REMOVED CORRODED (BEYOND LIMITS) FLOOR SUPPORT ANGLE CAP IAW SRM 51-42-06 STEP 11 AND 51-42-21 STEP 11. INSTALLED NEW ANGLE IAW SRM 51-42-06. INSTALLED NEW SERVICEASDR ASOA201000125Floorbeam · corrodedFLOOR SUPPORT ANGLE HAS CORROSION AROUND NUTPLATE HOLES AT FS 559.00 BETWEEN LBL 9 AND LBL 27. FOUND CORROSION TO BE BEYOND LIMITS. REMOVED FLOOR SUPPORT ANGLE CAP IAW SRM 51-42-06 STEP 11 AND 51-42-29 STEP 11. INSTALLED NEW SERVICEABLE FLOOR SUPPORT ANGLESDR ASOA201000124Floorbeam · corrodedFLOOR SUPPORT ANGLE HAS CORROSION AROUND NUTPLATE HOLES FS 559.00+80 RBL 27 TO RBL 36. REMOVED LIGHT CORROSION FROM FLOOR SUPPORT ANGLE IAW SRM 51-21-06 1A, 3A AND B1-2, 4 AND 5, FOUND TO BE WITHIN LIMITS IAW SRM 53-00-00 1A-B FIGURE 102. STARTING THICKNESSSDR ASOA201000123Floorbeam · corrodedFS 621, LBL 27 FLOOR SUPPORT UPPER FITTING HAS CORROSION AROUND RIVET HOLE. REMOVED CORRODED FLOOR SUPPORT FITTING IAW SRM 51-42-22 PG 21 ITEM 11A. INSTALLED NEW FLOOR SUPPORT FITTING IAW SRM 51-42-22 PG 17 ITEMS 9A THROUGH 9C(1), 51-41-02 PG 5 ITEM 3A THROUSDR ASOA201000122Cargo Track · corrodedBAGGAGE RAIL AT FS 621 ON LBL 9 CORRODED. REMOVED CORRODED BAGGAGE RAIL AT FS 621 LBL 9 & INSTALLED NEW RAIL (SERVICEABLE) IAW SRM 51-41-00.SDR ASOA201000121Cargo Track · corrodedBAGGAGE RAIL AT FS 559+112 LBL 9 CORRODED. REMOVED CORRODED BAGGAGE RAIL AT FS 559+112 LBL 9. LOCATED AND DRILLED NEW SERVICEABLE RAIL. INSTALLED RAIL IAW SRM 51-41-02 STEPS 1A, 2B1, C1A2A, 3A2A-D.SDR ASOA201000120Cargo Track · corrodedBAGGAGE RAIL AT FS 559+112 RBL 9 CORRODED. REMOVED CORRODED FLOOR CARGO TRACK SEGMENT FS 559+112 RBL 9 BY REMOVING 11 SCREWS. INSTALLED NEW FLOOR CARGO TRACK SEGMENT IAW SRM 51-40-11 PG 8 ITEMS 6A THROUGH 6B(1), 51-41-02 PG 1 ITEM 2A THROUGH PG 3 ITEM 2C2(ASDR ASOA201000119Seat Track · corrodedFLOOR TRACK SEGMENT CORRODED AT FS 559+80 LBL 9. REMOVED CORRODED FLOOR SEAT TRACK SEGMENT FS 559+80 RBL 9 BY REMOVING 9 COUNTERSUNK SCREWS. INSTALLED NEW FLOOR SEAT TRACK SEGMENT IAW SRM 51-40-11, PG 8 ITEMS 6A THROUGH 6B(1), 51-41-02 PG 1 ITEM 2A THROUGH SDR ASOA201000118Seat Track · corrodedFLOOR SEAT TRACK SEGMENT CORRODED FS 559+80 RBL 9. REMOVED CORRODED FLOOR SEAT TRACK SEGMENT FS 559+80 RBL 9 BY REMOVING 9 COUNTERSUNK SCREWS. INSTALLED NEW FLOOR SEAT TRACK SEGMENT FS 559+80 RBL 9 IAW SRM 51-40-11, PG 8 ITEMS 6A THROUGH 6B(1), 51-41-02 PG 1SDR ASOA201000117Seat Track · corrodedFLOOR SEAT TRACK SEGMENT CORRODED FS 559+80 RBL 27. REMOVED CORRODED SEAT TRACK FROM FS 559+80 RBL 27 IAW SRM 51-41-00. LOCATED & DRILLED NEW SERVICEABLE SEAT TRACK AT FS 559+80 RBL 27. INSTALLED SEAT TRACK P/N 601R387799 PO 112139 WITH SCREW P/N NAS517-3-4SDR ASOA201000115Sill · corrodedPRESSURE FLOOR SILL FROM FS 409.00+128 TO FS 559.00 OTBD OF LBL 36 HAS SEVERAL AREAS OF CORROSION. CLEANED AND STRIPPED PAINT TO ACCESS CORROSION IAW AMM 51-26-00-150-803. C/W REO 601R-53-41-666 REV O.SDR ASOA201000114Sill · corrodedPRESSURE FLOOR SILL FROM FS 409.00+128 TO FS 559.00 OTBD RBL 36 HAS SEVERAL AREAS OF CORROSION. CLEANED AND STRIPPED PAINT FOR ACCESS TO CORROSION IAW AMM 51-26-00-150-803. C/W EC/TC REO 601R-53-41-1163 AND REO 601R-53-41-1163 REV NC.SDR ASOA201000110Placard · missingCREW ESCAPE HATCH EXTERIOR SKIN MISSING ALL PLACARDS. REPLACED SILKSCREEN IAW AMM 11-10-03-400-801.SDR ASOA201000106Bulkhead · crackedFS 621.00 PRESSURE BULKHEAD WEB HAS 2 INDICATIONS NOTED AT RBL 18.00 HEEL LINE. 1, 3.50" LONG INTERMITTENT 50 PERCENT FSH AT WL 108.50 & 2) 0.25" LONG 40 PERCENT FSH AT WL 133.00. AREAS MARKED ON ACFT. FAILS NDT INSPECTION AT THIS TIME. C/W EC/TC REO 601R-53-SDR ASOA201000105Bulkhead · crackedFS 621.00 PRESSURE BULKHEAD WEB HAS AN 80 PERCENT FSH INDICATION NOTED APPROX 1.0" LONG AT LBL 27.50 WL 131.00 EXTENDING FROM THE UPPER VB CORNER OF THE AFT CARGO DOOR TRACK. AREA MARKED ON ACFT. FAILS NDT INSP AT THIS TIME. C/W EC/TC REO 601R-53-61-1541.SDR ASOA201000104Bulkhead · crackedFS 621.00 PRESSURE BULKHEAD WEB HAS A 40 PERCENT FSH INDICATION NOTED .50" LONG AT LBL 36.20 WL 78.50 INDICAITON MARKED ON ACFT. FAILS NDT INSP AT THIS TIME. COMPLIED WITH EC/TC REO 601R-53-61-1285 AND PROCESSED M-93 WEIGHT CHANGE FORM AS REQUIRED. COMPLIED WSDR ASOA201000102Handle · out of adjustPAX DOOR INNER HANDLE FAILED PULL TEST. ADJUSTED THE PAX DOOR FWD SPIGOT FITTING BY REMOVING .010 SHIM FROM UNDER SERRATED PLATE IAW MM 52-11-00-730-802, STEP 3A (23)(1)1-5 AND 18-62. PERFORMED PAX DOOR INNER HANDLE PULL TEST IAW MM 52-11-23-720-801 STEPS 3SDR ASOA201000085Placard · peelingPAX DOOR "EXIT" PLACARD IS PEELING. REMOVED PAX DOOR EXIT PLACARD IAW AMM 11-20-00-000-801. INSTALLED NEW PAX DOOR EXIT PLACARD IAW AMM 11-20-00-400-801.SDR ASOA201000084Angle · crackedRT MID FS 625 OBLIQUE ANGLE IS CRACKED AT BL 45, STR R14 WL 97.5. R & R RT MID FS 625 OBLIQUE ANGLE IAW SRM 51-42-21. PAINTED OBLIQUE ANGLE IAW SRM 51-25-16.SDR ASOA201000083Angle · crackedLT MID FS 625 OBLIQUE ANGLE IS CRACKED AT BL 45, STR LT WL 97.5. R & R LT MID FS 625 OBLIQUE ANGLE IAW SRM 51-42-21. PAINTED OBLIQUE ANGLE IAW SRM 51-25-16.SDR ASOA200901229Placard · wornEXIT PLACARD ON PAX DOOR IS WORN AND NOT READABLE. F/A REPORTS "EXIT" DECAL ON MAIN AIRSTAIR DOOR NEEDS TO BE REPLACED.SDR ASOA200901086Door · stuckPAX DOOR GETS STUCK IN CLOSED POSITION, WILL NOT OPEN FROM INNER HANDLE.SDR ASOA200901022Frame · crackedF.S. 718 LT FRAME HAS A PREVIOUS REPAIR BETWEEN STR 11L AND 12L THAT IS CRACKED. FRAME HOLES ALSO WILL NOT ALIGN WITH S/B 601R-53-055-01 ATTACH FITTINGS. REMOVED LT FS 718.00 FRAMED IAW SRM 51-42-06. INSTALLED NEW FRAME IAW SRM 51-42-06.SDR ASOA200901021Frame · crackedFS 718 RT FRAME HAS A PREVIOUS REPAIR BETWEEN STR 11R AND 12R THAT IS CRACKED. FRAME HOLES ALSO WILL NOT ALIGN WITH S/B 601R-53-055-01 ATTACH FITTINGS. REMOVED FRAME IAW SRM 51-42-06. INSTALLED NEW FRAME IAW SRM 51-42-06.SDR ASOA200900968Unknown · unknownWORKING APU DOOR POS UNKNOWN PER DML 478158-3SDR ASOA200900469Warning System · activatedIN FLIGHT RECEIVED SPOILERON CAUTION AND FLIGHT SPOILER CAUTION MESSAGE AND I/B GROUND SPOILER FAULT STATUS MESSAGE. EMERGENCY DECLARED.SDR ASOA200900383Warning System · activatedDURING FLIGHT REC'D SPOILERON, FLT SPLRS, + GND SPLR DEPLOY. CAUTION MSGS COMPLIED WITH QRH GROUND SPOILERS WERE NOT DEPLOYED. EMERGENCY DECLARED.SDR ASOA200900127Light · inoperativeLT SIDE AFT EMERGENCY LIGHT IS INOP.SDR ASOA200900079Step · crackedASD LOWER COMPOSITE STEP IS CRACKED ON THE FWD SIDE.SDR TRAX200801169Bpsu · malfunctionedFLAPS FAILED AT 20 DEGREES AND WOULD NOT RETRACT AFTER DEPARTURE. ENROUTE TO ATL A/C DIVERTED TO CAE DUE TO MTC. EMERGENCY VEHICLES ROLLED AS A PRECAUTION. R&R LT BPSU IAW CRJ-200 M/M 27-51-10. OPS CK GOOD.SDR TRAX200800890Lamp · inoperativeLT SIDE OF FUSELAGE EXTERNAL AFT EMERGENCY LIGHT INOP. RELAMP LT SIDE OF FUSELAGE EXTERNAL AFT EMERGENCY LIGHT IAW AMM 33-51-21. OPS CHECK GOOD. (B)SDR TRAX200800805Fcu · malfunctionedFLAPS FAIL EICAS CAUTION MSG WHEN FLAPS SELECTED FROM 20 TO 30. FLT 4343 CX. REMOVED AND REPLACED FECU IAW CRJ200 AMM 27-51-05, OPS CHECK GOOD.SDR TRAX200800135Light · brokenAAR-2150 - FLOOR EMERGENCY FLOOR LIGHT ON WARDROBE IS BROKEN.
SDR TRAX200800095Doubler · crackedRIGHT FS 640 BONDED SKIN DOUBLER CRACKED. REPAIRED RT 640.00 BONDED SKIN DOUBLER IAW REO 601R-53-61-506.
SDR TRAX200800094Doubler · crackedLEFT FS 640 BONDED SKIN DOUBLER WAS FOUND TO HAVE TWO CRACKS AS MARKED. COMPLIED WITH EC/TC REO 601R-53-61-2492.
SDR TRAX200800087Sign · inoperativeAAR - LIGHTED FLOOR LEVEL EXIT SIGN AT LEFT OVERWING EXIT DID NOT LIGHT DURING OPS CHECK OF NR 4 CHARGER ASSEMBLY. UPON FURTHER REVIEW OF INSERTS ON FLOOR PANEL 271ELF FOUND INSERT TO BE LOOSE AND NOT DAMAGE REBONDED SAME SERVICEABLE INSERT IAW CMM REPAIR.
SDR TRAX200800084Angle · crackedRIGHT FS 625 OBLIQUE ANGLE IS CRACKED. REMOVED CRACKED RIGHT FS 625 OBLIQUE ANGLE. LOCATED NEW OBLIQUE ANGLE P/N 601-35012-52, IAW CRJ SRM 51-40-11. OK TO INSTALL. INSTALLED OBLIQUE ANGLE IAW CRJ SRM 51-42-21 AND REO 601R-53-61-985. OK TO TOP COAT FASTENESDR TRAX200800083Fitting · crackedAAR - CLIP CRACKED I/B OF RBL 36.
SDR TRAX200800082Fitting · crackedAAR - CLIP CRACKED O/B OF RBL 27.
SDR TRAX200800081Fitting · crackedAAR - CLIP CRACKED O/B OF LBL 27.
SDR TRAX200701712Handle · damagedMAIN CABIN DOOR OUTER HANDLE WOULD NOT STOW FROM INSIDE OF A/C, HAD TO GET GROUND PERSONEL TO CLOSE FROM OUTSIDE. THAT STILL TOOK SEVERAL ATTEMPTS.SDR TRAX200700726Light · inoperativeSEVERAL EMERGENCY LIGHTS INOP.SDR TRAX200700705Power Supply · inoperativeNR 3 POWER PACK FOR EMERGENCY LIGHTS INOP.SDR TRAX200700699Sign · no testOVERHEAD EMERGENCY EXIT SIGN DID NOT ILLUMINATE DURING TEST.
Back to N843AS, cancelled Jun 1, 2017