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 AALA20111108TUL02Tab · crackedTAB ON FRAME IS CRACKED AT STATION 207, LONGERON 10 LEFT. INSTALLED REPAIR ANGLE DOUBLER AND FILLER PER AARD 53-10-00-11.SDR FOTR2011110821186Web · corrodedLEFT MAIN DECK WEB CHAFED IN MULTIPLE LOCATIONS ON UPPER SURFACE LBL 44 TO LBL 52, FS 807 - 845. REPAIRED ON FASI WO 21186 AT 14934.SDR AALA20111111TUL03Battery Pack · dischargedEMERGENCY LIGHTS AT FORWARD GALLEY INOPERATIVE. REPLACED BATTERY PACK AT FORWARD GALLEY. OPS CHECK NORMAL.SDR AALA20111107LGA01Battery Pack · dischargedEMERGENCY LIGHTS AT ROWS 13 TO 16 AND 32 INOPERATIVE. REPLACED BATTERY PACK AT AFT RIGHT LAVATORY. OPS CHECK NORMAL.SDR AALA20111107ATL01Indicator · erraticATL - INFLIGHT ORD-MCO. CREW REPORTED LEFT WING TANK FUEL INDICATION IN CRUISE MODE IN QUESTION TO AMOUNT OF FUEL QUANTITY AND FUEL BURNED BY FLIGHT CREW. FLIGHT DIVERTED ATL LANDED WITHOUT INCIDENT. PLACARD LEFT FUEL QUANTITY AND FUEL TOTALIZER PER AMM MELSDR AALA20111107ORD02Battery Pack · dischargedUNABLE TO TURN OFF EMERGENCY LIGHTS IN FIRST CLASS CEILING. REPLACED BATTERY PACK IN BIN 6EF. OPS CHECK NORMAL.SDR AALA20111106TUL02Frame · crackedTHE 1418 FRAME CRACKED AT LONGERON 2 LEFT. REPAIRED WITH REPAIR DOUBLER PER SRM 53-03-00 FIGURE 31A.SDR AALA20111105LGA02Battery Pack · out of positionEMERGENCY LIGHT AT SEATS 29DEF AND 30DEF INOPERATIVE. REPOSITIONED BATTERY PACK AT EMERGENCY POWER SUPPLY. OPS CHECK NORMAL.SDR AALA20111105LGA01Battery Pack · not seatedBATTERY PACK FOR CABIN EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERY PACK AT EMERGENCY POWER SUPPLY. OPS CHECK NORMAL.SDR AALA20111104TUL13Shear Tie · crackedSHEAR TIE CRACKED AFT SIDE OF 1451 LONGERON 2 LEFT. INSTALLED NEW SHEAR TIE PER AARD 51-10-00-5 AND SRM 51-30-05.SDR AALA20111102TUL20Shear Tie · crackedSHEAR TIE CRACKED AFT SIDE OF 1451 AFT OF LONGERON 2 LEFT. INSTALLED NEW SHEAR-TIE PER AARD 51-10-11-5.SDR AALA20111102TUL03Frame · crackedTHE 1474 CANT FRAME CRACKED AFT OF LONGERON 18 LEFT. INSTALLED REPAIR ANGLE PER EA MD80-53-020101 DATED 11-2-11.SDR AALA20111102LGA01Battery Pack · dischargedCEILING EMERGENCY LIGHTS FROM ROWS 7 TO 11 INOPERATIVE. RE-SEATED EMERGENCY LIGHT BATTERY PACK. OPS CHECKS NORMAL.SDR AALA20111101TUL01Skin · damagedMID CARGO DOOR EXTERIOR SKIN SEVERAL AREAS DAMAGED. REMOVED AND REPLACED OUTER SKIN PER ESO 80174.SDR AALA20111031TUL04Bulkhead · crackedSTATION 37 BULKHEAD CRACKED AT LOWER LEFT RADOME ALIGNMENT PIN. CRACK CONFIRMED BY DYE PENETRANT INSPECTION. INSTALLED ANGLE REPAIR DOUBLER PER AARD 53-10-00-19.SDR AALA20111029TUL02Cusp Web · corrodedCUSP IS CORRODED UNDER AFT GIRT BAR FITTING BRACKET AT AFT SERVICE DOOR. INSTALLED SUB FLOOR BRACKET, DOUBLER AND FILLER PER TO AARD 53-20-00-16.SDR AALA20111028TUL02Frame · corrodedAFT CARGO CORROSION ON FRAME 1309 AFT SIDE LONGERON 29 RIGHT TO LONGERON 26 LEFT. REMOVED DAMAGED AREA OF FRAME SPLICED IN NEW SECTION OF FRAME FROM LONGERONS 28 RIGHT TO 28 LEFT PER SRM 53-03-00 FIGURE 2A.SDR AALA20111027TUL02Rib · crackedRIGHT NUMBER 5 LEADING EDGE SLAT OUTBOARD TRACK ATTACH BRACKET IS CRACKED. REPLACED DAMAGED RIB PER ESO 80117 CH 27-80-1.SDR AALA20111027LGA02Connector · looseESCAPE PATH LIGHT AT SEAT 12D INOPERTAIVE. SECURED LOOSE CONNECTOR AT SEAT 12D. OPS CHECKS NORMAL.SDR AALA20111027LGA01Battery Pack · dischargedOVERHEAD EMERGENCY LIGHTS BETWEEN AFT LAVATORIES DO NOT ILLUMINATE. REPLACED BATTERY PACK IN RIGHT AFT LAVATORY. OPS CHECKS NORMAL.SDR AALA20111027TUL01Rib · crackedRIGHT NUMBER 5 LEADING EDGE SLAT OUTBOARD TRACK ATTACH BRACKET IS CRACKED. REPLACED DAMAGED RIB PER ESO 80117 CH 27-80-1.SDR FOTR2118615312Web · corrodedSUPPORT WEB BENEATH FLOOR FS207, LBL-44-45 HAS LARGE AREA OF EXFOLIATION AND A HOLE WHERE IT MEETS SEAT TRACK. REPAIRED ON FASI WO 21186 MR15312.SDR AALA20111026SAT01Check Valve · crackedSAT - CREW REPORTED TAIL COMPARTMENT HIGH TEMPERATURE LIGHT ILLUMINATED DURING CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED SAT LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED FLOW CONTROL CHECK VALVE THAT WAS CRACKED. SYSTEM GROUND CHECKSDR AALA20111025TUL12Seat Track · wornDEEP BLENDS ON TOP AND LUGS OF SEAT TRACK 1, STATIONS 1080 TO 1085. REMOVED DAMAGED MATERIAL AND INSTALLED PLUG PER AARD 53-20-00-10.SDR AALA20111025TUL11Seat Track · damagedDEEP BLENDS ON TOP AND LUGS, SEAT TRACK 1, STATIONS 1116 TO 1118. REMOVED DAMAGE AND INSTALLED PLUG PER AARD 53-20-00-10.SDR AALA20111025TUL10Mount Fitting · corrodedOUTBOARD G1 GALLEY MOUNT HAS CORROSION AT STATION 150. INSTALLED G1 GALLEY OUTBOARD MOUNT FITTING PER SRM 51-30-02 AND SRM 51-30-05.SDR AALA20111025LGA01Charger · inoperativeCEILING LIGHTS INOPERATIVE. REPLACED BATTERY CHARGER FOR CEILING LIGHTS. OPS CHECK NORMAL.SDR AALA20111023ORD02Control Box · inoperativeORD - CREW REPORTED LEFT AND RIGHT INBOARD AND OUTBOARD ANTI SKID LIGHTS ILLUMINATED WITH LANDING GEAR EXTENSION. FLIGHT LANDED ORD WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ANTI-SKID CONTROL BOX. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20111023ORD01Sensor · failedORD - INFLIGHT IND-DFW. CREW REPORTED ON TAKEOFF NOSE GEAR DOOR OPEN LIGHT ILLUMINATED. ACCOMPLISHED QRH ALL OTHER INDICATIONS SEEMED NORMAL. FLIGHT DIVERTED ORD LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED D1-32 SENSOR. SYSTEM GROUNDSDR AALA20111022TUL02Relay · inoperativeTUL - INFLIGHT DFW-ORD. CREW REPORTED AUXILIARY POWER UNIT FAILED WITH RIGHT GENERATOR ALREADY ON PLACARD. FLIGHT DIVERTED TUL LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED THE AUXILIARY POWER UNIT GENERATOR CONTROL UNIT. ADJUSTED VOLTSSDR AALA20111018TUL01Frame · crackedCRACK IN AFT RADIUS OF FRAME AT STATION 1418, EVEN WITH LONGERON LONGERON 2. INSTALLED REPAIR DOUBLER TO AFT SIDE OF FRAME STATION 1418 LONGERON 2 PER SRM 53-03-00.SDR AALA20111018LGA01Battery Pack · dischargedFIRST CLASS EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20111020TUL07Light · inoperativeRIGHT CEILING PANEL EMERGENCY LIGHT AT ROW 8 INOPERATIVE. REPLACED LAMP FOR RIGHT CEILING PANEL EMERGENCY LIGHT AT ROW 8. OPS CHECK NORMAL.SDR AALA20111020TUL06Light · inoperativeRIGHT CEILING PANEL EMERGENCY LIGHT AT ROW 5 INOPERATIVE. REPLACED LAMP FOR RIGHT CEILING PANEL EMERGENCY LIGHT AT ROW 5. OPS CHECK NORMAL.SDR AALA20111017DFW01Lens · missingLEFT CEILING PANEL EMERGENCY LIGHT AT ROW 28 MISSING LENS. REPLACED LENS FOR CEILING PANEL EMERGENCY LIGHT AT ROW 28. OPS CHECK NORMAL.SDR AALA20111013TUL06Frame · gougedFUSELAGE FRAME STATION 148 GOUGED. ACCOMPLISHED REPAIR PER SRM 51-70-5.SDR AALA20111013TUL09Cusp Web · corrodedRIGHT CUSP SHEET STATION 788 TO 807 CORRODED. ACCOMPLISHED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20111013TUL08Cusp Web · corrodedCUSP STATION 1205 LEFT SIDE CORRODED. ACCOMPLISHED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20111013TUL07Web · crackedCRACK AT WEB STATION 207 LONGERON 15 LEFT. ACCOMPLISHED DOUBLER REPAIR PER AARD53-10-00.SDR AALA20111014LGA03Light · inoperativeCEILING EMERGENCY LIGHT AT SEAT 27B INOPERATIVE. REPLACED LAMP FOR SEAT 27B EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20111014LGA02Light · inoperativeCEILING EMERGENCY LIGHT AT SEAT 23D INOPERATIVE. REPLACED LAMP FOR SEAT 23D EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20111014LGA01Battery Pack · dischargedRIGHT AND CENTER CEILING EMERGENCY LIGHTS BETWEEN AFT LAVATORIES INOPERATIVE. REPLACED RIGHT AFT LAVATORY FORWARD BATTERY PACK. OPS CHECK NORMAL.SDR AALA20111013LGA03Battery Pack · dischargedCEILING EMERGENCY LIGHTS AT ROWS 19 TO 21 INOPERATIVE. REPLACED BATTERY PACK AT ROW 20. OPS CHECKS NORMAL.SDR AALA20111013LGA02Battery Pack · dischargedFORWARD OVERHEAD CABIN/COCKPIT EMERGENCY CEILING LIGHTS ARE INOPERATIVE. REPLACED BATTERY PACK. OPS CHECKS NORMAL.SDR AALA20111013LGA01Battery Pack · dischargedFORWARD OVERWING EXIT EMERGENCY LIGHTS ARE AT ROW 20 INOPERATIVE. REPLACED BATTERY PACK. OPS CHECKS NORMAL.SDR AALA20111012TUL09Frame · crackedTHE 1418 FRAME CRACKED AT LONGERON 2 LEFT. INSTALLED DOUBLER AT 1418 LONGERON 2 LEFT PER SRM 53-03-00.SDR AALA20111012LGA01Battery Pack · dischargedCEILING EMERGENCY LIGHTS FROM ROWS 7 TO 11 INOPERATIVE. REPLACED EMERGENCY BATTERY PACK AT ROW 7DEF. OPS CHECK NORMAL.SDR AALA20111009DFW02Hydraulic Line · leakingDFW - CREW REPORTED RIGHT HYDRAULIC SYSTEM FAILED. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED HYDRAULIC LINE THAT WAS LEAKING. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20111007TUL11Membrane · corrodedBOTTOM OF MEMBRANE STATION 585 TO 598 CORRODED. REPLACED MEMBRANE WITH NEW SECTION.SDR AALA20111007TUL10Outflow Valve · faultyTUL - CREW REPORTED LOSS OF PRESSURIZATION DURING FCF. EMERGENCY DECLARED FLIGHT LANDED TUL WITHOUT INCIDENT. REPLACED OUTFLOW VALVE. SYSTEM GROUND CHECK NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82