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 AALA20130313035Frame · crackedTHE 1510 CANT FRAME CRACKED AT LOWER RIGHT TAIL CONE ALIGNMENT PIN. INSTALLED DOUBLER PER SRM 53-01-00.SDR AALA20130313034Membrane · crackedCRACK IN FASTENER HOLE AT FORWARD ENTRY DOOR SUB FLOOR, STATION 170 LEFT BUTTLINE 54. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20130312016Skin · dentedVERTICAL DENT IN FUSELAGE SKIN AT STATION 210, LONGERON 17 RIGHT. INSTALLED DOUBLER PER SRM 53-04-02 FIGURE 2.SDR AALA20130312015Membrane · corrodedCORROSION ON SUB-FLOOR UNDER G-1 GALLEY DRAIN PAN. INSTALLED DOUBLER ON SUB-FLOOR UNDER G-1 GALLEY DRAIN PAN PER AARD 53-20-00-16.SDR AALA20130312014Cusp Web · crackedLEFT CUSP IS CRACKED AT STATION 559. INSTALLED CUSP DOUBLER PER AARD 53-20-00-16.SDR AALA20130312013Membrane · corrodedSUBFLOOR CORROSION UNDER GALLEY TIEDOWN MOUNT STATION 218 RIGHT BUTTLINE 11. INSTALLED REPAIR DOUBLER UNDER GALLEY TIE-DOWN MOUNT AT STATION 218 RIGHT BUTTLINE 11 PER AARD 53-20-00-16.SDR AALA20130312005Rib · crackedLEFT NUMBER 5 SLAT SECOND FROM OUTBOARD END CRACK INDICATION. INSTALLED NEW ATTACH RIB PER ESO 80117.SDR AALA20130312017Shroud · brokenEMERGENCY LIGHT ON SEAT 13C SHROUD IS BROKEN. REMOVED AND REPLACED SEAT 13C EMERGENCY LIGHT SHROUD.SDR AALA20130308010Oven · malfunctionedSTL - INFLIGHT DFW-CMH. CREW REPORTED SMOKE IN CABIN COMING FROM FORWARD GALLEY OVEN. EMERGENCY DECLARED FLIGHT DIVERTED STL LANDED WITHOUT INCIDENT. DEFERRED FORWARD GALLEY OVEN PER NEF. FLIGHT CONTINUED TO DESTINATION. SYSTEM GROUND CHECK NORMAL OPERATISDR AALA20130305008Spring · brokenELP - CREW REPORTED RIGHT ENGINE SPOOLED DOWN ON APPROACH. RIGHT ENGINE FLAMED OUT (SINGLE ENGINE TIME TWO MINUTES). EMERGENCY DECLARED FLIGHT LANDED ELP WITHOUT INCIDENT. REPLACED FUEL LEVER CUTOUT SWITCH DETENT SPRING. SYSTEM GROUND CHECK NORMAL OPERATIOSDR AALA20130304003Switch · inoperativeLGA - CREW REPORTED LEFT PACK FAILED WITH RIGHT PACK ON MEL. EMERGENCY DECLARED FLIGHT RETURNED LGA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED BOTH SINGLE SEGMENT SWITCHES. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20130303001Actuator · inoperativeORD - CREW REPORTED UNABLE TO CONTROL PRESSURIZATION IN AUTOMATIC CONTROL. FLIGHT RETURNED ORD LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED CABIN PRESSURE OUTFLOW ACTUATOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20130301022Membrane · corrodedSUBFLOOR UNDER GALLEY TIEDOWN MOUNT AT STATION 218, RIGHT BUTTLINE 11 CORRODED. INSTALLED REPAIR DOUBLER UNDER GALLEY TIEDOWN MOUNT AT STATION 218 PER AARD 53-20-00-16.SDR AALA20130301021Membrane · corrodedMEMBRANE FROM STATIONS 200 TO 218 UNDER SEAT TRACK NUMBER FIVE CORRODED. INSTALLED CUSP MEMBRANE DOUBLER FROM STATIONS 200 TO 218 PER AARD 51-20-00-16.SDR AALA20130228001Battery Pack · dischargedOVERHEAD EMERGENCY LIGHTS AT ROWS 11 AND 12 INOPERATIVE. REPLACED BATTERY PACK. OPS CHECK NORMAL.SDR AALA20130226018Cusp Web · crackedCRACK ON LEFT CUSP UNDER HORSE COLLAR AT STATION 885, OUTBOARD OF NUMBER 1 SEAT TRACK. INSTALLED CUSP DOUBLER PER AARD 53-20-00-16.SDR AALA20130226007Cusp Web · crackedCRACK IN LEFT CUSP, STATION 431, AT LIGHTENING HOLE. ROUTED OUT DAMAGED AREA AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20130226005Connector · disconnectedESCAPE PATH LIGHT FROM ROWS 19 TO 32 INOPERATIVE. RE-INSTALLED POWER CABLE CONNECTOR AT EPM CONTROLLER MODULE AB5-3 AFT ZONE STATION 850. OPS CHECK NORMAL.SDR AALA20130225015Tab · damagedRUDDER TAB HAS A HOLE AT UPPER TIP TRAILING EDGE. APPLIED WET OVERLAYS TO REPAIR AREA PER SRM 51-70-01A. PERFORMED A RE-METALLIZING REPAIR OVER THE REPAIR AREA PER AARD 55-40-00-2.SDR AALA20130225014Cusp Web · crackedCUSP CRACKED AT STATION 218 AT NUMBER 5 SEAT TRACK. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20130225013Cusp Web · crackedLEFT CUSP IS CRACKED AT STATION 749. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20130225006Skin · crackedCROWN SKIN CRACKED AT STATION 1309, BETWEEN LONGERONS 7 AND 6 RIGHT. REMOVED DAMAGE AND INSTALLED FILLER AND DOUBLER PER SRM 53-04-00 FIGURE 32 AND BOEING DRAWING 5911014.SDR AALA20130225005Skin · crackedCROWN SKIN CRACKED AT STATION 1309, BETWEEN LONGERONS 7 AND 6 LEFT. REMOVED DAMAGE AND INSTALLED FILLER AND DOUBLER PER SRM 53-04-00 FIGURE 32 AND BOEING DRAWING 5911014.SDR WX0A2013030471521Battery Pack · dischargedDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE POWER SUPPLY BATTERY PACK AND MADE ALSDR AALA20130302003Seat Track · corrodedCABIN SEAT TRACK NUMBER 5 CORRODED. REMOVED AND REPLACED SECTION OF SEAT TRACK PER SRM 53-05-00 FIGURE 4 SHEET 1.SDR AALA20130302007Fitting · corrodedCABIN, FOWARD GALLEY TIEDOWN FITTING AT STATION 218, RIGHT BUTTLINE 11 CORRODED. REMOVED AND REPLACED TIEDOWN FITTING PER AARD 51-00-05-1 AND BOEING DRAWING 9936535.SDR AALA20130302006Fitting · corrodedCABIN, FOWARD GALLEY TIEDOWN FITTING AT STATION 210, RIGHT BUTTLINE 11 CORRODED. REMOVED AND REPLACED TIEDOWN FITTING PER AARD 51-00-05-1 AND BOEING DRAWING 9936535.SDR AALA20130302005Fitting · corrodedCABIN, FORWARD GALLEY TIEDOWN FITTING AT STATION 161, RIGHT BUTTLINE 45 CORRODED. REMOVED AND REPLACED TIEDOWN FITTING PER AARD 51-00-05-1 AND BOEING DRAWING 9936534-517.SDR AALA20130302004Fitting · corrodedCABIN, FOWARD GALLEY TIEDOWN FITTING AT STATION 161, RIGHT BUTTLINE 10 CORRODED. REMOVED AND REPLACED TIEDOWN FITTING PER AARD 51-00-05-1 AND BOEING DRAWING 9936534.SDR AALA20130313017Structure · damagedFASTENER HOLE AT STATION 221.4, LONGERON 24 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313016Structure · damagedFASTENER HOLE AT STATION 220.4, LONGERON 24 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313015Structure · damagedFASTENER HOLE AT STATION 219.4, LONGERON 24 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313014Structure · damagedFASTENER HOLE AT STATION 218.2, LONGERON 24 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313013Structure · damagedFASTENER HOLE AT STATION 217, LONGERON 24 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313012Structure · damagedFASTENER HOLE AT STATION 215.8, LONGERON 24 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313011Structure · damagedFASTENER HOLE AT STATION 214.6, LONGERON 24 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313010Structure · damagedFASTENER HOLE AT STATION 213.2, LONGERON 24 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313009Structure · damagedFASTENER HOLE AT STATION 212, LONGERON 24 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313008Structure · damagedFASTENER HOLE AT STATION 217.4, LONGERON 25 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313007Structure · damagedFASTENER HOLE AT STATION 214.9, LONGERON 25 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313006Structure · damagedFASTENER HOLE AT STATION 211.2, LONGERON 25 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313005Structure · damagedFASTENER HOLE AT STATION 208.5, LONGERON 25 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313004Structure · damagedFASTENER HOLE AT STATION 221, LONGERON 23 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313003Structure · damagedFASTENER HOLE AT STATION 219.5, LONGERON 23 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313002Structure · damagedFASTENER HOLE AT STATION 207, LONGERON 25 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130313001Structure · damagedFASTENER HOLE AT STATION 210, LONGERON 25 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130223005Structure · damagedFASTENER HOLE AT STATION 222.4, LONGERON 24 LEFT DAMAGED. REAMED HOLE AND INSTALLED REPAIR BUSHING PER EA MD80-53-028354.SDR AALA20130219016Membrane · corrodedCORROSION AT STATION 160 RIGHT BUTTLINE 12 ON THE LOWER SIDE OF THE STATION 160. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20130219002Lanyard · frayedLEFT NUMBER 1 DOOR SLIDE LANDYARD FRAYED. REPLACED DOOR SLIDE LANDYARD. OPS CHECK NORMAL.SDR AALA20130218014Intercostal · corrodedCORROSION ON TOP OF RIGHT AFT TIE-DOWN TRACK INTERCOSTAL SUPPORT, BETWEEN STATIONS 769 AND 786. INSTALLED INTERCOSTAL PER SRM 51-30-05.
Back to Mcdonnell Douglas DC-9-82