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 AALA20110725TUL02Pan · crackedWINDOW PAN CRACKED BETWEEN STATIONS 1079 AND 1098 LEFT SIDE, LOWER AFT CORNER. INSTALLED REPAIR ANGLE AS PER AARD 53-10-00-25.SDR AALA20110725TUL01Pan · crackedWINDOW PAN CRACKED BETWEEN STATIONS 1079 AND 1098 LEFT SIDE, TOP AFT CORNER. INSTALLED REPAIR ANGLE AS PER AARD 53-10-00-25.SDR AALA20110723TUL01Skin · damagedFORWARD ENTRY DOOR LOWER EDGE OF DOOR SKIN BENT AND DAMAGED. REMOVED DAMAGED AREA OF LOWER SKIN. FABRICATED AND INSTALLED REPAIR DOUBLER PER SRM 52-05-00 FIGURE 37.SDR AALA20110722TUL06Skin · dentedDENT IN FUSELAGE STATIONS 495 TO 503 LONGERON S 23 TO 24 LEFT. INSTALLED DOUBLER REPAIR AT STATION 503 LONGERONS 32 TO 24 LEFT PER BOEING DRAWING SG09530002.SDR AALA20110722TUL04Battery · not seatedCEILING EMERGENCY LIGHTS ROW 23 TO 30 INOPERATIVE. RESEATED BATTERIES AT ROW 24 AND 29. OPS CHECK NORMAL.SDR AALA20110722TUL03Battery Pack · dischargedEMERGENCY LIGHTS ABOVE AFT GALLEY INOPERATIVE. REPLACED BATTERY PACK B5-4 FOR EMERGENCY LIGHTS ABOVE AFT GALLEY. OPS CHECK NORMAL.SDR AALA20110722LGA03Light · inoperativeFOUND CEILING EMERGENCY LIGHT AT ROW 21 INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT AT ROW 21. OPS CHECK NORMAL.SDR AALA20110721TUL01Membrane · damagedFORWARD CABIN, HOLE IN SUBFLOOR, 15 INCHES RIGHT OF CENTER BUTT LINE, STATION 158. ROUTED OUT DAMAGED AND INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20110720TUL07Shear Tie · crackedSHEAR TIE CRACKED STATION 1451 LONGERON 2. INSTALLED DOUBLER PER AARD 51-10-00-5.SDR AALA20110720TUL05Frame · cracked1510 CANT FRAME CRACKED BELOW MAINTENANCE LIGHT SWITCH. INSTALLED DOUBLER PER SRM 53-01-00 AND 53-14-04.SDR AALA20110719TUL10Pan · crackedWINDOW PAN CRACKED UPPER AFT CORNER LEFT SIDE STATION 1003 TO 1022. REPAIR DOUBLER INSTALLED PER AARD 53-10-00-25.SDR AALA20110719TUL09Pan · crackedWINDOW PAN CRACKED UPPER AFT CORNER RIGHT SIDE STATION 1003 TO 1022. REPAIR DOUBLER INSTALLED PER AARD 53-10-00-25.SDR AALA20110719TUL08Pan · crackedWINDOW RINGPAN CRACKED AT FORWARD LOWER CORNER AT STATIONS 984 TO 1003. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110719TUL07Pan · crackedWINDOW PAN CRACK LEFT SIDE FORWARD LOWER CORNER STATIONS 946 TO 965. REPAIR DOUBLER INSTALLED PER AARD 53-10-00-25.SDR AALA20110719TUL06Pan · crackedWINDOW RING CRACKED AT LOWER AFT UPPER CORNER LEFT STATIONS 1060 TO 1079. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110719TUL05Structure · crackedWINDOW PANE CRACKED UPPER LEFT SIDE, STATIONS 946 TO 965. REPAIR DOUBLER INSTALLED PER AARD 53-10-00-25.SDR AALA20110719TUL04Pan · crackedWINDOW RING CRACKED AT UPPER AFT CORNER, LEFT STATIONS 1041 TO 1060. REPAIRED PER AARD 53-10-00-25.SDR AALA20110719LGA01Battery Pack · dischargedEMERGENCY EXIT LIGHTS IN COCKPIT, BOTH FORWARD DOORS AND 1ST ROW INOPERATIVE. REPLACED FORWARD OVERHEAD BATTERY PACK. OPS CHECK NORMAL.SDR AALA20110728DFW01Wire Harness · shortedFOUND POWER PORT UNIT AT SEAT 12D HAD SHORTED OUT. REPLACED POWER SUPPLY J BOX AND POWER PORT HARNESS FOR 12DEF. OPS CHECK NORMAL.SDR AALA20110719LGA02Battery · dischargedEMERGENCY LIGHTS FROM ROWS 28 TO 30 AND IN THE TAIL COMPARTMENT INOPERATIVE. RESEATED BATTERIES FOR AFT CABIN AND TAIL COMPARTMENT AREA EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20110718TUL07Intercostal · crackedFLOORBOARD CENTER LINE INTERCOSTAL IS CRACKED IN BEND STATION 1309. INSTALLED NEW INTERCOSTAL STATIONS 1287 TO 1309 PER AARD 51-10-00-5.SDR AALA20110718TUL06Gearbox · failedBNA - CREW REPORTED NUMBER 2 ENGINE OIL QUANTITY AND OIL PRESSURE LOSS. RIGHT ENGINE SHUTDOWN (SINGLE ENGINE TIME 10 MIN). EMERGENCY DECLARED FLIGHT RETURNED BNA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT ENGINE AT BNA ON 07/18/SDR AALA20110719TUL02Lens · crackedEMERGENCY LIGHT LENS SHROUD CRACKED AT ROW 12D. REPLACED LENS SHROUD FOR EMERGENCY LIGHT AT ROW 12D. OPS CHECK NORMAL.SDR AALA20110717DFW01Lens · crackedEMERGENCY LIGHT LENS SHROUD AT ROW 10D CRACKED. REPLACED EMERGENCY LIGHT LENS SHROUD AT ROWS 10D AND 12D. OPS CHECK NORMAL.SDR AALA20110716TUL01Frame · crackedAFT ACCS 1510 CANT FRAME CRACKED ABOVE MAINT LIGHT SWITCH. INSTALLED DOUBLER REPAIR PER SRM 53-01-00 AND SRM 53-14-04.SDR AALA20110716LGA01Battery Pack · not seatedCEILING EMERGENCY LIGHTS FROM ROW 18 TO 21 INOPERATIVE. RESEATED BATTERY PACK AT ROW 20. OPS CHECK NORMAL.SDR AALA20110715DFW03Control Valve · leakingDFW - CREW REPORTED TAIL COMPARTMENT OVERHEAT WARNING ILLUMINATED DURING CLIMBOUT. PERFORMED QRH PROCEDURES AND LIGHT EXTINGUISHED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT AND RIGHT TAIL SDR AALA20110715LGA01Battery · not seatedCEILING EMERGENCY LIGHTS AT ROWS 18 TO 21 INOPERATIVE. RESEATED BATTERIES IN BATTERY PACK AT ROW 20. OPS CHECK NORMAL.SDR AALA20110711TUL02Casting · crackedRIGHT WING GROUND SPOILER CASTING CRACKED. INSTALLED CASTING PER AARD 51-10-00-5SDR AALA20110711TUL08Battery · not seatedTAIL CONE EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERIES FOR EMERGENCY LIGHTS AT TAIL CONE EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20110711TUL07Terminal · looseRIGHT AFT OVERWING EXIT SIGN INOPERATIVE. SECURED LOOSE TERMINAL AT RIGHT AFT OVERWING EXIT SIGN. OPS CHECK NORMAL.SDR AALA20110709LGA01Power Supply · inoperativeSEVERAL EMERGENCY LIGHTS AT ROWS 18 TO 21 INOPERATIVE. CLEANED POWER SUPPLY CONTACTS FOR ROWS 18 TO 21 EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20110711TUL03Battery Pack · not seatedEXTERIOR OVERWING EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERY PACK FOR EXTERIOR OVERWING EMERGENCY LIGHTS.SDR AALA20110708LGA01Battery · not seatedFOUND ROW 23 TO 26 EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERIES FOR ROWS 23 TO 26 EMERGENCY LIGHTS.SDR AALA20110707TUL02Gyro · failedSTL - INFLIGHT DFW-CMH. CREW REPORTED ELECTRICAL ANOMOLY IN WHICH AUTO THROTTLES DISENGAGED, CAPTAINS FD BARS BIASED OUT OF VIEW, CAPTAINS FLIGHT MANAGEMENT ANNUNCIATOR WINDOWS WENT BLANK AND NO AUTOLAND ILLUMINATED. RE-ENGAGED AUTOTHROTTLE WITH NO SUBSEQUENSDR AALA20110706STL01Generator · failedSTL INFLIGHT DFW-ORD. CREW REPORTED LEFT ENGINE GENERATOR FAILED AND AUXILIARY POWER UNIT WOULD NOT START. APU START SUCCESSFUL AT 6000 FT. EMERGENCY DECLARED FLIGHT DIVERTED STL LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT ENGINSDR AALA20110706TUL04Beam · corrodedCORROSION SEVERAL PLACES ON LOWER LEG OF DOOR SILL BEAM. ACCOMPLISHED REPAIR PER EA MD80-017818.SDR AALA20110706TUL01Attach Angle · damagedRIGHT MAIN LANDING GEAR TRAPAZOID FITTING UPPER ATTACH ANGLE CORRODED AROUND FASTENERS. REPLACED UPPER ATTACH ANGLE PER AARD 51-10-00-5.SDR AALA20110703AUS01Battery Pack · dischargedEMERGENCY EXIT LIGHTS IN COCKPIT, FORWARD ENTRY, GALLEY AND FORWARD MOST AISLE INOPERATIVE. REPLACED BATTERY PACK. OPS CHECK NORMAL.SDR AALA20110702LGA02Battery · not seatedSEVERAL INTERIOR EMERGENCY LIGHT DID NOT WORK WHEN TESTING ON OVERNIGHT MAINT CHECK, FROM ROW 18 AFT. RESEATED EMERGENCY LIGHT BATTERIES IN CEILING AT ROW 20 AND IN RIGHT AFT LAVATORY. OPS CHECK NORMAL.SDR AALA20110701TUL07Vane · gougedDEEP GOUGE IN LEADING EGDE OF RIGHT NUMBER 1 FLAP VANE. FILLED AREA WITH TERECO PER EA MD80-57009042 AND ACCOMPLISHED HOT BOND REPAIR PER SRM 51-70-02.SDR AALA20110701SAN01Tube · brokenSAN - CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED ON CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED SAN LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND FLOW CONTROL VALVE LINE BROKEN AND BOOT FOR RIGHT TEMP CONTROL VALVE TOSDR AALA20110630DFW01Valve · inoperativeDFW - CREW REPORTED LEFT ENGINE HIGH OIL TEMPERATURE INDICATION DURING CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT ENGINE FUEL HEAT VALVE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20110630LGA01Battery · not seatedSEVERAL INTERIOR EMERGENCY LIGHTS FROM ROW 16 AFT DID NOT WORK WHEN PERFORMING FUNCTIONAL TEST ON OVERNIGHT "B" CHECK. RESEATED EMERGENCY LIGHT BATTERIES IN AFT CABIN AND IN RIGHT AFT LAVATORY. OPS CHECK NORMAL.SDR AALA20110628TUL06Cover Plate · leakingTUL - INFLIGHT DFW-LGA. CREW REPORTED LEFT WING FUEL LEAK. EMERGENCY DECLARED FLIGHT DIVERTED TUL LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND FUEL BOOST PUMP COVER PLATE SEAL LEAKING. REPLACED SEALS. SYSTEM GROUND CHECK NORMAL OPERATIONSDR AALA20110628TUL01Tube · brokenSDF - INFLIGHT EWR-DWF. CREW REPORTED THAT FUEL WAS NOT BEING SUPPLIED FROM THE CENTER TANKS WITH FUEL BOOST PUMPS SELECTED ON. EMERGENCY DECLARED FLIGHT DIVERTED SDF LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED BROKEN FUEL TUBE ON BOOSSDR AALA20110627LGA01Battery · not seatedINTERIOR EMERGENCY LIGHTS IN MID AND CENTER CABIN NOT WORKING. RESEATED EMERGENCY LIGHT BATTERIES IN MID AND AFT CABIN. OPS CHECK NORMAL.SDR AALA20110623DFW02Valve · inoperativeDFW - CREW REPORTED LEFT FUEL HEAT INDICATION DURING CLIMBOUT. HAD TO PUSH LEFT ENGINE THROTTLE UP TO KEEP OIL TEMP LESS THAN 135 DEGREES AND FUEL HEAT WOULD NOT GO OFF. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SESDR AALA20110623DFW01Downlock Sensor · faultyDFW - CREW REPORTED UNSAFE LANDING GEAR INDICATION. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND RIGHT MAIN DOWNLOCK INDICATING LOCKED. REPLACED DOWN LOCK SENSOR. SYSTEM GROUND CHECK NORMAL OPERATIONSDR AALA20110622LGA03Battery Pack · dischargedTAIL COMPARTMENT EMERGENCY LIGHTS, ABOVE CATWALK INOPERATIVE. REPLACED BATTERY PACK AT AFT LAVATORY B5 - 28. OPS CHECK NORMAL.
Back to Mcdonnell Douglas DC-9-82