N970EV, cancelled Dec 20, 2023
Service difficulty reports · 95
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 = 'N970EV' AND deregistration_id = 'N970EV-2023-12-20' 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 = 'N970EV' AND deregistration_id = 'N970EV-2023-12-20' 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 ASOA2013022503061Handle · lack of lubeSERVICE DOOR WILL NOT OPEN FROM OUTSIDE. LUBED SERVICE DOOR HANDLE, OPS CHECK GOOD IAW AMM 52-41-00.SDR ASOA2013020102947Lamp · burned outCEILING EMERGENCY FLOODLIGHT INOPERATIVE. REPLACED LAMP IAW AMM 33-51-16, OP'S CHECKED GOOD.SDR ASOA2012092002251Doubler · corrodedFOUND LOWER SERVICE DOOR DOUBLER AT FS 349, RBL 42 CORRODED. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 53-21-23/51-21-00/53-00-00 TR 53-27. COMPLIED WITH REO 601R-53-21-2344.SDR ASOA2012092002250Bulkhead Web · crackedFOUND REAR PRESSURE BULKHEAD WEB HAS INDICATION NOTED AT LBL 27.50 WL 130 APPROX .3" IN LENGTH 100% FSH. FAILED NDT INSPECTION. COMPLIED WITH ALL REQUIREMENTS OF REO 601R-53-61-1541 REV D, DATED 10-31-2011. SDR CLOSED.SDR ASOA2012092002249Floor Support · corrodedWHILE ACCESSING FOR FOUND FLOOR SUPPORT AT SERVICE DOOR CORRODED. COMPLIED WITH REO 601R-53-21-2346.SDR ASOA2012092002248Seat Track · corrodedSEAT TRACK CORRODED AT FS 364 TO 394. FURTHER INVESTIGATION FOUND CORROSION TO BE BEYOND ALLOWABLE LIMITS OF SRM 53-21-49. REMOVED CORRODED SEAT TRACK IAW AMM 53-01-11-000-802. INSTALLED NEW SEAT TRACK IAW AMM 53-01-11-400-802.SDR ASOA2012092002247Seat Track · corrodedSEAT TRACK CORRODED AT FS 364 TO 394. FURTHER INVESTIGATION FOUND CORROSION TO BE BEYOND ALLOWABLE LIMITS OF SRM 53-21-49. REMOVED CORRODED SEAT TRACK IAW AMM 53-01-11-000-802. INSTALLED NEW SEAT TRACK IAW AMM 53-01-11-400-802.SDR ASOA2012092002246Floor Support · corrodedINTERCOSTAL AND FLOOR SUPPORT CORRODED AT FS 349.00, RBL 42. REMOVED CORRODED FLOOR SUPPORT BRACKET AT FS 349.00 & RBL 42 IAW SRM 51-42-21. LOCATED & DRILLED NEW SERVICEABLE BRACKET IAW SRM 51-40-11. REPAIRED IAW REO 601R-53-21-2346.SDR ASOA2012092002245Floor Support · corrodedFLOOR SUPPORT AT FS 319.70, RBL 42 IS CORRODED. LOCATED AND DRILLED NEW FLOOR SUPPORT IAW SRM 51-40-11. INSTALLED FLOOR SUPPORT IAW SRM 51-42-21 AND 51-42-06 AT FS 319 RBL 42.SDR ASOA2012091902242Bracket · crackedSERVICE DOOR SILL PLATE BRACKET CORRODED AT FS 319.70. REMOVED CORRODED BRACKET AT FS 319.70 AND SERVICE DOOR SILL PLATE IAW SRM 51-42-21, 51-41-02. INSTALLED NEW SERVICEABLE BRACKET IAW SRM 51-40-11, LOCATING & 51-42-21.SDR ASOA2012091902241Floor Support · corrodedLBL 27, OTBD FLOOR SUPPORT CORRODED AROUND NUTPLATE HOLES FS 574 - 621. CORROSION FOUND TO BE OUT OF LIMITS. FLOOR SUPPORT REPLACED IAW SRM 53-090-00.SDR ASOA2012091802235Floorbeam · crackedFS 280, LBL 9, INBD FLOORBEAM ANGLE CRACKED. REMOVED CRACKED INBD FLOORBEAM AT FS 280, LBL 9 AND REPLACED WITH NEW PARTS IAW SRM 51-42-21, PN 601R31113-57.SDR ASOA2012091802234Floorbeam · crackedFS 280 RBL 9 OTBD FLOORBEAM ANGLE CRACKED. REMOVED CRACKED OTBD FLOORBEAM AT FS 280 RBL 9 AND REPLACED WITH NEW PARTS IAW SRM 51-42-21, PN 601R31113-58.SDR ASOA2012091802233Floorbeam · crackedFLOOR SUPPORT AT FS 484 RBL 36 CRACKED. REMOVED DAMAGED FLOOR SUPPORT AT RBL 36 IAW SRM 51-42-06 AND SRM 51-42-21. FABRICATED ANGLE IAW NDTM 51-20-06. REPAIRED THE INTERCOSTAL, AT 484 BETWEEN BL 27.00 AND 36.00 IAW REO 601R-53-41-059.SDR ASOA2012091802232Isolator · crackedREAR PRESSURE BULKHEAD FWD FACE RT SIDE OTBD ISOLATOR 2ND UP FROM BOTTOM IS CRACKED. R & R CRACKED ISOLATOR IAW SRM 51-42-06. SDR CLOSED.SDR ASOA2012091902240Seat Track · corrodedLT FLOOR SEAT TRACK CORRODED AT FS 409. CORROSION OUT OF LIMITS IAW SRM 53-31-49. REMOVED CORRODED SEAT TRACK IAW AMM 53-01-11-000-802. FIT, DRILLED UP & COUNTERSUNK NEW SEAT TRACK IAW SRM 51-40-11. INSTALLED NEW SEAT TRACK IAW AMM 53-01-11-400-802.SDR ASOA2012091902239Seat Track · corrodedRT FLOOR SEAT TRACK CORRODED AT FS 409. CORROSION OUT OF LIMITS IAW SRM 53-31-49. REMOVED CORRODED SEAT TRACK IAW AMM 53-01-11-000-802. FIT, DRILLED UP & COUNTERSUNK NEW SEAT TRACK SECTION IAW SRM 51-40-11. INSTALLED NEW SEAT TRACK IAW AMM 53-01-11-400-802SDR ASOA2012091902238Floorbeam · corrodedRT FLOORBEAM CAP HAS AREAS OF CORROSION FORM FS 409 TO 409+64 RBL 9. FOUND RT FLOORBEAM CAP TO BE OUT OF LIMITS IAW REO 601R-53-00-005. R & R RBL 9.0 FLOORBEAM CAP FROM FS 409 - 409+128 IAW SRM 51-42-06 AND CH 51-42-21.SDR ASOA2012091802231Floorbeam · corrodedLEFT FLOORBEAM CAP HAS AREAS OF CORROSION FROM FS 409.00 TO FS 409+96 LBL 9. REMOVED LIGHT SURFACE CORROSION .003" MAX MATERIAL REMOVED. FOUND TO BE WITHIN LIMITS IAW REO 601R-53-00-005. THIS REPAIR IS CLASSIFIED AS MAJOR REPAIR IAW SOP 5702.SDR ASOA2012091802230Channel · crackedFS 409+128 WL 69.0 RBL 18 INBD CHANNEL INDICATION NOTED IN JOGGLED RADIUS APPROX .10" LT VERTICALLY 60 PERCENT FULL SCREEN HEIGHT. FAILED NDT. REMOVED INBD CHANNEL IAW SRM 51-42-22 & 51-42-06. LOCATE ALL HOLES ON CHANNEL IAW SRM 51-40-11. INSTALLED INBD & SDR ASOA2012091802229Angle · crackedPAX DOOR OUTER HANDLE AFT SUPPORT ANGLE IS CRACKED. ANGLE LOCATED ON INSIDE OF DOOR. R & R OUTER HANDLE AFT SUPPORT ANGLE IAW SRM 51-42-06.SDR ASOA2012091802228Angle · crackedOBLIQUE ANGLES AT STRINGER 14L AND 14R CRACKED AT RADIUS AT 621.00 BULKHEAD WEB AFT FACE 621-625. REPLACED CRACKED OBLIQUE ANGLES AT STGR 14L AND STGR 14R AT RADIUS AT 621.00 BULKHEAD WEB AFT FACE 621-625 IAW SRM 51-42-21 PN 601-35012-52/601-35012-51. SDR CLSDR ASOA2012091802227Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED. REPAIRED PAX DOOR AFT DRAG ANGLE IAW EC/TC REO 601R-52-11-513.SDR ASOA2012071901934Lamp · burned outLEFT NR 2 EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED LT NR 2 EXTERIOR EMERGENCY LIGHT ASSY IAW AMM 33-51-21.SDR ASOA201201460Bulb · burned outPAX DOOR OUTER EMERGENCY LIGHT INOPERATIVE. REMOVED THE INOP BULB AND INSTALLED A NEW BULB IAW AMM 33-51-21. OPS CHECKED GOOD.SDR ASOA201002017Steering Sys · out of adjustAFTER T/O, MLG DISAGREE MESSAGE ILLUMINATED WITH LT & RT MLG SHOWING UP & WHITE, NLG INDICATING RED HASH MARKED BOX. ACFT RETURNED TO DEPARTURE. EMERGENCY DECLARED. C/W FUNCTIONAL TEST OF NOSE WHEEL STEERING SYS IAW AMM 32-51-00. REMOVED NLG SHOCK STRUT ASSSDR ASOA201001992Selector Valve · failedGEAR DISAGREE MSG AFTER TAKE OFF, NOSE GEAR WOULD NOT RETRACT. (ACFT RETURNED TO DEPARTURE AFTER T/O. R & R SELECTOR VALVE IAW AMM 32-22-20-04. OPS CHECK BAD, NO HELP. R & R NLG UPLOCK ASSY AND ADJUSTED NLG UPLOCK PIN BRACKET IAW AMM 32-33-05. OPS CHECK ANDSDR ASOA201001534Terminal · damagedDURING TAXI NOTICED STRONG ELECTRICAL BURNING ODOR ON FLT DECK. CHANGING PACKS AND BLEED SOURCE HAD NO EFFECT. STRONGEST SMELL IN NR 2 CBP AREA AND RT GALLEY AREA BY SERVICE DOOR. (GATE RETURN) ( HYD AC MOTOR PUMPS (ACMP) (SYS 1 AND 2) ACMP 1B ) ( HYD AC MOSDR ASOA201001461Web · crackedPAX DOOR FWD WEB HAS CRACK APPROX .4" FROM EDGE TO CTR OF RADIUS ON VERTICAL SURFACE, UNDER FIRST FIXED STEP APPROX 2.1" FROM INNER DOOR SKIN SURFACE. COMPLIED WITH STEPS 1 AND 2 OF REO 601R-52-11-1873. CUT OUT DAMAGED AREAS PAX DOOR FWD SIDE PANEL BOTTOM STSDR ASOA201001460Floorbeam · corrodedCARGO BAY FLOORBEAM CAP AT LBL 27 OTBD FROM FS 574 TO FS 621 HAS CORROSION AROUND NUTPLATES.SDR ASOA201001459Floorbeam · crackedFOUND CRACK ON FLOORBEAM UPPER FLANGE LAST OTBD FASTENER HOLE AT FS 574.00 LBL 45. REPAIRED IAW REO 601R-53-61-3846.SDR ASOA201001458Angle · crackedLT ANGLE UNDER CARGO DOOR SILL AT FS 605.00, LBL 43, HAS CRACK IN RADIUS. REMOVED LT ANGLE AT FS 605.00 IAW SRM 51-42. LT ANGLE REQUIRES LOCATING, DRILLING OF HOLES AND INSTALL. ANGLE BRACKET, PN 601R35011-13 AT FS 605.0 LBL 43 LOCATED, DRILLED AND INSTALLSDR ASOA201001440Floorbeam · crackedFS 280, AFT FLOOR SUPPORT ANGLE IS CRACKED OTBD OF RBL 9 AND LBL 9 & CORRODED ON TOP SIDE ALONG BULKHEAD AT RBL 9 AND LBL 9. FS 280 BULKHEAD WEB IS CRACKED BELOW FLOOR OTBD OF RBL 9 AND LBL 9. FS 280 FLOOR SUPPORT CLIPS ARE CRACKED INBD AND OTBD AT LBL 9 ANSDR ASOA201001438Web · crackedPAX DOOR AFT WEB IS CRACKED AT FASTENER HOLE FOR DRAG ANGLE AND STIFFENER. REMOVED CRACKED AFT WEB FROOM PAX DOOR. REMOVED ASSOCIATED STIFFENERS AND ANGLES. FIT, DRILLED AND INSTALLED SAME SERVICEABLE STIFFENERS AND ANGLES ONTO NEW WEB IAW SRM 51-42-06 ANDSDR ASOA201001436Isolator · brokenREAR PRESSURE BULKHEAD HAS 5 BROKEN ISOLATORS. REMOVED 5 BROKEN MOUNT ISOLATORS FROM 621 BULKHEAD BY DRILLING RIVETS FROM ISOLATORS AND MOUNT BRACKETS. INSTALLED FIVE NEW SERVICEABLE ISOLATOR MOUNTS BY INSTALLING ISOLATORS ON BRACKETS WITH RIVETS IAW SRM 51-SDR ASOA201001407Seat Track · corrodedCARGO BAY FLOOR SEAT RAIL AT RBL 27 FS 559.00+80 TO FS 559.00+96 IS CORRODED. REMOVED SEAT TRACK IN CARGO BAY REF AMM 53-01-11-000-802 & INSTALLED NEW SERVICEABLE TRACK IAW AMM 53-01-11-400-802.SDR ASOA201001406Seat Track · corrodedCARO BAY FLOOR SEAT RAILS AT RBL 9 FS 559.00+91 TO 559.00+96 AND FS 559.00+110 TO 569.00 ARE CORRODED. REMOVED SEAT RAILS IN CARGO COMPARTMENT. REF AMM 53-01-11-000-802 & INSTALLED NEW SERVICEABLE RAILS AT SAME LOCATIONS, REF AMM 53-01-11-400-802.SDR ASOA201001405Seat Track · corrodedCARGO BAY FLOOR SEAT RAILS AT LBL 9 FS 559.00+91 TO 559.00+96, FS 559.00+110 TO 569.00, FS 583, FS 600.00, AND FS 612.00 TO 617.00 ARE CORRODED. R & R SEAT RAIL AT LBL 9 BETWEEN FS 559.00+110 & FS 569 IAW SRM CH 51-41-02.SDR ASOA201001404Seat Track · corrodedCARGO BAY FLOOR SEAT RAILS AT LBL 27 FS 559.00+80 TO 559.00+96, 559.00+104, 559.00+110, AND 567.00 ARE CORRODED. REMOVED AND INSTALLED SERVICEABLE SEAT RAILS IAW 51-41-02 SRM.SDR ASOA201001403Floor Support · corrodedCARGO BAY FLOORBEAM AT LBL 27 OTBD FROM FS 574.00 TO FS 621.00 HAS CORROSION AROUND NUTPLATES. INSTALLED FLOORBEAM CAP IAW REO 601R-53-61-3778 AND REO 601R-53-91-3778, REV NC DATED 8/21/2010 AS WRITTEN. INTALLED MYLAR, PLASTIC COVER, DINITROL AND PULLEY SDR ASOA201001402Floor Support · corrodedFS 319, WL 73 AT SERVICE DOOR FLOOR SUPPORT ANGLE CORRODED. REMOVED FLOOR SUPPORT ANGLE IAW SRM 51-42-06, SRM 51-42-10 AND SRM 51-42-21. INSTALLED A NEW SERVICEABLE CLIP IAW SRM 51-42-21, 51-42-06 & 51-42-13.SDR ASOA201001401Floorbeam · crackedFS 280 OTBD OF LBL 9, WL 73 FLOOR SUPPORT J-ANGLE CRACKED AT ALTERNATE EXTENTION PULLEY BRACKET. COMPLIED WITH EC/TC REO 601R-53-11-926 IAW REO 601R-53-11-926, REV B.SDR ASOA201001400Floor Support · crackedFS 484 FLOOR SUPPORT ANGLE INBD RBL 36 CRACKED. REPAIR TO THE FLOOR SUPPORT AT FS 484 BETWEEN RBL 27.00 AND RBL 36 IS COMPLETED IAW REO 601R-53-41-059 AND MEETS WITH ALL THEIR REQUIREMENTS.SDR ASOA201001399Floor Support · crackedFS 484 FLOOR SUPPORT ANGLE OTBD RBL 27 CRACKED. REMOVED IAW SRM 51-42-21. NEW ANGLE 601R31171-9 FITTED AND DRILLED IAW SRM 51-40-11. NEW CLIP 601R31171-9 INSTALLED AND FLOOR SUPPORT ANGLE AT FS 484, RBL 27 REPAIRED IAW REO 601R-53-41-059. REPAIR TO THE INTESDR ASOA201001397Post · crackedFOUND FS 409.0+128, LBL 18.0 OTBD VERTICAL POST HAS INDICATION NOTED APPROX .3" IN LENGTH 50 PERCENT FSH AT WL 69.0 AFT FLANGE RADIUS, FAILED NDT INSPECTION. REMOVED INBD & OTBD POST. DRILLED UP NEW SERVICEABLE OTBD POST IAW SRM 51-40-06 & RIVETED INBD & NEWSDR ASOA201001396Post · crackedFOUND FS 409.0+128, RBL 18.0 OTBD VERTICAL POST HAS INDICATION NOTED APPROX .3" IN LENGTH 50 PERCENT FSH AT WL 69.0 AFT FLANGE RADIUS, FAILED NDT INSP. REMOVED BOTH POST INBD AND OTBD IAW SRM 51-42-06. DRILLED & LOCATED FASTENER HOLES IAW SRM 51-40-06. INSSDR ASOA201001435Placard · wornPAX DOOR ARROW DOWN AND EXIT PLACARDS WORN ON 5TH AND 3RD STEPS. R & R PAX DOOR ARROW AND EXIT PLACARDS IAW AMM 11-30-00-000-801 AND 11-30-00-400-801.SDR ASOA201001362Floorbeam · crackedCABIN FLOORBEAM STRUCTURE HAS CRACKS AT FS 280.0 RBL 9.0 INBD AND OTBD CLIPS. UPON FURTHER INVESTIGATION FOUND ADDITIONAL DAMAGE AT FS 280 BETWEEN RBL 9 AND LBL 9.SDR ASOA201001361Floorbeam · crackedCABIN FLOORBEAM STRUCTURE HAS A CRACK AT FS 280.0 LBL 9.0 INBD CLIP. UPON FURTHER INVESTIGATION FOUND ADDITIONAL DAMAGE AT FS 280 BETWEEN RBL 9 AND LBL 9.SDR ASOA201001360Drag Angle · crackedPOSSIBLE CRACK ON AFT PAX DOOR DRAG ANGLE. REMOVED DAMAGED DRAG ANGLE AND INSTALLED A NEW DRAG ANGLE IAW SRM 51-42-06 AND 51-42-13.
Back to N970EV, cancelled Dec 20, 2023