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 AALA20090623TUL01Bulkhead · crackedCRACKS IN FORWARD SIDE OF BULKHEAD AT STATION 37 AT UPPER LEFT RADOME ALIGNMENT PIN. INSTALLED DOUBLER PER AARD 53-10-00-19.SDR AALA2009062000006Battery Pack · dischargedLGA - EMERGENCY LIGHTS FOR ROW 20 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT ROW 20.SDR AALA2009062000005Battery Pack · dischargedLGA - AFT SECTION EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR AFT SECTION EMERGENCY LIGHTS.SDR AALA2009062000002Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT 11D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 11D.SDR AALA2009062000001Battery · not seatedLGA - TAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERIES IN CHARGER FOR TAIL COMPARTMENT EMERGENCY LIGHTS.SDR AALA20090629TUL02Stop Fitting · crackedSTOP FITTING CRACKED AT AFT END OF DOOR, AT THE END OF NUMBER 3 BEAM.SDR AALA20090619TUL03Stop Fitting · crackedDOOR STOP FITTING CRACKED, LOWER AFT EDGE OF AFT CX DOOR. REPLACED FITTING PER ESO 80174.SDR AALA20090619TUL02Stop Fitting · crackedMID CARGO DOOR STOP CRACKED. REPLACED WITH NEW DOOR STOP --CDK 2345-3 ON DOO2492 PER ESO 80174.SDR WX0A070337Battery Pack · inoperativeDURING A ROUTINE OVERNIGHT SERVICE CHECK INSP REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYS WOULD NOT TEST. MX PERSONNEL REMOVED AND REPLACED THE APPROPRIATE BATTERIES IN THE PWR SUPPLY BATTERY PACK. A SATISFACTORY OPS CHECK WAS ACCOMPLISHED IAWSDR AALA20090624TUL20Angle · crackedTHE J-BEAM AT LEFT SIDE STATION 46 LONGERON 26 LEFT IS CRACKED AT FASTENER HOLE IN DOUBLER. REMOVED AND REPLACED J-ANGLE DOUBLER AT STATION 46 LONGERON 26 LEFT PER AARD 53-10-00-4.SDR AALA2009061700003Battery Pack · dischargedBPS - OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EMERGENCY LIGHTS.SDR AALA2009061700002Battery Pack · dischargedLGA - FORWARD EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR EXIT LIGHTS AT ROW 3 TO ROW 20.SDR AALA2009061700001Battery Pack · dischargedLGA - EXIT LIGHTS INOPERATIVE. REPLACED FORWARD BATTERY PACK.SDR AALA20090624TUL19Pan · corrodedAFT LAVATORY SERVICE PANEL PAN CORRODED. INSTALLED DOUBLER PER EA MD80-53-006505.SDR AALA2009061600005Battery Pack · dischargedLGA - EMERGENCY BATTERY AT FORWARD POSITION INOPERATIVE. REPLACED BATTERY AT FORWARD POSITION.SDR AALA2009061600004Battery Pack · dischargedLGA - CEILING EMERGENCY LIGHTS FROM ROWS 26 TO 29 INOPERATIVE. REPLACED BATTERY PACK AT AFT CABIN.SDR AALA2009061600003Battery Pack · dischargedLGA - AFT LAVATORY DROP DOWN CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT AFT LAVATORY.SDR AALA20090624TUL18Cusp Web · corrodedRIGHT CUSP HAS CORROSION STATIONS 200-205. DAMAGED MATERIAL REMOVED, REPAIR DOUBLER INSTALLED PER EA MD-80-53-006501 AND AARD 53-20-00-14.SDR AALA2009061500006Battery Pack · dischargedTPA - OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EMERGENCY LIGHTS.SDR AALA2009061500001Battery Pack · dischargedMCO - LEFT NUMBER ONE DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR LEFT NUMBER ONE DOOR EMERGENCY LIGHT.SDR AALA20090624TUL17Cargo Track · corrodedAFT CARGO TIE DOWN TRACK CORRODED STATIONS 1211-1236. INSTALLED NEW RIGHT AFT TIE DOWN TRACK PER SRM 51-01-00 AND SRM 51-30-01.SDR AALA20090624TUL16Web · corrodedHEAVY CORROSION AROUND NUT PLATES ON WEB STATIONS 1211-1216. REPLACED WEB FROM STATIONS 1204 TO 1216 FROM LONGERON 30 RIGHT TO LONGERON 26 RIGHT SPLICED IN NEW SECTION PER AARD 53-10-00-24 AND SRM 51-30-00.SDR AALA20090624TUL10Angle · corrodedANGLE AT FORWARD LOWER DOOR BEAM, CORROSION REMOVAL OUT OF LIMITS. REMOVED AND INSTALLED NEW ANGLE BRACKET AT LOWER DOOR BEAM STATION 1155 PER SRM 51-30-00.SDR AALA20090624TUL09Beam · corrodedAFT CARGO DOOR BEAM CORRODED STATION 1155-1211. INSTALLED FULL LENGTH DOOR BEAM DOUBLER PER AARD 53-10-00-3.SDR AALA20090624TUL08Frame · crackedTHE 1418 FRAME CRACKED LONGERON 2 LEFT AND 2 RIGHT. INSTALLED DOUBLER PER EA MD80-53-006493.SDR DU4R2009374Track · corrodedDURING SCHEDULED INSPECTION, FOUND RT FWD TRANSITION TRACK HAD CORROSION FROM FS 1079 TO FS 1155 (AROUND NUT PLATE HOLES, INSIDE TRACK AND STEP DOWN ANGLE ATTACHED TO AFT END OF TRACK).SDR AALA2009061300003Battery Pack · dischargedLGA - AFT LAVATORY EMERGENCY BATTERY DEPLETED. REPLACED BATTERY PACK FOR AFT LAVATORY.SDR AALA20090624TUL07Pan · crackedAFT CARGO DOOR OUTER PAN CRACKED APPROXIMATELY 1.5 INCH IN RADIUS AT AFT END OF NR 5 BEAM. STOP DRILLED CRACK OUTER DOOR PAN AFT END NR 5 BEAM, FABRICATED AND INSTALLED DOUBLER PER SRM 52-30-00 AND ESO 80174.SDR AALA2009061200004Connector · looseMIA - SEAT MOUNTED EMERGENCY LIGHT AT 10D INOPERATIVE. SECURED LOOSE WALL CONNECTOR AT SEAT 10D.SDR AALA2009061100003Controller · inoperativeTUS - CAPTAIN ADVISED THAT THE FLIGHT EXPERIENCED A RAPID DEPRESSURIZATION SHORTLY AFTER DEPARTURE. EMERGENCY DECLARED, RETURNED TO TUS WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER ONE AND TWO CABIN PRESSURE CONTROLLERS AND CABIN PRESSURSDR AALA20090623TUL16Longeron · crackedCRACK AT LONGERON 4 LEFT, STATION 200. REMOVED AND REPLACED LONGERON 4 LEFT FROM STATION 160 TO 230 PER SRM 53-02-00 FIGURE 18.SDR DU4R2009377Skin · dentedDURING SCHEDULED INSP, FOUND PREVIOUSLY REPORTED AT FS 120, L-23L OUT OF LIMITS IAW SRM 53-04 FIG. 38, SHT. 13, CONDITION 3, D/X = 2.94 AND .720 INCH FROM INTERNAL STRUCTURE.SDR AALA20090612TUL09Cusp Web · crackedLEFT CUSP MEMBRANE HAS OLD STYLE REPAIR DOUBLER AND CRACKED 1271 TO 1307. INSTALLED NEW CUSP FROM 1251 TO 1309 PER SRM 53-05-00 FIG 97 AND AARD 53-20-00-16 FIG 3.SDR AALA20090612TUL08Cusp Web · crackedRIGHT CUSP MEMBRANE HAS OLD STYLE DOUBLER AND CRACK AT STATION 1271 TO 1307. INSTALLED NEW CUSP MEMBER STATION 1271 TO 1309 PER AARD 53-20-00-16.SDR AALA20090611TUL19Stop Fitting · crackedNR 1 FITTING FOR FWD STOP PAD ON FWD CARGO DOOR IS CRACKED. REMOVED AND REPLACED NR 1 STOP PAD FITTING PER ESO 80174.SDR AALA20090611TUL18Stop Fitting · crackedFWD CARGO DOOR NR 3 FWD STOP PAD FITTING CRACKED. REMOVED AND REPLACED STOP PAD FITTING PER ESO 80174.SDR AALA20090611TUL17Stop Fitting · crackedFWD CARGO DOOR NR 1 BEAM STOP PAD FITTING CRACKED. REMOVED AND REPLACED STOP PAD FITTING PER ESO 80174.SDR AALA20090611TUL16Angle · corrodedAFT CARGO DOOR L-ANGLE CORRODED AT LOWER FWD STOP PAD FITTING. REMOVED AND REPLACED L-ANGLE PER ESO 80174.SDR AALA20090611TUL15Frame · crackedRT CANT FRAME CRACKED AT LONG18R. INSTALLED ANGLE DOUBLER PER SRM 53-03-00 FIG 27.SDR AALA20090611TUL14Cusp Web · corrodedRT CUSP CORRODED STA 643-646. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090611TUL13Cusp Web · corrodedRT CUSP HAS CORROSION. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090611TUL12Frame · crackedRT FRAME CRACKED AT STA 886. INSTALLED NEW FRAME PER SRM 51-01-00.SDR AALA20090611TUL11Cusp Web · corrodedCUSP HAS CORROSION STA 579-584, L18R. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090611TUL10Cusp Web · crackedRT CUSP CRACKED OUTBOARD OF NR 6 SEAT TRACK. REMOVED DAMAGE AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090611TUL09Cusp Web · corrodedCORROSION ON BOTTOM OF RT CUSP. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090611TUL08Stop · crackedMID CARGO DOOR FWD LOWER DOOR STOP PAD FITTING CRACKED. REMOVED AND REPLACED FITTING PER ESO 80174.SDR AALA20090611TUL06Stop Fitting · crackedCRACK IN STOP FITTING. REMOVED AND REPLACED STOP FITTING PER ESO 80174 CPN 5724144.SDR AALA20090611TUL07Intercostal · crackedCABIN FLOORBEAM INTERCOSTAL CRACKED. REMOVED AND REPLACED INTERCOSTAL PER SRM 53-05-00.SDR AALA20090611TUL05Cusp Web · crackedRT CUSP CRACKED OUTBOARD OF NR 6 SEAT TRACK. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090611TUL04Cusp Web · corrodedLT CUSP CORRODED BENEATH FWD GIRT BAR FITTING AT AFT SERVICE DOOR. INSTALLED CUSP REPAIR DOUBLER PER AARD 53-20-00-16.
Back to Mcdonnell Douglas DC-9-82