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 GTIA040782Slide · out of limitsFOUND R1 DOOR EVAC SLIDE PRESSURE OUT OF LIMITS. REMOVED AND REPLACED R1 DOOR EVACUATION SLIDE. (M)SDR AALA20040964Engine · bird ingestionENROUTE, MULTIPLE BIRDSTRIKES TO LT ENGINE. FIRE LIGHT ILLUMINATED AND BOTH BOTTLES DISCHARGED. RETURNED AND LANDED WITHOUT INCIDENT. SINGLE ENGINE TIME FOUR MINUTES. AIRCRAFT OUT OF SERVICE FOR REPAIRS. OPEN.SDR AALA20040962Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS AT ROWS 4 THROUGH 6 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS AT ROWS 4 THROUGH 6. SYSTEM GROUND CHECKED NORMAL OPERATION. CLOSED.SDR WX0400030Connector · looseMAINTENANCE REPORTED SEAT EMERGENCY EXIT LIGHT AT ROW 20 INOPERATIVE. MAINTENANCE SECURED LOOSE CONNECTOR, EMERGENCY EXIT LIGHT OPERATES NORMALLY. AIRCRAFT RETURNED TO SERVICE.SDR WX0400031Battery · dischargedMAINTENANCE REPORTED AFT SERVICE DOOR AND AFT ENTRANCE DOOR EMERGENCY EXIT LIGHTED SIGNS INOPERATIVE, OVERHEAD EMERGENCY EXIT LIGHTS AFT FLIGHT ATTENDANT STATION, OVERHEAD EMERGENCY EXIT LIGHT ROW 2 AND OVERHEAD EMERGENCY EXIT LIGHTS ROWS 31 TO 33 INOPERATIVESDR MWEA040166Warning Light · false indicationTAIL CONE ANNUCIATOR ILLUMINATED. INSPECTED TAIL CONE LOCK/LATCH INSTALLATION, RESET CABLE LOCKBALL. OK FOR CONTINUED SERVICE.SDR MWEA040165Doubler · crackedMID CARGO DOOR OUTER PAN IS CRACKED APPROXIMATELY 1.6250 INCH IN RADIUS BELOW AFT LOCKING RECEPTACLE. FABRICATED AND INSTALLED DOUBLER.SDR P9RA20040040Power Supply · inoperativeEXTERIOR EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY POWER SUPPLY IAW MM.SDR AALA20040967Battery Pack · inoperativeEMERGENCY LIGHTS IN CEILING AT ROW 15 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN CEILING AT ROW 15. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA040164Skin · dentedOUTWARD DENT IN FUSELAGE AT STATION 1342 1.5 INCHES BELOW LONGERON 7 RIGHT. FABRICATED AND INSTALLED DOUBLER.SDR MWEA040163Pan · crackedAFT CARGO DOOR OUTER PAN IS CRACKED APPROXIMATELY ONE INCH BELOW AFT DOOR. FABRICATED AND INSTALLED DOUBLER.SDR ASMF200409005Actuator · failedAIRCRAFT RETURNED OF FLIGHT, NOSE LANDING GEAR DOOR WAS OPENED AND STRONG NOISE WAS HEARED BY CREW. AIRCRAFT WAS SENT TO THE HANGAR AND NOSE LANDING GEAR DOOR ACTUATORS WERE REPLACED IAW MM 32-22-01, TEST CORRECT.SDR GTIA040777Proximity Sensor · malfunctionedLGA - FLT 7501 - THE LEFT LANDING GEAR UNAFE LIGHT IS ILLUMINATED RED WITH AURAL WARNING. T/S THE MLG POSITION INDICATION AND DETERMINED THE MLG DOWN AND LOCKED SENSOR HARNESS INCORPORATED DEFECTIVE SPLICES. REMOVED AND REPLACED THE PROX SENSOR AND HARNESS CSDR GTIA040778Handle · looseFLL - FOUND L1 DOOR HANDLE LOOSE. TIGHTENED L1 DOOR HANDLE ASSEMBLY. (M)SDR GTIA040779Handle · looseFOUND L1 DOOR HANDLE LOOSE. TIGHTENED L1 DOOR HANDLE ASSEMBLY. (M)SDR AALA20040957Battery Pack · inoperativeDFW - EMERGENCY LIGHTING ABOVE SEATS 13, 14, AND 16 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTING ABOVE SEATS 13, 14, AND 16. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040955Battery · inoperativeDEN - EMERGENCY LIGHTS FROM 3DE TO 20DEF INOPERATIVE. REPLACED FORWARD BATTERY FOR EMERGENCY LIGHTS FROM 3DE TO 20DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040954Battery · inoperativeSJC - COCKPIT OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY FOR COCKPIT OVERHEAD EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040953Battery Pack · inoperativeDFW - CEILING EMERGENCY EXIT LIGHTS BETWEEN ROWS 13 AND 16 AND ROWS 23 AND 26 INOPERATIVE. ADDITIONALLY, FORWARD ENTRY DOOR PORTABLE EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED BATTERY PACKS FOR ROWS 13 AND 16 AND ROWS 23 AND 26. ALSO REPLACED FORWARD ENTRY SDR MWEA040158Panel · corrodedLEFT WING UPPER SURFACE PANEL 1325C HAS INTERGRANUALAR CORROSION AROUND SEVERAL FASTENERS. FABRICATED AND INSTALLED PANEL.SDR MWEA040157Panel · corrodedRIGHT WING TOP PANEL NR 1428 HAS INTERGRANULAR CORROSION AROUND ONE FASTENER. FABRICATED AND INSTALLED PANEL.SDR AALA20040950Battery Pack · inoperativeDFW - FORWARD OVERWING HATCH EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR FORWARD OVERWING HATCH EMERGENCY EXIT LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040949Battery Pack · inoperativeDFW - AFT OVERWING HATCH EXIT EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR AFT OVERWING HATCH EXIT EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040936Battery Pack · dischargedOVERHEAD EMERGENCY EXIT PATH LIGHTING AT ROWS 28-29 INOPERATIVE. REPLACED OVERHEAD EMERGENCY EXIT PATH LIGHTING BATTERY AT ROW 28. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040938Flashlight · defectiveSTL - L1 EMERGENCY EXIT DOOR FLASHLIGHT INOPERATIVE. REPLACED L1 EMERGENCY EXIT DOOR FLASHLIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR CALA0400628Beam · corrodedINSPECTION FOUND BULKHEAD BEAM WEB CORRODED AT STA 110, S30L. THE BEAM WEB WAS REPAIRED IAW ECRA 5310-04387.SDR GTIA040769Handle · looseFLL - FOUND L1 DOOR HANDLE LOOSE. TIGHTENED L1 DOOR HANDLE ASSEMBLY. (M)SDR AALA20040984Gasket · wornINFLIGHT BLUE HAZE AND FAINT SMOKE IN CABIN ON TAKEOFF. HAZE SOON DISSIPATED. AFTER LANDING DURING TAXI IN, SMOKE AND ODOR APPEARED AGAIN. PACKS SHUT DOWN AND SMELL AND HAZE DISSIPATED AGAIN. FOUND APU OIL SERVICE CAP WITH WORN GASKET. REPLACED APU OIL SESDR AALA20040943Battery Pack · inoperativeSEA - SEVERAL AFT CABIN CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR AFT CABIN CEILING EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040933Battery Pack · inoperativeDTW - FIRST CLASS CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS CEILING EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA040776Isolator · out of adjustNR 2 ENGINE PYLON FORWARD LOWER ISOLATOR, ALIGNMENT MARKS ARE OUT OF LIMITS. REMOVED AND REPLACED LOWER FORWARD ISOLATOR. (M)SDR MWEA040156Slide · failedTAIL CONE DID NOT DEPLOY WHEN TAIL CONE WAS DEPLOYED. FOUND SLIDE COVER NOT CORRECTLY ATTACHED TO HARD COVER. RECONNECTED SLIDE AND COVER ASSEMBLY. RETESTED TAIL CONE JETTISON AND SLIDE DEPLOYMENT.SDR GTIA040762Unknown · fumesFLL - FLT 380 - AFTER TAKEOFF FUMES FILLED A/C AND CAUSED AIR RETURN. PERFORMED A/C AIR CONDITION SYSTEM CHECK WITH ENGINES AT HIGH POWER SETTINGS. OPS CHECK NORMAL. (M) GTIASDR AALA20040915Windshield · crackedINFLIGHT T1263/28 ORD ELP AT 31000 FEET FIRST OFFICERS WINDSHIELD BEGAN TO ARC. POWER SECURED TO WINDSHIELD. ARCING STOPPED. OUTER PLY OF FIRST OFFICERS WINDSHIELD CRACKED. AIRCRAFT DIVERTED AND LANDED WITHOUT INCIDENT. REPLACED FIRST OFFICERS WINDSHIELD. SDR AALA20040920Battery Pack · inoperativeLAX - AFT CABIN CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR AFT CABIN CEILING EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040909Wire · brokenRDU FORWARD GALLEY SIDEWALL EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BROKEN BUTT SPLICE FOR WIRE TO FORWARD GALLEY SIDEWALL EXIT LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR GTIA040753Strut · dischargedRED NOSE UNSAFE LIGHT ON W GEAR HANDLE UP. SERVICED NOSE STRUT. LUBED NOSE GEAR. INSPECTED NOSE GEAR LINKAGE AND DOORS. (M)SDR P9RA20040032Tail Cone · deployedAIRCRAFT IN MAINTENANCE-TOL. TAIL CONE WAS INADVERTENTLY DEPLOYED BY RAMP SERVICE PERSONNEL. REINSTALLED TAIL CONE IAW MM 535300. SFB MAINTENANCE ENTRY 8/27/2004. INSPECT TAIL CONE EVACUATION SLIDE FOR PROPER INSTALLATION. INSPECTED SLIDE IAW MM 256200. SDR GTIA040751Control Valve · malfunctionedFLL - FLT 478 - FOUND BRAKE PEDAL DEPRESSION ON LEFT SIDE IS ALMOST TWICE THE RIGHT SIDE BEFORE BRAKE PADS MAKE CONTACT. REMOVED AND REPLACED LEFT WHEEL WELL BRAKE CONTROL VALVE. BLED ALL FOUR BRAKES FREE OF AIR. (M)SDR GTIA040752Strut · out of adjustAFTER TAKEOFF, NOSE GEAR WOULD NOT RETRACT AND DOORS WOULD NOT CLOSE. RETURNED TO MYR. SERVICED AND ADJUSTED NOSE GEAR STRUT, JACKED NOSE OF A/C AND RETRACTED AND EXTENDED NOSE GEAR 4 TIMES WITHOUT ANY DEFECTS NOTED. (M)SDR ASMF200408022Thermocouple · damagedDURING OVERNIGHT SERVICE WAS DETECTED RT ENGINE WITH HIGH EGT INDICATION. EGT INDICATION WAS CHECKED IAW MM 77-21-00 AND THERMOCOUPLE NR 4 WAS DETECTED WITH DAMAGE, IT WAS REPLACED IAW MM 77-21-03. PT2 AND PT7 WERE CHECKED AND NO LEAKS WERE DETECTED, TRIMMINGSDR AALA20040902Battery Pack · inoperativeEMERGENCY LIGHT AT FORWARD GALLEY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR ASAA0480485Tire · failedDURING LANDING ROLL, BOTH LT MLG TIRES RUPTURED. THE MLG STRUT DID NOT COLLAPSE, BUT SOME FUSELAGE DAMAGE WAS CAUSED BY FLYING PIECES OF TIRE MATERIAL. (AN O-53 FLIGHT IRREGULARITY/HAZARD REPORT HAS BEEN FILED AS HAS A PRELIMINARY ENGINEERING REPORT). THE PSDR GTIA040749Lanyard · disconnectedFOUND L1 DOOR LANYARD IS OFF. REINSTALLED L1 DOOR LANYARD. GTIA (M)SDR AALA20040898Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS IN AFT ENTRY INOPERATIVE. REPLACED BATTERY PACK AT B527 FOR OVERHEAD EMERGENCY LIGHTS IN AFT ENTRY. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR CALA0400616Flange · crackedINSPECTION FOUND A 3 INCH CRACK IN THE AFT CARGO DOOR FORWARD LOWER STOP FLANGE. REPAIRED IAW ECRA 5232-01047.SDR AALA200040896Battery Pack · inoperativeBOTH RT AND LT OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR BOTH RT AND LT HAND OVERWING EMERGENCY EXIT LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20040897Battery Pack · inoperativeAFT EMERGENCY LIGHTS ON ATTENDANT SEAT INOPERATIVE. REPLACED BATTERY PACK FOR AFT EMERGENCY LIGHTS ON ATTENDANT SEAT. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR GTIA040766Handle · looseFLL - FOUND L1 DOOR HANDLE LOOSE. TIGHTENED L1 DOOR HANDLE. (M)SDR GTIA040744Holder · out of adjustAFT GALLEY GIRT BAR NOT WORKING PROPERLY 'HOLDER'. ADJUSTED GIRT BAR HOLDER, OPS CHECK NORMAL. GTIA (M)
Back to Mcdonnell Douglas DC-9-82