N127DL, cancelled Jan 24, 2018
Service difficulty reports · 77
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 = 'N127DL' AND deregistration_id = 'N127DL-2018-01-24' 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 = 'N127DL' AND deregistration_id = 'N127DL-2018-01-24' 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 DALA2015113007280Battery Pack · inoperativeEMERGENCY CEILING LIGH AT ROWS 36-46 RT SIDE ARE INOPERATIVE. MAINTENANCE REPLACED CHARGER AND BATTERY PACK M734. SYSTEM OPERATION IS NORMAL.SDR DALA2015072904796Skin · damagedACFT SKIN DAMAGED AT BS 742. STRINGER 36R ACROSS 2 FASTENERS BY LAP SEAM REPAIRED IAW SRM 53-00-01.SDR DALA13061550127Doubler · damagedANTENNA DOUBLER FOUND DAMAGED. REPAIRED IAW ERA 520703-14.SDR DALA13043210127Circuit Card · failedAT CRUISE, ABOUT TWO HOURS INTO FLIGHT "RT ENGINE O/H LP2" STATUS MESSAGE. R & R RT ENG OVERHEAT CARDS M690 & M10274 IAW AMM 26-10-01. OPS CHECKED GOOD.SDR DALA13025260127Failsafe · crackedUT INSPECTION, FOUND CRACK INDICATION ON FAILSAFE STRAP AT THE RT BULKHEAD AT BS 955. BS 955 AT RT BLKHD FAIL SAFE STRAP REPAIR CARRIED OUT IAW PRI 513478-14AD, REV 0, REV 1 & REV 2. PERMANENT REPAIR COMPARED AND COMPLIED WITH FINAL ERA 513478-14AD, REV ORIGISDR DALA13025250127Failsafe · crackedUT INSPECTION FOUND CRACK INDICATION ON FAILSAFE STRAP AT THE REAR SPAR LT BULKHEAD AT BS 955. BS 955 LT BULKHEAD FAIL SAFE STRAP REPAIR CARRIED OUT IAW PRI 513476-14, AD REV 0, REV 1 & REV 2. PERMANENT REPAIR COMPARED AND COMPLIED WITH FINAL ERA 513476-14ADSDR DALA13023710127Tee Fitting · corrodedFOUND LEFT TEE FITTING WITH CORROSION. R & R WITH NEW TEE FITTING IAW PRI 514001-14AD, REV 0.SDR DALA13023640127Frame · corrodedBS 977 FRAME WEB AT S21-22R CORRODED. FRAME WEB REPAIRED IAW PRI 514000-14, REV ORIGINAL, 1, 2, 3 AND 4.SDR DALA13023630127Stringer · corrodedAFT CARGO BAY AT APPROX BS 1185 S36R CORRODED STRINGER, TRIMMED OFF AND CARRIED OUT SECTION REPAIR IAW SRM 53-00-03, REPAIR 2, FIG 201, REV 92.00.SDR DALA13023600127Web · crackedRIGHT WING L/E STATION 674 NOSE BEAM CRACKED WEB CARRIED OUT REPAIR IAW PRI 514008-14, REV 0. THE REPAIR COMPARED AND COMPLIED WITH ER/A 514008-14, REV ORIGINAL.SDR DALA13023480127Keelbeam · corrodedLOWER KEEL BEAM FOUND TO HAVE SEVERAL AREAS OF CORROSION BETWEEN BS 870-915. REPLACED SECTION.SDR DALA13023470127Stringer · corrodedFOUND BS 420 STRINGER 36L CORRODED. STRINGER CUT AND DISCARDED. CARRIED OUT SECTION REPAIR.SDR DALA13023460127Stringer Splice · corrodedFWD CARGO BS 437 S35L STRINGER SPLICE FOUND CORRODED. REPLACED DAMAGED STRINGER SPLICE.SDR DALA13023450127Stringer · corrodedFWD CARGO BS 414 FOUND STRINGER 35R CORRODED. REPLACED STRINGER.SDR DALA13020490127Floor Support · corrodedCABIN FLOOR SUPPORT AT BS 325, RBL 50 FOUND CORRODED. CORROSION REMOVED IAW SRM 51-10-02, REV 91.02. FOUND OUT OF LIMIT IAW SRM 53-00-51, FIG 101, REV 91.02. FLOOR SUPPORT TEE DAMAGED AREA CARRIED OUT REPAIR IAW SRM 53- 00-51, FIR 201, REPAIR 1.SDR DALA1303410127Coffeemaker · damagedDOOR 2L COFFEEMAKER DAMAGED AND INOPERATIVE. COFFEEMAKER SPARKING FROM SIDES. COFFEEMAKER REMOVED IAW ERA 511387-14. BOLT SHEARED OFF. C/BS COLLARED AND WIRES SECURED.SDR DALA1208990127Wire Harness · inoperativeEMERGENCY ESCAPE PATH LIGHTS AT SEAT 2AB ARE INOPERATIVE. MAINTENANCE REPLACED THE WIRE HARNESS. SYSTEM OPS NORMAL.SDR DALA1208980127Wire · brokenEMERGENCY ESCAPE PATH LIGHTS AT AFT RT LAVATORY RED LIGHT INOPERATIVE. MAINTENANCE REPAIRED BROKEN WIRE. SYSTEM OPS NORMAL.SDR DALA1306060127Sill · corrodedFUSELAGE AFT CARGO DOOR LOWER SILL FS 1270 UPPER CHORD. REPAIR IAW ERA 497875-14.SDR DALA1011320127Wire · cutAFT RT DOOR RED EMERGENCY LIGHTS ARE INOPERATIVE. MX FOUND WIRES CUT ON LENS ASSY AND SPLICED AND SECURED WIRES. SYS OPS IS NORMAL.SDR DL76S101286Wire · cutAFT RT DOOR RED EMERGENCY LIGHTS INOP. FOUND WIRES CUT TO LENS ASSY. SPLICED WIRES AND SECURED. OPS CK GOOD.SDR DL76S081727Engine · failedON DESCENT INTO ATL THE LEFT ENGINE ROLLED BACK. PERFORMED IN FLIGHT SHUTDOWN OF ENGINE. INSP INLET AND EXHAUST NTF. CHECKED CHIP DETECTORS NTF. RAN ENG IDLE AND T/O POWER ALL PARAMETERS NORMAL. SUMPED LEFT TANK BEF RUN NTF. REMOVED FUEL PUMP AND MEC. RSDR DL76S080394Duct · splitCREW REPORTED HEARING LOUD POP AND FELT EARS POP THEN GOT BODY DUCT LEAK LIGHT. AFT CABIN FILLED WITH SMOKE AND CABIN GOT VERY HOT. PASSENGER SEATED AT 42A GOT A BURN TO HER LEG. PBE AND HALON BOTTLES USED, FLT DIVERTED TO GSP. MTC FOUND PNEU DUCT LOCATED SDR DL76S070852Angle · wornFS 1417 LEFT FLOOR SUPPORT ANGLE HAS AN ELONGATED FASTENER HOLE. BULK CARGO COMPT, BS1417, STR 36L AREA FLOOR SUPPORT ANGLES ELONGATED HOLE REPAIRED IAW ERA 462310-14AD REV ORG.SDR DL76S070851Channel · nickedFWD CARGO DR LWR EDGE FWD REPAIRED PATCH NICKED. FWD CARGO DOOR LOWER EDGE CHANNEL REPLACED SRM 51-10-02 PAGE 8.SDR DL76S070850Spar · crackedLT WING FRONT SPAR AT NR 8 RIB POST FOUND 1 FASTENER HOLE CRACKED AT RIB POST. LT WING FRONT SPAR NR 8 RIB AREA REWORKED AND FASTENER INSTALLED PER ERA 461699-14AD REV ORG.SDR DL76S070849Rib · crackedRT WING LES 688 AREA RIB SUPPORT FWD END CRACKED. RT WING LES 688 AREA RIB SUPPORT REPAIRED PER SRM 57-41-01 FIGURE 201 REPAIR 4.SDR DL76S070833Frame · damagedDURING THE CURRENT HMV IN HKG, A FASTENER HOLE WAS FOUND ELONGATED IN THE FS 1417 FRAME NEAR STRINGER 36L. A BOEING APPROVED REPAIR WAS INSTALLED PER 462310-14.SDR DL76S070830Bulkhead · crackedON HMV, FOUND BULKHEAD CRACKED. REPAIRED PER SRM 53-80-00. REPAIR NR 9 FIG 201. AREA OF REPAIR WAS BS 1809 BETWEEN STRINGER 4R AND 8R.SDR DL76S070829Fitting · crackedA CRACK INDICATION WAS FOUND DURING ACCOMPLISHMENT OF HORIZONTAL STABILIZER PIVOT FITTINGS PER OPN 5927AD, LHS OUTBOARD FITTING, LOWER RIB CHORD, AND LOWER SPLICE PLATE. BOEING WAS CONTACTED FOR REPAIR INSTRUCTIONS FOR HOLE OVERSIZING. THE REPAIR WAS APPROVESDR DL76S070828Fitting · crackedDURING INSPECTION PER SIP EO MOD, NR 1 PYLON BULKHEAD FITTING WAS FOUND CRACKED AT BOLT HOLE COMMON TO UPPER SPAR FITTING. THE DISCREPANT HOLE ON BULKHEAD FITTING WAS OVERSIZED TO A FINAL DIAMETER OF 1.125" UNTIL THE CRACK INDICATION WAS REMOVED. BOEING APPRSDR DL76S070825Skin · crackedDURING INSPECTION OF THE FS 1725.5 SKIN AND CHORD STRAP AT S-7R WAS FOUND CRACKED THAT WAS OUTSIDE OF THE 767 SRM 53-80-01 REPAIR 5. BOEING APPROVED REPAIR WAS INSTALLED PER 462298-14AD.SDR DL76S070824Swivel Fitting · corrodedCORROSION WAS FOUND INSIDE THE LUG BORES AND ON THE BUSHINGS OF THE LT AND RT MLG SIDE STRUT SWIVEL FITTINGS. REPAIRED PER ERA 01-462303-14 REV ORG.SDR DL76S070787Floor Support · corrodedAFT CARGO FLOOR PANEL SUPPORT RIB AT STA 1197+66 LBL 38 CORRODED, REPAIRED ON AJN 51016 PER 53-00-07 FIGURE 201 REPAIR 4.SDR DL76S070786Floor Support · corrodedAFT CARGO STA 1197+66 LBL10 TO LBL 30 FLOOR PNL SUPPORT RIB SIGN OF CORROSION REPAIRED ON AJN 51001 PER 53-00-07 REPAIR 4 FIG 201.SDR DL76S070785Floorbeam · corrodedFWD CARGO BS 676 LBL42 FLOORBEAM ANCHOR NUT CORRODED ON BOTTOM SIDE, REPAIRED ON AJN 52957 PER 53-00-07 FIGURE 201 REPAIR 4.SDR DL76S070778Rib · crackedDURING ACCOMPLISHMENT OF SIP EO, THE LHS WING FRONT SPAR AT RIB NR 8 WAS FOUND CRACKED AT A FASTENER HOLE. THE CRACK WAS APPROXIMATELY 0.030 INCH IN LENGTH. THE SUBJECT HOLE FROM WHICH THE CRACK EMANATED WAS ALREADY BEYOND THE EA ALLOWABLES. BOEING APPROVEDSDR DL76S070777Fitting · damagedDURING INSPECTION OF THE AFT PITCH LOAD FITTING PER EA 01-074906-03AD, SEVERAL HOLES WERE FOUND TO BE OVERSIZED BEYOND THE ALLOWABLE LIMITS. BOEING WAS CONTACTED AND THEY ALLOWED THE OVERSIZED HOLES WITH CORRESPONDING MATCHING FASTENERS AS REFERENCED IN ERA 4SDR DL76S070775Nut Clip · unknownDURING ACCOMPLISHMENT OF EA 01-074906-03AD, NEED TEE CLIPS ARE ATTACHED TO THE SUBJECT PITCH LOAD FITTINGS, HOWEVER THEY HAD SHORT EDGE MARGIN. BACO GAVE AMOC APPROVAL FOR THE SHORT EDGE MARGIN CONDITION. REFERENCE ER/A 461700-14AD.SDR DL76S070773Floorbeam · corrodedFWD CARGO BS 434 RBL 41 TO RBL 45 FLOOR SUPPORT TOP SURFACE CORRODED. REPAIRED PER 53-00-07 FIGURE 201. REPAIR 4 ON AJN 52963.SDR DL76S070772Floorbeam · corrodedAFT CARGO FLOOR PANEL SUPPORT RIB AT STA 1197+66 LBL 38 SIGN OF CORROSION. REPAIRED PER 53-00-07 FIGURE 201 REPAIR 4 ON AJN 51016.SDR DL76S070771Floorbeam · corrodedAFT CARGO COMPARTMENT STA 1197 BELOW FLOOR FRAME UPPER CORD LBL 11 UPPER AND LOWER SURFACES CORRODED REPAIRED ON AJN52893 PER 53-00-07 FIRURE 2O1 REPAIR 4.SDR DL76S070770Floorbeam · corrodedFOUND AFT CARGO FLOOR PLANEL SUPPORT RIB AT STA 1219 LBL 40 CORROSION. REPAIRED PER 53-00-07 REPAIR 4 FIGURE 201 ON AJN 50830.SDR DL76S070769Floorbeam · corrodedAFT CARGO COMPT FLOOR PNL SUPPORT RIB RBL 42 AT STA 1197+88 HOLE CUTOUT SIGN OF CORROSION. REPAIRED PER 53-00-07 FIG 201 REPAIR 6 ON AJN 51468.SDR DL76S070766Floorbeam · corrodedAFT CARGO FLOOR PANEL SUPPORT RIB AT STA 1197+110 RBL 24 AND RBL 40 BOLT HOLE CORRODED. REPAIRED PER 53-00-07 REPAIR 4 FIGURE 201 ON AJN 51009.SDR DL76S070765Floorbeam · corrodedAFT CARGO COMPT -STA 1197+66 LBL 10 TO LBL 30 FLOOR PANEL SUPPORT RIB SIGN OF CORROSION. REPAIRED PER 53-00-01 REPAIR 4 FIGURE 201 ON NR AJN51001.SDR DL76S070733Pressure Panel · crackedCABIN BS 977 RBL 23 MLG PRESSURE WEB SKIN CRACKED AND REPAIRED PER 53-50-51 FIGURE 201 REPAIR 1 ON NR CARD AJN 53146.SDR DL76S070721Angle · crackedCABIN STA 999 RBL 32 SUPPORT CRACKED. REPAIRED PER 53-00-51 FIGURE 201 ON NR 51788.SDR DL76S070720Seat Track · crackedCABIN, STA 999 RBL54.75 SEAT TRACK FOUND CRACKED. REPAIRED ON NR 51787. REPAIRED PER 53-00-51 FIGURE 201 REPAIR 3.SDR DL76S070708Floorbeam · corrodedCABIN BS287, RBL 60-62 FLOORBEAM UPPER CORD CORRODED AS MARKED, REPAIRED PER 53-00-51D, FIG 201 ON AJN50915.
Back to N127DL, cancelled Jan 24, 2018