N971EV, cancelled Apr 22, 2024
Service difficulty reports · 74
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 = 'N971EV' AND deregistration_id = 'N971EV-2024-04-22' 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 = 'N971EV' AND deregistration_id = 'N971EV-2024-04-22' 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 ASOA2014011609765Warning Message · false activationNOSE GEAR WARNING IN FLIGHT, EMERGENCY DECLARED, ACFT RETURNED TO DEPARTURE. PERFORMED FUNCTIONAL TEST OF THE LANDING GEAR EXTENSION. RETRACTION SYS IAW AMM 32-30-00. NO DEFECTS NOTED. ACFT OK FOR SERVICE.SDR ASOA2013100109139Wire · brokenEMERGENCY LIGHT FOUND ENTRY DOOR WIRES HANGING LOOSE. REPAIRED BROKEN SPLICE ON ENTRY EXIT LIGHT IAW AMM 33-51-01. OPS CHECKED GOOD AT THIS TIME.SDR ASOA2013041603379Hose · brokenHYD 3 LO PRESS MSG IN FLT QTY 5, 0 PSI FOLLOWED QRH MANUAL GEAR EXTENTION NORMAL LANDING. AFTER INSP FOUND A BROKEN PRESS HOSE NR 8. R & R PRESS HOSE IAW AMM 29-12-03 REFER TO NEXT PG FOR LEAK CK ON PUMP 3A AND HYD SERVICE FOR SYS 3.SDR ASOA2013032103246Bulb · burned outRT FUSELAGE EXTERNAL NR 2 EMERGENCY LIGHT IS INOPERATIVE. R & R BULB IAW AMM 33-51-21. OP'S CHECKED GOOD.SDR ASOA2012100802336Attach Fitting · corrodedFS 625.30, APPROX WL 90 HAS CRACKED ATTACH FITTING TO REAR OF PRESSURE BULKHEAD. R & R DAMAGED ATTACH FITTING ON AFT SIDE OF PRESSURE BULKHEAD IAW SRM 51-42-21 AND 51-40-11.SDR ASOA2012102302396Bulkhead · crackedREAR PRESSURE BULKHEAD FORWARD FACE IS CRACKED ABOVE AFT CARGO DOOR TRACK, AREA IS MARKED. CUT OUT DAMAGE AND STARTED FABRICATING DOUBLERS IAW REO 601R-53-61-1541. COMPLIED WITH REO 601R-53-61-1541. FOUND TO BE SATISFACTORY.SDR ASOA2012100802335Seat Track · corrodedSHORT SEAT TRACK AT RBL 27 HAS CORROSION JUST AFT OF 9G BULKHEAD. BLENDED CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-61-49. LOCATED, DRILLED & COUNTERSUNK HOLES AS REQUIRED FOR NEW TRACK AND INSTALLED NEW TRACK SEGMENT & REMOVED OLD TRACK IAW SRM 53-61-SDR ASOA2012100802334Seat Track · corrodedSHORT SEAT TRACK AT LBL 27 HAS CORROSION JUST AFT OF 9G BULKHEAD. BLENDED CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-61-49. REMOVED OLD TRACK, LOCATED, DRILLED & COUNTERSUNK HOLES AS REQUIRED FOR NEW TRACK AND INSTALLED NEW TRACK SEGMENT IAW SRM 51-42-0SDR ASOA2012100802333Seat Track · corrodedSHORT SEAT TRACK AT LBL 9 HAS CORROSION JUST AFT OF 9G BULKHEAD. REMOVED CORRODED SECTION OF SEAT TRACK IAW SRM 53-61-49-00-01. LOCATED, DRILLED & COUNTERSUNK HOLES AS REQUIRED IAW SRM 51-41-02. INSTALLED NEW SEAT TRACK IAW SRM 53-61-49-00-01.SDR ASOA2012100802332Seat Track · corrodedSHORT SEAT TRACK AT BL 9R HAS CORROSION JUST AFT IF 9G BULKHEAD. REMOVED CORRODED SECTION OF SEAT TRACK IAW SRM 53-61-49-00-01. LOCATED, DRILLED & COUNTERSUNK HOLES AS REQUIRED IAW SRM 51-41-02. INSTALLED NEW SEAT TRACK IAW SRM 53-61-49-00-01.SDR ASOA2012102302395Seat Track · corrodedRT SIDE SEAT TRACK CORRODED AT FS 544 - 559+96. REMOVED SEAT TRACK IAW AMM 53-01-11-000-802. DRILLED NEW SEAT TRACK AND COUNTER SUNK IAW SRM 51-40-11-00. INSTALLED NEW SEAT TRACK IAW SRM 51-40-11-00, AND AMM 53-01-11-400-802.SDR ASOA2012101202347Seat Track · corrodedSEAT TRACK AT RBL 9, BS 589 HAS CORROSION. REMOVED CORROSION & FOUND TO BE OUT OF LIMITS IAW SRM 53-61-49. R & R WITH NEW SEAT TRACK IAW SRM 53-61-49.SDR ASOA2012101202346Seat Track · corrodedSEAT TRACK AT LBL 9, BS 589 HAS CORROSION. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 53-61-49. R & R WITH NEW SEAT TRACK IAW SRM 53-61-49.SDR ASOA2012100802331Cargo Track · corrodedCARGO TRACK AT LBL 9 JUST FWD OF FS 621 HAS CORROSION. REMOVED CORROSION & FOUND TO BE OUT OF LIMITS IAW SRM 53-61-49. INSTALLED NEW CARGO TRACK IAW SRM 51-41-02 AND 53-61-49.SDR ASOA2012100802330Bracket · crackedCARGO COMPARTMENT LINTEL AFT FITTING LOWER AFT BRACKET CRACKED AT BS 621. REMOVED CRACKED LINTEL AFT FITTING LWR AFT BRACKET & INSTALLED NEW BRACKET IAW SRM 52-42-21.SDR ASOA2012100802329Attach Bracket · crackedCARGO COMPARTMENT DOOR FWD TRACK, LOWER SUPPORT FRAME, ATTACH BRACKET IS CRACKED AT FS 574. REMOVED CRACKED ATTACH BRACKET IAW SRM 51-42-06. LOCATED, DRILLED AND INSTALLED NEW BRACKET IAW SRM 51-42-06 & 51-40-11.SDR ASOA2012100802328Sill · crackedAFT CARGO DOOR SILL IS CRACKED AT FS 605. COMPLIED WITH ECTC REO 601R-53-61-433 AND REO 601R-53-61-433, REV B.SDR ASOA2012102302394Skin · crackedLT WING LOWER WING PLANK CRACKED AT WS 149.58. COMPLIED WITH REO 601R-57-21-130. CRACK INDICATION ON SHIM. R & R SHIM AT WS 148.019 AT LOWER T/E PANEL, SRM 51-42-06. FOUND TO BE SATISFACTORY. MAJOR REPAIRSDR ASOA2012102302393Strut · weakPAX DOOR FAILED FUNCTIONAL CK, DOOR WILL NOT FALL FAST ENOUGH. PAX DOOR COUNTER BALANCE ON AFT SIDE APPEARS TO BE LEAKING AND FEELS WEAK R & R PAX DOOR COUNTERBALANCE GAS-SPRING IAW AMM 52-11-17-400-802 AFT. FOUND TO BE SATISFACTORY.SDR ASOA2012083002139Lens · missingRT SIDE EXTERIOR EMERGENCY LIGHT LENS POPPED OUT. RESECURED RT 3 EMERGENCY LIGHT LENS ASSY. IAW AMM 33-51-21, OPS CHECKED GOOD, ACFT OK FOR SERVICE.SDR ASOA2012081002050Sign · unsecureEXIT LIGHT NEAR SERVICE DOOR UNSECURE. R & R EXIT LIGHTED SIGN BESIDES SERVICE DOOR ON GALLEY WALL. OPS CHECKED GOOD IAW AMM 33-51-13.SDR ASOA201201777Pump · leakingDURING FLIGHT, LOST ALL HYD SYS 2 PRESSURE AND QTY WENT DOWN TO 5 PERCENT. DIVERTED, AFTER RUNNING QRH. EMERGENCY DECLARED. FOUND O-RING LEAKING FROM NR 2 HYD RESERVOIR. R & R NR 2 HYD RESERVOIR O-RING IAW AMM 29-11-30. R & R EDP IAW AMM 29-11-01. OPS ASDR ASOA201201707Oil System · warning messageAFTER TAKE OFF RECEIVED RT ENGINE OIL PRESSURE MASTER WARNING MESSAGE. COMPLIED WITH QRH AND RETURNED TO DEPARTURE. EMERGENCY DECLARED. ACFT OK FOR SERVICE.SDR ASOA201201706Engine · oil consumptionLOW OIL PRESSURE WARNING ENROUTE, DIVERTED. EMERGENCY DECLARED. SERVICED RT ENGINE OIL SYS IAW AMM 12-13-79. ADDED 5.5 QTS. PERFORMED OIL CONSUMPTION CHECK ON RT ENG IAW AMM 71-00-00-710-810. RAN ENGINE 18 MINS- 0 QTS CONSUMPTION. CHECKED GOOD. ACFT OK SDR ASOA201102440Trim System · malfunctionedSTAB TRIM & MACH TRIM WOULD NOT ENGAGE. EMERGENCY DECLARED. COMPLIED WITH FIM 27-00. RESET CIRCUIT BREAKER CBP2-F5 AND CBP4-A1. OPS CHECKED GOOD IAW 27-40-00. OK FOR SERVICE.SDR ASOA201102121Flashlight · inoperativeF/A FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW AMM 25-61-02. CHECKED GOOD.SDR ASOA201001824Light · inoperativeAFT EMERGENCY CEILING LIGHT IS INOP. REMOVED AND REPLACED AFT EMERGENCY CEILING LIGHT BULB IAW CRJ 200 AMM 33-51-16. OP'S CHECKED GOOD, ITEM: 1. REMOVED AND REPLACED AFT EMERGENCY CEILING LIGHT BULB IAW CRJ 200 AMM 33-51-16. OP'S CHECKED GOOD.SDR ASOA201001632Seat Track · corrodedNR 1 AND 2 RT SEAT TRACKS ARE CORRODED. REMOVED SEAT TRACK, LOCATED DRILLED AND COUNTERSUNK NEW SEAT TRACK, TORQUED SCREWS IAW AMM 53-01-11.SDR ASOA201001631Seat Track · corrodedNR 1 AND 2 LT SEAT TRACKS ARE CORRODED. REMOVED CORRODED SEAT TRACKS AND INSTALLED DUPLICATED TRACKS IAW AMM 53-01-11, SRM 51-25-06, 51-25-16, 51-21-11, 51-40-11.SDR ASOA201001600Floor Support · corrodedFLOOR SUPPORT CORRODED AT AFT OTBD END OF FLOORBOARD 232CRF. REMOVED CORROSION AT FLOOR SUPPORT AT AFT OTBD END OF FLOORBOARD IAW SRM 51-21-06, 17550 10-17-10.SDR ASOA201001599Attach Fitting · crackedFS 280 RT INBD CLIP AT RBL 9 IS CRACKED. REMOVED CRACKED CLIP, DUPLICATED SERVICEABLE CLIP, TREATED, PRIMED AND INSTALLED SERVICEABLE CLIP IAW SRM 51-25-06; 53-21-43; 51-24-21; 51-42-21; 51-25-16; 51-21-11, 16948 10-17-10.SDR ASOA201001598Attach Fitting · crackedFS 280 LT INBD CLIP AT LBL9 IS CRACKED. REMOVED CRACKED CLIP, DUPLICATED SERVICEABLE CLIP, TREATED, PRIMED AND INSTALLED SERVICEABLE CLIP IAW SRM 53-21-43; 51-24-21; 51-42-21; 51-25-06; 51-25-10; 51-21-11.SDR ASOA201001597Attach Fitting · corrodedPAX DOOR LOWER FWD FRAME CLIP AT FS 320 CORRODED. FABRICATED AND INSTALLED SERVICEABLE FRAME CLIP AT FS 320 IAW SRM 51-24-21, 51-42-06 AND 51-42-21.SDR ASOA201001596Attach Fitting · corrodedPAX DOOR LOWER AFT FRAME CLIP AT FS 320 CORRODED. FABRICATED AND INSTALLED SERVICEABLE FRAME CLIP AT FS 320 IAW SRM 51-24-21, 51-42-06 AND 51-42-21.SDR ASOA201001595Attach Fitting · corrodedPAX DOOR LOWER FWD FRAME CLIP AT FS339 CORRODED. FABRICATED AND INSTALLED SERVICEABLE FRAME CLIP AT FS339 IAW SRM 51-24-21, 51-42-06 AND 51-42-21.SDR ASOA201001594Attach Fitting · corrodedPAX DOOR LOWER AFT FRAME CLIP AT FS 339 CORRODED. FABRICATED AND INSTALLED SERVICEABLE FRAME CLIP AT FS 339 IAW SRM 51-24-21, 51-42-06 AND 51-42-21.SDR ASOA201001587Fitting · crackedRIGHT BATHTUB FITTING AT RBL19 IS CRACKED. (OPEN)SDR ASOA201001586Attach Angle · crackedRIGHT 484 INTERCOSTAL CLIP IS CRACKED. (OPEN)SDR ASOA201001585Placard · tornPAX DOOR OPEN/EXIT, AND ASSIST PLACARDS ARE TORN. (OPEN)SDR ASOA201000982Bulkhead · crackedBS 202 BULKHEAD IS SUSPECT FOR CRACK AT LT PARKING BRAKE CABLE. WORK COMPLETED IAW INSPECT FS 202 BULKHEAD CRACK IAW NDTM 51-20-06. FABRICATED SHIMS ALSO FABRICATED DOUBLER IAW EC/TC REO 601R-53-11-563. REMOVED DAMAGE AS SHOWN IN REO 601R-53-11-653. COMPLSDR ASOA201000535Light · inoperativeAFT CEILING EMERGENCY LIGHT OUT. (RESOLVED ON W/O: 155136 TASKCARD: N/R-00049) R & R AFT CEILING EMERGENCY LIGHT IAW AMM 33-51-16-400-801. OPS TEST OF EMERGENCY LIGHTS GOOD IAW AMM 33-51-00-710-801. (CLOSED)SDR ASOA201000495Placard · missingEXIT PLACARD MISSING ON PAX AIRSTAIR DOOR. INSTALLED PLACARD IAW AMM 11-30-02.SDR ASOA200901459Switch · brokenF/A FLASHLIGHT SWITCH IS BROKEN.SDR ASOA200901018Flap System · failedFLAPS FAILED AT 20 [EMERGENCY DECLARED].SDR ASOA200900620Door · stuckPAX DOOR WILL NOT OPEN OR CLOSE. FLT 5606 DEL 20 MINS. PASSENGER DOOR POWER ASSIST SYSTEM.SDR ASOA200900139Steering Sys · malfunctionedSTEERING INOP IN FLIGHT, RESET PER QRH AND REOCCURRED MULTIPLE TIMES, REPEAT WRITE UP EMERGENCY DECLARED.SDR ASOA200801359Floorbeam · corrodedFLOORBEAM AT LBL 9 FS 589 TO FS 621 HAS CORROSION ON OUTBOARD FLANGE FLOORBOARD ATTACH HOLES. REMOVED FLOORBEAM CAP AT LBL 9, FS 589 TO FS 621 IAW SRM 51-42-06 AND 51-42-21. DRILLED NEW SERVICEABLE FLOORBEAM CAP IAW SRM 51-40-11. OK TO INSTALL. INSTALLED NEWSDR ASOA200801308Web · crackedPAX DOOR AFT WEB IS CRACKED IN 2 PLACES IN ZONE 4 APPROX .125 X .500. COMPLIED W/STEPS 1, 4, 5, 6 & 7 OF BOMBARDIER REO 601R-52-11-702. NDT REQ'ED. PERFORMED EDDY CURRENT INSPECTION ON PAX DOOR AFT WEB IN ZONE 4 CUTOUTS. NO REJECTABLE INDICATIONS FOUND AT SDR TRAX200801302Handle · crackedJOB 8752811 OP 357 PAX DOOR OUTER HANDLE IS CRACKED. RESOLVED ON W/O 101539 TASKCARD NR 00442. PAX DOOR OUTER HANDLE BEING REPLACED UNDER 8752815/5771. REF 8752815/5771 FOR MX ACTION.SDR TRAX200801301Skin · crackedPAX DOOR FORWARD SIDE SKIN IS CRACKED AT HANDRAIL STOP/SUPPORT BRACKET.
Back to N971EV, cancelled Apr 22, 2024