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 AALA2009051600935Light · inoperativeLGA CEILING EMERGENCY LIGHTS BY FLIGHT ATTENDANT SEAT AT AFT GALLEY DOOR INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHTS BY FLIGHT ATTENDANT SEAT AT AFT GALLEY DOOR.SDR AALA2009051600934Wire · brokenLGA AFT STAIRS SIDEWALL EMERGENCY LIGHTS INOPERATIVE. REPAIRED BROKEN WIRE AT EMERGENCY LIGHT SIDEWALL HARNESS.SDR AALA2009051600933Connector · brokenLGA EMERGENCY PATH LIGHTS FOR SEAT 27D INOPERATIVE. REPAIRED BROKEN EMERGENCY PATH LIGHT CONNECTOR AT SEAT 27D.SDR AALA2009051600932Battery Pack · not seatedLGA CEILING EMERGENCY LIGHTS FROM ROW 4 TO 11 INOPERATIVE. RESEATED MID CABIN EMERGENCY LIGHT BATTERY PACK.SDR AALA2009051500001Generator · inoperativeSLC - DURING FLIGHT RIGHT GENERATOR KICKED OFF AND AUXILIARY POWER UNIT WOULD NOT COME ON. RETURNED SLC WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED THE NUMBER 2 ENGINE GENERATOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090609TUL44Support Angle · crackedNR 2 SEAT TRACK SUPPORT ANGLE CRACKED AT STATION 927 BELOW FLOORBEAM. REMOVED CRACKED ANGLE, INSTALLED NEW ANGLE PER SRM 51-01.SDR AALA20090609TUL43Longeron · crackedLONGERON 20L CRACKED AT STATION 1003. STOP DRILLED CRACK AND INSTALLED DOUBLER PER AARD 53-10-00-18.SDR AALA20090609TUL47Pressure Panel · crackedCRACK IN RIGHT WHEEL WELL PRESSURE DECK AT STATION 990 IN AREA OF FUEL LINE SHROUD. STOP DRILLED CRACK, INSTALLED TITANIUM DOUBLER PER AARD 53-30-00-13.SDR WX0A070311Shear Tie · crackedSHEAR TIE CRACKED AT BOTTOM END BETWEEN L13-L14, LEFT AT STATION 1380. REPAIRED PER ESO 80559 / AARD 53-10-20, REF E58 6278265.SDR WX0A070309Seat Track · corrodedNR 6 SEAT TRACK CORRODED AT SPLICE AT STATION 798 REF E58 6278336. REPLACED SECTION OF NR 6 SEAT TRACK FROM STATION 798 TO STATION 909 PER SRM 53-05 FIG 4 SHEET 5 PAGE 36.SDR AALA2009051300004Selector · inoperativeCREW REPORTED CABIN LOST PRESSURIZTION. LANDED STL WITHOUT INCIDENT. FOUND NR 1 PRESSURE CONTROL INOPERATIVE. REPLACED NUMBER ONE CABIN PRESSURE CONTROLLER AND NR 1 AND 2 CABIN PRESSURE SELECTOR. MPN 1304768. SYSTEM GROUND CHECK NORMAL OPERATION. (CLOSED)SDR AALA09051300004AO-Ring · failedRIGHT HYDRAULIC FAILURE OCCURRED ON DESCENT. EMERGENCY DECLARED LANDED ATL WITHOUT INCIDENT. FOUND BLOWN O-RING ON RIGHT HAND THRUST REVERSER CONTROL VALVE. REPLACED O-RING. SYSTEM GROUND CHECK NORMAL OPERATION. (CLOSED)SDR AALA2009051300926Charger · inoperativeDFW ESCAPE PATH LIGHTING FROM ROW 20 AND BACK INOPERATIVE. REPLACED AFT POSITIONED BATTERY CHARGER ASSEMBLY.SDR AALA20090609TUL45Stop Fitting · crackedAFT CARGO DOOR LOWER FORWARD STOP FITTING CRACKED. REMOVED AND REPLACED STOP PAD FITTING PER ESO 80174.SDR WX0A070308Shear Tie · crackedSHEAR TIE CRACKED AT STATION 1401 BELOW APU EXHAUST DUCT.SDR AALA20090513TUL02Fitting · crackedFWD CARGO DOOR, FWD EDGE LOWER STOP PAD FITTING CRACKED. REMOVED AND REPLACED STOP PAD FITTING PER ESO 80174.SDR AALA20090513TUL03Fitting · crackedFWD CARGO DOOR, FWD EDGE SECOND FROM BOTTOM STOP PAD FITTING CRACKED. REMOVED AND REPLACED STOP PAD FITTING PER ESO 80174.SDR AALA20090515TUL03Bracket · crackedRT WHEEL WELL MLG DOOR ACTUATOR BRACKET CRACKET. REMOVED AND REPLACED BRACKET PER AARD 51-00-00-012 AND SRM 51-30-05.SDR AALA20090513TUL05Web · crackedWEB CRACKED AT FASTENER, AT CANT FRAME 1485 AT UPPER LT SIDE. STOP DRILLED AND INSTALLED DOUBLER PER AARD 53-10-00-32.SDR AALA200905090909Guard · damagedDFW - EMERGENCY LIGHT GUARD AT SEAT 9D DAMAGED. REPLACED GUARD FOR EMERGENCY LIGHT AT SEAT 9D.SDR AALA2009050900908Light · inoperativeLGA - FLOOR EXIT SIGN ACROSS FROM FORWARD LAVATORY INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR FLOOR EXIT SIGN ACROSS FROM FORWARD LAVATORY.SDR AALA2009050900907Battery · not seatedLGA - CEILING EMERGENCY LIGHTS BETWEEN AFT LAVATORIES INOPERATIVE. RESEATED BATTERIES IN CHARGER FOR CEILING EMERGENCY LIGHTS BETWEEN AFT LAVATORIES.SDR AALA2009050900906Battery · not seatedLGA - TAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERIES IN CHARGER.SDR AALA2009050900905Battery Pack · corrodedLGA - TAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. CLEANED AND RESEATED BATTERY PACK FOR TAIL COMPARTMENT EMERGENCY LIGHTS.SDR AALA2009050900904Light · brokenLGA - EMERGENCY LIGHTS AT FIRST CLASS LAVATORY INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY AT FIRST CLASS LAVATORY.SDR AALA20090513TUL08Battery Pack · weak3 EMERGENCY LIGHT BATTERY PACKS WEAK. REMOVED AND REPLACED BATTERY PACKS PER MM 33-53-00-6. OP`S CHECK GOOD.SDR AALA20090609TUL05Bracket · damagedMID CARGO AFT CORNER BRACKET HAS CORROSION. REMOVED AND REPLACED CORNER BRACKET PER AARD 51-00-00-012.SDR AALA20090609TUL06Skin · crackedVERTICAL STAB L/E SKIN CRACKED AFT OF RAM AIR INTAKE LEFT SIDE. INSTALLED DOUBLER PER SRM 55-01-00 FIGURE 2 SHEET 2.SDR AALA20090609TUL03Pressure Panel · crackedCRACK IN RIGHT WHEEL WELL PRESSURE DECK ADJACENT TO FUEL SHROUD SUPPORT ANGLE. INSTALLED DOUBLER PER SRM 53-01 FIGURE 2 SHEET 3.SDR AALA20090513TUL23Casting · crackedRT WING GROUND SPOILER CASTING CRACKED. REPLACED SPOILER CASTING PER SRM 51-30-00.SDR AALA20090512TUL62Fitting · corrodedCORROSION ON DOOR JAMB LOWER FWD FITTING IN MID CARGO. REPLACED BRACKET PER AARD 51-00-00-012.SDR AALA20090512TUL60Bracket · corrodedCORNER BRACKET IN MID CARGO CORRODED. REPLACED CORNER BRACKET PER AARD 51-00-00-012.SDR AALA20090512TUL59Frame · crackedCANT FRAME 1474 CRACKED. INSTALLED DOUBLER ON CANT FRAME AT L18L PER ZAARD 53-10-00-15.SDR AALA20090512TUL58Battery Pack · dischargedAFT AISLE BATTERY PACK AB5-4 HAS LOW OUTPUT. REMOVED AND REPLACED BATTERY PER 33-60-98-4.SDR AALA20090609TUL15Mount · corrodedCABIN FORWARD ENTRY AREA HAS CORROSION ON INBOARD G1 GALLEY SUB FLOOR MOUNT BRACKET. INSTALLED NEW G1 GALLEY MOUNT BRACKET PER SRM 51-30-15.SDR AALA20090609TUL02Stop Fitting · crackedTOP FORWARD STOP PAD FITTING CRACKED ON AFT CARGO DOOR. REMOVED AND REPLACED FITTING PER ESO 80174.SDR AALA20090609TUL01Doubler · crackedCABIN FORWARD ENTRY AREA HAS CRACK IN STRAP DOUBLER STA 208 LONGERON 15 LEFT. INSTALLED REPAIR DOUBLER PER 53-10-00-11.SDR AALA2009050600875Flashlight · missingLGA LEFT NUMBER 1 DOOR EMERGENCY FLASHLIGHT MISSING. REPLACED LEFT NUMBER 1 DOOR EMERGENCY FLASHLIGHT.SDR AALA2009050600874Battery Pack · dischargedLGA FORWARD EXIT LIGHTS IN MID CABIN INOPERATIVE. REPLACED BATTERY PACK IN MID CABIN FOR FORWARD EXIT LIGHTS.SDR AALA20090826TUL05Stop Fitting · crackedDOOR STOP FITTING AT FORWARD END OF NUMBER 1 BEAM IS CRACKED. REMOVED AND INSTALLED A SERVICEABLE DOOR STOP FITTING.SDR AALA20090826TUL04Stop Fitting · crackedDOOR STOP FITTING AT FORWARD END OF NUMBER 5 BEAM IS CRACKED. REMOVED AND INSTALLED A SERVICEABLE DOOR STOP FITTING.SDR AALA20090826TUL03Stop Fitting · crackedDOOR STOP FITTING AT FORWARD END OF NUMBER 3 BEAM IS CRACKED. REMOVED AND INSTALLED A SERVICEABLE DOOR STOP FITTING.SDR AALA2009050500001Sensor · inoperativeLANDING NOSE GEAR UNSAFE INDICATION. EMERGENCY DECLARED FLIGHT DID A GO AROUND THEN LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NOSE GEAR LOCK SENSOR. SYSTEM GROUND CHECK NORMAL OPERATION. (CLOSED)SDR AALA20090605TUL10Longeron · wornWEAR MARK ON LONGERON 2 LEFT APPROXIMATELY 1 INCH LONG BY .020 DEEP. INSTALLED J-ANGLE DOUBLER, MATERIAL .063 7075T6 ON LONGERON 2 LEFT AT STATION 256 PER SRM 51-10-3.SDR AALA2009050500873Screw · missingLGA COCKPIT DOOR EMERGENCY EXIT SIGN MISSING SCREWS. REPLACED MISSING SCREWS FOR COCKPIT DOOR EMERGENCY EXIT SIGN.SDR AALA2009050500872Battery Pack · dischargedLGA FORWARD EXIT LIGHT INOPERATIVE. REPLACED MID CABIN BATTERY PACK.SDR AALA2009050500871Flashlight · inoperativeLGA LEFT NUMBER ONE FORWARD ENTRY DOOR FLASHLIGHT INOPERATIVE. REPLACED LEFT NUMBER ONE FORWARD ENTRY DOOR FLASHLIGHT.SDR AALA20090521TUL32Battery Pack · dischargedCABIN CEILING PANEL EMERGENCY LIGHTS DIM ROW 23 TO ROW 30. REPLACED TWO BATTERY PACKS AT ROW 25 AND 29. OPS CHECK GOOD.SDR AALA20090521TUL31Support Angle · corrodedAFT CARGO FLOORBOARD SUPPORT Z ANGLE CORRODED STATION 1155 AFT END OF RIGHT TIEDOWN TRACK. INSTALLED NEW Z ANGLE PER SRM 53-01-01.SDR AALA20090521TUL30Beam · corrodedAFT CARGO, CORROSION FOUND IN NUMEROUS AREAS ON HORIZONTAL AND VERTICAL LEG OF AFT CARGO DOOR BEAM. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3
Back to Mcdonnell Douglas DC-9-82