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 AALA20110410TUL03Cusp Web · crackedCRACK IN CUSP STATION 326. INSTALLED REPAIR DOUBLER IN ACCORDANCE WITH AARD 53-20-00-16.SDR AALA20110408TUL06Angle · corrodedRIGHT MAIN LANDING GEAR WHEEL WELL, CORROSION ON BOTTOM OF ANGLE JUST ABOVE ACCUMULATOR. INSTALLED NEW CHORD ANGLE PER SRM 51-30-01 AND AARD 51-10-00-5.SDR AALA20110407TUL06Pan · crackedFORWARD SERVICE DOOR PAN FORWARD LOWER CORNER CRACKED AT FASTENER HOLE. INSTALLED SECTION OF FORWARD SERVICE DOOR PAN, SHIM, SPLICE ANGLE, FILLER AND PLATE PER EA MD80-53-016188, AND SRM 53-05-00 FIG 55, AND BOEING DRAWING J060288.SDR AALA20110407TUL05Angle · damagedRIGHT MAIN LANDING GEAR WHEEL WELL HAS CORROSION ON BOTTOM OF ANGLE JUST ABOVE ACCUMULATOR. INSTALLED NEW CHORD ANGLE PER SRM 51-30-01 AND AARD 51-10-00-5.SDR AALA20110407TUL02Angle · crackedCRACK IN ANGLE, CENTER OF PRESSURE BULKHEAD, ABOVE AFT ENTRY DOOR CUTOUT AT STATION 1338. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-15.SDR AALA20110407TUL01Cusp Web · corrodedCORROSION UNDER LEFT CUSP STATIONS 585 TO 595. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20110408TUL03Light · inoperativeSEAT 19D AFT EMERGENCY LIGHT MISSING LAMP. REPLACED LAMP FOR AFT EMERGENCY LIGHT AT SEAT 19D. OPS CHECK NORMAL.SDR AALA20110408TUL02Guard · missingSEAT 19D AFT EMEREGNCY LIGHT MISSING GUARD. REPLACED GUARD FOR SEAT 19D AFT EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110407DFW06Charger · inoperativeCEILING EMERGENCY LIGHTS FROM ROWS 18 TO 21 INOPERATIVE. REPLACED CHARGER FOR CEILING EMERGENCY LIGHTS FROM ROWS 18 TO 21. OPS CHECK NORMAL.SDR AALA20110407DFW04Charger · inoperativeTAIL CONE EMERGENCY LIGHTS INOPERATIVE. REPLACED CHARGER AND BATTERIES FOR TAIL CONE EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110407DFW03Lens · missingSEAT 19D AFT EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR AFT EMERGENCY LIGHT AT SEAT 19D. OPS CHECK NORMAL.SDR AALA20110407DFW02Guard · damagedEMERGENCY LIGHT GUARD AT SEAT 15D DAMAGED. REPLACED GUARD FOR EMERGENCY LIGHT AT SEAT 15D. OPS CHECK NORMAL.SDR AALA20110407DFW01Guard · damagedEMERGENCY LIGHT GUARD AT SEAT 12D DAMAGED. REPLACED GUARD FOR EMERGENCY LIGHT AT SEAT 12D. OPS CHECK NORMAL.SDR AALA20110406DFW01Valve · faultyDFW - CREW REPORTED BOTH FUEL HEAT LIGHTS FLICKERED MULTIPLE TIMES AND FUEL TEMPERATURE KEPT RISING TO 55C. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT AND LEFT ENGINE FUEL HEAT VALVES. SYSTSDR AALA20110405TUL11Skin · damagedFUSELAGE - 3 EACH BLEND OUTS MISSING ADL STICKER IN FUSELAGE SKIN STATIONS 600 TO 616 LONGERONS 21 TO 22 RIGHT. INSTALLED NEW REPAIR DOUBLER PER SRM 53-04-02 AND BOEING DWG NUMBER SG0950001.SDR AALA20110405TUL06Pan · crackedCRACK IN WINDOW PAN UPPER AFT CORNER STATION 1060 RIGHT SIDE. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20110405TUL05Pan · crackedWINDOW PAN CRACKED UPPER FORWARD CORNER STATION 886 LEFT SIDE. INSTALLED REPAIR DOUBLER IN ACCORDANCE WITH AARD 53-10-00-25.SDR AALA20110405TUL04Door Frame · crackedFORWARD ENTRY DOOR JAMB WEB AT STATION 208 LONGERON 15 LEFT IS CRACKED. INSTALLED REPAIR STRAP PER AARD53-10-00-11.SDR AALA20110405TUL03Bulkhead · crackedCRACK AT STATION 37 UPPER LEFT RADOME ALIGNMENT PIN. PERFORMED REPAIR PER AARD 53-10-00-19.SDR AALA20110404TUL08Fitting · damagedCORROSION ON FITTING AT FORWARD END OF THRESHOLD. REPLACED FITTING.SDR AALA20110404TUL06Cusp Web · corrodedRIGHT SUBFLOOR CORRODED STATIONS 200 TO 218 BETWEEN SEAT TRACKS NUMBER 5 AND 6. REMOVED CORROSION AND INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20110404TUL05Skin · dentedDENTS WITH GOUGES IN FUSELAGE SKIN STATION 237 LONGERONS 17 TO 18 LEFT. INSTALLED DOUBLER PER SRM 53-04-00 FIGURE 38 SHEET 30 VIEW P.SDR AALA20110404TUL04Beam · corrodedCORROSION ON LOWER DOOR BEAM STATIONS 636 TO 693. INSTALLED DOOR BEAM DOUBLER.SDR AALA20110404TUL02Diaphragm · corrodedCORROSION IN SUBFLOOR DIAPHRAGM AT STATION 194 INBOARD SIDE OF FORWARD ENTRY THRESHOLD ATTACH ANGLE. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20110404TUL01Intercostal · crackedINTERCOSTAL CRACKED BELOW FORWARD ENTRY SUB-FLOOR STATION 175. INSTALLED NEW INTERCOSTAL PER AARD 51-10-00-5, BOEING DRAWING 5930540 AND BOEING DRAWING 9936534.SDR AALA20110404SFO01Light · inoperativeLEFT NUMBER 1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR LEFT NUMBER 1 DOOR. OPS CHECK NORMAL.SDR AALA20110403TUL04Pan · corrodedCORROSION ON LOWER DOOR PAN STATIONS 370 TO 427. INSTALLED FORWARD CARGO DOOR LOWER PAN AND DOUBLERS PER SRM 53-05-00.SDR AALA20110403TUL02Track · corrodedRIGHT TIE DOWN TRACK HAS SEVERAL AREAS OF CORROSION UPPER AND LOWER LEGS STATIONS 1231 TO 1309. INSTALLED SERVICEABLE TIE-DOWN TRACK PER SRM 51-30-01.SDR AALA20110403TUL01Track · corrodedLEFT TIE DOWN TRACK HAS CORROSION ON LOWER SIDE OF SPLICE INBOARD AND OUTBOARD SIDES STATIONS 1211 TO 1231. INSTALLED SERVICEABLE SPLICE PARTS PER SRM 51-30-05.SDR AALA20110405TUL01Strap · gougedSTRAP ON TOP OF FRAME HAS OUT OF LIMITS SCREW GOUGE. REPLACED STRAP.SDR AALA20110401TUL10Support · corrodedAFT SERVICE DOOR AFT GIRT BAR T-SUPPORT CORRODED. INSTALLED NEW T-PER AARD 51-10-00-5.SDR AALA20110401TUL04Gusset · gougedSCREW GOUGE IN STRAP INBOARD SIDE OF RIGHT TIEDOWN TRACK AT STATION 368. INSTALLED NEW GUSSET PER SRM 51-30-02.SDR AALA20110330TUL12Structure · dentedFUSELAGE DENTED STATION 236 LONGERONS 16 AND 17. INSTALLED DOUBLER PER SRM 53-04-00 FIGURE 12B.SDR AALA20110330TUL11A/C Pack · dirtyJAX - INFLIGHT RWS-DFW. FLIGHT ATTENDANTS REPORTED ODOR IN AFT CABIN. EMERGENCY DECLARED FLIGHT DIVERTED JAX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND COALESCER BAGS EXTREMELY DIRTY. ACCOMPLISHED PACK BURN. SYSTEM GROUND CHECK NORMALSDR AALA20110330TUL10Attach Fitting · corrodedCABIN GALLEY NUMBER 1 ATTACH FITTING FORWARD OUTBOARD IS CORRODED. INSTALLED NEW SERVICEABLE G-1 GALLEY ATTACH FITTING PER AARD 51-10-00-5.SDR AALA20110330TUL08Cusp Web · corrodedCORROSION IN CUSP TEE STATIONS 265 TO 168. INSTALLED NEW CUSP TEE PER SRM 53-05-00.SDR AALA20110330TUL07Structure · dentedDENT IN FUSELAGE STATION 58.75 LONGERON 18 RIGHT. INSTALLED DOUBLER PER SRM 53-04-03.SDR AALA20110330TUL02Mount · corrodedCORROSION IN G1 GALLEY OUTBOARD FLOOR MOUNT STATION 160. REMOVED OLD CENTER FLOOR G1 GALLEY MOUNT AND REPLACED PER AARD 51-10-00-05.SDR AALA20110330TUL01Seat Track · corrodedSEAT TRACK NUMBER 2 APPROXIMATELY STATION 219 FOOT HOLD LOCKING TOOTH IS WORN BEYOND LIMITS. REMOVED DAMAGED AREA, TREATED AND PRIME PAINTED AND INSTALLED REPAIR PLUG AND CHANNEL PER AARD 53-20-00-10.SDR AALA20110329DFW01Piston · damagedDFW - CREW REPORTED AFTER TAKEOFF LANDING GEAR HANDLE WOULD NOT RETRACT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NOSE LANDING GEAR STRUT PISTON THAT WAS DAMAGED. SYSTEM GROUND CHECK NORMAL OPESDR AALA20110329TUL15Diaphragm · corrodedCORROSION IN SUBFLOOR DIAPHRAGM STATION 180 APPROXIMATELY 14 INCHES INBOARD OF FORWARD SERVICE DOOR CUTOUT. INSTALLED REPAIR DOUBLER AT STATIONS 160 TO 200 RIGHT BUTTLINES 44 TO 57 PER AARD 53-20-00-16 AND FACTOR DOUBLER AT STATIONS 160 TO 180 RIGHT BUTTLINESSDR AALA20110329TUL14Diaphragm · corrodedCORROSION IN SUBFLOOR DIAPHRAGM RIGHT SIDE FORWARD OF FIBER GLASS HAT CHANNEL STATION 166. INSTALLED REPAIR DOUBLER AT STATIONS 160 TO 200 RIGHT BUTTLINES 44 TO 57 PER AARD 53-20-00-16 AND FACTOR DOUBLER AT STATIONS 160 TO 180 RIGHT BUTTLINES 45 TO 57 PER AARSDR AALA20110329TUL13Cusp Web · corrodedCORROSION IN CUSP TEE RIGHT SIDE STATION 208 SEEN THROUGH WEB HOLE. INSTALLED NEW RIGHT CUSP ANGLE FROM STATIONS 185 TO 228 PER SRM 53-05-00 FIGURE 55 AND INSTALLED REPAIR SPLICE ANGLES AT STATION 185 PER SRM 53-05-00 FIGURE 55.SDR AALA20110329TUL12Longeron · crackedCRACK IN LONGERON 2 LEFT STATION 160. INSTALLED LONGERON 2 LEFT AND SPLICE STATION 148 TO 180 SRM 53-02-00 FIGURE 18.SDR AALA20110329TUL11Cusp Web · corrodedCORROSION OUT OF LIMITS RIGHT CUSP STATION 540. INSTALLED DOUBLER AT RIGHT CUSP STATION 540 PER AARD 53-20-00-16.SDR AALA20110329TUL10Cusp Web · crackedLEFT CUSP CRACKED AT LIGHTNING HOLE STATION 316. INSTALLED REPAIR DOUBLER AT LEFT CUSP STATION 316 PER AARD 53-20-00-16.SDR AALA20110329TUL09Cusp Web · corrodedCORROSION ON LEFT CUSP STATIONS 990 TO 1000. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20110329TUL08Diaphragm · gougedGOUGE IN SUB-FLOOR DIAPHRAGM APPROXIMATELY 22 INCHES LEFT OF CENTER LINE STATION 198. INSTALLED REPAIR DOUBLER REF AARD 53-20-00-16.SDR AALA20110329TUL07Skin · dentedDENT IN FUSELAGE STATION 313 BETWEEN LONGERONS 20 AND 21 RIGHT. DYE-CHECKED AREA, COLD WORKED SKIN AND INSTALLED INTERNAL DOUBLER PER BOEING DRAWING SG095300001.SDR AALA20110329TUL02Panel · damagedTHE RIGHT WING INBOARD FLAP HAS A DAMAGED AREA .75 INCH LONG BY .25 INCH WIDE, 41 INCHES FROM THE INBOARD EDGE SEAL AND 4.25 INCHES FORWARD OF TRAILING EDGE. RIGHT INBOARD FLAP REMOVED DAMAGED MATERIAL AS PER SRM 57-01-00, DYE CHECK SHOWS NO FURTHER CRACK MIG
Back to Mcdonnell Douglas DC-9-82