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 AALA20120918017Battery Pack · dischargedCEILING EMERGENCY LIGHTS IN COACH CLASS INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS FROM SEAT ROWS 14 TO 16. OPS CHECK NORMAL.SDR AALA20120918016Light · inoperativeFIRST CLASS CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR FIRST CLASS CEILING EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120915002Position Sensor · defectiveDFW - CREW REPORTED MAIN LANDING GEAR DOOR OPEN LIGHT REMAINED ON AFTER GEAR RETRACTION. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED MAIN LANDING GEAR DOOR POSITION SENSOR. SYSTEM GROUND CHECK NORMAL OPERASDR AALA20120914016Beam · corrodedCARGO AFT CX CORROSION ALONG DOOR CUTOUT BEAM UNDER DOUBLER STATION 1155 TO 1212. ACCOMPLISHED NESTED ANGLE REPAIR PER AARD 53-10-00-3 AND EA MD80-53-026045.SDR AALA20120914014Longeron · crackedTWO EACH CRACKS AT LONGERON 3 LEFT, INBOARD AND OUTBOARD SIDE, STATION 160. INSTALLED LONGERON SPLICE REPAIR PER SRM 53-02-00 FIGURE 18.SDR AALA20120914013Cusp Web · corrodedLEFT CUSP CORRODED AT STATION 583 OUTBOARD NUMBER 1 SEAT TRACK. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120914012Cusp Web · crackedRIGHT CUSP SHEET IS CRACKED AT STATIONS 810 TO 812 RIGHT BUTTLINES 58 TO 60. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120914011Cusp Web · corrodedFORWARD SERVICE DOOR LOWER AFT JAM SUB FLOOR CORRODED AT STATIONS 200 TO 204. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120914010Cusp Web · damagedFLOORBOARD MOUNT HOLE IN THE CENTER OF SUB FLOOR 10 INCHES INBOARD OF AFT SERVICE DOOR LOWER JAM AT APPROXIMATE STATION 1155 DAMAGED. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120910007Totalizer · failedBNA - INFLIGHT IAD-DFW. CREW REPORTED SUSPECTED FUEL LOSS IN CRUISE. EMERGENCY DECLARED FLIGHT DIVERTED BNA LANDED WITHOUT INCIDENT. PLACARD FUEL QUANTITY TOTALIZER PER MEL. FLIGHT CONTINUED TO DESTINATION. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120910004Skin · crackedCRACK IN SKIN AT STATION 1437 BELOW LONGERON 3 RIGHT. STOP DRILLED CRACK AND INSTALLED DOUBLER PER AARD 53-30-00-02.SDR AALA20120910003Support · corrodedCORROSION BELOW FORWARD ENTRY DOOR THRESHOLD SUPPORT ON SUBFLOOR AT STATION 164. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120910001Engine · failedLBB - INFLIGHT DFW-SAN. CREW REPORTED RIGHT ENGINE OIL QUANTITY LOSS AND VIBRATIONS. RIGHT ENGINE WAS SHUTDOWN (SINGLE ENGINE TIME 15 MINUTES). EMERGENCY DECLARED FLIGHT DIVERETD LBB LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT SDR AALA20120909004Seal · defectiveMTY - CREW REPORTED NOSE LANDING GEAR WOULD NOT RETRACT. NOSE GEAR RED LIGHT REMAINS ON WITH GEAR HANDLE UP / RETRACTED. EMERGENCY DECLARED FLIGHT RETURNED MTY LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NOSE GEAR SHOCK STRUT SEAL. SYSDR WX0A071304Switch · damagedPILOT; ON DESCENT WITH WING LANDING LIGHTS AND NOSE LIGHT ON, ELECTRICAL FIRE WAS SMELLED & SEVERAL SECONDS LATER SMOKE WAS SEEN COMING FROM PANEL LIGHTS. LIGHTS WERE TURNED OFF AND NO MORE SMOKE SEEN. MX; DURING INSPECTION FOUND ARCING BEHIND NOSE LIGHT SWISDR AALA20120907035Seat Track · gougedCABIN HAS A GOUGE IN NUMBER 3 SEAT TRACK AT STATION 568. INSTALLED PLUG IN SEAT TRACK 3 AT STATION 568 PER AARD 53-20-00-10.SDR AALA20120907034Generator · failedDFW - CREW REPORTED LEFT GENERATOR FAILED IN-FLIGHT. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT ENGINE GENERATOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120907033Skin · dentedDENT AND SCRATCH LN FUSELAGE SKIN BELOW AND AFT OF FORWARD LAVATORY SERVICE AREA, STATION 294, LONGERON 24 LEFT. INSTALLED REPAIR DOUBLER PER SRM 53-04-0 FIGURE 8.SDR AALA20120906016Fitting · crackedSTATION 927 AND BELOW SEAT TRACK NUMBER 5 HAS VERTICAL ANGLE CRACKED AT LOWER END. REPLACED DAMAGED VERTICAL FITTING UNDER SEAT TRACK NUMBER 5, STATION 927 PER AARD 51-00-05-1.SDR AALA20120906014Pan · crackedWINDOW AT STATION 1070 LEFT SIDE: WINDOW RING PAN HAS CRACK AT FORWARD LOWER FASTENER AND AT RADIUS. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20120906013Pan · crackedWINDOW AT STATION 1070 RIGHT SIDE: WINDOW RING PAN HAS CRACK AFT UPPER AT AFT MOST FASTENER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20120906012Pan · crackedWINDOW AT STATION 1070 RIGHT SIDE: WINDOW RING PAN HAS CRACK BOTTOM FORWARD AT FORWARD MOST FASTENER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20120906011Pan · crackedWINDOW AT STATION 1070 LEFT SIDE: WINDOW RING PAN HAS CRACK AFT UPPER AT AFT MOST FASTENER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR 2WAA2012FA0000303Duct · separatedDURING CRUISE RIGHT LAVATORY SMOKE DETECTOR WENT OFF AND THE FLIGHT ATTENDANT REPORTED SMELL OF SMOKE. INSPECTED AREA OF AFT VENTRAL AIRSTAIRS AND FOUND THE DUCT BETWEEN THE RT ACM AND PRIMARY HEAT EXCHANGER HAD BECOME SEPARATED. RECONNECTED RT ACM TO PRIMARSDR AALA20120906006Light · inoperativeLEFT AND CENTER CEILING EMERGENCY LIGHTS, BETWEEN AFT LAVATORIES INOPERATIVE. REPLACED LAMP FOR AFT AISLE EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20120906005Battery · dischargedCEILING EMERGENCY LIGHTS FROM ROWS 13 TO 21 INOPERATIVE. RECHARGED BATTERY. OPS CHECK NORMAL.SDR AALA20120905002Frame · damagedELONGATED HOLE UNDER DOOR GUIDE AT STATION 1212 FROM LONGERONS 25 TO 24 RIGHT. INSTALLED REPAIR DOUBLER ON FRAME STATION 1212 PER EA MD80-53-025872.SDR AALA20120904007Portable Light · inoperativeLEFT NUMBER 1 DOOR PORTABLE EMERGENCY LIGHT (B5-29) INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR LEFT NUMBER 1 DOOR PORTABLE EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120901003Sensor · inoperativeDFW - CREW REPORTED DURING TAKEOFF V1 STALL INDICATION FAILURE LIGHT, SLAT DISAGREE LIGHT AND WARNING HORN CAME ON. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT ANGLE OF ATTACK VANE. SYSTEM GSDR AALA20120831007Skin · corrodedCORROSION ON INTERNAL SKIN FROM STATIONS 750 TO 760 AT LONGERONS 30 TO 29 LEFT AND RIGHT. INSTALLED DOUBLER PER SRM 53-04-03 FIGURE 11 SHEET 1 VIEW A.SDR AALA20120830005Door Frame · damagedFORWARD CARGO DOOR FRAME DAMAGE AT STATION 370 ON FORWARD UPPER CORNER OF FRAME. INSTALLED DOUBLER REPAIR PER SRM 53-05-00 FIGURE 105.SDR AALA20120830004Wedge · dentedRIGHT WING TRAILING EDGE: DENT IN BOTTOM SIDE OF INBOARD FLAP, 9 INCHES FROM INBOARD END. INSTALLED PERMANENT FLUSH DOUBLER REPAIR PER SRM 57-01-00 FIGURE 5 SHEET 2.SDR AALA20120829008Portable Light · inoperativeLEFT NUMBER 1 DOOR EMERGENCY PORTABLE LIGHT INOPERATIVE. REMOVED AND REPLACED PORTABLE BATTERY LIGHT. OPS CHECK NORMAL.SDR AALA20120829007Battery Pack · dischargedAFT CABIN ESCAPE PATH LIGHT INOPERATIVE. REPLACED AFT CABIN BATTERY PACK. OPS CHECK NORMAL.SDR AALA20120829006Battery Pack · dischargedFORWARD CABIN ESCAPE PATH LIGHT INOPERATIVE. REPLACED FORWARD BATTERIES PACK. OPS CHECK NORMAL.SDR AALA20120829005Light · damagedESCAPE PATH LIGHT SIGN ACROSS FROM FIRST CLASS LAVATORY. FOUND LAMPS AT SEAT 20D DAMAGED, CREATING DEAD SHORT. REPLACED LAMP FOR SEAT 20D ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120829004Battery · not seatedRIGHT AND CENTER CEILING EMERGENCY LIGHTS, BETWEEN AFT LAVATORIES INOPERATIVE. RESEATED EMERGENCY LIGHT BATTERY (AFT). OPS CHECK NORMAL.SDR AALA20120829003Battery · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 28 TO 30 INOPERATIVE. RESET EMERGENCY LIGHT BATTERY. OPS CHECK NORMAL.SDR AALA20120829002Battery · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 13 TO 16 INOPERATIVE. RESEATED EMERGENCY LIGHT BATTERY (MID). OPS CHECK NORMAL.SDR AALA20120829001Battery Pack · dischargedCEILING EMERGENCY LIGHTS FROM ROWS 3 TO 6. REMOVED AND REPLACED BATTERY PACK. OPS CHECK NORMAL.SDR AALA20120827019Cusp Web · crackedCUSP SHEET CRACKED AT FASTENER BETWEEN SEAT TRACKS NUMBERS 1 AND 2. INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20120826004Skin · damagedLIGHTNING STRIKE TO FUSELAGE SKIN. INSTALLED DOUBLER PER SRM 53-04-02 FIGURE 2 SHEET 3 VIEW C.SDR AALA20120826003Skin · damagedLIGHTNING STRIKE TO FUSELAGE SKIN. INSTALLED DOUBLER PER SRM 53-04-02 FIGURE 2 SHEET 3 VIEW C.SDR AALA20120826002Skin · damagedLIGHTNING STRIKE TO FUSELAGE SKIN. INSTALLED DOUBLER PER SRM 53-04-02 FIGURE 2 SHEET 3 VIEW C.SDR AALA20120826005Pan · crackedLEFT FORWARD OVERWING EXIT DOOR PAN CRACKED AT UPPER AFT CORNER. DYE CHECKED AND STOP DRILLED CRACK. FABRICATED AND INSTALLED DOUBLER PER SRM 52-05-00 FIGURE 51.SDR AALA20120825009Longeron · crackedLONGERON 4 LEFT IS CRACKED AT STATION 218 IN THE RADIUS IN THE OUTBOARD LEG. INSTALLED LONGERON AND SPLICE AT LONGERON 4 STATION 218 PER SRM 53-02-00 FIGURE 18.SDR AALA20120824005Engine · failedBHM - INFLIGHT DFW-CLT CREW REPORTED LEFT ENGINE OIL PRESSURE LOW AND OIL QUANTITY WENT TO ZERO. CAPTAIN FOLLOWED QRH PROCEDURES AND SHUT DOWN LEFT ENGINE (SINGLE ENGINE TIME 15 MINUTES). EMERGENCY DECLARED FLIGHT DIVERTED BHM LANDED WITHOUT INCIDENT. AIRSDR AALA20120824003Seat Track · corrodedNUMBER 5 SEAT TRACK AT STATION 200 CORRODED. ACCOMPLISHED STRAP REPAIR PER AARD 53-20-00-13.SDR AALA20120824001Skin · crackedCRACK IN RIGHT FUSELAGE SKIN AT STATION 1310 BETWEEN LONGERONS 6 AND 7 RIGHT. INSTALLED DOUBLER, FILLER AND FINGERS PER SRM 53-04-03 FIGURE 9 AND 51-01-00 PARAGRAPH 4.SDR AALA20120822002Contact · dirtyCEILING EMERGENCY LIGHTS FROM ROWS 28 TO 30 INOPERATIVE. FOUND CONTACTS ON BATTERY PACK DIRTY. CLEANED CONTACTS. OPS CHECK NORMAL.
Back to Mcdonnell Douglas DC-9-82