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 AALA20150226010Cusp Web · corrodedCARGO MID CX CORROSION ON BOTTOM OF CUSP BETWEEN STATIONS 563 & 565 AT LONGERON 18 RT. INSTALLED DOUBLER IAW AARD 53-20-00-16.SDR AALA20150226030Compressor · stalledAIR INTERRUPT, EMER DECLARED, LANDING UNEVENTFUL & ACFT WAS NOT OVERWEIGHT. RT ENG COMPRESSOR STALL & SHUT DOWN AT 3000 FEET & ACFT RETURNED. R & R RT ENG. FOUND LIBERATED NOSE BULLET & EXTENSIVE DAMAGE TO IGV CASE.SDR AALA20150226019Fuel Filter · faultyDURING TAKEOFF NR 1 ENG FUEL FILTER INLET PRESS LOW LIGHT ILLUMINATED. TAKEOFF ABORTED AT 40 KNOTS. R & R NR 1 ENG FUEL FILTER. PERFORMED LEAK CHECK IAW AMM 73-12-01-201. SYS CHECKED NORMAL.SDR AALA20150226007Battery Pack · dischargedDURING INSPECTION, DISCOVERED EXTERIOR OVERWING EMER LIGHTS INOPERATIVE. REPLACED EMER LIGHT BATTERY PACK IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20150226005Battery Pack · dischargedTAIL CONE EMER LIGHTS WEAK. REPLACED TAIL CONE EMER LIGHT BATTERY PACK IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20150226004Battery Pack · dischargedOVERHEAD EMER LIGHTS AT ROWS 23 - 28 WEAK. REPLACED BATTERY PACK FOR OVERHEAD EMER LIGHTS IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20150226003Battery Pack · dischargedOVERHEAD EMER LIGHTS AT ROWS 28 - 32 WILL NOT TEST. REPLACED BATTERY PACK FOR EMER LIGHTS ON OVERHEAD IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20150226002Battery Pack · dischargedFORWARD EMER EXIT LIGHTS WON’T TEST. REPLACED BATTERY PACK FOR FWD EMER EXIT LIGHTS IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20150226001Battery Pack · dischargedEXTERIOR OVERWING EMER LIGHTS WOULD NOT TEST. REPLACED EXTERIOR OVERWING EMER LIGHT BATTERY PACK IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20150225009Seat Track · corrodedNUMBER 6 SEAT TRACK CORRODED BETWEEN FS 216 & 797. R & R SEAT TRACK & SPLICE IAW SRM 53-05-00-001 FIG 4F.SDR AALA20150225007Longeron · crackedLONGERON 25 LT IS CRACKED AT FS 200 & 160. R & R LONGERON SECTION IAW SRM 53-02-00.SDR AALA20150225006Cusp Web · crackedLEFT CUSP CRACKED AT FS 226 OTBD OF SEAT TRACK NR 1. R & R CUSP SHEET IAW AARD 53-20-00-16.SDR AALA20150225005Longeron · crackedLONGERON 24 LT CRACKED AT FS 200. R & R LONGERON SECTION IAW SRM 53-02-00.SDR AALA20150225004Longeron · crackedLONGERON 23 LT IS CRACKED AT FS 200. R & R LONGERON SECTION IAW SRM 53-02-00.SDR AALA20150226014Battery Pack · dischargedEMERGENCY LIGHT WILL NOT TEST. R & R BATTERY PACK IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20150226013Battery Pack · dischargedEMERGENCY PORTABLE BATTERY PACK LIGHT INOPERATIVE, WILL NOT TEST. REPLACED EMER PORTABLE BATTERY PACK LIGHT ASSEMBLY IAW AMM 33-53-00.SDR AALA20150226009Battery Pack · dischargedEMERGENCY EXIT LIGHTS AT SEATS 24 A - F INOPERATIVE. R & R BATTERY PACK FOR AFT OVERWING EMER EXIT SIGNS IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20150311011Connector · disconnectedTAIL COMPARTMENT STAIRS SIDEWALL AFT LIGHT INOPERATIVE. FOUND CONNECTOR OFF, RE-CONNECTED IAW SP. PERFORMED OPERATIONAL CHECK IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20150311010Connector · disconnectedTAIL COMPARTMENT OVERHEAD LIGHTS INOPERATIVE. FOUND CONNECTOR OFF, RECONNNECTED IAW SP. PERFORMED OPERATIONAL CHECK IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20150224020Indicator · faultyDURING TAKEOFF NR 1 ENG EPR STUCK AT 1.4. TAKEOFF WAS ABORTED AT UNDER 50 KNOTS. ALL OTHER INDICATIONS UNRESPONSIVE. R & R NR 1 ENG EPR INDICATOR IAW AMM 77-11-01 & NR 1 ENG EPR TRANSMITTER IAW MM 77-11-02. CHECKED DRAIN TRAPS FOR MOISTURE. SYS CHECKED NOSDR AALA20150224005Pan · corrodedFORWARD CARGO DOOR SILL PAN CORRODED BETWEEN FS 397 & 399 AT LONGERON 28 RT. REPAIRED IAW EA 53-038696 DATED 2-20-15.SDR AALA20150224004Floor Support · crackedFLOOR SUPPORT UNDER SEAT TRACK 3 IS CRACKED AT FS 864. R & R FLOOR SUPPORT IAW AARD 51-00-05-1.SDR AALA20150225001Module · inoperativeFORWARD CABIN SEAT MOUNTED ESCAPE PATH LIGHTS STAYED ON AFTER TEST. REPLACED POWER SUPPLY MODULE & BATTERY. SYS CHECKED NORMAL.SDR AALA20150224002Battery Pack · dischargedOVERHEAD EMER LIGHTS AT ROWS 29 - 32 WON’T TEST. R & R EMER LIGHT BATTERY PACK FOR ROWS 29 - 32. PERFORMED OPERATIONAL CHECK IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20150224001Battery Pack · dischargedEMERGENCY LIGHTS OVER TAIL CONE WON’T TEST. R & R EMER LIGHT BATTERY PACK FOR TAIL CONE. PERFORMED OPERATIONAL CHECK IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20150223015Indicator · faultyAIR INTERRUPT, DIVERTED & AN EMER NOT DECLARED. LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CRUISE THE STANDBY ATTITUDE INDICATOR FAILED & RED FLAG CAME INTO VIEW. R & R THE STANDBY HORIZON INDICATOR IAW AMM 34-28-01 & INVERTER IAW AMM 34-28-02. SYS CSDR AALA20150223014Cusp Web · crackedRIGHT CUSP SHEET CRACKED AT LIGHTNING HOLE AT FS 282. REPAIRED IAW AARD 53-20-00-16.SDR AALA20150223013Intercostal · crackedINTERCOSTAL WEB CRACKED AT FS 206 & LONGERON 11 LT. REPAIRED WEB IAW AARD 53-10-00-11.SDR AALA20150223012Structure · puncturedAPU ENCLOSURE HAS PUNCTURE DAMAGE ON AFT RT INTERIOR SIDE BETWEEN FS 1338 - 1380. REPAIRED IAW AARD 53-20-00-11 FIG 1 REPAIR 11.SDR AALA20150221004Former · crackedLEFT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED LT WING NR 4 SLAT INBD FORMER REPAIR DOUBLER & HAT BUSHING IAW WORK CARD 57-98-05.SDR AALA20150221003Former · crackedRIGHT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED RT WING NR 4 INBD FORMER REPAIR DOUBLER & HAT BUSHING IAW WORK CARD 57-98-06.SDR AALA20150224021Frame · corrodedCORROSION ON BOTTOM AFT LIP OF FRAME AT FS 1271 BETWEEN LONGERON 29 RT & 29 LT. R & R LOWER J COMPLETE IAW AARD 51-10-00-01.SDR AALA20150223011Gcu · faultyAIR INTERRUPT, NO EMER DECLARED & LANDING UNEVENTFUL. ACFT WAS NOT OVERWEIGHT. RT ENG RATIO WENT TO ZERO ON ROTATION. THEN AT 300 - 400 FEET ALTITUDE, BOTH DIGITAL FLIGHT GUIDANCE SYS WERE LOST WITH CB`S POPPING. R & R RT ENG CSD & GEN IAW AMM 24-10-01. REPSDR AALA20150219013Generator · faultyAIR INTERRUPT, NO EMER DECLARED & LANDING UNEVENTFUL. ACFT WAS NOT OVERWEIGHT. RT ENG PRESS RATIO WENT TO ZERO ON ROTATION. THEN AT 300 - 400 FEET ALTITUDE, BOTH DIGITAL FLIGHT GUIDANCE SYS WERE LOST WITH CB`S POPPING. R & R RT ENG CSD & GEN IAW AMM 24-10-SDR AALA20150218015Pseu · faultyREJECTED TAKEOFF, CREW RECEIVED FLAP 1 SLAT AURAL WARNING AT 130 KNOTS ON TAKEOFF. REPLACED PROX SWITCH ELECTRONIC UNIT IAW AMM 32-60-04. SYS CHECKED NORMAL.SDR AALA20150227006Pan · crackedRIGHT FWD UPPER CORNER WINDOW RING PAN CRACKED AT FS 927. REPAIRED IAW AARD 53-10-00-25.SDR 2WAA20150217001Wing · handler errorDE-ICING TRUCK HIT LT WING TIP DURING DE-ICING. REMOVED LT WING TIP EXTENSION T/E PANEL IAW MM 57-20-02. CLEANED AND INSPECTED AREA FOR DAMAGES IAW WO 2701, ITEM NR 2. REPLACED DAMAGED LT WING TIP EXTENSION PANEL IAW MM 57-20-02. PERFORMED INTERIM REPAIR ASDR AALA20150227004Pan · crackedCRACK IN LT SIDE WINDOW PAN FWD UPPER CORNER. DAMAGE REMOVED & DOUBLER INSTALLED IAW AARD 51-10-00-25.SDR AALA20150218002Battery Pack · dischargedEMERGENCY LIGHTS CONTROLLED BY BATTERY B5-101, INOPERATIVE ON TEST. REPLACED BATTERY PACK B5-105. SYS CHECKED NORMAL.SDR AALA20150217021Rib · crackedRIGHT WING NR 4 SLAT TRACK LE INBD SUPPORT RIB CRACKED. INSTALLED REPAIR DOUBLER IAW EA 57-038624 DATED 16 FEB 2015.SDR AALA20150217020Rib · crackedLEFT WING NR 4 SLAT TRACK LE INBD SUPPORT RIB CRACKED. INSTALLED REPAIR DOUBLER IAW EA MD80-57-038624 DATED 16 FEB 2015.SDR AALA20150212014Cable · defectiveL1 DOOR SLIDE CABLE SLIDE IS UNWRAPPING. REPLACED DOOR SLIDE IAW AAMM 25-62-00.SDR AALA20150212013Window Frame · damagedL1 DOOR OBSERVATION WINDOW FROSTED OR FROZEN OVER. R & R INNER PANE, INNER SEAL, OUTER PANE & OUTER SEAL IAW AMM 56-30-00 AT L1 DOOR. SEE SDRS AALA20150212010, AALA20150212011 & AALA20150212012 FOR ADDITIONAL PART NUMBERS.SDR AALA20150212012Seal · damagedL1 DOOR OBSERVATION WINDOW FROSTED OR FROZEN OVER. R & R INNER PANE, INNER SEAL, OUTER PANE & OUTER SEAL IAW AMM 56-30-00 AT L1 DOOR. SEE SDRS AALA20150212010, AALA20150212011 & AALA20150212013 FOR ADDITIONAL PART NUMBERS.SDR AALA20150212011Window Frame · damagedL1 DOOR OBSERVATION WINDOW FROSTED OR FROZEN OVER. R & R INNER PANE, INNER SEAL, OUTER PANE & OUTER SEAL IAW AMM 56-30-00 AT L1 DOOR. SEE SDRS AALA20150212010, AALA20150212012 & AALA20150212013 FOR ADDITIONAL PART NUMBERS.SDR AALA20150212010Seal · damagedL1 DOOR OBSERVATION WINDOW FROSTED OR FROZEN OVER. R & R INNER PANE, INNER SEAL, OUTER PANE & OUTER SEAL IAW AMM 56-30-00 AT L1 DOOR. SEE SDRS AALA20150212011, AALA20150212012 & AALA20150212013 FOR ADDITIONAL PART NUMBERS.SDR AALA20150211004Longeron · crackedCRACK ON LONGERON AT BS 200, 23 LT. REPAIRED LONGERON IAW SRM 53-02-00.SDR AALA20150211003Longeron · crackedCRACK ON LONGERON AT BS 200, STRINGER 24 LT. REPAIRED LONGERON IAW SRM 53-02-00 FIGURE 18.SDR AALA20150209015Casting · crackedMID CARGO COMPARTMENT FWD CTR DOOR STOP CASTING IS CRACKED. R & R CASTING IAW AARD 51-00-05-1 & DWG 5910141.SDR AALA20150209010Former · crackedLEFT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED LT WING NR 4 SLAT INBD FORMER DOUBLER & HAT BUSHING IAW WORK CARD 57-98-05.
Back to Mcdonnell Douglas DC-9-82