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 AALA20101005TUL05Frame · crackedFRAME CRACKED AFT OF STATION 1418 AT LONGERON 2 LEFT. INSTALLED DOUBLER PER AARD 53-03-00 FIGURE 31A.SDR AALA20100930TUL14Pan · crackedWINDOW RINGPAN CRACKED TAB AT LOWER FORWARD CORNER STATION 1250. REMOVED DAMAGED TAB AND INSTALLED DOUBLER PER AARD 53-20-00-25.SDR AALA20100930TUL13Pan · crackedWINDOW RINGPAN CRACKED AT UPPER FORWARD TAB STATION 946. REMOVED DAMAGED AREA AND INSTALLED DOUBLER PER AARD 53-20-00-25.SDR AALA20100930TUL12Pan · crackedWINDOW RINGPAN CRACKED AT LOWER FORWARD TAB. TRIMMED OFF CRACKED TAB AND INSTALLED DOUBLER REPAIR PER AARD 53-10-00-25.SDR AALA20100930TUL02Attach Bracket · crackedNUMBER 5 SLAT 2ND FROM OUTBOARD TRACK ATTACH BRACKET IS CRACKED. REPLACED CRACKED TRACK ATTACH BRACKET 2ND FROM OUTBOARD PER ESO 80117.SDR AALA20100930TUL01Attach Bracket · crackedNUMBER 5 SLAT OUTBOARD MOST SLAT ATTACH BRACKET IS CRACKED. REPLACED CRACKED SLAT ATTACH BRACKET OUTBOARD MOST POSITION PER ESO 8011.SDR AALA20100929TUL19Tab · crackedLEFT BETWEEN STATIONS 1003 TO 1022 UPPER AFT WINDOW CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100929TUL18Tab · crackedLEFT BETWEEN STATIONS 984 TO 1003 UPPER AFT WINDOW TAB CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100929TUL16Pan · crackedLEFT BETWEEN STATIONS 750 TO 731 BOTTOM AFT WINDOW TAB CRACKED. CUT OUT CRACKED AREA OF RINGPAN AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100929TUL15Pan · crackedLEFT BETWEEN STATIONS 1250 TO 1231 LOWER AFT WINDOW TAB CRACKED. CUT OUT CRACKED AREA OF RINGPAN AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100929TUL14Tab · crackedLEFT BETWEEN STATIONS 1212 TO 1231 LOWER FORWARD WINDOW TAB CRACKED. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100929TUL13Tab · crackedLEFT BETWEEN STATIONS 1212 TO 1231 AFT UPPER WINDOW TAB CRACKED. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100929TUL12Frame · crackedFRAME 1451 IS CRACKED ON FORWARD SIDE NEXT TO LONGERON 3 LEFT. INSTALLED REPAIR PER EA MD80-53-013194 AND SRM 51-70-05 FIGURE 1 ON FRAME 1451 FORWARD SIDE NEXT TO LONGERON 3 LEFT SIDE.SDR AALA20100929TUL11Skin · damagedFUSELAGE - TEMPORARY DOUBLER REPAIR, UPPER AFT LEFT SIDE OF FUSELAGE SKIN, JUST AFT OF LEFT LOUVER BOX. REMOVED TEMPORARY AND INSTALLED PERMANENT REPAIR DOUBLER PER EA MD80-53-013210 AND SRM 53-01-00. REMOVED AND REPLACED INTERCOSTAL DUE TO TOOLING MARKS BEHSDR AALA20100929TUL07Pan · crackedRIGHT BETWEEN STATIONS 1060 TO 1079 UPPER AFT WINDOW TAB CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100929TUL06Window Frame · crackedRIGHT WINDOW FRAME HAS CRACK AT STATION 1136 FORWARD LOWER CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100929TUL04Pan · crackedRIGHT BETWEEN STATIONS 1041 TO 1060 BOTTOM AFT WINDOW TAB CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100928DFW01Actuator · failedDFW - CREW REPORTED AIRCRAFT LOST BOTH CONTROLLERS IN AUTO AND MANUAL. EMERGENCY DECLARED RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED OUTFLOW VALVE ACTUATOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20100928TUL11Web · crackedAFT ACCESSORY WEB CRACKED LEFT OF RUDDER PACK AT 1485 CANT FRAME. INSTALLED DOUBLER PER AARD 53-10-00-32.SDR AALA20100928TUL06Frame · crackedTHERE IS A 5/16 INCH CRACK ON THE RIGHT BOTTOM OF FRAME 1497 AT RUDDER ACTUATOR INTERCOSTAL. INTERIM REPAIR ACCOMPLISHED PER ESO 80559 DATED 30JAN08. REINSPECT AT NEXT LIGHT C CHECK TO ENSURE NO CRACK PROPAGATION. INSTALLED PERMANENT REPAIR PER EA MD80-53-0SDR AALA20100928TUL05Longeron · crackedLONGERON 2 RIGHT AT 1418 CRACKED. ACCOMPLISHED LONGERON REPAIR PER AARD 53-30-00-2 AND EA MD80-53-013235.SDR AALA20100928TUL04Splice · damagedCORROSION ON TIE-DOWN TRACK SPLICE LEFT HAND SIDE AT STATION 1220. INSTALLED NEW TIE-DOWN SPLICE AT STATION 1220 PER SRM 51-30-05.SDR AALA20100928TUL03Frame · crackedFRAME 1418 IS CRACKED NEXT TO RADIUS BLOCK ON FORWARD SIDE OF FRAME AT LONGERON RIGHT. INSTALLED REPAIR DOUBLER PER SRM 53-03-00 FIGURE 31A.SDR AALA20100928TUL02Splice · damagedCUSP T UPPER SPLICE ANGLE AT LEFT SIDE APPROXIMATE STATION 1088. HOLES DON"T LINE UP DUE TO DOUBLER IN SAME AREA. INSTALLED NEW CUSP T SPLICE PER SRM 51-01-00, SRM 51-30-05 AND EA MD80-51-013081.SDR AALA20100928LGA01Battery Pack · dischargedEMERGENCY LIGHTS IN CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN CABIN. OPS CHECK NORMAL.SDR AALA20100927TUL06Tee Fitting · damagedCORROSION IN FRAME FOOT FORWARD SIDE OF STATION 200 JUST AFT OF FORWARD SERVICE DOOR CUTOUT (MARKED). INSTALLED CUSP TEE AT STATION 200 PER SRM 51-30-0 SATISFY THE DISCREPANCY PER SRM 51-30-05 AND ATTACHED EA MD80-51-013081.SDR AALA20100927TUL05Track · corrodedHEAVY CARGO/AFT - CORROSION ON TIE DOWN TRACK RIGHT SIDE STATIONS 1007 TO 1155. REMOVED AND REPLACED TRACK PER SRM 51-30-01.SDR AALA20100927TUL01Cargo Track · corrodedAFT CARGO CORROSION ON LEFT TIE DOWN TRACK EARS STATIONS 1225 TO 1250. MKD - INSTALLED NEW LEFT AFT TIE DOWN TRACK STATIONS 1220 TO 1322 PER SRM 51-30-01.SDR AALA20100926TUL04Cargo Track · corrodedAFT CARGO CORROSION ON TIE DOWN TRACK LEFT SIDE STATIONS 1007 TO 1220. REMOVED AND REPLACED TRACK PER SRM 51-30-01.SDR AALA20100926TUL03Membrane · corrodedCORROSION ON SUBFLOOR AT G-2 AFT INBOARD MOUNT STATION 218. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100926TUL02Mount Fitting · corrodedCORROSION ON G-2 AFT INBOARD MOUNT FITTING. REPLACED MOUNT FITTING PER SRM 51-30-05.SDR AALA20100926TUL01Cusp Web · crackedLEFT CUSP CRACKED AT STATION 1086. ROUTED OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100925DFW01Anti-Skid Valve · faultyDFW - DURING ANTI-SKID TEST PRIOR TO LANDING RECEIVED LEFT AND RIGHT INBOARD AND OUTBOARD ANTI-SKID FAIL LIGHTS. EMERGENCY DECLARED LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT INBOARD ANTI-SKID VALVE. SYSTEM GROUND CHECKED NORSDR AALA20100925TUL01Fitting · corrodedAFT CARGO CORROSION ON DOOR CUTOUT LOWER FORWARD FITTING. INSTALLED NEW FITTING PER SRM 51-30-05.SDR AALA20100927TUL04Lens · missingEMERGENCY LIGHT AT SEAT 15D IS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 15D. OPS CHECKS NORMAL.SDR AALA20100926DFW03Light · inoperativeEMERGENCY LIGHT AT SEAT 15D IS INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 15D. OPS CHECKS NORMAL.SDR AALA20100924TUL11Angle · crackedLEFT WHALEBONE TO KEEL BEAM ANGLE CRACKED. REMOVED AND REPLACED ANGLE PER SRM 51-01-00.SDR AALA20100924TUL10Cusp Web · corrodedCORROSION UNDER FORWARD GIRT BAR BRACKET AT AFT SERVICE DOOR STATIONS 1142 TO 1143. INSTALLED CUSP REPAIR DOUBLER AT FORWARD GIRT BAR BRACKET AT AFT SERVICE DOOR STATIONS 1142 TO 1143 PER AARD 53-20-00-16.SDR AALA20100924TUL05Cusp Web · corrodedCORROSION UNDER AFT GIRT BAR BRACKET AT AFT SERVICE DOOR STATIONS 1168 TO 1169. INSTALLED LEFT CUSP DOUBLER REPAIR AND CUSP DOUBLER FILLER PER AARD 53-20-00-16, AT STATIONS 1164 TO 1170.SDR AALA20100924TUL04Cusp Web · corrodedCORROSION ON BOTTOM RIGHT CUSP STATION 1174. INSTALLED CUSP REPAIR FROM STATIONS 1170 TO 1197 PER AARD 53-20-00-16.SDR AALA20100924TUL03Cusp Web · corrodedCORROSION RIGHT CUSP STATIONS 1142 TO 1147. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100923TUL04Membrane · damagedHOLE IN SUB FLOOR NEAR STATION 170 LEFT BUTTLINE 14. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100923TUL03Attach Angle · crackedDORSAL FIN ANGLE CRACKED RIGHT SIDE 6 INCH AFT OF FORWARD ACCESS OPENING. REPLACED DORSAL FIN ATTACH ANGLE RIGHT SIDE PER AARD 55-30-00-7.SDR AALA20100923TUL02Support · crackedCABIN, OVERWING STRUCTURE, STATION 927 BELOW SEAT TRACK 2 VERTICAL SUPPORT IS CRACKED AT BOTTOM FORWARD FASTENER AREA. REPAIRED PER EA MD80-53-013130 DATED 9/22/2010.SDR AALA20100923TUL01Cusp Web · crackedRIGHT CUSP IS CRACKED AT STATION 218 TO 223 UPPER SIDE. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20100922TUL02Skin · damagedMID CARGO DOOR OUTER SKIN BELOW HANDLE HAS DEEP BLENDS 3 INCH BY 4 INCH. INTERNAL REPAIR DOUBLER INSTALLED BELOW MID CARGO DOOR HANDLE PER SRM 52-04-00.SDR AALA20100922TUL11Cusp Web · corrodedCORROSION ON LEFT CUSP AT LIGHTENING HOLE BOTTOM SIDE STATION 498. INSTALLED DOUBLER AT STATION 498 LEFT CUSP PER AARD 53-20-00-16 AND SRM 51-10-03.SDR AALA20100922TUL10Cusp Web · crackedRIGHT CUSP IS CRACKED AT STATION 740 TO 742 UPPER SIDE. REMOVED DAMAGED STRUCTURE, FABRICATED AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100922TUL07Frame · crackedAFT ACCY STATION 1510 RIGHT LOWER FRAME CRACKED AT ALIGNMENT PIN. INSTALLED NEW SECTION OF FRAME AND DOUBLER PER SRM 53-01 FIGURE 2.SDR AALA20100922TUL03Seat Track · corrodedSEAT TRACK NUMBER 2 STATIONS 1152 TO 1154 OUT OF LIMITS AT 1152. ROUTED OUT DAMAGE ON SEAT TRACK PER AARD 53-20-00-10. INSTALLED PLUG PER AARD 53-20-00-10.
Back to Mcdonnell Douglas DC-9-82