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 AALA2009021600127Pan · crackedRIGHT WINDOW PAN AT STATION 1193 UPPER CORNER CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA2009021600125Pan · crackedRIGHT WINDOW PAN AT STATION 1212 CRACKED UPPER CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA2009012300019Fitting · crackedGROUND SPOILER ACTUATOR FITTING CRACKED INBOARD SIDE. NEW 8130 SPOILER CASTING INSTALLED PER SRM 57-00 AND SRM 51-30-00.SDR AALA2009012100330Battery Pack · disconnectedLGA - LIGHTS IN EMERGENCY EXIT SIGN AT AFT STAIRS INOPERATIVE. CLEANED AND RECONNECTED BATTERY PACK.SDR AALA2009012100329Contact · corrodedLGA - EMERGENCY LIGHTS IN CEILING FROM ROWS 27 THRU 30 INOPERATIVE. CLEANED CONTACTS ON BATTERY PACK FOR ROWS 27 THRU 30.SDR AALA2009012100328Battery Pack · disconnectedLGA - LIGHTS IN EMERGENCY SIGN AT AFT OVERWING DOORS INOPERATIVE. RECONNECTED BATTERY PACK AT AFT OVERWING DOOR.SDR AALA2009012100324Battery Pack · disconnectedLGA - LIGHTS IN EMERGENCY SIGN AT AFT STAIRS INOPERATIVE. RECONNECTED BATTERY PACK AT AFT STAIRS.SDR AALA2009012100323Battery Pack · disconnectedLGA - EMERGENCY EXIT SIGN INOPERATIVE. RECONNECTED BATTERY PACK IN EXIT SIGN.SDR AALA2009012100322Battery Pack · disconnectedLGA - LIGHTS IN EMERGENCY SIGNS AT AFT OVERWING INOPERATIVE. RECONNECTED BATTERY PACK AT AFT OVERWING.SDR AALA20090513TUL16Frame · crackedCANT FRAME CRACKED AT TAILCONE ALIGNMENT PIN, 9:00 POSITION. INSTALLED REPAIR DOUBLER PER SRM 53-01-00.SDR AALA2009012300018Battery Pack · inoperativeEMERGENCY LIGHTING BATTERY PACK B5-N6 INOPERATIVE WHILE TESTING PER CARD 4289. REMOVED UNSERVICEABLE BATTERY PACK, INSTALLED NEW BATTERY PACK BAT5014 PER MM 33-53-00-6 AND CARD 4285.SDR AALA2009012300017Battery · weakFLOOR PROXIMITY EMERGENCY LIGHT PACK AB5-3 WEAK DURING TESTING PER CARD 4289. INSTALLED A SERVICEABLE BATTERY PER CARD 4289 AND MM 33-60-98-4.SDR AALA2009012000320Battery Pack · dischargedLGA - FIRST CLASS EXIT LIGHTS TO ROW 20 INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS EXIT LIGHTS TO ROW 20.SDR AALA2009012000312Connector · unsecureLGA- LEFT EMERGENCY LIGHT AT ROW 19 INOPERATIVE. SECURED CONNECTOR FOR LEFT EMERGENCY LIGHT AT ROW 19SDR AALA2009012200012Longeron · cracked1 INCH CRACK ON FORWARD AND AFT SIDE STATION 1418 LONGERON 2R. INSTALLED REPAIR PER ESO 80559 DATED 01/19/09.SDR AALA200910604Fitting · crackedAFT CARGO DOOR JAMB, FORWARD LOWER STOP PAD FITTING CRACKED. INSTALLED A SERVICEABLE STOP PAD FITTING PER ESO 80174.SDR AALA200910603Support Fitting · crackedFORWARD CARGO DOOR JAMB, SECOND FROM TOP FORWARD DOOR STOP PAD SUPPORT FITTING CRACKED. INSTALLED A SERVICEABLE STOP FITTING PER ESO 80174.SDR AALA200910602Fitting · crackedFORWARD CARGO DOOR JAMB, FORWARD TOP DOOR STOP PAD SUPPORT FITTING CRACKED. INSTALLED A SERVICEABLE STOP FITTING PER ESO 80174.SDR AALA2009011800304Battery Pack · dischargedLGA- AFT OVERWING EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT AFT OVERWING EXIT.SDR AALA2009011800303Battery Pack · dischargedLGA- FIRST CLASS OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN FIRST CLASS.SDR AALA2009011800302Battery Pack · dischargedLGA- EMERGENCY LIGHTS FROM ROW 3 THRU 19 INOPERATIVE. REPLACED BATTERY PACK FOR ROWS 3 THRU 19.SDR AALA2008011700167Transfer Pump · failedBNA INFLIGHT DCA TO DFW - CREW REPORTED LEFT HYDRAULIC SYSTEM QUANTITY LOSS AND RIGHT ENGINE DRIVEN PUMP MAKING NOISE. LANDED BNA WITHOUT INCIDENT. FOUND NUMBER ONE ENGINE HYDRAULIC PUMP FAILED. REPLACED NUMBER ONE ENGINE HYDRAULIC PUMP AND LEFT HYDRAULIC SSDR AALA200910607Skin · crackedSKIN CRACKED AT FASTENERS IN STATION 1380 BETWEEN LONGERONS 14R AND 13R. INSTALLED REPAIR PER AARD 53-30-00-02.SDR AALA2009011600321Battery Pack · dischargedLGA - AFT EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT AFT EXIT.SDR AALA2009011600301Battery Pack · dischargedLGA- FIRST CLASS EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS EMERGENCY LIGHTS.SDR AALA2009011600300Battery Pack · dischargedLGA- FIRST CLASS EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS EMERGENCY LIGHTS.SDR AALA2009011600299Battery Pack · dischargedLGA- CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACE BATTERY PACK FOR CEILING EMERGENCY LIGHTS.SDR AALA200910557Doubler · corrodedDOUBLER CORRODED AT STATION 1338 BETWEEN LONGERONS 28 RIGHT AND 28 LEFT. INSTALLED A SERVICEABLE DOUBLER.SDR AALA2009021600110Shear Tie · crackedSHEAR TIE CRACKED IN AFT ACCESSORY COMPARTMENT BETWEEN STRINGER 1 RIGHT AND STRINGER 2 RIGHT AT STATION 1437. INSTALLED NEW SHEAR TIE PER SRM 51-30.SDR AALA2009021300109Frame · crackedCANT FRAME 1463 WEB CRACKED 2 INCHES AT RIGHT SIDE ABOVE ACCUMULATOR LONGERON 17 TO 18 RIGHT. STOP DRILLED CRACK AND INSTALLED DOUBLER PER AARD 53-00-00-09 AND SRM 53-01-00 FIGURE 162.SDR AALA200910605Shear Tie · crackedSHEAR TIE CRACKED AT STATION 1451 FRAME AT LONGERON 2 RIGHT. INSTALLED A SERVICEABLE SHEAR TIE PER SRM 53-01.SDR AALA200910600Angle · cracked"J" ANGLE DOUBLER CRACKED LEFT SIDE OF FORWARD DOOR JAMB. REMOVED AND REPLACED DOUBLER PER AARD 53-10-00-4.SDR AALA200910585Longeron · corrodedLONGERON 2 LEFT AT STATION 1418 CORRODED. INSTALLED A SERVICEABLE LONGERON PER AARD 53-30-00-2.SDR AALA200910584Casting · crackedLEFT SPOILER CASTING CRACKED ON LEFT WING. REMOVED AND INSTALLED A SERVICEABLE CASTING.SDR AALA200910583Doubler · crackedRIGHT FORWARD DOOR JAMB DOUBLER CRACKED. REMOVED AND REPLACED DOUBLER PER AARD 53-10-00-4.SDR AALA2009011300292Battery Pack · dischargedDFW- COCKPIT EMERGENCY LIGHTS STAYS ON WITH POWER OFF. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN COCKPIT.SDR AALA2009021300108Intercostal · crackedINTERCOSTAL IS CRACKED AT RIGHT CANT FRAME AT STATION 1485 AT AFT ARC. INSTALLED NEW INTERCOSTAL AT RIGHT CANT FRAME 1485 PER SRM 53-01.SDR AALA200910579Casting · corrodedCORROSION ON DOOR JAMB,FORWARD LOWER CASTING. REPLACED WITH NEW CASTING.SDR AALA2009011200287Battery Pack · dischargedLGA- TAIL CONE EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK ON TAIL CONE.SDR AALA2009021300101Beam · corrodedCORROSION ON DOOR BEAM IN MID CARGO AT STATION 636 TO 693. INSTALLED DOUBLER PER AARD 53-10-00-3.SDR AALA2009021300100Lug · corrodedNUMBER 8 RIGHT OUTBOARD HORIZONTAL STABILIZER PLATE LUG BORE CORRODED AND OUT OF LIMITS. INSTALLED SERVICEABLE NUMBER 8 LUG PLATE PER CARD NR 2988AA.SDR AALA2009020900056Plate · corrodedNUMBER SEVEN LUG PLATE BORE RIGHT OUTBOARD IS CORRODED AND OUT OF LIMITS (HORIZONTAL STABILIZER). INSTALLED NEW SERVICEABLE NUMBER SEVEN LUG PLATE PER CARD K2988AA.SDR AALA2009020900055Plate · corrodedNUMBER SIX PLATE LUG BORE CORRODED AND OUT OF LIMITS. INSTALLED SERVICEABLE NUMBER SIX LUG PLATE PER CARD K2988AA.SDR AALA2009020900054Plate · corrodedNUMBER FIVE PLATE LUG BORE CORRODED AND OUT OF LIMITS. INSTALLED SERVICEABLE NUMBER FIVE LUG PLATE IN ACCORDANCE WITH WORK CARD K2988AA.SDR AALA2009020900053Lug · corrodedNUMBER FOUR PLATE LUG BORE AT LEFT INBOARD CORRODED AND OUT OF LIMITS. INSTALLED SERVICEABLE NUMBER FOUR LEFT INBOARD LUG BORE PLATE IN ACCORDANCE WITH WORK CARD K2988AA.SDR AALA2009020900052Lug · corrodedNR 3 LEFT INBOARD LUG PLATE BORE CORRODED (TAIL HORIZONTAL STABILIZER) AND OUT OF LIMITS. INSTALLED SERVICEABLE NR 3 LEFT INBOARD LUG PLATE IN ACCORDANCE WITH WORK CARD K2988AA.SDR AALA2009020900051Lug · corrodedNR 2 PLATE LUG LEFT OUTBOARD (TAIL HORIZONTAL STABILIZER) CORRODED AND OUT OF LIMITS. INSTALLED SERVICEABLE NR 2 LEFT OUTBOARD LUG PLATE IN ACCORDANCE WITH WORK CARD K2988AA.SDR AALA2009020900050Lug · corrodedNUMBER ONE PLATE LUG BORE CORRODED AND OUT OF LIMITS. LT OUTBOARD (TAIL HORIZONTAL STABILIZER). INSTALLED SERVICEABLE NR 1 PLATE LUG IN ACCORDANCE WITH WORK CARD K2988AA.SDR AALA200910590Frame · cracked1510 CANT FRAME CRACKED AT RIGHT LOWER TAIL CONE ALIGNMENT PIN. INSTALLED REPAIR PER ESO 80559 DATED 01/12/09.SDR AALA200910589Frame · crackedSTATION 1510 CANT FRAME CRACKED AT TAIL CONE ALIGNMENT PIN, JUST ABOVE RIGHT LOWER TAIL CONE LATCH. INSTALLED REPAIR PER ESO 80559 DATED 01/12/09.
Back to Mcdonnell Douglas DC-9-82