N982AX, cancelled Mar 8, 2018
Service difficulty reports · 131
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
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 n_number = 'N982AX' AND deregistration_id = 'N982AX-2018-03-08' 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 n_number = 'N982AX' AND deregistration_id = 'N982AX-2018-03-08' 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 ABXA9801175Shear-Tie · crackedDURING C-CHECK, FOUND FRAME SHEAR-TIE CRACKED AT STATION 945 BETWEEN LONGERONS 15R AND 16R. REPLACED SHEAR-TIE IAW DC9 SRM 51-30-5.SDR ABXA9801174Shear-Tie · crackedDURING C-CHECK, FOUND FRAME SHEAR-TIE CRACKED AT STATION 980 AND LONGERON 14R. REPLACED SHEAR-TIE IAW DC9 SRM 51-30-2 AND 51-30-5.SDR ABXA9801173Shear-Tie · crackedDURING C-CHECK, FOUND FRAME SHEAR-TIE AT STATION 980 AND LONGERON 14L CRACKED. REPLACED SHEAR-TIE IAW DC9 SRM 51-30-2 AND 51-30-5.SDR ABXA9801172Stiffener · crackedDURING C-CHECK, FOUND STIFFENER ON LONGERON 28L, STATION 760, CRACKED. REPLACED STIFFENER IAW DC9 SRM 51-30-2, 51-30-5 AND DC9 SRM DWG 5956040.SDR ABXA9801171Stiffener · crackedDURING C-CHECK, FOUND STIFFENER ON LONGERON 30 AT STATION 760 CRACKED. REPAIRED STIFFENER IAW DC9 SRM DWG K05159.SDR ABXA9801170Stiffener · crackedDURING C-CHECK, FOUND STIFFENER ON LONGERON 28R, AT STATION 760 CRACKED. INSTALLED NEW STIFFENER IAW DC9 SRM 51-30-2 AND 57-30-5.SDR ABXA9801168Longeron · crackedDURING C-CHECK, FOUND LONGERON 30 CRACKED AT SPLICE BETWEEN STATION 794 TO 813. REPAIRED LONGERON IAW DC9 SRM 53-02.SDR ABXA9801167Longeron · crackedDURING C-CHECK, FOUND LONGERON 25L CRACKED AT STATION 160. REPAIRED LONGERON IAW DC9 SRM 53-02.SDR ABXA9801166Longeron · crackedDURING C-CHECK, FOUND LONGERON 24L CRACKED AT STATION 200. REPAIRED IAW DC9 SRM 53-02.SDR ABXA9801165Longeron · crackedDURING C-CHECK, FOUND LONGERON 16R CRACKED AT STATION 945. REPAIRED LONGERON IAW DC9 SRM 53-02.SDR ABXA9801164Longeron · crackedDURING C-CHECK, FOUND LONGERON 12R CRACKED AT STATION 965. REPAIRED LONGERON IAW DC9 SRM DWG K05864.SDR ABXA9801163Longeron · crackedDURING C-CHECK, FOUND LONGERON 2R CRACKED AT STATION 1076. REPAIRED LONGERON 2R IAW DC9 SRM 53-02.SDR ABXA9801148Bulkhead Web · corrodedDURING C-CHECK, FOUND LEFT PYLON BULKHEAD FORWARD LOWER SIDE CORRODED. REPLACED WEB ON PYLON BULKHEAD IAW DC9 SRM 51-30-2, 51-30-5, AND 51-30-1.SDR ABXA9801147Fitting · crackedDURING C-CHECK, FOUND CENTER WING FORWARD SPAR ATTACH FITTING AT STATION 600 AND LONGERON 24R CRACKED. REPLACED FITTING IAW DC9 SRM 51-30-5.SDR ABXA9801146Angle · crackedDURING C-CHECK, FOUND VERTICAL STABILIZER ATTACH ANGLE RIGHT SIDE CRACKED AT LOWER AFT CORNER. REPAIRED ANGLE IAW DC9 SRM 51-30-2 AND 51-30-5.SDR ABXA9801145Blkhd Fitting · crackedDURING C-CHECK, FOUND RIGHT PYLON BULKHEAD AT STATION 965 INBOARD ATTACH FITTING CRACKED. REPLACED FITTING IAW DC9 SRM 51-30-1 AND 51-30-5.SDR ABXA9801144Fitting · crackedDURING C-CHECK, FOUND LEFT FLAP OUTBOARD HINGE INTERNAL ATTACH FITTING CRACKED. REPLACED FITTING IAW DC9 SRM 51-30-1 AND 51-30-2.SDR ABXA9801143Skin · crackedDURING C-CHECK, FOUND INTERNAL FUSELAGE SKIN AT STATION 1080 CRACKED BETWEEN LONGERON 1R AND 2R. REPAIRED IAW DC9 SRM 53-04.SDR ABXA9801142Skin · crackedDURING C-CHECK, FOUND SKIN CRACKED AT STATION 194, LONGERON 22L. REPAIRED SKIN IAW ABX EA 53300001-003.SDR ABX9801162Longeron · crackedDURING C-CHECK, FOUND LONGERON 2L CRACKED AT STATION 1076. REPAIRED LONGERON IAW DC9 SRM 53-02.SDR ABXA9801090Web · crackedDURING C-CHECK, FOUND RIGHT CUSP WEB CRACKED UNDER FLOOR TRACK AT RBL 54, STATION 658. REPAIRED IAW DC9 SRM 53-01.SDR ABXA9801089Angle · crackedDURING C-CHECK, FOUND VERTICAL ANGLE/BRACKET CRACKED ON OUTBOARD SIDE OF NR 2 PYLON, UNDER THROTTLE CONDUIT JAM NUT. REPLACED BRACKET/ANGLE IAW DC9 SRM.SDR ABXA9801088Floorbeam · crackedDURING C-CHECK, FOUND FLOORBEAM AT STATION 680 AND LBL 54 CRACKED. REPLACED FLOORBEAM IAW DC9 SRM 51-30-1, 51-30-2, AND 51-30-5.SDR ABXA9801087Support · crackedDURING C-CHECK, FOUND FLOORBEAM SUPPORT CRACKED STATION 680 AND RBL 44. REPLACED SUPPORT FITTING IAW DC9 SRM 51-30-1 AND 51-30-2.SDR ABXA9801086Bulkhead Fitting · crackedDURING C-CHECK, FOUND AFT PRESSURE BULKHEAD DOOR JAMB FITTING CRACKED JUST ABOVE DOOR WARNING SWITCH. REPLACED FITTING IAW DC9 SRM 51-30-5.SDR ABXA9801085Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM AT STATION 965 CORRODED FROM LBL 22 TO LBL 44. REPAIRED FLOORBEAM IAW ABX REA D953-25565MR.SDR ABXA9800827Batteries · dischargedWHEN TESTING EMERGENCY LIGHTS, LIGHTS WENT FROM DIM TO OFF IN 5 SECS. REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERIES.SDR ABXA9800358Switch · defectiveWHEN LANDING GEAR WAS PLACED DOWN, THREE GREEN LIGHTS AND THE GEAR DOOR OPEN LIGHT REMAINED ON. REPLACED MAIN LANDING GEAR DOOR POSITION SWITCH.SDR ABXA9700545Bulb · deformedWHEN SELECTING GEAR HANDLE TO NEUTRAL DURING UPLOCK CHECK, THE LEFT MAIN GEAR GREEN LIGHT CAME ON. RECYCLED GEAR AND LIGHT STAYED ON. CHECKED PROXIMITY SWITCH LIGHT AND LIGHT WAS OFF WITH GEAR UP. VERIFIED, FOUND DEFORMED BULB IN LEFT MLG (GREEN) LIGHT SOCSDR ABXA9700065Seat Track · wornDURING C-CHECK INSPECTION, FOUND UPPER CARGO COMPARTMENT SEAT TRACKS LOBES WORN BEYOND LIMITS. INSERT REPAIR INSTALLED IAW ABX EA 53470018.SDR ABXA9700064Frame · corrodedDURING C-CHECK, FOUND FRAME FLANGE CORRODED BEYOND LIMITS AT STATION 851 LONGERONS 5 TO 6 RIGHT. REMOVED CORROSION, REPAIRED FRAME IAW ABX SUPPLEMENTAL SRM DWG K05159.SDR ABXA9700063Frame · crackedDURING C-CHECK INSPECTION, FOUND CANTED FRAME WEB STA 1121 CRACKED. REPAIRED WEB IAW DC9 SRM 53-01.SDR ABXA9700062Frame · crackedDURING C-CHECK INSPECTION, FOUND CRACKED FRAME STA 699 LEFT. REPLACED FRAME IAW DC9 SB 53-131.SDR ABXA9700433Skin · crackedFOUND THE FUSELAGE SKIN AT STA 965 LONGERON 13 AND 14 LEFT TO BE CRACKED AND TORN. REPAIRED AREA IAW ABX REA D953-18818-MR.SDR ABXA9700432Skin · crackedDURING C-CHECK, FOUND FUSELAGE SKIN, AT STA 965 LONGERON 13 TO 14 RIGHT, TO BE CRACKED AND TORN. REPAIR WAS ACCOMPLISHED IAW ABX REA D953-18818-MR.SDR ABXA9700067Skin · crackedDURING C-CHECK INSPECTION, FOUND REPAIR ON FUSELAGE SKIN STATION 965, LONGERON 13 TO 14 RIGHT TO BE BENT AND DISTORTED. INSTALLED REPAIR DOUBLER PER ABX REA D953-18792-MR.SDR ABXA9700066Skin · crackedDURING C-CHECK INSPECTION, FOUND REPAIR ON FUSELAGE SKIN AT STATION 965, LONGERON 13 T0 14 LEFT TO BE BENT AND DISTORTED. INSTALLED DOUBLER REPAIR IAW REA DC953-18792-MR.SDR ABXA9700061Rib · crackedDURING C-CHECK INSPECTION, FOUND LEFT HAND HORIZONTAL STABILIZER INBOARD LEADING EDGE HAS A CRACKED RIB ON LOWER AFT END SECOND RIB FROM INBOARD. REPAIRED CRACKED RIB IAW DC9 SRM 55-02.SDR ABXA9700060Rib · crackedDURING C-CHECK INSPECTION, FOUND TWO LEADING EDGE PANEL RIBS CRACKED. REPAIRED LEADING EDGE RIBS IAW DC9 SRM 55-01.SDR ABXA9700385Skin · excess blendoutDURING C INSPECTION, FOUND A DEEP BLENDOUT ON NR 1 SLAT DRIVE TRACK CUTOUT IN LEADING EDGE SKIN. REPAIRED IAW ABX REA D957-18774.SDR ABXA9700931Spoiler · corrodedLEFT OUTBOARD SPOILER CORRODED AND CRACKED. REPLACED ALL HONEYCOMB CORE, DOUBLERS AND SKIN.SDR ABXA9700068Frame · crackedDURING C-CHECK INSPECTION, FOUND SEVERE DENT AND CRACK AT STATION 945, LONGERON 5 RT. INSTALLED NEW FRAME SEGEMENT AT STATION 945 IAW DC9 SRM 51-30-02, 51-30-05.SDR ABXA9700028Coalescer · dirtyAFTER TAKEOFF, GOT OIL SMELL IN COCKPIT, ALL INSTRUMENT INDICATIONS WERE NORMAL. REPLACED LEFT AND RIGHT COALESCER BAGS.SDR ABXA9700008Uplatch Mech · lack of lubeUNSATISFACTORY UPLATCH CHECK DEPARTING. LEFT MAIN LANDING GEAR GREEN LIGHT ON BRIGHT, NO GEAR DOOR OPEN LIGHT. RECYCLED LANDING GEAR, SECOND UPLATCH CHECK WAS SATISFACTORY. LUBED LEFT MAIN LANDING GEAR AND LEFT MAIN LANDING GEAR UPLATCH MECHANISM. PERFORMESDR ABXA9600384Skin · gougedDURING C INSPECTION, FOUND A DEEP GOUGE IN NR 2 SLAT DRIVE TRACK CUTOUT IN LEADING EDGE SKIN. REPAIRED IAW ABX REA D957-18788.SDR ABXA9500962Jamb · dentedDURING C-CHECK INSPECTION, FOUND SERVICE DOOR JAMB DENTED. REPAIRED IAW ABX REA D953-12952-MR.SDR ABXA9500980Intercostal · damagedDURING C-CHECK INSPECTION, FOUND MISDRILLED HOLES IN THE INTERCOSTAL AT STA 370, LONGERON 28R. REPAIRED IAW ABX REA D953-13047-MR.SDR ABXA9500979Former · misdrilledDURING C-CHECK INSPECTION, FOUND MISDRILLED HOLES IN THE FORMER AT STA 370, LONGERON 28R. REPAIRED IAW ABX REA D953-13047-MR.SDR ABXA9500955Doubler · corrodedDURING C-CHECK INSPECTION, FOUND EXCESSIVE CORROSION ON AFT LOWER CARGO DOOR DOUBLER. REPAIRED DOUBLER IAW ABX REA D953-12953-MR.SDR ABXA9500954Skin · corrodedDURING C-CHECK INSPECTION AND PSE INSPECTION 53.09.035A, AD 94-03-01, FOUND EXCESSIVE CORROSION ON THE FUSELAGE SKIN. REPAIRED SKIN IAW ABX REA D953-12953-MR.
Back to N982AX, cancelled Mar 8, 2018