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 AALA20121206002Shear Tie · corrodedCORROSION ON FORWARD AND AFT SIDE OF SHEAR TIE AT STATION 1155 BETWEEN LONGERONS 30 LEFT AND 29 RIGHT. INSTALLED NEW SHEAR-TIE AT STATION 1155 PER AARD 51-00-05-1.SDR AALA20121206001Cusp Web · corrodedBOTTOM OF LEFT CUSP AT STATION 1164 IS CORRODED AT FASTNERS. INSTALLED CUSP REPAIR PER SRM 53-05-00 FIGURE 131A-23 AND EA MD80-53-027406.SDR AALA20121207006Stiffener · crackedSTIFFENER AT AFT VAULT DOOR LEFT JAMB BETWEEN LATCH LUG CUTOUTS CRACKED. REPLACED WITH NEW STIFFENER PER AARD 51-00-05-1.SDR AALA20121205010Gusset · crackedCRACK AT LEFT GUSSET, STATION 207, LONGERON 11 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-11.SDR AALA20121205004Battery Pack · dischargedTAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. REPLACED RIGHT AFT LAVATORY BATTERY PACK. OPS CHECK NORMAL.SDR AALA20130104015Skin · crackedCRACK IN FUSELAGE AT RIVET AT FRAME STATION 165.5 AND LONGERON 22 LEFT. INSTALLED DOUBLER PER BOEING DRAWING SR09530219.SDR AALA20121203023Skin · damagedLEFT ELEVATOR TOP SKIN HAS TWO DENTS LOCATED APPROXIMATELY 7 INCHES INBOARD OF STATION XET 26 AND 10 INCHES AFT OF LEADING EDGE OF ELEVATOR. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121203020Frame · damagedAFT CARGO STATION 1212 UPPER SIDE OF FRAME NUT PLATE ATTACH HOLE ELONGATED. INSTALLED REPAIR DOUBLER PER EA MD80-53-027356.SDR AALA20121203019Skin · dentedRIGHT ELEVATOR TOP SKIN HAS TWO DENT LOCATED APPROXIMATELY 150 INCHES FROM INBOARD END AND 10 INCHES FROM TRAILING EDGE OF ELEVATOR. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121203018Skin · dentedLEFT ELEVATOR TOP SKIN HAS TWO DENTS LOCATED APPROXIMATELY 70 INCHES FROM INBOARD EDGE AND 5 INCHES UP FROM TRAILING EDGE. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121203017Skin · dentedLEFT ELEVATOR TOP SKIN HAS THREE DENTS LOCATED APPROXIMATELY 19 INCHES OUTBOARD OF STATION XET 80 AND 8 TO 14 INCHES FORWARD OF TRAILING EDGE. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121203004Skin · damagedLEFT ELEVATOR TOP SKIN HAS THREE DENTS LOCATED APPROXIMATELY 34 INCHES INBOARD OF STATION 173 AND 5 INCHES FORWARD OF TRAILING EDGE OF ELEVATOR. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121203003Structure · damagedLEFT ELEVATOR 4 DENTS LOCATED APPROXIMATELY 3 TO 5 INCHES INBOARD OF STATION XET 80 AND 9 TO 14 INCHES FORWARD OF TRAILING EDGE. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121203002Structure · damagedLEFT ELEVATOR 3 DENTS LOCATED APPROXIMATELY 3 INCHES OUTBOARD OF STATION XET 46 AND 3 INCHES FORWARD OF TRAILING EDGE. INSTALLED REPAIR DOUBLER PER SRM 51-70-06.SDR AALA20121202007Skin · dentedLEFT ELEVATOR TOP SKIN HAS TWO DENTS LOCATED APPROXIMATELY 2 INCHES OUTBOARD OF STATION XET 65 AND 11 INCHES FORWARD OF TRAILING EDGE OF ELEVATOR. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121202006Skin · dentedLEFT ELEVATOR TOP SKIN HAS THREE DENTS LOCATED APPROXIMATELY 10 INCHES OUTBOARD OF STATION XET 46 AND 9 INCHES FORWARD OF TRAILING EDGE OF ELEVATOR. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121202002Pin · looseSEAT MOUNTED EMERGENCY LIGHT AT 17D INOPERATIVE. FOUND LOOSE PIN IN CONNECTOR INSTALLED AND SECURED PIN ON CONNECTOR. OPS CHECK NORMAL.SDR AALA20121202001Light · inoperativeRIGHT NUMBER 1 DOOR EMERGENCY EXIT SIGN INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 1 DOOR EMERGENCY EXIT SIGN. OPS CHECK NORMAL.SDR AALA20121203007Structure · dentedLEFT ELEVATOR 4 DENTS LOCATED APPROXIMATELY 5 INCHES INBOARD OF STATION XET 80 AND 9 TO 14 INCHES FORWARD OF TRAILING EDGE. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121206006Skin · dentedLEFT ELEVATOR TOP SKIN HAS TWO DENTS LOCATED APPROXIMATELY 7 INCHES OUTBOARD OF STATION XET 26 AND 10 INCHES FORWARD OF TRAILING EDGE. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121206005Skin · damagedLEFT ELEVATOR TOP SKIN HAS TWO DENTS LOCATED APPROXIMATELY 2 INCHES OUTBOARD OF STATION XET 26 AND 7 INCHES FORWARD OF TRAILING EDGE. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121203016Skin · dentedLEFT ELEVATOR TOP SKIN HAS MANY DENTS LOCATED APPROXIMATELY 3 INCHES OUTBOARD OF STATION XET 26 AND 19 INCHES AFT OF LEADING EDGE. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121203012Skin · dentedLEFT ELEVATOR TOP SKIN HAS 2 DENTS 32 INCHES OUTBOARD OF STATION XET 80 AND 3 INCHES FORWARD OF TRAILING EDGE. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121205009Skin · dentedRIGHT ELEVATOR TOP SKIN HAS DENTS LOCATED APPROXIMATELY 136 INCHES FROM INBOARD EDGE AND 6 INCHES UP FROM TRAILING EDGE. INSTALLED REPAIR DOUBLER PER SRM 51-70-06.SDR AALA20121205008Structure · dentedDENTS 46 INCHES OUTBOARD OF STATION XTE 173 AND FORWARD OF TRAILING EDGE. INSTALLED DOUBLER ON ELEVATOR PER SRM 51-70-06.SDR AALA20121203009Structure · dentedLEFT ELEVATOR HAS 2 DENTS 35 INCHES OUTBOARD OF STATION XET 80 AND 8 INCHES FORWARD OF TRAILING EDGE. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121203006Skin · dentedLEFT ELEVATOR TOP SKIN HAS THREE DENTS LOCATED APPROXIMATELY 10 INCHES OUTBOARD OF STATION XET 46 AND 9 INCHES FORWARD OF TRAILING EDGE OF ELEVATOR. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121130022Skin · damagedRIGHT ELEVATOR TOP SKIN HAS DENTS LOCATED APPROXIMATELY 130 INCHES FROM INBOARD END AND 10 INCHES UP FROM TRAILING EDGE. INSTALLED REPAIR DOUBLER PER SRM 51-70-06.SDR AALA20121130015Skin · dentedRIGHT ELEVATOR TOP SKIN HAS DENTS APPROXIMATELY 32 INCHES FROM INBOARD EDGE AND UP 5 INCHES FROM TRAILING EDGE. INSTALLED REPAIR DOUBLER PER SRM 51-70-06.SDR AALA20121130014Skin · dentedRIGHT ELEVATOR TOP SKIN HAS 3 DENTS APPROXIMATELY 45 INCHES FROM INBOARD END AND 7 INCHES FROM TRAILING EDGE OF ELEVATOR. INSTALLED REPAIR DOUBLER PER SRM 51-70-06.SDR AALA20121130013Structure · damagedDENTS APPROXIMATELY 28 INCHES FROM INBOARD EDGE AND 20 INCHES FROM TRAILING EDGE. INSTALLED DOUBLER ON RIGHT ELEVATOR SRM 51-70-06.SDR AALA20121130006Structure · damagedDENTS 30 INCHES INBOARD OF STATION XET 26 AND 9 INCHES FORWARD OF TRAILING EDGE. INSTALLED DOUBLER ON ELEVATOR PER SRM 51-70-06.SDR AALA20121201001Light · inoperativeLEFT NUMBER 1 DOOR PORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY. OPS CHECK NORMAL.SDR AALA20121130009Drain Pan · corrodedSUBFLOOR UNDER G-1 DRAIN PAN IS CORRODED. INSTALLED DOUBLER UNDER G-1 GALLEY DRAIN PAN PER AARD 53-20-00-16.SDR AALA20121203008Skin · dentedLEFT ELEVATOR TOP SKIN HAS 2 DENTS LOCATED APPROXIMATELY 2 INCHES OUTBOARD OF STATION XET 65 AND 11 INCHES FORWARD OF TRAILING EDGE. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121129029Intercostal · crackedCEILING INTERCOSTAL CRACKED AT STATION 774, CENTER. INSTALLED NEW INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20121129019Tee Fitting · scratchedSCRATCHES IN RADIUS OF RIGHT AFT PRESSURE BULKHEAD T CHORD, IN RIGHT AFT LAVATORY AREA, ON AFT SIDE OF FRAME, BETWEEN LONGERONS 8 AND 17 RIGHT. INSTALLED RIGHT AFT PRESSURE BULKHEAD T CHORD PER SRM 53-03-00 FIGURE 37A AND EA MD80-53-02755.SDR AALA20121129018Frame · crackedCUT BELL FRAME ANGLE BETWEEN LONGERONS 4 AND 5 RIGHT AT STATION 1338, FOR OTHER MAINTENANCE. INSTALLED BELL FRAME REPAIR ANGLE AND BELL FRAME REPAIR STRAP PER SRM 53-03-00 FIGURE 14 AND EA MD80-53-027258.SDR AALA20121129017Skin · damagedLOWER DORSAL LEADING EDGE REQUIRES DOUBLER AT STATION ZFS 52.267 DUE TO 9 HOLES BEING TO DEEP FOR REPAIR BUSHINGS. INSTALLED REPAIR DOUBLER PER SRM 55-03-00 PARAGRAPH 28.SDR AALA20121203011Skin · dentedLEFT ELEVATOR TOP SKIN HAS 3 DENTS LOCATED APPROXIMATLEY 34 INCHES INBOARD OF STATION XET 173 AND 56 INCHES FORWARD OF TRAILING EDGE OF ELEVATOR. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121203010Structure · dentedLEFT ELEVATOR HAS 3 DENTS LOCATED APPROXIMATELY 34 INCHES OUTBOARD OF STATION XET 80 AND 9 INCHES FORWARD OF TRAILING EDGE. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121129002Battery Pack · not seatedRIGHT CENTER CEILING EMERGENCY LIGHTS BETWEEN AFT LAVATORIES INOPERATIVE. RESEATED BATTERIES ON RIGHT AFT LAVATORY FORWARD BATTERY PACK. OPS CHECK NORMAL.SDR AALA20121128009Longeron · corrodedCORROSION ON LONGERON 27 LEFT FROM STATIONS 1286 TO 1288. INSTALLED LONGERON SPLICE PER SRM 53-02-00.SDR AALA20121128008Support Angle · crackedSTATION 927, LEFT SIDE BELOW NUMBER 2 SEAT TRACK HAS VERTICAL ANGLE CRACKED AT LOWER SIDE. INSTALLED REPLACEMENT ANGLE PER AARD 53-00-05-1.SDR AALA20121128001Duct · rupturedDFW - CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED DURING CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED Y DUCT AT RIGHT SIDE PACK BAY THAT WAS RUPTURED. SYSTEM GROUND SDR AALA20121128003Skin · crackedSKIN AT INBOARD CORNER OF LEFT RADOME HINGE IS CRACKED. INSTALLED DOUBLER PER SRM 53-05-00 FIGURE 77.SDR AALA20121127022Skin · damagedGRIND MARKS IN SKIN FROM STATIONS 1363 TO 1367 ABOVE LONGERON 4 LEFT. INSTALLED DOUBLER PER SRM 53-01-00 FIGURE 4.SDR AALA20121127021Skin · dentedDENT WITH GOUGE IN FUSELAGE SKIN AT STATION 1304 LONGERON 19 RIGHT. INSTALLED DOUBLER PER SRM 53-04-02.SDR AALA20121127020Beam · corrodedMID CARGO DOOR BEAM CORRODED FROM STATIONS 645 TO 674, LONGERON 28 RIGHT. REMOVED CORROSION AND INSTALLED FULL LENGTH DOUBLER PER AARD 53-10-00-3.SDR AALA20121127012Skin · damagedLEFT WING TRAILING EDGE: DAMAGE TO BOTTOM SIDE OF INBOARD FLAP, OUTBOARD WEDGE, INBOARD END. INSTALLED NEW SKIN REPAIR PER SRM 51-70-06.
Back to Mcdonnell Douglas DC-9-82