N973EV, cancelled Jul 6, 2023
Service difficulty reports · 63
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 = 'N973EV' AND deregistration_id = 'N973EV-2023-07-06' 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 = 'N973EV' AND deregistration_id = 'N973EV-2023-07-06' 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 ASOA201201623Warning Light · illuminatedON GEAR RETRACTION, NOSEWHEEL STEERING INOPERATIVE, FOLLOWED BY GEAR DISAGREE. NOSE WHEEL DID NOT RETRACT. PERFORMED QRH PROCEDURES. RETURN TO DEPARTURE. EMERGENCY DECLARED. NO DEFECTS NOTED. ACFT OK FOR SERVICE.SDR ASOA201201599Priority Valve · failedGEAR DISAGREE ILLUMINATED, DURING GEAR RETRACTION. ACFT RETURNED TO DEPARTURE, EMERGENCY DECLARED. R & R NLG PRIORITY VALVE IAW AMM 32-33-15. OPS TEST GOOD IAW AMM 32-30-00.SDR ASOA201200541Lamp · burned outNR 3 CABIN CEILING EMERGENCY LIGHT INOPERATIVE. RELAMPED NR 3 CABIN CEILING EMERGENCY LIGHT IAW AMM 33-51-16.SDR ASOA201102208Wire Harness · damagedRECEIVED NWS INOPERATIVE MESSAGE IN FLT, PERFORMED QRH WOULD NOT RESET. EMERGENCY DECLARED. R & R NOSE LANDING GEAR STEERING HARNESS IAW AMM 32-61-25, OPS CHECKED GOOD.SDR ASOA201101266Floorbeam · crackedFS 280 INBD & OTBD CLIPS ARE CRACKED AT LBL 9 AND RBL 9. THIS REPAIR IS CLASSIFIED AS A MINOR REPAIR IAW ASA SOP 5702. (CLOSED)SDR ASOA201101242Angle · corrodedFS 280.00 FWD J ANGLE CORRODED. REMOVED MINOR SURFACE CORROSION IAW SRM 51-21-06.SDR ASOA201101241Angle · crackedFS 280.00 UPPER ANGLE OTBD OF LBL 9 CRACKED AND FS 280.00 WEB CORRODED. REPAIRED IAW REO 601R-53-11-926 REV B.SDR ASOA201101229Bulkhead Web · failedFOUND REAR PRESSURE BULKHEAD WEB THAT SURROUNDS THE LINTEL ATTACHMENT FITTING HAS INDICATION NOTED APPROX 1" IN LEGNTH 100 PERCENT FSH FAILED NDT INSPECTION. REPAIRED IAW EC/TC REO 601R-53-61-1230.SDR ASOA201101220Post · crackedFOUND FS 409+128 VERTICAL POST BL 0.0 LT AND RT SIDES HAS INDICATIONS NOTED AT WL 69.0 AFT FLANGE RADIUS APPROX .3" IN LENGTH 80 PERCENT FSH. BOTH FAILED NDT INSPECTION. REMOVED POST ASSY IAW SRM 51-42-06. INSTALLED POST ASSY IAW SRM 51-42-06 AND REO 601R-SDR ASOA201101264Cable · wornRT ENG THROTTLE CABLE AT FS 461.00 OUTER COATING IS TORN. REO 601R-76-11-006 AND MET ALL REQUIREMENTS OF REO 60R-76-11-006. RIGGING OF THE THROTTLE CONTROLS DUE IAW AMM 76-10-00-830-801. PERFORMED RIGGING OF THE THROTTLE CONTROLS IAW AMM 76-10-00-830-801. CSDR ASOA201101236Isolator · brokenREAR PRESSURE BULKHEAD FWD FACE HAS 6 BROKEN ISOLATORS. INSTALLED NEW SERVICEABLE ISOLATORS PN SL2337-3 IAW SRM 51-42-13. REPAIR CLASSIFIED AS MINOR IAW SOP 5702.SDR ASOA201101210Sill · corrodedRT CABIN FLOOR SILL CORRODED FROM FS 349.00 TO FS 364.00. CLEANED AREA IAW SRM 51-26-00, REMOVED MINOR CORROSION FROM SURFACE APPROX .003" DEEP MATERAL AFTER BLENDING .060" IAW SRM 51-21-06. ORIGINAL THICKNESS .063 WITHIN LIMITS OF SRM 53-00-00. RESTORED ALSDR ASOA201101209Floorbeam · corrodedCABIN FLOORBEAM AT FS 349.00 CORRODED AT OTBD END RBL 45. BLENDED MINOR CORROSION, REMOVING .005" D MAX DAMAGE .058" REMAINING WITHIN LIMITS IAW SRM 51-21-06 IAW 53-00-00 AND 53-21-15.SDR ASOA201101208Floorbeam · corrodedCABIN FLOORBEAM AT FS 349.00 BETWEEN RBL 27 AND RBL 45 IS CORRODED AT SEVERAL LOCATIONS ALONG ENTIRE LENGTH. REPAIRED IAW SRM 51-42-10, 51-21-06, IAW 53-00-00 AND 53-21-15. MINOR REPAIR.SDR ASOA201101207Cargo Track · corrodedCARGO TRACK AT LBL 9, BETWEEN FS 559.00+80 AND 559.00+96 CORRODED. REMOVED AND REPLACED CARGO TRACK IAW SRM 51-40-11& AMM TASK 53-01-11-400-802. MINOR REPAIR.SDR ASOA201101206Floorbeam · crackedFS 280.00 INBD AND OTBD FLOORBEAM ANGLE CRACKED AT LBL 9 AND RBL 9. REMOVED IAW SRM 51-42-06 AND 51-42-21. INSTALLED IAW SRM 51-42-21.SDR ASOA201101205Angle · crackedFS 484.00 LT ANGLE AT LBL 36.0 IS CRACKED. REPAIRED IAW REO 601R-53-41-059.SDR ASOA201101204Angle · crackedFS 484.00 RT, ANGLE AT RBL 27 IS CRACKED. R & R ANGLE IAW SRM 51-40-11, 51-42-06.SDR ASOA201101263Arm · gougedLT OTBD FLAP INBD HINGE ARM HAS 3 GOUGES ON OTBD SIDE WHERE HINGE ARM ATTACHES TO HINGE BOX APPROX .005" DEEP. REPAIRED 3 GOUGES ON LT OTBD FLAP INBD HINGE ARM IAW WITH REO 601R-57-54-197, STEPS 1-5 .005 MATERIAL MAX REMOVED. REO 601R-57-54-194 HAS BEEN ACCOSDR ASOA201101262Panel · bentGROUND AIR CONDITIONING PANEL 172BR FWD & AFT LANDINGS ARE BENT. REMOVED SEALANT FROM REWORK AREAS IAW SRM 51-23-00. REF LINE ITEM 5 FOR APPLICATION OF SEALANT. C/W STEP 1 OF REO 601R-53-61-4105. STEP 2 OF REO 601R-53-61-4105 NEED C/W. C/W STEP 2 OF REO 601SDR ASOA201101228Angle · crackedAFT EQUIPMENT COMPARTMENT FS 621 TO 625 OBLIQUE ANGLES ARE CRACKED LT & RT SIDES. REPLACED LT AND RT OBLIQUE ANGLES IAW SRM 51-42-06 AND 51-40-11. THIS REPAIR IS CLASSIFIED AS A MINOR REPAIR IAW SOP 5702.SDR ASOA201101302Sill · corrodedPAX DOOR LOWER SILL CORRODED AROUND PROXIMITY SWITCH AND GROUND STUD. . REMOVED PAX DOOR LOWER SILL ASSY FOR REPLACEMENT IAW SRM 51-42-06 AND 51-42-21. DRILLED AND LOCATED NEW PART 601R-31527-221 IAW SRM 51-40-11 AND 51-40-06. INSTALLED NEW PAX DOOR LOWERSDR ASOA201101250Sill · corrodedSERVICE DOOR CUTOUT LOWER SILL IS CORRODED FROM FS 310 TO FS 349. REMOVED CORRODED SERVICE DOOR SILL ANGLE ASSY IAW SRM 51-42-13, 51-42-06, 51-42-10,, AND 51-42-21. INSTALLED NEW SERVICE DOOR SILL ANGLE ASSY IAW SRM 51-42-34, 51-42-21, AND 51-42-36, AND 51-SDR ASOA201101227Sill · corrodedPAX DOOR LOWER SILL UPPER ANGLE CORRODED AROUND RIVETS ATTACHING LIGHTNING PROTECTION MOUNTING CLIPS. AFTER FURTHER INVESTIGATION FOUND PROTECTOR LEAD CONNECTION ANGLE TO BE CORRODED ONLY, ANGLE IS IN SERVICEABLE CONDITION WITH NO CORROSION EVIDENT WHATSOEVERSDR ASOA201101062Inverter · unserviceableRT EMERGENCY EXIT, FLOOR LEVER EXIT SIGN INOPERATIVE. REMOVED AND REPLACED NR3 INVERTER IAW AMM 33-51-07.SDR ASOA201100664Light · inoperativeLOWER EXIT SIGN FOR RT OVERWING EMERGENCY EXIT DOOR INOP. R & R RT OVERWING EMERGENCY EXIT DOOR LOWER EXIT LIGHT IAW AMM 33-51-09. OPS CHECK GOOD. NO FURTHER DEFECTS FOUND AT THIS TIME. R & R RT OVER WING EMERGENCY EXIT DOOR LOWER EXIT LIGHT IAW AMM 33-51-SDR ASOA201100487Lamp · burned outNR 1 LT EXTERIOR EMERGENCY LIGHT INOP. RELAMPED NR 1 LT EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-21, OP'S CHECK GOOD. RELAMPED NR 1 LT EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-21, OP'S CHECK GOOD.SDR ASOA201100095Placard · deterioratedEXIT PLACARD ON MAIN CABIN DOOR WORN ( NON-REQUIRED PLACARDS ). R & R EXIT PLACARD IAW AMM 11-30-00. (CLOSED)SDR ASOA201001141Lamp · burned outAFT CABIN CEILING EMERGENCY LIGHT INOP. RELAMPED AFT CABIN CEILING LIGHT IAW AMM 33-51-16. OPS CHECK GOOD. RELAMPED AFT CABIN CEILING LIGHT IAW AMM 33-51-16. OPS CHECK GOOD.SDR ASOA201000406Coalescer Bag · odorSTRONG ODOR FROM PACKS. R & R COALESTER SOCKS IAW AMM 21-51-13 OP CK GOOD. ACFT OK FOR SERVICE.SDR ASOA200901171Light · inoperativeNR 4 CEILING EMERGENCY LIGHT INOPERATIVE.SDR ASOA200900992Light · inoperativeRT OVERWING EMERGENCY EXIT LWR EMERGENCY LIGHT, INOPERATIVE.SDR ASOA200900607Doubler · crackedLEFT BONDED SKIN DOUBLER CRACKED AT FS 640.SDR ASOA200900581Floor Support · crackedRIGHT FLOOR SUPPORT STRUT LOCATED AT FS559.0 NEEDS NDT FOR SUSPECTED CRACK. FOUND RIGHT FLOOR SUPPORT STRUT CRACKED. REMOVED AND REINSTALLED COMPONENTS NECESSARY TO PERFORM THE REPAIR. PERFORMED EDDY CURRENT INSPECTION OF CAP ANGLE AT RBL 9.00 FS 559 IAW NDSDR ASOA200900572Isolator · broken2 EA ISOLATORS BROKEN ON FWD SIDE OF AFT PRESSURE BULKHEAD(MARKED)SDR ASOA200900569Frame · damagedWHILE PERFORMING EC/TC AWL2 53-41-201 FS 559.00, RECEIVED A SUSPECT INDICATION UNDER BEAM AT LBL 18 FRAME CAP ANGLE RADIUS. PERFORMED EDDY CURRENT INSPECTION OF INDICATION AT 559 UNDER BEAM AT LBL 18 IAW NDTM 51-20-06. REMOVED AND REINSTALLED REQUIRED COMPONESDR ASOA200900562Fitting · crackedCLIP CRACKED AT FS589 AND CARGO DOOR SILL (UNDER DOOR SILL AT FRAME). WORK COMPLETED IN ACCORDANCE WITH IAW SRM 51-42-06, 51-42-21 AND 41-42-15. INSTALLED INTERCOSTAL IAW SRM 51-42-21. COMPLETELY INSTALLED CARGO DOOR SILL IAW SRM 51-41-02. INSTALLED CARGSDR ASOA200900559Intercostal · crackedAFT SIDE PAX DOOR 318 INTERCOSTAL IS CRACKED.SDR ASOA200900368Sensor · failedFLAP FAIL ON TAKEOFF FLAPS STUCK ON 8FT. EMERGENCY DECLARED, A/C RETURNED TO ATL AFTER T/O. THIS SDR WILL REMAIN OPEN PENDING MTC DETERMINATION OF AN APPROPRIATE CORRECTIVE ACTION. FLT 5108 DEL 38 MINS. SKEW DETECTION SYSTEM. REMOVED AND REPLACED LT NR 3 SDR ASOA200900259Handle · crackedASD HANDLE IS CRACKED.SDR TRAX200801239Spring Strut · defectiveMAIN DOOR IS NOT LOCKING CLOSE. REMOVED AND REPLACED FWD PAX DOOR GAS SPRING STRUT IAW AMM 52-11-14. OPS CHECK GOOD, ACFT OK FOR SERVICE. (K)SDR TRAX200700914Flashlight · inoperativeF/O SIDE FLASHLIGHT INOP.SDR TRAX200700872Structure · crackedCRACK FOUND ON FLOOR STRUCTURE AT FS 461.00 LBL 9 AND RBL 9.SDR TRAX200700850Structure · crackedCLIP CRACKED AT FS 484 LBL 36 UNDER FLOOR.SDR TRAX200700849Floorbeam · corrodedCORROSION FOUND ON TOP OF BEAM BETWEEN LBL 27 TO 40 FS 349.00.SDR TRAX200700847Sill · corrodedCORROSION ON FWD AND AFT BRACKET OF PASSENGER DOOR FLOOR SILL NEAR HINGE ATTACHMENT POINTS.SDR TRAX200700842Sill · corrodedLEFT FLOOR SILL CORRODED BETWEEN FS 574 TO FS 621.SDR TRAX200700829Intercostal · crackedINTERCOSTAL CRACK BETWEEN FS 621 TO 625 LT AND RT.SDR TRAX200700825Angle · crackedPREVIOUSLY REPAIRED FLOOR ANGLE CRACKED AT FS 621 LT AND RT. [06-21-07] REPAIRED IAW REO 601R-53-61-117 REV:C.SDR TRAX200700821Angle · crackedCRACK FOUND AT FS 280.00 FLOOR ANGLE IN LOWER FLANGE AT LBL 9.0. [06-21-07] REPAIR CARRIED OUT IAW REO 601R-53-11-171 REV C.
Back to N973EV, cancelled Jul 6, 2023