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 AALA2009020700461Battery Pack · dischargedLGA - SEVERAL CEILING EMERGENCY LIGHTS FROM ROWS 7 TO 32 INOPERATIVE. REPLACED BATTERY PACK AT FORWARD GALLEY AND ROW 25.SDR AALA2009020700460Battery · looseLGA - TAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERY FOR TAIL COMPARTMENT EMERGENCY LIGHTS.SDR AALA20090226TUL06Seat Track · corrodedCORROSION SEAT TRACK NUMBER 6, INSTALLED NEW SECTION SEAT TRACK SECTION PER SRM 53-40-01-2.SDR AALA2009021300104Bracket · corrodedGIRT BAR SUPPORT STRUCTURE AFT BRACKET CORRODED. INSTALLED NEW GIRT BAR SUPPORT BRACKET PER SRM 51-01.SDR AALA20090225TUL01Window Frame · crackedWINDOW FRAME CRACKED AT BOTTOM FORWARD CORNER AT STATION 1079 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA2009020600455Battery Pack · dischargedDFW - CABIN CEILING EMERGENCY LIGHTS FROM ROWS 23 TO 27 CAME ON WHEN THE AIRCRAFT POWER IS TURNED OFF. REPLACED BATTERY PACKS FOR ROWS 23 TO 27.SDR AALA2009020600454Battery Pack · dischargedDFW - THE AFT OVERWING EMERGENCY LIGHTS STAYED ON WHEN POWERING DOWN THE AIRCRAFT. REPLACED BATTERY PACK FOR AFT OVERWING LIGHTS.SDR AALA20090226TUL01Mount · corrodedGALLEY TIE DOWN CORRODED, REMOVED AND REPLACED GALLEY TIE DOWN PER SRM 51-01.SDR AALA2009020600227Fitting · crackedVAULT DOOR LOWER LEFT JAMB FITTING CRACKED, REMOVED AND REPLACED WITH NEW FITTING PER SRM 51-01.SDR AALA2009020600226Window Frame · crackedWINDOW FRAME CRACKED BOTTOM FORWARD CORNER AT STATION 1079 LEFT, DOUBLER INSTALLED PER AARD 53-10-00-25.SDR AALA2009020600225Window Frame · crackedWINDOW FRAME CRACKED AT STATION 905 RIGHT BOTTOM AFT CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA2009020600224Window Frame · crackedWINDOW FRAME CRACKED FORWARD TOP CORNER AT STATION 845 LEFT, INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA2009020600223Window Frame · crackedWINDOW FRAME CRACKED AT FORWARD TOP CORNER LEFT STATION 927, INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA2009021300097Longeron · corrodedRIVET BULGING ON SKIN. CORROSION AT LONGERON 26 LEFT AT STATION 686. INSTALLED SPLICE FOR LONGERON 26 LEFT AT STATION 686 AFTER CORROSION REMOVAL IN ACCORDANCE WITH SRM 53- 34-00.SDR AALA2009020401018Adc · malfunctionedJFK - INFLIGHT LGA-ORD. THE CAPTAIN REPORTED THAT DURING TAKEOFF THE F/O LOST HIS AIR SPEED INDICATOR. FLIGHT WAS ABOVE ROLLOUT SPEED SO TAKEOFF CONTINUED. AUTO THROTTLES DISENGAGED AND OTHER INSTRUMENTS FAILED. THE CAPTAIN FLEW THE PLANE MANUALLY INTO JFKSDR AALA2009020300744Strap · brokenLGA STRAP FOR LOWER FLASHLIGHT BY FORWARD JUMPSEAT BROKEN. REPLACED STRAP FOR LOWER FLASHLIGHT BY FORWARD JUMPSEAT.SDR AALA2009020300449Battery Pack · dischargedSFO - LEFT AND RIGHT OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EMERGENCY EXIT LIGHTS.SDR AALA2009020300448Battery Pack · dischargedSFO - EMERGENCY LIGHTS WILL NOT COME ON ONLY ROW LIGHTS COME ON. REPLACED BATTERY PACK.SDR AALA2009020300447Wire Harness · damagedSFO - EMERGENCY LIGHTS WILL NOT COME ON ONLY ROW LIGHTS COME ON. REPAIRED WIRE HARNESS AT SEAT ASSEMBLY 7DEF.SDR AALA2009021300096Intercostal · crackedWEB CRACKED ABOVE AND FORWARD OF TAIL CONE UPPER RIGHT LATCH RECEPTACLE AT CANT STATION 1510. REPLACED INTERCOSTAL IN ACCORDANCE WITH DRAWING 9911875, MSR NR 081531.SDR AALA2009021300095Support Fitting · crackedSUPPORT FITTING CRACKED AT LEFT WING STATION 280. STOP DRILLED CRACK AND INSTALLED DOUBLER IN ACCORDANCE WITH ESO 80559 DATED 03 FEB 09.SDR AALA2009020100444Battery Pack · dischargedLGA - FIRST CLASS EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK IN FIRST CLASS.SDR AALA2009020100443Battery Pack · dischargedLGA - AFT CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK AT AFT CEILING.SDR AALA2009020100442Battery Pack · dischargedLGA - OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED OVERWING BATTERY PACK.SDR AALA2009013100421Battery Pack · not seatedLGA- TAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. CLEANED AND RECONNECTED BATTERY PACK.SDR AALA2009013100420Battery Pack · dischargedLGA - AFT STAIRS LEFT SIDEWALL EMERGENCY LIGHTS INOPERATIVE. REPLACED EMERGENCY PATH LIGHTING BATTERY PACK.SDR AALA2009013100419Battery Pack · dischargedLGA - SEAT MOUNTED ESCAPE PATH LIGHTING FROM ROW 20D TO 32D INOPERATIVE. REPLACED BATTERY PACK.SDR AALA2009013100418Battery Pack · dischargedDFW - THE FORWARD CABIN EXIT MARKERS AND SEAT EMERGENCY PATH LIGHTING FROM FRONT TO ROW 19 INOPERATIVE. REPLACED THE BATTERY PACK FOR THE AB5-1 CHARGING MODULE.SDR AALA2009013100417Lamp · burned outDFW - EMERGENCY EXIT MARKER LIGHT FORWARD OF RIGHT NUMBER ONE DOOR IS BROKEN. REPLACED THE LAMP AT EMERGENCY EXIT MARKER FORWARD OF RIGHT NUMBER ONE DOOR.SDR AALA2009013100416Light · brokenDFW - THE FORWARD CABIN PORTABLE EMERGENCY LIGHT IS INOPERATIVE. REPLACED THE LIGHT ASSEMBLY FOR THE FORWARD CABIN PORTABLE EMERGENCY LIGHT.SDR AALA2009013100415Lamp · burned outDFW - BOTTOM LAMP IN THE FORWARD SEAT EMERGENCY PATH LIGHTING AT SEAT 28D INOPERATIVE. REPLACED LAMP AT THE BOTTOM POSITION IN THE FORWARD SEAT EMERGENCY PATH LIGHTING AT SEAT 28D.SDR AALA2009013100414Lamp · burned outDFW - BOTTOM LAMP IN THE FORWARD SEAT EMERGENCY PATH LIGHTING AT SEAT 21D INOPERATIVE. REPLACED LAMP AT THE BOTTOM POSITION IN THE FORWARD SEAT EMERGENCY PATH LIGHTING AT SEAT 21D.SDR AALA2009013100413Lamp · burned outDFW - SEAT EMERGENCY PATH LIGHTING AT SEAT 13D INOPERATIVE. REPLACED LAMP AT BOTTOM POSITION IN SEAT EMERGENCY PATH LIGHTING AT SEAT 13D.SDR AALA2009013100412Light · brokenDFW - SEAT EMERGENCY PATH LIGHTING AT 10D INOPERATIVE. REPLACED LIGHT ASSEMBLY AT SEAT 10D.SDR AALA2009013100411Shroud · crackedDFW - SHROUD FOR EMERGENCY PATH LIGHTING AT SEAT 28D CRACKED. REPLACED SHROUD AT SEAT 28D.SDR AALA2009013100410Shroud · crackedDFW - SHROUD FOR EMERGENCY PATH LIGHTING AT SEAT 27D CRACKED. REPLACED SHROUD AT SEAT 27D.SDR AALA2009013100409Shroud · crackedDFW - SHROUD FOR EMERGENCY PATH LIGHTING AT SEAT 25D CRACKED. REPLACED SHROUD AT SEAT 25D.SDR AALA2009013100408Shroud · crackedDFW - SHROUD FOR EMERGENCY PATH LIGHTING AT SEAT 24D CRACKED. REPLACED SHROUD AT SEAT 24D.SDR AALA2009013100407Shroud · crackedDFW - SHROUD FOR EMERGENCY PATH LIGHTING AT SEAT 23D CRACKED. REPLACED SHROUD AT SEAT 23D.SDR AALA2009013100406Shroud · crackedDFW - SHROUD FOR EMERGENCY PATH LIGHTING AT SEAT 7D CRACKED. REPLACED SHROUD AT SEAT 7D.SDR AALA2009013100252Piston · bentDFW INFLIGHT. NOSE LANDING GEAR FAILED TO RETRACT. RED UNSAFE LIGHT ILLUMINATED. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED PISTON AND ACCOMPLISHED NOSE LANDING GEAR STRUT REPACK AND SERVICE. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA2009013100250Engine · making metalDFW INFLIGHT - CREW REPORTED NUMBER ONE ENGINE OIL CLOG INDICATION. REDUCED NUMBER ONE ENGINE TO IDLE AND RETURNED TO DFW. LANDED WITHOUT INCIDENT. FOUND METAL IN OIL FILTER. REPLACED NUMBER ONE ENGINE AT DFW ON 31 JAN 2009.SDR RYNA2009013100003Light · illuminatedFORWARD CARGO DOOR LIGHT ON AFTER TAKEOFF. FUNCTIONALLY CHECKED CARGO DOOR PROXIMITY SWITCH AS PER AMM 52-70-02. OPS CHECK NORMAL.SDR AALA20090626TUL02Battery Pack · dischargedUNSERVICEABLE BATTERY PACK MID AISLE SEAT EMERGENCY LIGHT AB5-2. REPLACED BATTERY PACK WITH BAT5016.SDR AALA2009013000402Lamp · burned outLGA - EXIT SIGN ABOVE LEFT FORWARD OVERWING DOOR INOPERATIVE. CLEANED CONTACTS AND REPLACED LAMP AT EXIT SIGN ABOVE LEFT FORWARD OVERWING.SDR AALA2009013000401Battery Pack · dischargedMSP - EMERGENCY FLOOD LIGHTS OVER CENTER AREA INOPERATIVE. REPLACED BATTERY PACK.SDR AALA2009013000248Strut · failedDFW - INFLIGHT. CREW REPORTED NOSE LANDING GEAR INDICATION. CYCLED GEAR AND RECEIVED GREEN DOWN AND LOCKED INDICATION. LANDED DFW WITHOUT INCIDENT. REPLACED NOSE LANDING GEAR SHOCK STRUT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA2009020900043Battery Pack · weakMID AISLE SEAT EMERGENCY LIGHT BATTERY PACK AB5 3 WEAK. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA2009020900042Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK AT BS 27 AT AFT RIGHT LAVATORY INOPERATIVE. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA2009012900400Battery · corrodedDFW - TAIL CONE SLIDE EMERGENCY LIGHT INOPERATIVE. CLEANED BATTERY CONTACTS AND CHARGED CELLS FOR TAIL CONE SLIDE EMERGENCY LIGHT.
Back to Mcdonnell Douglas DC-9-82