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 AALA200802549Hook And Loop · damagedHOOK AND LOOP ON GIRT BAR FLAP FOR EMERGENCY EXIT SLIDE AT AFT SERVICE DOOR FAILS TO ADHERE TOGETHER PROPERLY. REPLACED SLIDE AT AFT SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802548Cusp Web · corrodedCORROSION FOUND ON RT CUSP BELOW GALLEY AT STATION 160 TO 207. AREA OF DISCREPANCY WAS 8.5 INCHES BY 6.5 INCHES. INSTALLED DOUBLER IN ACCORDANCE WITH SRM 52-20-00-16.SDR AALA200802547Pan · corrodedCORROSION FOUND ON FORWARD SERVICE DOOR AT GALLEY DRAIN PAN AT STATION 160. AREA OF DISCREPANCY WAS 8.5 INCHES BY 9 INCHES. INSTALLED DOUBLER IN ACCORDANCE WITH SRM 52-20-00-16.SDR AALA200802546Longeron · crackedCRACK FOUND AT LONGERON 2 RT AFT OF BS 1418. REPAIRED IN ACCORDANCE WITH AARD 53-30-00-2.SDR AALA200802529Cusp Web · crackedCUSP IS CRACKED. AREA OF DISCREPANCY IS 18 INCHES BY 8 INCHES. CRACK LENGTH IS 1 INCH. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200802528Pan · corrodedFORWARD CARGO DOOR PAN IS CORRODED. AREA OF DISCREPANCY IS 57 INCHES BY 8 INCHES. REPLACED FORWARD CARGO DOOR PAN PER SRM 53-05-00.SDR AALA200802527Floor Support · corrodedFLOORBOARD SUPPORT IS CORRODED. AREA OF DISCREPANCY IS 1 INCH BY 30 INCHES. REPLACED FLOORBOARD SUPPORT PER SRM 51-01-00.SDR AALA200802526Frame · corrodedTUL FRAME IN AFT CARGO IS CORRODED. AREA OF DISCREPANCY IS 1 INCH BY 2 INCHES WITH A DEPTH OF .072 INCHES. INSTALLED DOUBLER ON FRAME IN AFT CARGO PER ESO 80559 DATED 17 SEP 2008.SDR AALA200802525Beam · corrodedDOUBLER ON MID CARGO DOOR BEAM IS CORRODED. AREA OF DISCREPANCY IS 32 INCHES BY 4 INCHES. INSTALLED DOUBLER ON MID CARGO DOOR BEAM PER AARD 53-10-00-03.SDR AALA200802524Cusp Web · corrodedRT CUSP SHEET IS CORRODED. AREA OF DISCREPANCY IS 12 INCHES BY 37 INCHES. INSTALLED NEW CUSP SHEET PER AARD 53-20-00-16.SDR AALA200802523Frame · crackedCRACK IN THE UPPER RADIUS OF OVERWING FRAME TAB AT RT STATION 905. CRACK LENGTH IS .5 INCHES. INSTALLED NEW FRAME SECTION PER SRM 51-01-00.SDR AALA200802519Longeron Splice · crackedCRACK IN LONGERON PRODUCTION SPLICE IN AFT CARGO AT STATIONS 1297 LONGERON 25 LT. AREA OF DISCREPANCY IS 2 INCHES BY 6 INCHES. CRACK LENGTH IS 2 INCHES. INSTALLED NEW LONGERON SPLICE PER SRM 51-30-00.SDR AALA200802543Frame · crackedCRACK IN WEB OF CANTER FRAME AT STATION 1485. CRACK LENGTH IS 1.5 INCHES. INSTALLED DOUBLER IN ACCORDANCE WITH AARD 53-10-00-32.SDR AALA200802542Pan · corrodedCORROSION FOUND ON FORWARD CARGO DOOR THRESHOLD PAN. AREA OF DISCREPANCY IS 1 INCH BY 57 INCHES WITH A DEPTH OF .030 INCH. REPLACED LOWER SECTION OF PAN IN ACCORDANCE WITH SRM 53-05-00.SDR AALA200802370Shroud · missingDFW EMERGENCY LIGHT AT SEAT ROW 21 MISSING SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 21. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802369Lens · missingDFW EMERGENCY LIGHT AT SEAT ROW 21 MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 21. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802368Lamp · missingDFW EMERGENCY LIGHT AT SEAT ROW 21 MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 21. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802367Shroud · damagedDFW EMERGENCY LIGHT AT SEAT ROW 22 HAS DAMAGED SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 22. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802366Shroud · damagedDFW EMERGENCY LIGHT AT SEAT ROW 25 HAS DAMAGED SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 25. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA20082340Lamp · inoperativeEMERGENCY LIGHT AT SEAT 24D INOPERATIVE. REPLACED LAMP. GROUND CHECKED NORMAL.SDR AALA200802339Lens · missingEMERGENCY LIGHT AT SEAT 15D MISSING LENS. REPLACED LENS. GROUND CHECKED NORMAL.SDR AALA200802338Shroud · missingEMERGENCY LIGHT AT SEAT 15D MISSING SHROUD. REPLACED SHROUD. GROUND CHECKED NORMAL.SDR AALA200802337Lamp · inoperativeEMERGENCY LIGHT AT LT GALLEY AISLE INOPERATIVE. REPLACED LAMP. GROUND CHECKED NORMAL.SDR AALA200802336Wire Harness · damagedLGA EMERGENCY LIGHT AT SEAT 21D INOPERATIVE. REPAIRED WIRING FOR EMERGENCY LIGHT AT SEAT 21D. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802341Actuator · malfunctionedINFLT T564, DURING CLIMB. CREW REPORTED UNSAFE NLG INDICATION ON RETRACTION. RECYCLED AND RECEIVED 3 GREEN LIGHT FOR NLG DOWN. ON RETRACTION RECEIVED UNSAFE LIGHT AGAIN. LANDED WITHOUT INCIDENT. REPLACED NLG UP PROXIMITY SENSOR ELECTRONIC UNIT AS PRECAUTISDR AALA200802298Wire Harness · inoperativeLGA INFLIGHT T712/07SEP. CREW REPORTED ANTI SKID FAILED DURING LANDING FOLLOWED BY NR 1 AND 2 TIRE FAILURE. ACFT TAXIED TO GATE UNDER ITS OWN POWER. REPAIRED TRANSDUCER WIRING AND REPLACED NR 1 AND 2 TIRES. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802289Battery Pack · inoperativeDFW EMERGENCY LIGHTS AT OVERHEAD AFT SERVICE DOOR AND TAIL CONE AREA INOPERATIVE. REPLACED BATTERY PACK AT AFT LAVATORY FOR EMERGENCY LIGHTS AT OVERHEAD AFT SERVICE DOOR AND TAIL CONE AREA. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802288Lens · missingLGA EMERGENCY LIGHT AT OVERHEAD AFT SERVICE AREA MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT OVERHEAD AFT SERVICE AREA. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802287Contact · dirtyLGA EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 23 TO 30 INOPERATIVE. CLEANED AND ADJUSTED CONTACT AT ROW 28 FOR EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 23 TO 30. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802286Contact · dirtyLGA EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 23 TO 30 INOPERATIVE. CLEANED AND ADJUSTED CONTACT AT ROW 25 FOR EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 23 TO 30. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802285Contact · dirtyLGA EXTERIOR EMERGENCY LIGHTS AT RT HAND OVERWING EXIT INOPERATIVE. CLEANED AND ADJUSTED CONTACT FOR EXTERIOR EMERGENCY LIGHTS AT RT HAND OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802284Contact · dirtyLGA EXTERIOR EMERGENCY LIGHTS AT LT HAND OVERWING EXIT INOPERATIVE. CLEANED AND ADJUSTED CONTACT FOR EXTERIOR EMERGENCY LIGHTS AT LT HAND OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802281Lamp · inoperativeMSP EMERGENCY LIGHT AT SEAT ROW 2D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 2D. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802280Lamp · brokenMSP EMERGENCY LIGHT AT SEAT ROW 25 HAS BROKEN LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 25. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802279Lens · brokenMSP EMERGENCY LIGHT AT SEAT ROW 25 HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 25. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802277Tube · brokenORD INFLIGHT T333/06SEP. CREW REPORTED LOSS OF RT HYDRAULIC SYSTEM. LANDED ORD WITHOUT INCIDENT. FOUND RT TAIL COMPARTMENT HYDRAULIC PRESSURE LINE BROKEN. REPLACED TUBE ASSEMBLY FOR RT TAIL COMPARTMENT HYDRAULIC PRESSURE LINE. SYSTEM GROUND CHECKED NORMALSDR AALA200802269Light · inoperativeEMERGENCY LIGHT AT OVERHEAD AFT GALLEY AISLE INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD AFT GALLEY AISLE. SYSTEM GROUND CHECKED NORMAL OPERATION. (K)SDR AALA200802268Flashlight · inoperativeEMERGENCY FLASH LIGHT AT AFT GALLEY INOPERATIVE. REPLACED BULB, BATTERY AND STRAP. SYSTEM GROUND CHECKED NORMAL OPERATION. (K)SDR AALA200802266Apu · leakingCREW REPORTED SMOKE IN CABIN. RETURNED TO DEPARTURE AND LANDED WITHOUT INCIDENT. FOUND AUXILIARY POWER UNIT (APU) OIL LEAKAGE WITH POSITIVE INDICATIONS OF INGESTION INTO APU INTAKE. REPLACED APU AND PERFORMED PACK BURN. SYS GROUND CHECKED NORMAL OPERATION. (K)SDR AALA200802263Screw · brokenLT NR (1) SLIDE GIRT BAR FWD RETAINER CLIP BROKEN. REPLACED ATTACH SCREW IN FWD SLIDE GIRT BAR SUPPORT BRACKET. SYSTEM GROUND CHECKED NORMAL OPERATION. (K)SDR AALA200802262Acm · failedCREW REPORTED LT AIR CONDITIONING PACK LOW FLOW INDICATION AND ZERO PRESSURIZATION. RT PACK INOPERATIVE. RETURNED TO DEPARTURE AND LANDED WITHOUT INCIDENT. REPLACED LT AND RT AIR CYCLE MACHINE (ACM). SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802256Oxygen Mask · failedDFW INFLIGHT T323/01SEP. DURING DESCENT THROUGH FL110 PRESSURIZATION FLOW LIGHT ILLUMINATED. OXYGEN MASKS WERE DEPLOYED AND CREW REPORTED ELECTRICAL SMELL. CREW REPORTED UNABLE TO CONTROL CABIN PRESSURE. LANDED DFW WITHOUT INCIDENT. FOUND OXYGEN MASKS AT SDR AALA200802252Pin · brokenGDL FOUND BROKEN SCREW AT AFT GALLEY DOOR LEVER MECHANISM. REPLACED PIN AT AFT GALLEY DOOR MECHANISM. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802245Battery Pack · not seatedLGA EMERGENCY LIGHTS AT CAT WALK INOPERATIVE. RESEATED BATTERY PACK FOR EMERGENCY LIGHTS AT CAT WALK. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802244Battery Pack · not seatedLGA EXTERIOR EMERGENCY LIGHTS AT AFT OVERWING DOOR INOPERATIVE. RESEATED BATTERY PACK FOR EXTERIOR EMERGENCY LIGHTS AT AFT OVERWING DOOR. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802239Battery Pack · dischargedLGA EXTERIOR EMERGENCY LIGHTS AT AFT RT AND LT HAND FUSELAGE INOPERATIVE. REPLACED BATTERY PACK FOR EXTERIOR EMERGENCY LIGHTS AT AFT RT AND LT HAND FUSELAGE. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802222Light · inoperativeSTL EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 13 TO 16 AND BETWEEN AFT LAVATORIES STAYED ON WHEN ALL POWER REMOVED FROM ACFT. RESET EMERGENCY LIGHT SYSTEM AND CHARGED. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802209Battery Pack · inoperativeSTL EMERGENCY LIGHTS AT AFT CABIN INOPERATIVE. REPLACED BATTERY PACK AT B5107 FOR EMERGENCY LIGHTS AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802208Battery Pack · inoperativeSTL EMERGENCY LIGHTS AT FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK AT B5100 FOR EMERGENCY LIGHTS AT FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802212Battery Pack · inoperativeSTL EMERGENCY LIGHTS AT MID CABIN INOPERATIVE. REPLACED BATTERY PACK AT AB53 FOR EMERGENCY LIGHTS AT MID CABIN. SYSTEM GROUND CHECKED NORMAL OPS.
Back to Mcdonnell Douglas DC-9-82