Mcdonnell Douglas DC-9-82
Service difficulty reports · 23,866
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = 'DC982' 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 aircraft_model_key = 'DC982' 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 AALA20120730006Battery Pack · dischargedEMERGENCY EXIT LIGHTS IN THE CABIN CAME ON FOR NO APPARENT REASON AFTER TAKEOFF. LIGHTS STAYED ON FOR ABOUT 5 MINUTES AND THEN WENT OUT. REPLACED EMERGENCY LIGHT BATTERY PACK ABOVE SEAT 6F. OPS CHECK NORMAL.SDR EE4Y2012080100266Skin · crackedLOWER FUSELAGE AT Y STA 68.5-Z13RH SECTION SKIN WITH CRACKED. THE SKIN WAS REPAIRED IAW EO COO-9-53-197-12 WITH APPROVAL. UNDER NON ROUTINE ITEM; WO:A1A163,SUBJOB:1,ITEM:303.SDR AALA20120730001Proximity Sensor · inoperativeSAT - CREW REPORTED ON DESCENT LANDING GEAR DOOR WARNING LIGHT ILLUMINATED. LANDING GEAR DOORS WERE EXTENDED MANUALLY. EMERGENCY DECLARED FLIGHT LANDED SAT WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED GEAR UP AND DOOR LATCH PROXIMITY SENSOR ANSDR AALA20120729003Pump · failedDFW - CREW REPORTED LEFT HYDRAULIC HIGH TEMPERATURE LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT ENGINE HYDRAULIC PUMP. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120728012Membrane · corrodedLOWER SURFACE OF CABIN SUBFLOOR CORRODED BELOW G1 GALLEY DRAIN PAN. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120728011Cusp Web · crackedRIGHT CUSP CRACKED AT STATION 843 BELOW HORSE COLLAR. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120728010Skin · crackedFUSELAGE SKIN CRACKED AT STATION 1309 ABOVE LONGERON 7 LEFT. INSTALLED DOUBLER PER SRM 53-04-03 FIGURE 3.SDR AALA20120728009Skin · damagedDENT WITH GOUGE AT STATION 390 BETWEEN LONGERONS 26 AND 27 LEFT. INSTALLED INTERNAL DOUBLER PER SRM 53-04-02 FIGURE 2.SDR AALA20120728008Membrane · corrodedCORROSION ON SUBFLOOR AT STATION 200 INBOARD OF FORWARD SERVICE DOOR. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120727014Frame · damagedDEEP GOUGE WITH CORROSION AT BOTTOM OF FRAME STATION 1309 BETWEEN LONGERONS 22 AND 23 LEFT. INSTALLED FRAME SPLICE PER SRM 53-03-00.SDR AALA20120726009Controller · inoperativeDFW - CREW REPORTED AT 31,000 FEET RED CABIN ALTITUDE LIGHT ILLUMINATED AND WARNING HORN WENT OFF. ACCOMPLISHED EMERGENCY DESCENT. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER ONE AND TWO PRESSURE COSDR AALA20120726002Hinge · crackedRIGHT WING PANEL 1603A BUTE DOOR FORWARD HINGE HAS A 1/2 INCH CRACK LOCATED APPROXIMATELY 3 FEET INBOARD OF THE 4TH FLAP HINGE FAIRING. INSTALLED MIDDLE HINGE AND REPAIR STRAP PER EA.SDR AALA20120726001Hinge · crackedLEFT WING PANEL 1503A BUTE DOOR FORWARD HINGE HAS A 1/2 INCH CRACK LOCATED APPROXIMATELY 3 FEET INBOARD OF THE 4TH FLAP HINGE FAIRING AND PANEL 1502C BUTE DOOR FORWARD HINGE HAS A 3/8 INCH CRACK LOCATED APPROXIMATELY 6 INCHES OUTBOARD OF THE 2ND FLAP HINGE FAISDR AALA20120808002Skin · damagedDEEP SCRAPE AND GOUGES AT STATION 233 ABOVE LONGERON 7 LEFT. INSTALLED INTERNAL DOUBLER PER SRM 53-04-02, FIGURE 2, SHEET 2.SDR AALA20120724021Cusp Web · corrodedCORROSION ON RIGHT CUSP FROM STATIONS 505 TO 507. REMOVED DAMAGE AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120724018O-Ring · damagedSMF - CREW REPORTED SMOKE IN COCKPIT AND THEN CABIN. EMERGENCY DECLARED FLIGHT RETURNED SMF LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND AUXILIARY POWER UNIT OIL COOLER LINE LEAKING. REPLACED O-RING ON THE APU OIL COOLER. SYSTEM GROUND CHSDR AALA20120724015Skin Panel · damagedDUE TO NUMBER ON HOLES FOUND ON INSPECTION, DOUBLER IS REQUIRED ON UPPER LEADING EDGE PER SRM 55-03-00 FIGURE 29. INSTALLED REPAIR DOUBLER TO UPPER LEADING EDGE PANEL PER SRM 55-03-00 AND SRM 51-60-00.SDR AALA20120725006Battery Pack · dischargedLEFT AND RIGHT CEILING EMERGENCY LIGHTS BETWEEN AFT LAVATORIES INOPERATIVE. REPLACED BATTERY PACK AT RIGHT AFT LAVATORY. OPS CHECK NORMAL.SDR AALA20120725005Battery · dirtyCEILING EMERGENCY LIGHTS INOP FROM ROW 28 TO ROW 30. CLEANED AND RESEATED EMERGENCY BATTERIES AT ROW 29DEF. OPS CHECK NORMAL.SDR AALA20120724003Structure · damagedELONGATED HOLES AT STATION ZFS 55 OF VERTICAL STABILIZER. INSTALLED DOUBLER PER SRM 55-03-00 AND SRM 51-60-00.SDR AALA20120724001Casting · crackedGROUND SPOILER ACTUATOR FITTING ON LEFT WING TRAILING EDGE IS CRACKED ON THE INBOARD FORWARD CORNER. REPLACED CASTING PER AARD 51-00-05-1.SDR AALA20120723011Angle · crackedSTATION 927, JUST BELOW NUMBER 2 SEAT TRACK HAS VERTICAL ANGLE CRACKED. REMOVED AND REPLACED VERTICAL ANGLE PER AARD 51-00-05-1.SDR AALA20120723001Battery Pack · dischargedCEILING EMERGENCY LIGHTS FROM ROWS 3 TO 6 INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS FROM ROWS 3 TO 6. OPS CHECK NORMAL.SDR WX0A071256Battery · dischargedDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE BATTERIES IN THE POWER SUPPLY BATTERSDR AALA20120721007Generator · failedORD - CREW REPORTED DURING CLIMBOUT THE ENTIRE ELECTRICAL SYSTEM AC BEGAN CYCLING ON AND OFF VERY RAPIDLY (PINBALL EFFECT). OPENED AC CROSSTIE IN AN EFFORT TO STABLIZE THE SYSTEM WITH NO EFFECT. TURNED THE GENERATOR SWITCHES OFF ONE AT TIME, SYSTEM DID NOT SSDR AALA20120720017Bracket · crackedWEB AT FORWARD ENTRY DOOR JAM AT STATION 206, LONGERON 11 LEFT CRACKED. REMOVED AND REPLACED BRACKET PER AARD 53-10-00-11.SDR AALA20120719014Generator · failedDFW - CREW REPORTED LEFT ENGINE GENERATOR FAILED ON CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. PLACARD LEFT ENGINE GENERATOR PER MEL. FLIGHT CONTINUED TO DESTINATION. REPLACED LEFT HAND ENGINE GENERATOR AND GENERATOR CONTROL SDR AALA20120720004Battery Pack · dischargedOVERWING EMERGENCY LIGHTS DID NOT COME ON ON TEST MODE. REPLACED BATTERY PACK FOR OVERWING EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20120719017Charger · inoperativeFORWARD CABIN AND FLIGHT DECK EMERGENCY LIGHTS ARE INOPERATIVE. REPLACED BATTERY CHARGER FOR FORWARD EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20120719016Light · inoperativeLEFT NUMBER 1 DOOR PORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED PORTABLE EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120719013Skin · dentedDEEP SCRATCHES WITH DENT AT STATION 218 LONGERON 7 LEFT. INSTALLED INTERNAL DOUBLER PER SRM 53-04-02.SDR AALA20120723006Lens · missingAISLE EMERGENCY LIGHT AT SEAT 28D MISSING RED LENS. REPLACED RED LENS FOR AISLE EMERGENCY LIGHT AT SEAT 28D. OPS CHECK NORMAL.SDR AALA20120719001Light · brokenAISLE EMERGENCY LIGHT AT SEAT 28D HAS BROKEN LAMP. REPLACED LAMP FOR SEAT 28D AISLE EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120718002Battery Pack · dischargedLEFT AND RIGHT EXTERIOR EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR LEFT AND RIGHT EXTERIOR EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR WX0A071247Battery · dischargedDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE BATTERIES IN THE POWER SUPPLY BATTERSDR AALA20120716007Light · inoperativeFORWARD GALLEY EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LAMP FOR FORWARD GALLEY EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120716001Light · defectiveLEFT NUMBER 1 DOOR EMERGENCY PORTABLE LIGHT DIM. REPLACED LIGHT ASSEMBLY FOR LEFT NUMBER 1 DOOR PORTABLE LIGHT. OPS CHECK NORMAL.SDR WX0A071244Vane · chafedRIGHT WING O/B FLAP I/B VANE LEADING EDGE CHAFED. REMOVED DAMAGE AREA. FAB REPAIR PARTS & INSTALLED IAW MD-80 SRM 51-70-2 PARA 18.SDR WX0A071243Vane · gougedLEFT WING O/B FLAP I/B VANE LEADING EDGE GOUGED. REMOVED DAMAGED AREA. FAB REPAIR PARTS AND INSTALLED IAW MD-80 SRM 51-70-2 PARA 18.SDR AALA20120711007Skin · corrodedFUSELAGE STATION 750, LONGERONS 29 RIGHT AND 29 LEFT, FUSELAGE SKIN IS BULGING OUT. INSTALLED FUSELAGE SKIN REPAIR PER SRM 53-04-03 FIG 11. INSTALLED 2 REPAIR STRAPS PER EA MD80-53-024926 ON INTERNAL DOUBLER BETWEEN LONGERONS 28 AND 29 BOTH LEFT AND RIGHT SISDR AALA20120711004Skin · damagedFORWARD ENTRY DOOR HOLD OPEN HOOK CUTOUT SKIN DOUBLER DAMAGED. INSTALLED DOUBLER PER EA COMP-52-024852.SDR AALA20120711001Battery · dirtyCEILING EMERGENCY LIGHTS FROM ROWS 18 TO 27 INOPERATIVE. CLEANED CONTACTS ON BATTERY AND RESEATED. OPS CHECKED NORMAL.SDR AALA20120710017Duct · leakingLAS - CREW REPORTED TAIL COMPARTMENT HIGH LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED LAS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED CONNECTOR ASSEMBLY, PERI SEAL AND DUCT 1858 ON LEFT SIDE OF TAIL COMPARTMENT. SYSTEM GROUNDSDR AALA20120710009Battery Pack · dischargedEMERGENCY LIGHTS IN AIR STAIR AREA AND TAIL CONE INOPERATIVE. REPLACED BATTERY PACK. OPS CHECK NORMAL.SDR AALA20120710007Battery Pack · dischargedOVERHEAD EMERGENCY LIGHTS FROM ROWS 7 TO 21 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS FROM ROWS 7 TO 21. OPS CHECK NORMAL.SDR AALA20120709012Clamp · looseLAS - CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED AFTER TAKEOFF. EMERGENCY DECLARED FLIGHT RETURNED LAS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND AUXILIARY POWER UNIT EXHAUST SHROUD LEAKING AT BOTH UPPER AND LOWER CSDR WX0A071242Battery Pack · dischargedDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE POWER SUPPLY BATTERY PACK AND MADE ASDR AALA20120708001Switch · inoperativeAUS - INFLIGHT DFW-LGA. CREW REPORTED BOTH PACKS CYCLED ON AND OFF 2 TIMES AND PRESSURIZATION FLOW LIGHT ILLUMINATED. FLIGHT DIVERTED AUS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT AND RIGHT SINGLE ENGINE SECOND CLIMB PRESSURE SWSDR AALA20120707001Shear Tie · corrodedAFT SHEAR TIE AT STATION 1149 BETWEEN LONGERONS 29 AND 30 CORRODED. REPLACED SHEAR TIE.SDR EE4Y2012072400262Angle · crackedLOWER FUSELAGE AFT CARGO COMPARTMENT BS 1155 BETWEEN LONGERON 28 AND 29 RT ANGLE CRACKED. ANGLE WAS REPLACED WITH THE SRM 51-01, PARAGRAPH 2.
Back to Mcdonnell Douglas DC-9-82