N707DH, cancelled May 21, 2015
Service difficulty reports · 121
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 = 'N707DH' AND deregistration_id = 'N707DH-2015-05-21' 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 = 'N707DH' AND deregistration_id = 'N707DH-2015-05-21' 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 DHL9870710CAngle · crackedAT C-CHECK, CRACKED UPPER SKIN SUPPORT ANGLE AT R/W INBD TRAILING EDGE CAVITY, JUST FWD OF INBD AILERON. REPLACED ANGLE PER SRM 51-40-3, 4 X 2.5. N/R 2776SDR DHL9870709CFitting · crackedAT C-CHECK, CRACK INDICATION AT R/W INBD T/E FLAP CAVITY NR 10 SPOILER OUTBD HINGE SUPPORT FITTING. REMOVED AND REPLACED FITTING PER SRM 51-30-2. N/R 2778SDR DHL9870708CAngle · crackedAT C-CHECK, RT WING L/E LOWER COVE PANEL SIDE ATTACH ANGLE L/E 130 IS CRACKED AT ATTACH FASTENERS. INSTALLED NEW ANGLE PER SRM 51-40-3, 24 X 12. N/R 2783SDR DHL9870707CChannel · crackedAT C-CHECK, R/W OUTBD T/E FLAP WELL T/E LOWER PANEL SUPPORT INBD CHANNEL AT WS 491 CRACKED. REPLACED CRACK PER SRM 51-30-2. N/R 2797SDR DHL9870744CSkin · corrodedAT C-CHECK, SKIN BULGE AT BS 390, STR 4 LT. ACCOMPLISHED HFEC, FROM BS 360 TO 440. 10 PERCENT MATERIAL LOSS. CUT OUT DAMAGED AREA 6 BY 3 PER SRM 53-30-3. FABRICATED AND INSTALLED REPAIR PARTS BS 390, STR 14 LEFT PER SRM 53-30-3. N/R 3527.SDR DHL9870721CHinge · crackedAT C-CHECK, MCD UPPER HINGE CRACKED LUG AT 2ND FROM FWD END. REMOVED AND REPLACED HINGE PER SRM 51-30-2. N/R 3528SDR DHL9870720CLinks · chafedAT C-CHECK, NLG WHEEL WELL DOORS ACTUATING MECHANISM ACTUATION ROD, QUADRANT, LINKS ARE CHAFED SEVERELY AT FWD BULKHEAD. REMOVED AND REPLACED MECHANISM AND LINK PER MM 32-21-21. N/R 3577SDR DHL9870718CSkin · crackedAT C-CHECK, CRACKS IN RADUIS AND CORROSION IS PRESENT AT CIRCUMFERENTIAL AT BS 480, OUTBD OF STR 27L AFT IN E AND E COMPT. STOP DRILL CRACK, HFEC, INSTALLED DOUBLER REPAIR PER SRM 51-40-3. 7 X 5'. INSTALLED ANGLE PER SRM 51-40-3, 3 X 2. N/R 3513SDR DHL9870713CHinge · crackedMAIN CARGO DOOR UPPER HINGE CRACKED LUG AT AFT END. REMOVED AND REPLACED HINGE PER SRM 51-30-2. N/R 3529SDR DHL9870702CSkin · crackedAT C-CHECK, NR 3 SLAT INBD TRACK CUTOUT IN WING LEADING EDGE IS CRACKED. STOP DRILL, HFEC, INSTALLED DOUBLER REPAIR PER SRM 51-10-1, 6 X 10. N/R 1016SDR DHL9870701CRib · crackedAT C-CHECK, LEADING EDGE COVE RIB IS CRACKED AT FRONT SPAR STATION 338 ON OUTBD SIDE. REMOVED AND REPLACED ATTACH ANGLE PER SRM 51-40-3, 20 X 1.5 X 1.5. N/R 1027SDR DHL98707001Bulkhead · crackedFOUND SUSPECTED CRACK AT AFT AIRSTAIR DOOR JAMB (1183 BULKHEAD) RIGHT SIDE AT 2ND STOP FROM THE TOP. CRACKED CONFIRMED, STOP DRILLED CRACK, EDDY CURRENT STOP DRILL, INSTALLED DOUBLER REPAIR PER 98PMSI189D-1B ENGINEERING DRAWING.SDR DHL97707004Strut · crackedCRACK FOUND ON RIGHT MLG STRUT BARREL APPROX 13 LONG. REMOVED AND REPLACED LANDING GEAR ASSY PER DHL JOB INSTRUCTION CARD.SDR DHL97707003Accessory Unit · pin looseGOT GEAR WARNING HORN ON SHORT FINAL WHEN SELECTED TO FLAPS 30 AND THE HORN WOULD NOT SILENCE. FOUND PIN NR 7 ON LANDING GEAR ACCY UNIT, CONNECTOR D 1164 A MAKING INTERMITTENT CONTACT. REPLACED PIN, OPS CHECKED GOOD PER M/M 32-09-11.SDR DHL97707002Hose · failedON DESCENT, S/O NOTED ILLUMINATION OF THE NR 1 B-HYDRAULIC ELECTRIC PUMP LIGHT. SHORTLY AFTERWARD, B-SYSTEM QTY BEGAN DROPPING AND WAS AT 0 BY LANDING. UPON LOWERING OF LANDING GEAR, A-SYSTEM QTY SLOWLY DROPPED. THEREAFTER, A-SYSTEM AND BRAKE PRESSURE REMAISDR DHL97707001Dme Interrogator · inoperativeNR 2 DME IS INOP. MILEAGE DIFFERS FROM NR 1 DME FROM 20 MILES TO 150 MILES. FLAG COMES INTO VIEW INTERMITTENTLY. REMOVED AND REPLACED DME INTERROGATOR. OPS CHECK OK PER M/M.SDR DHL96707004Inlet Bullet · malfunctionedREJECTED TO NR 3 ENGINE, NOT MAKING TARGET EPR WITH ENGINE A/I ON. PARAMETERS ON ENGINE NR 1 WERE EPR 2.00 NI 96 PERCENT EGT 520 N2 93.5 F/F 9,500. ENGINE NR 3 PARAMETER WERE EPR 1.86 WITH A/I OFF NR 1 AND NR 3 ENGINE NORMAL. REMOVED AND REPLACED NR 3 ENGINSDR DHL96707003Pressure Line · rupturedAFTER T/O AROUND 30 MIN OUT OF IAH, AIRCRAFT SUFFERED COMPLETE FAILURE OF HYDRAULIC A-SYSTEM. TURNED BACK TO IAH. AIRCRAFT LANDED AND STOPPED AT END OF RUNWAY WAITING TO BE TOWED. RAMP FOUND NOSE GEAR HOSE BROKEN. REPLACED HOSE WITH FLEX LINE, CHECKED BOTHSDR 96DHL70701DSeat Track · corrodedAT D-CHECK, NUMBER 6 SEAT TRACK WAS CORRODED FROM BS 600 TO BS 740 RBL 44. INSTALLED NEW SEAT TRACK PER SRM 53-10-5 AND 53-30-2.SDR DHL95707002Radar Rt Unit · malfunctionedWEATHER RADAR SPIKES WHEN AIRCRAFT IS IN TURBULENCE OF LIGHT AND GREATER INTENSITY. DIVERTED TO SAT AND LANDED WITHOUT INCIDENT. FOUND LOOSE WIRES IN RADAR JUNCTION BOX TERMINAL 56. TIGHTENED LOOSE WIRES PER MM 20-11, REMOVED AND REPLACED RADAR RECEIVER TRASDR 95ZZZX532Switch · dirtyCVG - AT 200 FEET AGL FINAL APPROACH, GPWS ACTIVATED WITH 'TOO LOW FLAPS' WARNING. FLAP POSITION WAS VERIFIED IN 30 DEGREE POSITION BY ALL THREE CREW MEMBERS. GO-AROUND WAS EXECUTED, NEXT APPROACH WAS UNEVENTFUL TO A NORMAL LANDING. CLEANED FLAP SWITCH. OP
Back to N707DH, cancelled May 21, 2015