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 WX0A070453Angle · bentDURING BOW 1C/2C/S1/S2/S4, LT CUSP T-ANGLE BENT AT STA 1245. ADDRESSED AS REQUIRED.SDR WX0A070452Shear Tie · crackedDURING BOW 1C/2C/S1/S2/S4, FOUND SHEAR TIE CRACKED AT STA 1451 LONG 2 RT. ADDRESSED AS REQUIRED.SDR AALA20091027TUL09Stop Fitting · crackedMID CARGO DOOR LOWER STOP FITTING IS CRACKED. REPLACED WITH NEW STOP FITTING PER ESO 80174.SDR AALA20091027TUL08Stop Fitting · crackedMID CARGO DOOR UPPER STOP FITTING IS CRACKED. REPLACED STOP FITTING PER ESO 80174.SDR AALA20091027TUL07Stop Fitting · crackedFORWARD CARGO DOOR CRACKED AT STOP PAD FITTING AT AFT NUMBER TWO BEAM. REPLACED STOP PAD FITTING PER SEO 80174.SDR AALA20091027TUL06Stop Fitting · crackedFORWARD CARGO DOOR CRACKED AT STOP PAD FITTING AT AFT NUMBER ONE BEAM. REPLACED STOP PAD FITTING PER ESO 80174.SDR AALA20091027TUL05Stop Fitting · crackedFORWARD CARGO DOOR CRACKED AT STOP PAD FITTING AT AFT NUMBER 5 BEAM. REPLACED STOP PAD FITTING PER ESO 80174.SDR AALA20091027TUL04Stop Fitting · crackedFORWARD CARGO DOOR STOP PAD FITTING AT AFT NUMBER 4 BEAM CRACKED. REPLACED STOP PAD FITTING PER ESO 80174.SDR AALA20091027TUL03Stop Fitting · crackedAFT CARGO DOOR STOP PAD FITTING AT FORWARD END AT NUMBER 1 BEAM CRACKED. REPLACED STOP PAD FITTING PER ESO 80172.SDR AALA20091027TUL02Tab · crackedFOUND CRACK AT LEFT UPPER AFT WINDOW PAN TAB AT STATION 1041. INSTALLED DOUBLER ANGLE PER AARD 53-10-00-25.SDR AALA20091027TUL01Tab · crackedFOUND CRACK AT LEFT UPPER AFT WINDOW PAN TAB AT STATION 1060. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20091103TUL12Longeron · damagedMISDRILLED HOLE IN FORWARD END OF LONGERON 25 LEFT AT T-CAP. REPAIRED HOLE PER ENGINEERING AUTHORIZATION MD80-53-007858.SDR WX0A070450Cargo Track · corrodedDURING BOW 1C/2C/S1/S2/S4, TIEDOWN TRACK IN AFT CARGO FOUND CORRODED BEYOND MM LIMITS, RT SIDE FROM STA 1212 - 1307. ADDRESSED AS REQUIRED.SDR WX0A070449Cargo Track · corrodedDURING BOW 1C/2C/S1/S2/S4, LT AFT TIEDOWN TRACK CORRODED SEVERAL PLACES IN REAR CARGO. ADDRESSED AS REQUIRED.SDR WX0A070444Angle · corrodedDURING BOW 1C/2C/S1/S2/S4, 2 INCH ANGLE INBOARD OF RT TIEDOWN TRACK IS CORRODED. ADDRESSED AS REQUIRED.SDR AALA20091027LGA02Battery Pack · dischargedEMERGENCY LIGHTS AT FORWARD CEILING INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091027LGA01Battery Pack · dischargedEXTERIOR EMERGENCY LIGHTS AT AFT CARGO INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091026TUL04Stop Fitting · crackedCRACKED DOOR STOP FITTING AT NUMBER 2 BEAM FORWARD OF CARGO DOOR. INSTALLED NEW FITTING PER ESO 80174.SDR AALA20091026TUL03Stop Fitting · crackedCRACKED DOOR STOP FITTING NUMBER 3 BEAM FORWARD CARGO DOOR. INSTALLED NEW FITTING PER ESO 80174.SDR AALA20091026TUL02Stop Fitting · crackedAFT CARGO DOOR STOP PAD CRACKED ON AFT EDGE OF CARGO DOOR. REPLACED DOOR STOP PAD PER ESO 80174.SDR AALA20091026TUL01Stop Fitting · crackedAFT CARGO DOOR STOP PAD CRACKED ON AFT EDGE OF CARGO DOOR. REPLACED DOOR STOP PAD PER ESO 80174.SDR AALA20091026DFW02Battery Pack · dischargedEMERGENCY LIGHTS IN TAIL COMPARTMENT INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091026LGA02Battery Pack · dischargedEMERGENCY LIGHT IN FORWARD CABIN AISLE INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091026DFW01Connector · looseEMERGENCY LIGHT AT SEAT 23DEF INOPERATIVE. REPINNED SEAT 23DEF EMERGENCY LIGHT CONNECTOR.SDR AALA20091026LGA01Battery Pack · dischargedEMERGENCY LIGHT IN AFT CABIN INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091025LGA02Battery Pack · dischargedEMERGENCY LIGHT IN AFT CABIN INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091025LGA01Battery Pack · dischargedEMERGENCY LIGHT AT AFT CABIN INOPERATIVE. REPLACED BATTERY PACK AT SEAT 20DEF.SDR AALA20091111TUL03Battery Pack · dischargedEMERGENCY LIGHTS IN THE TAIL COMPARTMENT INOPERATIVE. REPLACED BATTERY PACK B5-28.SDR AALA20091111TUL02Shroud · missingEMERGENCY LIGHT AT SEAT 24D MISSING SHROUD. REPLACED SHROUD AT SEAT 24D.SDR AALA20091111TUL01Shroud · missingEMERGENCY LIGHT AT SEAT 19D MISSING SHROUD. REPLACED SHROUD AT SEAT 19D.SDR AALA20091029TUL02Frame · crackedCANT FRAME STATION 1497 CRACKED AT RIGHT SIDE, LONGERON 16. INSTALLED REPAIR DOUBLER PER SRM 53-01 WITH PROVISIONS PER EA MD80-53-007851.SDR AALA20091023DFW01Battery Pack · dischargedEMERGENCY LIGHTS IN THE AFT CABIN CEILING PANEL INOPERATIVE. REPLACED BATTERY PACK B5-27.SDR AALA20091022PHX01Shroud · missingEMERGENCY LIGHTS AT SEAT 8D MISSING SHROUD. REPLACED SHROUD AT SEAT 8D.SDR WX0A070442Diaphragm · corrodedDURING BOW 1C/2C/S1/S2/S4, CORROSION WAS FOUND ON SUBFLOOR AT STA 160, RBL 4 TO 15. ADDRESSED AS REQUIRED.SDR AALA20091022LGA01Pitot Tube · failedINFLIGHT BWI TO DFW. ON CLIMBOUT OF BWI THE RUDDER LIMITER PITOT HEATER FAILED. RESET CIRCUIT BREAKER ONE TIME BUT IT POPPED AGAIN. LANDED LGA WITHOUT INCIDENT. REPLACED THE RUDDER LIMITER PITOT HEATER.SDR AALA20091021TUL03Stop Fitting · crackedDOOR STOP PAD CRACKED AT CENTER DOOR PAD SUPPORT BRACKET AT FORWARD CARGO DOOR. REMOVED AND REPLACED CENTER DOOR STOP PAD PER ESO 80174.SDR AALA20091021TUL02Stop Fitting · crackedDOOR STOP PAD CRACKED AT AFT UPPER CORNER AT AFT CARGO DOOR. REMOVED AND REPLACED AFT UPPER CORNER DOOR STOP PAD.SDR AALA20091021TUL01Stop Fitting · crackedDOOR STOP PAD CRACKED AT FORWARD UPPER CORNER AT AFT CARGO DOOR. REMOVED AND REPLACED FORWARD UPPER CORNER DOOR STOP PAD.SDR AALA20091021DFW03Contact · dirtyEMERGENCY LIGHT BATTERY PACK B5-28 INOPERATIVE. CLEANED BATTERY PACK CONTACTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20091021DFW02Connector · looseEMERGENCY LIGHT AT SEAT 25D INOPERATIVE. SECURED WIRE HARNESS OUTBOARD CONNECTOR AT SEAT 25D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20091021DFW01Light · damagedEMERGENCY LIGHT AT SEAT 13D DAMAGED. SHROUD AND LENS BROKEN OFF. REPLACED SHROUD AND LENS AT SEAT 13D.SDR AALA20091018LGA02Battery · not seatedCEILING EMERGENCY LIGHTS AT SEAT ROWS 28 TO 31 INOPERATIVE. RESEATED EMERGENCY LIGHTS BATTERIES.SDR AALA20091018LGA01Battery Pack · looseTAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. RESET BATTERY PACK.SDR AALA20091017LGA03Battery · not seatedEMERGENCY CEILING LIGHTS BY AFT LAVATORY INOPERATIVE. RESEATED BATTERIES IN BATTERY PACK IN RIGHT AFT LAVATORY.SDR AALA20091017LGA02Wire · damagedEMERGENCY EXIT SIGN ACROSS FROM FIRST CLASS LAVATORY INOPERATIVE. REPAIRED WIRE ON EXIT SIGN.SDR AALA20091017DFW01Shroud · missingEMERGENCY LIGHT AT SEAT 11D IS MISSING SHROUD. REPLACED SHROUD AT SEAT 11D.SDR AALA20091013DFW05Lens · missingFORWARD CATWALK EMERGENCY LIGHT LENS MISSING. REPLACED MISSING LENS.SDR AALA20091013LGA01Battery · dischargedFORWARD EMERGENCY EGRESS LIGHT INOPERATIVE. REPLACED BATTERY AND OPS CHECKED NORMAL.SDR AALA20091012DFW02Shutoff Valve · leakingDFW INFLIGHT. RIGHT HYDRAULIC QUANTITY WENT TO ZERO ALONG WITH HYDRAULIC PRESSURE TO 1500 PSI WHEN SLATS WERE EXTENDED ON FINAL APPROACH. LANDING WAS NORMAL EXCEPT FOR DRAGGING DOORS ON LANDING. FOUND RIGHT SHUT OFF VALVE LEAKING. REPLACED GROUND SPOILER CSDR AALA20091013LGA02Battery Pack · dischargedOVERHEAD EMERGENCY LIGHTS AT SEAT ROWS 4 TO 6 INOPERATIVE. REPLACED BATTERY PACK.
Back to Mcdonnell Douglas DC-9-82