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 AALA20130411008Coalescer Bag · dirtyCLT - CREW REPORTED ELECTRICAL ODOR IN CABIN AREA. EMERGENCY DECLARED FLIGHT RETURNED CLT LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. ACCOMPLISHED CABIN ODOR CARD 21-96-01 AND REPLACED BOTH WATER SEPARATOR BAGS. SYSTEM GROUND CHECK NORMAL OPERASDR AALA20130412009Light · missingESCAPE PATH LIGHT AT SEAT 22D MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 22D.SDR AALA20130412003Shroud · missingESCAPE PATH LIGHT AT SEAT 29D MISSING SHROUD. REPLACED SHROUD FOR ESCAPE PATH LIGHT AT SEAT 29D. OPS CHECK NORMAL.SDR AALA20130412002Lens · missingESCAPE PATH LIGHT AT SEAT 22D MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 22D. OPS CHECK NORMAL.SDR AALA20130412001Light · inoperativeCEILING EMERGENCY LIGHT AT SEAT 27B INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT AT SEAT 27B. OPS CHECK NORMAL.SDR AALA20130501010Cusp Web · corrodedCUT OUT AREA OF SUBFLOOR AND EEXISTING DOUBLER CORRODED. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20130420009Skin · damagedFORWARD CARGO DOOR HAS SEVERAL SCRATCHES ON EXTERIOR SKIN. INSTALLED NEW EXTERIOR SKIN ON FORWARD CARGO DOOR.SDR AALA20130501014Longeron · crackedLONGERON 3 LEFT IS CRACKED AT STATION 160. INSTALLED LONGERON SPLICE PER SRM 53-02-00 FIGURE 18.SDR AALA20130501012Sill · corrodedFORWARD SERVICE DOOR SILL CORRODED AT STATION 198. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-14.SDR AALA20130407003Cover · looseEMERGENCY ESCAPE PATH LIGHT HOLDER AT 25D LOOSE. RE-ATTACHED 25D SIDE COVER. OPS CHECK NORMAL.SDR AALA20130405007Diaphragm · corrodedFUSELAGE RIGHT E AND E COMPARTMENT SUB-FLOOR UNDER CUSP CORRODED AND CRACKED FROM STATIONS 200 TO 210, LONGERON 18 RIGHT. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20130402016Engine · failedDFW - CREW REPORTED LEFT ENGINE OIL PRESSURE LOSS DURING CLIMBOUT. SHUTDOWN LEFT ENGINE (SINGLE ENGINE TIME 22 MINUTES). EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT ENGINE AT DFW ON 04/03/201SDR AALA20130401007Sensor · leakingMCI - CREW REPORTED CABIN ALTITUDE WARNING. EMERGENCY DESCENT INITIATED AND O2 MASKS WERE MANUALLY DEPLOYED. EMERGENCY DECLARED FLIGHT LANDED MCI WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FIGHT FERRIED TO TUL FOR FURTHER MAINTENANCE. REPLACED LEAKISDR AALA20130331005Controller · inoperativeORD - INFLIGHT MKE-DFW. CREW REPORTED DIFFICULTY CONTROLLING CABIN PRESSURE AFTER TAKEOFF. CREW STATED THEY WERE IN MANUAL AND DID NOT EXPERIENCE ANY PACK PROBLEMS AND FLOW LIGHT WAS NOT ILLUMINATED. EMERGENCY DECLARED FLIGHT DIVERTED ORD LANDED WITHOUT INCSDR AALA20130327003Controller · inoperativeIAD - INFLIGHT DCA-DFW. CREW REPORTED UNABLE TO PRESSURIZE CABIN. EMERGENCY DECLARED FLIGHT DIVERTED IAD LANDED WITHOUT INCIDENT. PLACARD NUMBERS ONE AND TWO AUTO PRESSURE CONTROLLERS PER MEL. FIGHT CONTINUED TO DESTINATION. REPLACED OUTFLOW VALVE ACTUATORSDR AALA20130326025Diaphragm · corrodedCORROSION ON SUB-FLOOR UNDER G-1 GALLEY DRAIN PAN. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20130326024Diaphragm · corrodedCORROSION TOP OF SUBFLOOR AT STATION 200 UNDER FORWARD END OF NUMBER 4 SEAT TRACK. INSTALLED DIAPHRAGM REPAIR DOUBLER FROM STATIONS 200 TO 218 AND RIGHT BUTTLINES 17 TO 26 PER AARD 53-20-00-16.SDR AALA20130326023Cusp Web · crackedCRACK IN LEFT CUSP AT STATION 218 OUTBOARD OF NUMBER 2 SEAT TRACK. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20130325024Guard · missingELP - INFLIGHT DFW-PHX. CREW REPORTED FUEL IMBALANCE DURING CLIMBOUT. FLIGHT DIVERTED ELP LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND FUEL PANEL REFUELING POWER SWITCH GUARD DOWN AND CENTER AND RIGHT TANK SWITCHES IN THE OPEN POSITION. SDR AALA20130325016Module · inoperativeDFW - CREW REPORTED INTERMITTANT FAULTS: TAS INPUT FAIL, HDG INPUT FAIL, ALT INPUT FAIL SYNCHRO INPUT FAIL. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NPU CONFIGURATION MODULE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20130325021Bearing · migratedOKC - CREW REPORTED FLAP HANDLE BINDING. EMERGENCY DECLARED, FLIGHT LANDED OKC WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND BEARING MIGRATED FROM HOOK ASSEMBLY - POSITION INTERLOCK. INSTALLED SERVICEABLE HOOK ASSEMBLY - POSITION INTERLOCK. SYSTESDR AALA20130322015Shear Tie · crackedSHEAR-TIE AT STATION 1437 RIGHT SIDE OF LONGERON IS CRACKED. REPLACED SHEAR-TIE AT STATION 1437 BETWEEN LONGERONS 1 AND 2 PER AARD 51-00-05-1.SDR AALA20130321026Skin · crackedRIGHT SIDE OF FUSELAGE HAS CRACK IN SKIN AT FASTENER HOLE AT STATION 1418 BELOW LONGERON 2 RIGHT. INSTALLED INTERNAL AND EXTERNAL DOUBLER AND FILLER PER SRM 53-04-00 FIGURE 40.SDR AALA20130321017Splice · corrodedLEFT TIE DOWN TRACK SPLICE FROM STATIONS 1212 TO 1227 CORRODED. INSTALLED NEW LEFT TIE DOWN TRACK SPLICE FROM STATIONS 1212 TO 1227 PER AARD 51-00-05-1.SDR AALA20130321021Longeron · crackedSTATION 1437 LONGERON 2 RIGHT HAS CRACK UNDER FRAME. REMOVED CRACKED PORTION OF LONGERON AND INSTALLED SERVICEABLE LONGERON AND LONGERON SPLICE AT STATION 1437 PER SRMS 53-02-00, 53-14-04, 51-60-00 AND AARD 53-00-00-05.SDR AALA20130321018Longeron · crackedCRACK IN LONGERON 3 LAFT AT STATION 160. REMOVED CRACKED SECTION AND INSTALLED NEW SECTION OF LONGERON 3 LEFT FROM STATIONS 150 TO 170 PER SRM 53-14-01 FIGURE 3. INSTALLED LONGERON SPLICE AT STATION 170 PER SRM 51-30-05.SDR AALA20130321015Longeron Clip · damagedLEFT LONGERON 4 END CLIP AT STATION 148 HAS ELONGATED HOLES WHERE CLIP ATTACHES TO LONGERON. INSTALLED NEW LONGERON 4 LEFT END CLIP AT STATION 148 PER AARD 51-00-05-1 AND BOEING DRAWING 5911405.SDR AALA20130321013Longeron Clip · damagedLEFT LONGERON 3 END CLIP AT STATION 148 HAS ELONGATED HOLES WHERE CLIP ATTACHES TO LONGERON. INSTALLED NEW LONGERON 3 END CLIP AT STATION 148 PER AARD 51-00-05-1 AND BOEING DRAWING 5911405.SDR AALA20130321004Longeron · crackedCRACK IN LONGERON 3 LEFT. SPLICED IN NEW SECTION OF LONGRON FROM STATIONS 150 TO 170 PER SRM 53-02-00.SDR AALA20130320013Gcu · inoperativeDFW - CREW REPORTED ON DESCENT THE LEFT GENERATOR FAILED AND THE CROSSTIE LOCK-OUT LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT GENERATOR CONTROL UNIT. SYSTEM GROUND CHECK NORMAL OPESDR AALA20130320012Beam · corrodedCORROSION ON THE DOOR BEAM FROM STATIONS 1160 TO 1202. REMOVED CORROSION AND INSTALLED DOOR BEAM DOUBLER AS PER AARD 53-10-00-3.SDR AALA20130321020Wire · damagedSEAT MOUNTED EMERGENCY LIGHTS FROM ROW 21 AND AFT PLUS AFT CEILING EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED WIRE L788A016 FROM PIN 7 ON BATTERY PACK B5-103, CAPPED AND STOWED. INSTALLED JUMPER WIRE FROM PIN 7 ON B5-103 BATTERY PACK TO PIN 7 ON BATTERY PACK SDR AALA20130319033Longeron · crackedCRACK IN LONGERON 4 LEFT AT STATION 160. INSTALLED LONGERON REPAIR PER SRM 53-02-00 AND BOEING DRAWING 5911406.SDR AALA20130319022Cusp Web · crackedCRACK IN CUSP BETWEEN STATIONS 415 AND 419 RIGHT. INSTALLED CUSP REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20130319005Fitting · crackedFITTING CRACKED UNDER SEAT TRACK NUMBER 4 AT STATION 845. INSTALLED NEW FITTING PER AARD 51-00-05-1.SDR AALA20130319004Longeron · crackedCRACK IN LONGERON 4 LEFT AT STATION 160. INSTALLED NEW SECTION OF LONGERON AND RE-INSTALLED ORIGINAL SPLICES.SDR AALA20130318038Cusp Web · corrodedRIGHT CUSP FROM STATIONS 1223 TO 1226 CORRODED. REMOVED CORROSION AND INSTALLED CUSP DOUBLER PER AARD 53-20-00-16.SDR AALA20130318016Cusp Web · corrodedBOTTOM OF LEFT CUSP HAS CORROSION AT STATION 1175. INSTALLED CUSP DOUBLER PER AARD 53-20-00-16.SDR AALA20130318015Cusp Web · corrodedBOTTOM OF LEFT CUSP HAS CORROSION AT STATION 1143. INSTALLED CUSP SUPPORT AT STATION 1143 PER BOEING DRAWING 9930612 AND AARD 53-20-00-16.SDR AALA20130318014Cusp Web · crackedCRACK IN CUSP FROM STATIONS 307 TO 310 RIGHT. INSTALLED CUSP DOUBLER PER AARD 53-20-00-16.SDR AALA20130318005Battery Pack · dischargedEMERGENCY LIGHTS FROM ROW 20 FORWARD INOPERATIVE. REPLACED FORWARD OVERWING BATTERY PACK. OPS CHECK NORMAL.SDR AALA20130318001Cusp Web · corrodedCORROSION ON CUSP RIGHT SIDE AT FUSELAGE STATIONS 1197 TO 1206. INSTALLED DOUBLER PER AARD.SDR AALA20130318002Duct · crackedAUS - REPEAT ITEM CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED ON CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED AUS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND DUCT CRACKED ON THE RIGHT SIDE OF AFT ACCESSORY COMPARTMENSDR AALA20130315011Duct · crackedDFW - CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINTED DURING CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED Y DUCT THAT WAS CRACKED. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20130315002Skin · crackedRIGHT SIDE FUSELAGE SKIN CRACKED AT STATION 1309 BETWEEN LONGERONS 6 AND 7 RIGHT. INSTALLED DOUBLER PER EA MD80-53-028792.SDR AALA20130314016Pan · crackedFORWARD SERVICE DOOR HAS CRACK ON DOOR PAN AT DOOR HINGE LOWER CUTOUT. INSTALLED DOUBLER PER ESO 80177 AND EA MD80-52-028790.SDR AALA20130314015Skin · crackedCROWN SKIN IS CRACKED AT STATION 1309 BETWEEN LONGERONS 7 AND 6 RIGHT. INSTALLED REPAIR DOUBLER AND PLUG PER SRM 53-04-00, FIGURE 32.SDR AALA20130314014Skin · crackedCROWN SKIN IS CRACKED AT STATION 1309 BETWEEN LONGERONS 7 AND 6 LEFT. INSTALLED REPAIR DOUBLER AND PLUG PER SRM 53-04-00 FIGURE 32 AND BOEING DRAWING 5911014.SDR AALA20130313040Duct · leakingSFO - INFLIGHT SJC-DFW CREW REPORTED TAIL COMPARTMENT TEMPERAURE HIGH LIGHT ILLUMINATED DURING CLIMB-OUT. EMERGENCY DECLARED FLIGHT DIVERTED SFO LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND TOP DUCT LEAK FROM TUBING ABOVE HEAT EXCHANGER. RSDR AALA20130313039Cusp Web · crackedCRACK IN LEFT CUSP AT STATION 218 OUTBOARD NUMBER 2 SEAT TRACK. INSTALLED DOUBLER PER AARD 53-20-00-16.
Back to Mcdonnell Douglas DC-9-82