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 AALA20141123004Light · inoperativeEMERGENCY PATH LIGHTING AT ROW 18 IS INOPERATIVE. R & R LAMP IN EMER PATH LIGHT AT ROW 18 IAW AMM 33-53-00-501. SYS CHECKED GOOD.SDR AALA20141123003Light · inoperativeEMERGENCY CEILING LIGHT ROW 9 LT IS INOPERATIVE. R & R LAMP IN EMER CEILING LIGHT ROW 9 IAW MM 33-53-00-501. SYS CHECKED NORMAL.SDR AALA20141119013Windshield · crackedFOUND CRACK IN UPPER PART OF CAPTAIN`S L1 WINDSHIELD. R & R CAPTAIN`S L1 WINDSHIELD IAW AMM 56-10-02. PERFORMED OPERATIONAL CHECKS IAW AMM 31-41-00 & 31-42-00. SYS CHECKED NORMAL.SDR AALA20141119001Light · inoperativeEMERGENCY DECLARED & LANDING UNEVENTFUL. ACFT NOT OVERWEIGHT. DURING APPROACH LT MLG DOWN INDICATION LIGHT DID NOT ILLUMINATE. CREW CHANGED INDICATION LIGHT & GOT GREEN INDICATION & ACCOMPLISHED TOWER FLYBY TO CONFIRM GEAR DOWN & LOCKED. ACFT TAXIED TO GATSDR AALA20141118006Casting · crackedRIGHT WING GND SPOILER ACTUATOR CASTING IS CRACKED AT THE FWD INBD SIDE ABOVE THE ACTUATOR MOUNT BOLT. R & R CASTING IAW AARD 51-00-05-1, SRM 51-30--02-001 & EA MD80-57-037460 REV A DATED 11/20/2014.SDR AALA20141117002Portable Light · inoperativePORTABLE EMER LIGHT AT L1 DOOR IS INOPERATIVE. R & R PORTABLE EMER LIGHT. SYS CHECKED NORMAL.SDR AALA20141117001Strut · crackedVERTICAL SUPPORT STRUT AFT OF STATION 218 BULKHEAD AT LBL 30 IS CRACKED AT BOTTOM RADIUS. REPAIRED STRUT IAW SRM 53-01-00-001 FIG 2 & AARD 53-10-00-15.SDR AALA20141115006Portable Light · inoperativeFORWARD PORTABLE EMER LIGHT INOPERATIVE WHEN TESTED IAW CARD 0801. R & R L1 PORTABLE EMER LIGHT IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20141115001Battery · weakFORWARD EMER PATH LIGHTING IS WEAK WHEN TESTED IAW CARD 5403. R & R FWD EMER PATH LIGHTING BATTERY AT OVERWING AREA IAW 33-60-98. SYS CHECKED NORMAL.SDR AALA20141114001Longeron · crackedLONGERON 25 LT CRACKED AT LOWER MOUNT HOLE AT FS 160. REPAIRED LONGERON IAW SRM 53-02-00-001.SDR AALA20141114002Portable Light · inoperativePORTABLE EMER LIGHT FAILED ADJUSTMENT TEST. R & R PORTABLE EMER LIGHT. SYS CHECKED NORMAL.SDR AALA20141111006Light · inoperativeL1 DOOR EMER LIGHT DID NOT ILLUMINATE ON TEST. R & R LIGHT ASSEMBLY. SYS CHECKED NORMAL.SDR AALA20141110006Unknown · malfunctionedEMERGENCY DECLARED & LANDING UNEVENTFUL. ACFT NOT OVERWEIGHT. DURING CLIMB RECEIVED A SLAT OVERSPEED WARNING & DISAGREE LIGHT ILLUMINATED WHILE ACCELERATING THROUGH 280 KNOTS. AUTOPILOT WOULD NOT HOLD ATTITUDE. FLIGHT CONTROLS WERE VERY HEAVY WHEN AUTOPILOTSDR AALA20141111003Power Supply · inoperativeSEVERAL TAIL COMPARTMENT EMER LIGHTS INOPERATIVE. REPLACED AFT MOST MOUNTED POWER SUPPLY.SDR AALA20141111002Portable Light · inoperativePORTABLE EMER LIGHT FAILED OPERATIONAL CHECK. REPLACED PORTABLE EMER LIGHT.SDR AALA20141113016Skin · crackedFUSELAGE SKIN HAS A CRACK AT LOWER AFT CORNER OF FWD AIRSTAIR DOOR CUT OUT. REPAIRED SKIN IAW SRM 53-05-00 FIG 57A & AARD 51-60-00-02.SDR AALA20141106007Generator · failedLEFT GEN FAILED & APU UNABLE TO START. ACFT DIVERTED. SERVICED APU, STARTED OK. LT GEN WAS PLACARDED. REPLACED LT ENG GEN IAW AMM 24-20-01-401 & CONSTANT SPEED DRIVE IAW AMM 24-10-01-401. SYS CHECKED NORMAL IAW AMM 24-10-00-501 & 24-20-01-401.SDR AALA20141103002Connector · looseFOUND OVERWING EMER EXIT LIGHTS OVER ROW 21 INOPERATIVE. TIGHTENED LOOSE CONNECTION TERMINAL AT THE BATTERY PACK.SDR AALA20141102005Frame · corrodedCORROSION ON FRAME AT FUSELAGE STATION 1155 BETWEEN LONGERONS 26 & 27 RT. REMOVED CORROSION & INSTALLED REPAIR DOUBLER IAW ENGINEERING AUTHORIZATION MD80-53-037226.SDR AALA20141030010Former · crackedRIGHT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED RT WING NR 4 INBD FORMER DOUBLER & HAT BUSHING IAW WORK CARD 57-98-06.SDR AALA20141030009Former · 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.SDR AALA20141029013Rib · crackedLEFT WING NR 4 SLAT TRACK INBD SUPPORT RIB CRACKED. INSTALLED LT REPAIR DOUBLER IAW SRM 51-00 & EA MD80-57-037139.SDR AALA20141028010Support Rib · crackedRIGHT WING NR 4 SLAT TRACK INBD RIB CRACKED. ACCOMPLISHED NESTED ANGLE REPAIR IAW EA MD80-57-037132.SDR AALA20141028008Support Rib · crackedLEFT WING NR 4 SLAT TRACK INBD SUPPORT RIB CRACKED. ACCOMPLISHED NESTED ANGLE REPAIR IAW EA MD80-57-037132.SDR AALA20141027005Cusp Web · corrodedLEFT CUSP AT STATION 1169 CORRODED. REMOVED CORROSION DAMAGE & INSTALLED DOUBLER REPAIR IAW AARD 53-20-00-16.SDR AALA20141027004Support Angle · crackedSUBFLOOR SUPPORT ANGLE CRACKED AT STATION 185 & RBL 26, BOTTOM SIDE OF SUBFLOOR. REMOVED CRACKED ANGLE & INSTALLED NEW SERVICEABLE FABRICATED ANGLE IAW SRMS 51-00-00-1, 51-10-09 & DWG 9936534.SDR AALA20141027003Seat Track · corrodedCORROSION ON NR 1 SEAT TRACK FROM STATIONS 1174 TO 1309. REPLACED NR 1 SEAT TRACK IAW SRM 53-05-00.SDR AALA20141027002Seat Track · corrodedCORROSION ON NR 2 SEAT TRACK FROM STATIONS 1153 TO 1193. ACCOMPLISHED SEAT TRACK SPLICE FROM 1153 TO 1193 IAW SRM 53-05-00.SDR AALA20141025004Pan · crackedAFT ENTRY DOOR WEB 5917579-239 & PAN CRACKED. REPAIRED WITH NESTED ANGLE DOUBLERS ON PAN & DOUBLER ON WEB.SDR AALA20141025003Support · crackedDOOR STOP SUPPORT CASTING CRACKED. REPLACED SUPPORT.SDR AALA20141025001Light · inoperativeAFT STAIRWAY EMER EXIT SIGN INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR AFT STAIRWAY EMER EXIT SIGN. OPERATIONS CHECKED NORMAL.SDR AALA20141024012Skin · dentedDENTS IN SKIN AT STATION 1354 BETWEEN LONGERONS 8 TO 9 LT. INSTALLED DOUBLER IAW SRM 53-01-00 FIGURE 2 SHEET 3.SDR AALA20141024011Cusp Web · corrodedCORROSION ON CUSP SHEET FROM STATIONS 1250 TO 1309. REPLACED LT CUSP SHEET IAW AARD 53-20-00-16.SDR AALA20141024001Seat Track · corrodedNUMBER 6 SEAT TRACK CORRODED FROM STATIONS 216 TO 302. REPLACED NR 6 SEAT TRACK IAW SRM 53-05-00.SDR AALA20141024015Frame · crackedCANTED FRAME 1485 CRACKED AT THE AFT AIRSTAIR MOUNT RT SIDE. ACCOMPLISHED REPAIR SPLICE IAW AARD 53-10-0033.SDR AALA20141024003Former · crackedRIGHT WING LE NR 4 SLAT TRACK LE INBD FORMER IS CRACKED. INSTALLED RT WING NR 4 SLAT TRACK LE INBD FORMER DOUBLER & HAT BUSHING IAW WORK CARD 57-98-06 & EA MD80-57-037112.SDR AALA20141024002Former · crackedLEFT WING LE NR 4 SLAT TRACK LE INBD FORMER IS CRACKED. INSTALLED LT WING NR 4 SLAT TRACK LE INBD FORMER DOUBLER & HAT BUSHING IAW WORK CARD 57-98-05 & EA MD80-57-037112.SDR AALA20141023015Cargo Track · corrodedCORROSION ON RT TIE DOWN TRACK FROM STATIONS 1220 TO 1322 AFT CARGO. R & R TRACK.SDR AALA20141023014Cusp Web · crackedRIGHT CUSP CRACKED AT STATION 247. INSTALLED DOUBLER.SDR AALA20141023013Seat Track · corrodedRIGHT SEAT TRACK FROM STATIONS 324 TO 326 CORRODED. INSTALLED PLUG REPAIR IAW SRM 53-05-00-001 & 53-20-00-10.SDR AALA20141023010Battery Pack · dischargedEGRESS POWER SUPPLY, AB4-5 FAILED TEST. REPLACED BATTERY PACK. OPERATIONS CHECKED NORMAL.SDR AALA20141022018Web · wornAFT ACCESSORY TEMPERATURE CONTROL VLV HAS WORN INTO WEB ON FRAME 1380 LT SIDE BELOW LONGERON 4 LT. INSTALLED DOUBLER IAW 53-10-00-28.SDR AALA20141022010Seat Track · corrodedSEAT TRACK NR 2 CORRODED AT STATION 764. REPLACED SEAT TRACK SECTION FROM STATIONS 668 TO 793.SDR AALA20141022003Angle · crackedCRACKED LT ANGLE INSIDE & BELOW RAM AIR INTAKE 5912188-49. R & R ANGLE 5912188-49.SDR AALA20141021007Intercostal · crackedCRACK IN LT TIE-DOWN TRACK INTERCOSTAL BETWEEN FUSELAGE STATIONS 1322 & 1309. R & R INTERCOSTAL.SDR AALA20141020002Cusp Web · corrodedCORROSION ON LT CUSP BETWEEN FUSELAGE STATIONS 218 & 237. REPAIRED CUSP IAW AARD 53-20-00-16.SDR AALA20141020001Cusp Web · corrodedCORROSION ON RT CUSP BETWEEN FUSELAGE STATIONS 807 & 845. R & R RT CUSP IAW AARD 51-00-05-1.SDR AALA20141019012Generator · malfunctionedRIGHT ENG GEN OIL TEMP HIGH WITH APU ON PLACARD. FLIGHT DIVERTED & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED RT ENG GEN & CONSTANT SPEED DRIVE. SYS GND CHECKED NORMAL, OPERATION CLOSED.SDR AALA20141017014Structure · damagedTEMPORARY DOUBLER INSTALLED AT STATION 1309 & LONGERON 7 LT. INSTALLED CLASS 1 PERMANENT REPAIR DOUBLER IAW SRM 55-04-02 FIGURE 2 SHEET 29.SDR AALA20141016012Unknown · malfunctionedGEAR WOULD NOT RETRACT WHEN THE HANDLE WAS PLACED IN UP POSITION. EMER DECLARED FLIGHT RETURNED & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. ACCOMPLISHED SEVERAL CYCLES OF LG EXTENSION & RETRACTION WITH NO FAULTS NOTED. SYS GND CHECKED NORMAL, OPE
Back to Mcdonnell Douglas DC-9-82