N807DH, cancelled Oct 4, 2022
Service difficulty reports · 580
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 = 'N807DH' AND deregistration_id = 'N807DH-2022-10-04' 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 = 'N807DH' AND deregistration_id = 'N807DH-2022-10-04' 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 DHLA201100539Actuator · leakingAFTER DEPARTURE, ACFT LOST HYDRAULIC LEVEL TO JUST ABOVE THE EMERGENCY LEVEL. ALL PROCEDURES COMPLIED AND ACFT RETURNED TO DEPARTURE. ACFT GROUNDED ON ARRIVAL. R & R RT MLG ACTUATOR AND REPLENISHED HYDRAULICS IAW MM 37-32-2, & 12-03-00.SDR DHLA201100531Fitting · corrodedRT OUTER WING FWD BOTTOM PANEL.- FITTING HAS EXFOLIATION CORROSION S-62 (NR 4 ALT TANK) STA XW 408.000 PERFORMED MAJOR REPAIR IAW SRM 57-1-0 PG 1, DWG 3640143. REMOVED LEVEL II CORROSION IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 57-2-0, PG 16, FIG 7SDR DHLA201100530Fitting · corrodedRT OUTER WING FWD BOTTOM PANEL.- FITTING HAS EXFOLIATION CORROSIOIN S-63, STA XW 408.000 (NR4 ALT TANK) PERFORMED MAJOR REPAIR IAW SRM 57-1-0 PG 1, DWG 3640143. REMOVED LEVEL II CORROSION IAW SRM 51-1-8, PG 17-18. FOUND OUT OF LIMITS IAW SRM 57-2-0 PG 16, FIGSDR DHLA201100532Stringer · crackedRT INNER WING AFT TOP PANEL.- STRINGER NR4 CRACKED STA XRS 87.000. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3, DATED 07-21-11, EVA D857-00408 REV IR DATED 07-06-11. CUT OUT DAMAGED STRINGER SEGMENT , FABRICATED SPLICES & NEW STRINGER SEGMENT IAW DWG ED-5386 DSDR DHLA201100527Longeron · corrodedFWD ACCY COMPT- L33R SHOWS EXFOLIATION CORROSION AT STA 14.000. PERFORMED MAJOR REPAIR IAW SRM 53-2-2, FIG 10 SHEET 1,3, TR 53-153 SHEET 4, TR 53-193. REMOVED FASTENERS IAW SRM 51-1-21. REMOVED LEVEL II CORROSION IAW SRM 51-1-8, PG 17-18. FOUND OUT OF LIMITSDR DHLA201100521Longeron · corrodedFWD ACCY COMPT- L33R SHOWS EXFOLIATION CORROSION AT STA 14.000. PERFORMED MAJOR REPAIR IAW SRM 53-2-2, FIG 10 SHEET 1,3, TR 53-153, SHEET 4, TR 53-193. REMOVED FASTENERS IAW SRM 51-1-21. REMOVED LEVEL II CORROSION IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS SDR DHLA201100524Frame · deformedMAIN CARGO BAY FRAME DEFORMED BS 1580.000 L19TO 21R. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG. 2 SHEET 6, SRM 53-4-1 FIG. 51 SHEET 21. REMOVED DEFORMED FRAME SEGMENT & EXISTING ANGLES IAW SRM 51-1-20D. FABRICATED NEW SEGMENT IAW SRM 53-4-1 FIG. 51 SHEET 21 ISDR DHLA201100523Fitting · corrodedFWD ACCY COMPT FITTING CORRODED BY EXFOLIATION STA 8.000 L33R. PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1 REMOVED CORROSION IAW SRM 51-1-8 PG 17-18 FOUND WITHIN LIMITS IAW SRM 53-2-0, PG 2P. REMOVED CORRODED FITING IAW SRM 51-1-20 D SRM 51-3-0. CLEANESDR DHLA201100529Tee Fitting · crackedR2 SERVICE DOOR INNER FITTING CRACKED 1". REMOVED CRACKED TEE FITTING IAW SRM 51-1-20D, SRM 51-1-21. CLEANED, TREATED & PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TEE FITTING IAW SRM 51-1-20D, SRM 51-1-21, SRM 51-3-1.SDR DHLA201100520Skin · corrodedEXT FUS LWR SKIN CORRODED STA 1460.000 - 1480.000, L34L TO 35L. PERFORMED MAJOR REPAIR IAW SRM 53-1-0, PG 1, SRM 53-4-1, FIG. 17A SHEET 2. REMOVED LEVEL II CORROSION IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 53-2-0 PG 2M. REMOVED CORRODED PLATING SDR DHLA201100522Skin · crackedRT WING UPPER SKIN 2" CRACK STA XRS 74.869 (BETWEEN CTR SPAR AND S-8). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 06-28-11, EVA D857-00406 REV IR, ASTAR DWG ES D85700406-001-D REV "B". CUT OUT DAMAGED AREA & FABRICATED FILLER PLATE & REPAIR DOUBLER IAW SDR DHLA201100519Frame · deformedMAIN CARGO COMPT FRAME DEFORMED STA 1580.000 L21 TO 19L PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 2, SHEET 6, SRM 53-4-1 FIG 51 SHEET 21. REMOVED DEFORMED FRAME SEGMENT & EXISTING ANGLES IAW SRM 51-1-20D. FABRICATED NEW FRAME SEGMENT IAW SRM 53-4-1 FIG 51, SHESDR DHLA201100528Angle · crackedNR 2 ENG TO PYLON ANGLE CRACK 10" STA YN 183.000 AT 12 O'CLOCK POS, LT SIDE. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3, DATE 07-02-11, EVA D854-00407, REV IR DATED 06-14-11, DWG ASTAR ES D85400407-001-D. REMOVED FASTENERS IAW SRM 51-1-21, SRM 51-1-20D, SRM 5SDR DHLA201100526Fitting · corrodedRT MLG WHEEL WELL FITTING CORRODED AT STA 857.125, RBL 47 (EXFOLIATION). REMOVED LEVEL II CORROSION IAW SRM 51-1-8 PG 17-20. FOUND OUT OF LIMITS IAW SRM 53-2-0 PG 2M. REMOVED CORRODED FITTING IAW SRM 51-1-20D. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8SDR DHLA201100518Skin · corrodedRT AILERON SKIN LOWER PLATING CORRODED STA XA 737.000 - XA 775.000. PERFORMED MAJOR REPAIR IAW SRM 57-8-1 FIG 4. REMOVED LEVEL 2 CORROSION IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 57-2-0 FIG. 7. REMOVED CORRODED PANEL PLATING IAW SRM 57-1-0 PG 1SDR DHLA201000138Engine · power lossENG NR1 ROLLED BACK ON CLIMBOUT. PERFORMED ENG SHUTDOWN & RE-LIGHT. NO FUTHER PROBLEMS. ACFT WAS GROUNDED UPON ARRIVAL. C/W TROUBLESHOOTING IAW MM AND MM 71-00. NO FAULTS NOTED. RAN ENG IAW JRH 12.6. OPS CHECKS SERVICEABLE.SDR DHLA201000119Lamp · inoperativeEMERGENCY LIGHT DISARMED LIGHT NOT ILLUMINATED ON DIMM SETTING. ACFT WAS GROUNDED. RELAMPED DISARMED LIGHT IAW MM 33-13-0. OPS GOOD PN 313.SDR DHLA201000092Skin · corrodedFUSELAGE SKIN BULGING WITH SEVERAL CORROSION INDUCED CRACKS AT FS 26.0, RBL5.0, BETWEEN LONGERONS 36 AND 35R. RESOLUTION: ACCOMPLISHED FUSELAGE SKIN DOUBLER AND FILLER REPAIR IAW SRM 53-2-1, FIG 7, TR 53-203, SHEETS 9, 10, 23, AND 24. REPAIR LOCATION: FS 1SDR DHLA201000015Tire · failedON LANDING, SIGNIFICANT ACFT VIBRATION NOTED. AFTER CLEARING RUNWAY GROUND CONFIRMED 2 LT TIRES WERE BLOWN. NOTE ANTI-SKID ON DMI NR 35939 AT THE TIME OF INCIDENT. LT INBD FLAP FOUND WITH 12" X 10" X .5" DENT. TIRE AND WHEEL ASSEMBLES REPLACED ON LT GEAR. LSDR DHLA201000003Lamp · inoperativeDURING EMERGENCY LIGHTING CHECK, ONLY 2 OF THE 3 REQUIRED LTS ILLUMINATED ON INSTRUMENT PANEL GLARESHIELD. RELAMPED IAW MM 33-50. OPS CK OK IAW MM 33-5. FOUND DURING CHECK, ACFT WAS GROUNDED.SDR DHLA2010807501Keelbeam · crackedMLG W/W KEEL BEAM TEE ANGLE CRACKED 1/4" AT STA 940.000. REMOVED AND REPLACED TEE ANGLE AT STA 940.000 IAW JC EC-01874-001 AND DWG NR 4645516 AND IAW SRM 51-1-20D.SDR DHLA2010807502Doubler · crackedFUSE NOSE SECTION ACCESS DOOR NR 2 INLET INTERNAL DOUBLER CRACKED 1 3/4". PERFORMED MAJOR REPAIR IAW 8110-3 DTD 12-04-09 EVA D853-00286 REV IR DTD 11-20-09 REMOVED EXISTING REPAIR IAW SRM 51-1-21 INSTALLED REPAIR PARTS IAW SMN-DWG ED-5017.SDR DHLA2010807504Beam · corrodedFWD CARGO COMPT, BEAM CORRODED STA 180.000 LBL 5. PERFORMED MAJOR REPAIR IAW SRM 51-2-1 SHEET 9,12 TR NR 51-130, DTD 01-26-04.SDR DHLA2010807508Skin · crackedLT INBD FLAP LWR SKIN CRACKED STA XCW 64.000. PERFORMED MAJOR REPAIR IAW SRM 57-7-1-FIG1 PG2.SDR DHLA2010807503Skin · crackedLEFT WING UPPER SKIN CRACKED STA XRS 74.000 S-9. PERFORMED MAJOR REPAIR ON LT WING UPPER SKIN AT STA XRS 74.000 S-9 IAW SRM 57-2-1, FIG 17.SDR DHLA2010807505Skin · scratchedREMOVE PAINT AND INSPECT FUSELAGE SKIN FOR DEEP SCRATCHES AT STA 1360 L-24L. PERFORMED MAJOR REPAIR IAW SRM 53-2-1-FIG 7 SHEET 2,23,24 AND TR NR 53-203 DTD 01/21/08. THIS IS A CLASS 1 REPAIR INITIAL INSP 4,000 LC, REPETITIVE 4,000 LC NEXT REINSPECTION DUE 33.SDR DHLA200900051Battery Pack · dischargedON PRE-DEPARTURE CHECK FOUND EMERGENCY LIGHT INOP. R & R BATTERY PACK IAW MM 33-51-1 CHECKED OPERATION OK. AIRCRAFT WAS GROUNDEDSDR DHLA200900050Light · burnedDURING ENGINE START, ODOR OF SMOKE IN COCKPIT, S/O OBSERVED SMOKE COMING FROM PANEL NEAR DOOR HANDLE, PANEL WAS HOT AND PAINT WAS BURNED. FOUND READ, ENTRY , INSIGNIA DIMMMING RESISTER OVERHEATING, PULLED AND COLLARD C/B CAP AND STOWED WIRES PER SWPM 20-10-04SDR DHLA200900045Pump · failedCLIMBING THROUGH FL 210 IN LEFT TURN NR 4 ENGINE FLAMED OUT. RAN CHECK LIST ABNORMAL PROCEDURES RESTARTED ENG, ALL PARAMETERS OK. CLEANED CBP LINE IAW CFM MM 73-21-10, OPS CHECK GOOD. ALSO REMOVED AND REPLACED NASH PUMP IAW CFM MM 73-11-10 OPS AND LEAK CHECSDR DHLA200900043Fire Warning · false activationENG NR 1 FIRE INDICATION. SHUT ENG DOWN WITH NORMAL LANDING. INSPECTED NR 1 ENGINE, NO EVIDENCE OF FIRE INDICATED, ALSO INSPECTED FIRE DETECTION SYSTEM AND ENGINE MANIFOLDS FOR LEAKS. ALL SYSTEMS OPS & LEAK CHECK GOOD IAW 26-10-0, 36-00, 71-00 & JRH 13.2. SDR DHLA200900017Line · crackedNR 4 OIL QUANTITY WENT TO 0 AND OIL 8 PSI ADHERED TO EMERGENCY PROCEDURE. FOUND OIL LINE TO ENG OIL PRESSURE XMITER CRACKED. REMOVED AND REPLACED LINE. OPS AND LK CHECK GOOD PER MM-79-32-1. SERVICED ENG OIL PER 12-20-1. RUN ENG, PER JRH CH 11 LINE ASSY P/SDR DHLA200800005AWire Harness · failedNR 4 ENGINE FIRE WARNING ILLUMINATED COMPLETED CHECKLIST. IFSD ENGINE NR 4, FOUND "A" LOOP CORE LT SIDE PYLON HARNESS PIN BROKEN. REPLACED CONNECTOR PER S/W/P 20-71-02. ALSO REPLACED HOT SECTION WIRE HARNESS PER POWERPLANT BUILDUP MAN 71-00-01-114A. REPLACSDR DHLA200800004AElement · failedWHILE IN A LOOP ENGINE FIRE LIGHT ON NR 4 ENGINE ILLUMINATED MOMENTARILY THEN WENT OUT SWITCHED TO B LOOP LIGHT STAYED OUT FOR THE DURATION OF THE FLT. REPLACED PYLON SENSING ELEMENT AND INBD CORE SENSING ELEMENT OPS CK IS GOOD IAW M/M 26-10-1, P/N OF PYLON SSDR DHLA200800112Fire Warning · malfunctionedPRIOR TO DESCENT NR 3 FIRE WARNING HANDLE ILLUMINATED AND MASTER FIRE WARNING BELL SOUNDED INTERMITTENTLY THEN EXTINGUISHED FIRE LOOP TESTED OK. RESOLUTION DESCRIPTION: XFERRED TO DMI 33829 PER MEL 26-2-3 PLACARD NR 3 ENG "B" LOOP INOP. CAT C & MXC NOTIFIEDSDR DHLA200800071Fire Loop · shortedENG FIRE WARNING NR 3 COMPLIED WITH PHASE 1 EMERG CHECKLIST ABNORMAL PROCEDURES AGENT DISCHARGED. INSPECTED ENG, NO FIRE IS LOCATED FAULT AND DETERMINED "A" LOOP P/N 898475 AT FAULT ENTERED ON MEL 26-2-3 DMI 32800 M/C NOTED REMOVED AND REPLACED BOTTLE IAW 26-SDR DHLA200800069Fire Loop · malfunctionedFLT 916 - NR 3 ENGINE FIRE INDICATION IN CRUISE SHUT DOWN PER EMER CHECK LIST AND BLEW BOTH BOTTLES. INDICATION PERSISTED OFF AND ON. LT BOTTLE SHOWED BLOWN AT SAME TIME AS FIRE. INSPECTED CONNECTORS AT FIREWALL AND INSIDE PYLON CHECKED WIRING ON ENGINE ANDSDR DHLA200800070Fire Loop · malfunctionedFLT 916 - NR 3 ENGINE FIRE INDICATION IN CRUISE SHUTDOWN PER EMER CHECK LIST AND BLEW BOTH BOTTLES. INDICATION PERSISTED OFF AND ON. LT BOTTLE SHOWED BLOWN AT SAME TIME AS FIRE. INSPECTED CONNECTORS AT FIREWALL AND INSIDE PYLON CHECKED WIRING ON ENGINE AND SDR DHLA200800064Connector · malfunctionedFLT 916 - NR 3 ENGINE FIRE INDICATION IN CRUISE SHUT DOWN PER EMER CHECK LIST AND BLEW BOTH BOTTLES. INDICATION PERSISTED OFF AND ON. LT BOTTLE SHOWED BLOWN AT SAME TIME AS FIRE. AIRCRAFT WAS GROUNDED. INSPECTED CONNECTORS AT FIREWALL AND INSIDE PYLON CHECKSDR DHLA200800057Fire Loop · false indicationNR 3 ENG FIRE WARNING. COMPLETED CHECK LIST LIGHT REMAINED ON. PERFORMED NR 3 ENG RUN PER JRH 11.1 ALL SYSTEMS OPERATE NORMALLY. NO LEAKS NOTED SYS B-LOOP CHECKS NORMAL. LOOP-A CAUSES INTERMITTENT FALSE WARNINGS. PLACED A-LOOP ON DMI 32839 PER MEL 26-2-3 SDR DHL2008807525Fitting · crackedFWD CARGO COMPT FITTING CRACKED STA 300.000 L-26L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1. REMOVED CRACKED FITTING IAW SRM 51-1-20D. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW FITTING IAW SRM 51-1-11, SRM 51-1-20D, SSDR DHL2008807526Stiffener · crackedKEEL BEAM TEE STIFFENER (EXTRUSION) HAS TWO CRACKS OF 0.250 INCH STA 896.000. REMOVED CRACKED TEE STIFFENER IAW SRM 51-1-20D. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW STIFFENER IAW SRM 51-1-20D, SRM 51-3-1 (TORQUE).SDR DHL2008807530Skin · crackedFUSELAGE NOSE SECTION, MODIFICATION DOUBLER AT AFT UPPER CORNER OF RT PRIMARY HEAT EXCHANGER, STA -12.000 L-24R (0.500" SKIN CRACKED) MAJOR REPAIR. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 04-30-08, EVA D853-00056 REV IR DATED 04-16-08, ASTAR DWG NR ESDR DHL2008807528Skin · crackedLT ELEV UPPER SKIN CRACKED 2 INCHES AND SEVERAL FASTENERS LOOSE (STA XE 79.531) MAJOR REPAIR. PERFORMED MAJOR REPAIR IAW SRM 55-4-1 FIG 1 SHEET 1-2. REMOVED DAMAGED PANEL PLATING IAW SRM 55-1-0 PG 1, SRM 51-1-21. FABRICATED PLATING AND FINGER DOUBLER BOTH FSDR DHL2008807523Skin · canningRT RUDDER SKIN OIL CANNING (STA ZR 136.000 - 125.000) MAJOR REPAIR. PERFORMED MAJOR REPAIR IAW SRM 55-6-1 FIG 1. REMOVED DAMAGED PANEL PLATING IAW SRM 55-1-0 PG 1, SRM 51-1-21. FABRICATED PLATING AND BONDED DOUBLER BOTH FROM AL2024T3 0.016" IAW SRM 55-6-1 FSDR DHL2008807513Stiffener · crackedRUDDER INTERNAL STRUCTURE STIFFENER CRACKED 1.500 INCH STA ZR 162.000. REMOVED CRACKED STIFFENER IAW SRM 51-1-21. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW STIFFENER IAW SRM 51-1-21.SDR DHL2008807512Stiffener · crackedRUDDER INTERNAL STRUCTURE STIFFENER CRACKED 1.500 INCH STA ZR 105.000. REMOVED CRACKED STIFFENER IAW SRM 51-1-21. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW STIFFENER IAW SRM 51-1-21.SDR DHL2008807521Fitting · crackedMAIN CARGO COMPT FRAME FITTING CRACKED 3 INCHES STA 857.125 L-19R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1. REMOVED CRACKED FITTING IAW SRM 51-1-20D. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW FITTING IAW SRM 51-1-20DSDR DHL2008807511Panel · delaminatedWING TO FUS LWR PANEL NR 732 INTERNAL SKIN DELAMINATED (STA 980.000 - 1050.000). REMOVED WING TO FUS LWR PANEL NR 732 IAW SRM 51-3-0. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PANEL IAW SRM 51-3-0.SDR DHL2008807527None · noneREMOVED AND REPLACED EXISTING REPAIR AT FUSELAGE STA 320 LT SIDE L-28L WITH PERMANENT TYPE REPAIR PER SRM. INDICATE TYPE OF REPAIR, RE-INSPECTION INTERVAL AND NEXT REQUIRED INSPECTION (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-2-1 FIG 7 SHEET 1,4. RESDR DHL2008807536Skin · corrodedFUSELAGE EXTERNAL SKIN CORRODED (STA 665.000 - 680.000, L-35L - L-36) MAJOR REPAIR. PERFORMED MAJOR REPAIR IAW SRM 53-2-1 FIG 7 SHEET 1-4. REMOVED CORROSION IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 53-2-0 PG 2P. FABRICATED REPAIR DOUBLER (AL707
Back to N807DH, cancelled Oct 4, 2022