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 AALA20101122TUL03Membrane · damagedCORROSION ON SUBFLOOR BELOW G-1 GALLEY DRAIN PAN. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20101120TUL05Seat Track · damagedFOUND HOLE DRILLED IN THE OUTBOARD EDGE OF NUMBER 2 SEAT TRACK AT STATION 1236. STRAP REPAIR PER EA MD 80 53-014163.SDR AALA20101120TUL04Support · crackedNUMBER 3 SEAT TRACK VERTICAL UNDER FLOOR SUPPORT CRACKED AT STATION 826 [MKD]. REMOVED CRACKED FITTING, DRILLED UP NEW ONE, AND INSTALLED ALL PER AARD 51-10-00-5.SDR AALA20101119TUL08Stop Fitting · crackedAFT DOOR JAMB RIGHT UPPER STOP FITTING CRACKED. REMOVED AND REPLACED FITTING.SDR AALA20101119TUL04Beam · damagedDAMAGE TO I BEAM STATION 1160. REPLACED I BEAM.SDR AALA20101119TUL11Beam · crackedFORWARD SERVICE DOOR NUMBER 2 BEAM CRACKED AT FORWARD INNER RADIUS. INSTALLED NEW BEAM, HOLD OPEN HOOK FITTING AND DRILLED INNER SKIN HOLES PER ESO 80177.SDR AALA20101119TUL10Skin · corrodedHEAVY CARGO/AFT AREA OF BARE METAL ON SKIN STATIONS 1206 TO 1212 LONGERON 29 TO 30 RIGHT. CORROSION OUT OF LIMITS. INSTALLED DOUBLER PER SRM 53-04-00 FIGURE 38 SHEET 22.SDR AALA20101119TUL07Seat Track · corrodedSEAT TRACK NUMBER 1 HAS CORROSION OUT OF LIMITS AT STATION 898. REMOVED CORROSION AND INSTALLED REPAIR PLUG AT SEAT TRACK NUMBER 1, STATION 898 PER AARD 53-20-00-10.SDR AALA20101118TUL25Track · corrodedAFT CARGO CORROSION LEFT TIE DOWN TRACK STATIONS 1007 TO 1212. INSTALLED TRACK SPLICE PER AARD 51-10-0-5.SDR AALA20101118TUL17Shear Tie · damagedSHEAR TIE STATION 180 DAMAGED. INSTALLED SHEAR TIE.SDR AALA20101118TUL22Cusp Web · corrodedCORROSION IN RIGHT SIDE CUSP STATIONS 1182 TO 1190. DOUBLER INSTALLED PER AARD 53-20-00-16.SDR AALA20101118TUL21Cusp Web · crackedCRACK IN LEFT SIDE CUSP STATION 1264. DOUBLER INSTALLED PER AARD 53-20-00-16.SDR AALA20101118TUL10Pan · crackedRIGHT WINDOW PAN BETWEEN STATIONS 1022 TO 1041 HAS LOWER FORWARD EAR CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20101118TUL09Pan · crackedSTATION 1098 LEFT UPPER AFT WINDOW PAN TAB IS CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20101118TUL08Pan · crackedRIGHT WINDOW PAN BETWEEN STATIONS 1041 TO 1060 HAS LOWER FORWARD EAR CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20101118TUL07Pan · crackedRIGHT WINDOW PAN BETWEEN STATIONS 1155 TO 1174 HAS LOWER FORWARD EAR CRACKED. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20101118TUL06Pan · crackedRIGHT WINDOW PAN BETWEEN STATIONS 1060 TO 1079 HAS LOWER FORWARD EAR CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20101118TUL05Pan · crackedRIGHT WINDOW PAN BETWEEN STATIONS 1174 TO 1193 HAS LOWER FORWARD EAR CRACKED. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20101118TUL03Intercostal · crackedINTERCOSTAL IN CARGO CEILING STATIONS 1271 TO 1287 BUTTLINE-0 IS CRACKED AT FASTENER HOLES. REMOVED DAMAGED INTERCOSTAL AND INSTALLED NEW INTERCOSTAL PER AARD 51-10-00-5.SDR AALA20101118TUL01Seat Track · corrodedCORROSION IN SEAT TRACK NUMBER 2 AT CLIP NUT HOLES STATIONS 1152 TO 1159. REPAIR STRAP DOUBLER INSTALLED PER AARD 53-20-00-13.SDR AALA20101117TUL16Cusp Web · corrodedRIGHT CUSP CORRODED STATIONS 1092 TO 1093. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20101117TUL14Cargo Track · corrodedAFT CARGO - CORROSION ON THE LEFT TIE DOWN TRACK UPPER AND LOWER SIDES BETWEEN BETWEEN STATIONS 1212 AND 1231. REMOVED AND REPLACED DAMAGED SPLICE PLATES PER SRM 51-30-05.SDR AALA20101117TUL15Skin · dentedDENT IN FUSELAGE AT STATION 329 BELOW LONGERON 27 RIGHT. REMOVED DAMAGED SKIN AND INSTALLED DOUBLER PER SRM 53-04-00 FIGURE 12B.SDR AALA20101117TUL13Cargo Track · corrodedLEFT AFT TIE DOWN TRACK HAS CORROSION SEVERAL PLACES ALONG THE LENGTH APPROXIMATE STATIONS 1220 TP 1322. REMOVED AND REPLACED DAMAGED TRACK PER SRM 51-30-05 AND 51-30-01.SDR AALA20101117TUL12Skin · dentedFUSELAGE SKIN DENTED WITH A CREASE AT FRAME STATIONS 313 TO 332, BETWEEN LONGERON 27 TO 28 RIGHT. REMOVED DAMAGED SECTION OF SKIN, INSTALLED DOUBLER REPAIR PER SRM 53-04-00 FIGURE 12B.SDR AALA20101117TUL02Cusp Web · crackedRIGHT CUSP CRACKED STATION 1300, LIGHTNING HOLE TO LIGHTNING HOLE. INSTALLED RIGHT CUSP AT STATIONS 1250 TO 1309 PER AARD 51-10-00-5 REPAIR 1.SDR AALA20101117TUL05Cusp Web · damagedTOOL DAMAGE ON CUSP UNDER NUMBER 1 SEAT TRACK STATION 824. INSTALLED NEW CUSP SHEET PER AARD 51-10-00-5 REPAIR 1.SDR AALA20101116TUL02Frame · crackedSTATION 1418 FRAME CRACKED BETWEEN LONGERON 2 RIGHT AND LEFT. ACCOMPLISHED SPLICE REPAIR PER EA MD80-53-011681.SDR AALA20101116TUL01Frame · corrodedCORROSION AFT SIDE FRAME STATION 1250 LONGERON 29 LEFT TO 29 RIGHT. INSTALLED FRAME SPLICE PER EA MD80-53-014022.SDR AALA20101116TUL13Cusp Web · corrodedRIGHT CUSP SHEET STATIONS 598 TO 712 CORRODED. REMOVED AND REPLACED CUSP PER AARD 53-20-00-16.SDR AALA20101116TUL12Beam · corrodedAFT CARGO DOOR CUT OUT LOWER BEAM, CORROSION REMOVAL BEYOND LIMITS. INSTALLED DOUBLER PER AARD 53-10-00-3.SDR AALA20101116TUL11Frame · crackedFRAME 1418 CRACKED ON AFT SIDE AT LONGERON 2 LEFT. STOP-DRILLED CRACK INSTALLED DOUBLER REPAIR PER SRM 53-10-00-15.SDR AALA20101116TUL08Hinge Bracket · corrodedAFT CARGO DOOR CUTOUT-FORWARD HINGE BRACKET CORRODED. REMOVED AFT CARGO DOOR- FORWARD HINGE BRACKET ON THE AIRCRAFT. INSTALLED NEW HINGE BRACKET PER SRM 51-30-05.SDR AALA20101116TUL07Cusp Web · corrodedCORROSION AT LEFT AFT SERVICE DOOR-UNDER AFT GIRT BAR BRACKET. REMOVED CORRODED CUSP SECTION, INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20101116LGA02Battery · not seatedFOUND CEILING EMERGENCY LIGHTS INOPERATIVE FROM SEATS 28 TO ROW 30. RESEATED THE EMERGENCY LIGHT BATTERY. OPS CHECKED NORMAL.SDR AALA20101116LGA01Slide · unwanted deployRIGHT NUMBER 1 DOOR SLIDE WAS DEPLOYED INADVERTANTLY BY CATERING. GIRT BAR WAS FOUND IN THE STOWED POSITION. CHECKED RIGHT NUMBER 1 DOOR BUSSEL. FOUND OK. REPLACED DOOR SLIDE PER AMM 25-62-00-2. OK FOR SERVICE.SDR AALA20101115TUL12Cusp Web · corrodedRIGHT CUSP CORRODED STATIONS 1174 TO 1250. REPLACED CUSP SHEET PER SRM 51-30-01 AND SRM 51-30-05.SDR AALA20101115TUL11Membrane · corrodedCORROSION ON SUBFLOOR UNDER G1 DRAIN PAN. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20101115TUL06Cusp Web · corrodedLEFT CUSP, STATIONS 712 TO 731 CORROSION OUT OF LIMITS. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20101115TUL05Cusp Web · corrodedLEFT CUSP, STATIONS 1098 TO 1103 HAS CORROSION THAT IS OUT OF LIMITS. INSTALLED DOUBLER AND SPACER PER AARD 53-20-00-16.SDR AALA20101115TUL01Attach Fitting · crackedRIGHT WING GROUND SPOILER FITTING CRACK IN OUTBOARD SIDE OF CASTING TRAILING EDGE OF WING. INSTALLED NEW SPOILER ATTACH FITTING PER AARD 51-10-00-5.SDR AALA20101114TUL11Beam · corrodedAFT CARGO - DOOR FRAME UPPER BOX TOP SIDE HAS CORROSION AT THE UPPER FORWARD END JUST FORWARD OF THE FORWARD HINGE MOUNT APPROXIMATELY STATION 1160. REMOVED AND REPLACED BEAM PER AARD 51-10-00-05.SDR AALA20101114TUL10Cusp Web · corrodedCORROSION UNDER FORWARD GIRT BAR BRACKET AT STATION 1140. INSTALLED .040" 6AL-4V TITANIUM REPAIR DOUBLER STATION 1140 PER AARD 53-20-00-16.SDR AALA20101114TUL09Cusp Web · corrodedCORROSION UNDER AFT GIRT BAR BRACKET AT STATION 1166. INSTALLED .040" 6AL-4V TITANIUM REPAIR DOUBLER STATION 1166 PER AARD 53-20-00-16.SDR AALA20101114TUL08Pan · crackedCRACK IN RIGHT UPPER AFT CORNER OF WINDOW PAN AT STATION 1193. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20101114TUL06Pan · crackedCRACK IN UPPER AFT CORNER OF RIGHT WINDOW PAN AT STATION 1060. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20101114TUL05Pan · crackedCRACK IN RIGHT UPPER AFT CORNER OF WINDOW PAN AT STATION 1022. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20101114TUL03Pan · crackedCRACK IN UPPER AFT CORNER OF LEFT WINDOW PAN AT STATION 1079. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20101114TUL02Pan · crackedCRACK IN UPPER FORWARD CORNER OF WINDOW PAN AT STATION 845. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20101114TUL01Cusp Web · corrodedLEFT CUSP STATIONS 1098 TO 1103 HAS CORROSION THAT IS OUT OF LIMITS. INSTALLED DOUBLER AND SPACER PER AARD 53-20-00-16.
Back to Mcdonnell Douglas DC-9-82