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 AALA20120313011Skin · dentedDENT AT STATION 218 LONGERONS 18 TO 19 LEFT. DOUBLER INSTALLED PER SRM 53-04-05 FIGURE 2.SDR AALA20120313010Longeron · corrodedCORROSION TO LONGERON 25 RIGHT AT STATION 603. REPAIR DOUBLER INSTALLED PER SRM 53-02-00.SDR AALA20120312018Cusp Web · puncturedLEFT CUSP SHEET PUNCTURED AT STATION 1175. ACCOMPLISHED CUSP SPLICE REPAIR PER BOEING DRAWING SG09530019.SDR AALA20120312017Membrane · corrodedCORROSION ON SUBFLOOR FROM STATIONS 200 TO 215 BELOW NUMBER 5 SEAT TRACK. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120312016Cusp Web · crackedLEFT CUSP IS CRACKED AT STATION 1174 FROM EDGE OF CUSP TO CUTOUT FOR H FITTING. ACCOMPLISHED CUSP SPLICE REPAIR PER BOEING DRAWING SG09530019.SDR AALA20120308014Computer · failedCREW REPORTED NUMBER 2 CENTRAL AIR DATA COMPUTER FAILED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER 2 CENTRAL AIR DATA COMPUTER. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120308018Adc · failedAT ABOUT 300FT AGL AFTER TAKEOFF, F/O`S CADC FAILED WITH FLAGS IN AIRSPEED AND ALTIMETER AND BOTH FLIGHT DIRECTORS FAILED. FOUND C/B F12 POPPED. PLACED BOTH CADCS ON NR 1 AND F/O`S INSTRUMENTS BEGAN TO INDICATE NORMAL. ALTITUDE SELECT WINDOW FLIGHT GUIDANCESDR AALA20120308003Intercostal · crackedCENTER CEILING INTERCOSTAL IS CRACKED AT STATION 1309. INSTALLED NEW INTERCOSTAL PER AARD 51-10-00-5.SDR AALA20120308002Seat Track · corrodedSEAT TRACK NUMBER 5 CORRODED FROM STATIONS 203 TO 205. REPLACED SEAT TRACK AND SPLICE PER SRM 53-05-00.SDR AALA20120307005Cusp Web · crackedCUSP SHEET CRACKED INBOARD SIDE OF CUSP LIGHTENING HOLE AT STATION NUMBER 219 LEFT UNDERNEATH NUMBER 1 SEAT TRACK. INSTALLED NEW CUSP SHEET AS PER AARD 51-10-00-5.SDR AALA20120307002Skin · dentedAFT CARGO DOOR, OUTER SKIN HAS 2 LARGE DENTS BETWEEN NUMBERS 4 AND 5 BEAMS APPROXIMATELY 2 AND 3 FEET FROM FORWARD EDGE. REPLACED WITH NEW SKIN PER ESO 80174.SDR AALA20120307001Servo · inoperativeDEN - INFLIGT DFW-SLC. CREW REPORTED BOTH AUTO-PILOTS FAILED DURING FLIGHT. FLIGHT DIVERTED DEN LANDED WITHOUT INCIDENT. PLACARD BOTH AUTOPILOTS AS INOPERTAIVE PER MEL. REPLACED AUTOPILOT AILERON SERVO AT ORD ON 03/07/2012 . SYSTEM GROUND CHECK NORMAL OPESDR AALA20120306008Cargo Track · corrodedCORROSION ON RIGHT NUMBER AFT TIE-DOWN TRACK AT FASTENER HOLES STATIONS 1212 TO 1287. INSTALLED AFT RIGHT TIEDOWN TRACK PER SRM 51-30-01.SDR AALA20120306015Attach Fitting · damagedAFT CARGO STATION 1174 DOORWAY INTERCOSTAL ATTACH CLIP HOLE ELONGATED. REMOVED AND INSTALLED NEW CLIP PER AARD 51-10-00-5 AND DRAWING 5936065.SDR AALA20120306013Beam · corrodedAFT CARGO DOORWAY LOWER BEAM VERTICAL LEG HAS CORROSION SEVERAL PLACES BETWEEN STATIONS 1155 TO 1212. INSTALLED DOOR BEAM DOUBLER REPAIR PER AARD 53-10-00-3.SDR AALA20120306009Door Frame · corrodedAFT CARGO DOOR JAMB UPPER WEB HAS CORROSION SEVERAL PLACES BETWEEN STATIONS 1155 TO 1212. INSTALLED FASTENERS PER SRM 51-30-05 AND SRM 51-30-02.SDR AALA20120306007Cusp Web · corrodedCORROSION ON SUBFLOOR, STATIONS 220 TO 226, RIGHT BUTTLINES 47 TO 50. INSTALLED SERVICEABLE CUSP SHEET FROM STATIONS 218 TO 237 RIGHT PER AARD 51-10-00-5 AND AARD 53-20-00-16.SDR AALA20120306003Door Frame · corrodedAFT CARGO DOOR JAMB UPPER WEB HAS CORROSION SEVERAL PLACES BTWN STATIONS 1155 TO 1212. REPLACED WEB PER AARD 51-10-00-5.SDR AALA20120305010Fitting · damagedFRAME FOOT AT STATION 218 GOUGED. INSTALLED NEW FOOT FITTING AT STATION 218 PER SRM 51-30-05 AND SRM 51-30-01.SDR AALA20120305006Engine · failedLIT - INFLIGHT DFW-MEM. CREW REPORTED LOSS OF RIGHT ENGINE OIL PRESSURE AND QUANTITY IN FLIGHT. RIGHT ENGINE WAS SHUTDOWN (SINGLE ENGINE TIME 15 MINUTES). EMERGENCY DECLARED FLIGHT DIVERTED LIT LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLSDR AALA20120304002Connector · defectiveEMERGENCY PATH LIGHTING AT ROW 3D INOPERATIVE. REPLACED CONNECTOR PLUG AT ROW 3D. OPS CHECK NORMAL.SDR AALA20120303012Mount Fitting · corrodedG-1 GALLEY INBD MOUNT HAS CORROSION ON THE UPPER SURFACE AND IN THE BORE AT STATION 160 RIGHT BUTTLINE 12. INSTALLED REPLACEMENT G-1 GALLEY MOUNT FITTING PER AARD 51-10-00-5.SDR AALA20120303011Mount Fitting · corrodedG-1 GALLEY OUTBOARD MOUNT IS CORRODED ON THE UPPER SURFACE AND IN THE BORE AT STATION 160 AT THE AFT INBOARD SIDE OF THE DRAIN PAN. INSTALLED REPLACEMENT G-1 GALLEY MOUNT FITTING PER AARD 51-10-00-5.SDR AALA20120303010Mount Fitting · corrodedG-1 GALLEY OUTBOARD MOUNT IS CORRODED ON THE UPPER SURFACE AND IN THE BORE AT STATION 160 AT THE AFT OUTBOARD SIDE OF THE DRAIN PAN. INSTALLED REPLACEMENT G-1 GALLEY MOUNT FITTING PER AARD 51-10-00-5.SDR AALA20120303009Membrane · corrodedCORROSION ON SUB-FLOOR UNDER G-1 GALLEY DRAIN PAN. INSTALLED REPAIR DOUBLER ON SUB-FLOOR UNDER G-1 GALLEY DRAIN PAN PER AARD 53-20-00-16.SDR AALA20120303008Membrane · corrodedSUB-FLOOR UNDER NUMBER 1 GALLEY MOUNT STATION 160, RIGHT BUTTLINE 12 CORRODED. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20120302016Casting · crackedRIGHT WING, GROUND SPOILER CASTING CRACKED IN OUTBOARD FORWARD RADIUS AREA. REMOVED AND INSTALLED RIGHT GROUND SPOILER CASTING PER AARD 51-10-00-5 AND SRM 51-30-02.SDR WX0A2012031371123Battery 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 BATTERIES IN THE POWER SUPPLY BATTERSDR AALA20120301004Light · disconnectedAIRSTAIR SIDEWALL ESCAPE PATH LIGHT INOPERATIVE. FOUND ESCAPE PATH LIGHT IN AFT STAIR DISCONNECTED. RESECURED LIGHT ASSEMBLY. OPS CHECK NORMAL.SDR AALA20120301003Contact · dirtyCEILING EMERGENCY LIGHTS FROM ROWS 28 TO 30 INOPERATIVE. CLEANED CONTACT ON BATTERY PACK AT ROW 27DEF. OPS CHECK NORMAL.SDR AALA20120301002Contact · dirtyCEILING EMERGENCY LIGHTS FROM ROWS 22 TO 27 INOPERATIVE. CLEANED CONTACTS ON BATTERY PACK AT ROW 23DEF. OPS CHECK NORMAL.SDR AALA20120228036Sensor · defectivePIT - CREW REPORTED NOSE LANDING GEAR FAILED TO RETRACT. EMERGENCY DECLARED FLIGHT RETURNED PIT LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NOSE LOCKED GEAR SENSOR D1-32 AND CONNECTOR P1-1157. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120229006Battery Pack · not seatedRIGHT CENTER CEILING EMERGENCY LIGHTS BETWEEN AFT LAVATORIES INOPERATIVE. RESEATED RIGHT EMERGENCY BATTERY PACK. OPS CHECK NORMAL.SDR AALA20120229005Light · inoperativeFIRST CLASS GALLEY FORWARD STANDBY EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR FIRST CLASS GALLEY FORWARD STANDBY EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120228037Stop Fitting · crackedLOWER LEFT VAULT DOOR STOP ON JAMB INTERNAL SUPPORT IS CRACKED. REPLACED STOP FITTING PER AARD 51-10-00-5.SDR AALA20120228010Cusp Web · damagedLEFT CUSP FROM STATIONS 633 TO 635 DAMAGED. INSTALLED DOUBLER FROM STATIONS 632 TO 639 PER AARD 53-20-00-16.SDR AALA20120228009Cusp Web · crackedRIGHT STATION 915 CUSP CRACKED. CUT OUT DAMAGED MATERIAL AND INSTALLED DOUBLER REPAIR AS PER AARD 53-20-00-16.SDR AALA20120228008Membrane · crackedSUBFLOOR CRACKED UNDER FORWARD GALLEY DRAIN PAN. ROUTED OUT DAMAGED MATERIAL AND INSTALLED DOUBLER REPAIR AS PER AARD 53-20-00-16.SDR AALA20120228007Cusp Web · corrodedRIGHT STATION 838, OUTBOARD OF NUMBER 6 SEAT TRACK, CUSP SHEET HAS CORROSION AT LIGHTENING HOLE. REMOVED CORROSION AND INSTALLED DOUBLER REPAIR AS PER AARD 53-20-00-16.SDR AALA20120301014Skin · damagedAFT CARGO DOOR OUTER SKIN HAS 5 DENTS IN AN AREA BETWEEN THE NUMBER 4 AND 5 BEAM. CUT OUT DAMAGED AREA AND INSTALLED REPAIR DOUBLER PER SRM 53-04-03 FIGURE 3.SDR AALA20120228031Skin · damagedRIGHT ELEVATOR HAS PUNCTURE HOLE ON BOTTOM SKIN. INSTALLED REPAIR DOUBLER PER SRM 55-03-00 AND EA COMP-55-022099 DATED 2/27/2012.SDR WX0A2012022171114Battery · inoperativeDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION, MAINTENANCE REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE REMOVED AND REPLACED THE BATTERIES IN POWER SUPPLY BATTERY PACK. AN OPERATIONAL CHECK WAS ACCOMPLISHESDR AALA20120219003Gcu · inoperativeCREW REPORTED RIGHT GENERATOR FAILED IN FLIGHT. EMERGENCY DECLARED FLIGHT LANDED WITHOUT INCIDENT. REPLACED RIGHT GENERATOR CONTROL UNIT. SYSTEM GROUND CHECK NORMAL OPERATION.SDR WX0A2012021771115Battery · inoperativeDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION, MAINTENANCE REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE REMOVED AND REPLACED THE BATTERIES IN POWER SUPPLY BATTERY PACK. AN OPERATIONAL CHECK WAS ACCOMPLISHESDR RYNA201202160011Connector · looseF/O AIRSPEED INDICATOR NOT WORKING ON TAKEOFF ROLL, RTO AT 80 KTS. FOUND LOOSE PITOT CONNECTOR ON NR 2 ADC. SECURED CONNECTOR. PERFORMED PITOT STATIC TEST OF NR 2 SYSTEM. NO LEAKS FOUND. REF AMM 34-11-00.SDR AALA20120216LGA01Battery Pack · dischargedTAIL COMPARTMENT EMERGENCY LIGHTS ABOVE CATWALK INOPERATIVE. REPLACED BATTERY PACK BY RIGHT AFT LAVATORY. OPS CHECK NORMAL.SDR AALA20120213ORD01Duct · blownORD - INFLIGHT DTW-DFW. CREW REPORTED UNABLE TO PRESSURIZE CABIN DURING CLIMBOUT. SELECTED CABIN ALT CNTRL LEVER TO MANUAL AND MANUALLY CLOSED THE OUTFLOW VALVE. THE CABIN CONTINUED TO CLIMB AND INITIATED DESCENT TO 10,000. EMERGENCY DECLARED FLIGHT DIVERTSDR WX0A2012021271106Battery Pack · inoperativeDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION, MAINTENANCE REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE REMOVED AND REPLACED THE POWER SUPPLY BATTERY PACK. AN OPERATIONAL CHECK WAS ACCOMPLISHED PER AMM 33-SDR AALA20120209TUL08Controller · inoperativeMTY - CREW REPORTED UNABLE TO PRESSURIZE AIRCRAFT. EMERGENCY DECLARED FLIGHT RETURNED MTY LANDED WITHOUT INCIDENT. BOTH CABIN AUTO PRESSURE CONTROLLERS PLACARD PER MEL 21-32-03-2. FLIGHT CONTINUED TO DESTINATION. REPLACED BOTH CABIN CONTROLLERS AT DFW ON 0SDR AALA20120208TUL01Bullet · looseOMA - CREW REPORTED RIGHT ENGINE COMPRESSOR STALL. RIGHT ENGINE REDUCED TO IDLE. EMERGENCY DECLARED, LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. INSPECTION FOUND RIGHT ENGINE NOSE BULLET CAME LOOSE. REPLACED FRONT ACCESSORY DRIVE GROUP. SYSTE
Back to Mcdonnell Douglas DC-9-82