N908AX, cancelled Mar 31, 2016
Service difficulty reports · 110
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 = 'N908AX' AND deregistration_id = 'N908AX-2016-03-31' 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 = 'N908AX' AND deregistration_id = 'N908AX-2016-03-31' 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 ABXA000496Skin · crackedFUSELAGE SKIN CRACKED AND BULGED AT FS 990L. MAINTENANCE REPAIRED THE DAMAGE IAW ABX REA 953-38967.SDR ABXA000464Battery · dischargedDURING PRE-DEPARTURE CHECK, COCKPIT EMERGENCY LIGHTS WERE INOPERATIVE. REPLACED EMERGENCYLIGHTS POWER SUPPLY BATTERIES.SDR ABXA9900350Latch · lack of lubeCOCKPIT DOOR WOULD NOT OPEN FROM CABIN SIDE. LUBRICATED COCKPIT DOOR LATCH MECHANISM, OPS CHECKED GOOD.SDR ABXA9900270Vane · delaminatedRIGHT FLAP INBOARD FIXED VANE DELAMINATED 2 PLACES ON LOWER SURFACE. REPLACED VANE ASSEMBLY IAW DC9 MM 27-51-3.SDR ABXA9900269Fitting · crackedKEEL WEB FORWARD ATTACH ANGLE FITTING CRACKED AT LEFT SIDE. REPLACED ANGLE IAW DC9 SRM 51-30-3 AND 51-30-1.SDR ABXA9900304Longeron · crackedLONGERON 16 RIGHT WAS CRACKED AT STATION 905. REPAIRED IAW DC9 SRM 53-02.SDR ABXA9900302Longeron · crackedLONGERON 20 LEFT CRACKED AT AFT END OF TRAPEZOIDAL PANEL. REPAIRED LONGERON IAW DC9 SRM 53-02.SDR ABXA9900301Floorbeam · crackedFLOORBEAM CRACKED AT STATION 351 BL 0 TO LBL 5. REPAIRED FLOORBEAM IAW ABX REA D953-27445MR.SDR ABXA9900300Longeron · crackedLONGERON 12 RIGHT CRACKED AT STATION 965. REPAIRED LONGERON IAW DC9 SRM 53-02.SDR ABXA9900299Shear Tie · crackedSHEAR TIE FORMER CRACKED AT STATION 980 BELOW LONGERON 14 RIGHT. REPLACED SHEAR TIE IAW DC9 SRM 53-30-02.SDR ABXA9900298Longeron · crackedLONGERON 18R CRACKED AT FRAME STATION 996. REPLACED ANGLE IAW DC9 SRM 51-30-5.SDR ABXA9900297Frame · crackedFRAME AT STATION 980 CRACKED AT LONGERON 16 LEFT. REPAIRED FRAME IAW DC9 SRM 53-03 AND DACO DWG 9958238.SDR ABXA9900271Trapezoid Panel · crackedLEFT TRAPEZOIDAL PANEL UPPER OUTBOARD FLANGE CRACKED STARTING AT 6TH FASTENER HOLE RUNNING THROUGH 8TH FASTENER HOLE INTO RADIUS OF THE VERTICAL FLANGE. REPLACED TRAPEZOIDAL PANEL IAW DC9 S/B'S 53-10D, 53-115 AND 53-182.SDR ABXA9900309Frame · crackedFUSELAGE FRAME CRACKED AT STATION 389 AND LONGERON 5 RIGHT. REPAIRED FRAME IAW DC9 SRM 53-03.SDR ABXA9900308Longeron · crackedLONGERON 13 LEFT CRACKED AT STATION 965 LOWER ATTACH BOLT. REPAIRED LONGERON IAW DC9 SRM 53-02.SDR ABXA9900307Shear Tie · crackedFUSELAGE FRAME SHEAR TIE CRACKED BELOW LONGERON 15 LEFT AT STATION 945. REPLACED SHEAR TIE IAW DC9 SRM 51-10-4 AND 51-30-2.SDR ABXA9900306Longeron · crackedLONGERON 3 RIGHT CRACKED AT STATION 718. REPAIRED LONGERON IAW DC9 SRM 53-02.SDR ABXA9900305Longeron · crackedLONGERON 17 RIGHT CRACKED AT STATION 945. REPAIRED IAW DC9 SRM 53-02.SDR ABXA9800499Door · unserviceableCOCKPIT ENTRY DOOR WAS DIFFICULT TO OPEN AND CLOSE. REPLACED COCKPIT ENTRY DOOR, OPS CHECKED GOOD.SDR ABXA9701470Window · out of adjustDURING PRE-DEPARTURE CHECK, FOUND THE FIRST OFFICER'S CLEARVIEW WINDOW (EMERG EXIT) WOULD NOT UNLOCK. ADJUSTED FORE AND AFT ADJUSTMENT STOPS TO UPPER TRACK IAW DC9 MM 56-10-3.SDR ABXA9701466Window · out of adjustFIRST OFFICER'S CLEAR VIEW WINDOW (EMERG EXIT) WOULD NOT OPEN. READJUSTED THE FIRST OFFICER'S WINDOW IAW DC9 MM CHAPTER 56.SDR ABXA9701409Window Lock · out of adjustFIRST OFFICER'S CLEARVIEW WINDOW WOULD NOT OPEN. CAPTAIN'S CLEARVIEW WINDOW WOULD NOT OPEN FULLY. ADJUSTED UPPER LOCK ON THE FIRST OFFICER'S CLEARVIEW WINDOW. RESECURED TRIM ON CAPTAIN'S CLEARVIEW WINDOW.SDR ABXA9701350Pressure Panel · crackedDURING C-CHECK, FOUND THE UPPER PRESSURE PANEL STA 83 CRACKED AT THE LEFT CUSP. REPAIRED PRESSURE PANEL IAW DC-9 SB 53-187.SDR ABXA9701332Bracket · corrodedDURING C-CHECK, FOUND THE RT OUTBOARD SPOILER CONTROL BRACKET ASSEMBLY CORRODED. REMOVED AND REPLACED THE SPOILER CONTROL BRACKET IAW DC9 MM 20-16-0 AND 27-60-0.SDR ABXA9701331Panel · separatedDURING C-CHECK, FOUND THE LT OUTBOARD SPOILER PANEL SEPARATED AT THE CENTER FITTING. REMOVED AND REPLACED THE OUTBOARD SPOILER PANEL IAW ABX DC9 MM SUPP 27-61-1.SDR ABXA9701292Cusp Web · crackedDURING C-CHECK, FOUND THE LEFT CUSP WEB CRACKED BETWEEN FS 598 AND 617. REPAIRED CUSP WEB IAW DC-9 SRM 53-01.SDR ABXA9701291Frame · crackedDURING C-CHECK, FOUND THE RT MAIN FRAME AT FS 699 FORWARD UPPER FLANGE CRACKED AT THE SEAT TRACK ATTACH ZEE ANGLE OUTBOARD ATTACH HOLE. REPAIRED THE MAIN FRAME IAW DC-9 SB 53-131 AND ABX REA D953-202248-MR. (REPAIR DOUBLER PN 5935650 INSTALLED).SDR ABXA9701290Frame · corrodedDURING C-CHECK, FOUND STA 889 FRAME EXFOLIATED BETWEEN LONGERONS 21L AND 23L. *S/D* REPLACED FRAME IAW DC9 SRM 51-30-2 AND 51-30-5.SDR ABXA9701272Bracket · crackedDURING C-CHECK, FOUND THE RT FLAP FOLLOW-UP PULLEY UPPER BRACKET AT FLAP HINGE 164 CRACKED. *S/D* REPLACED BRACKET IAW DC9 MM 20-10-1.SDR ABXA9701271Bulkhead Web · crackedDURING C-CHECK, FOUND THE RT SIDE BULKHEAD WEB AT FS 37 CRACKED AT A RIVET. *S/D* REPAIRED WEB IAW DC9 SRM 53-01.SDR ABXA9701270Fitting · crackedDURING C-CHECK, FOUND THE OUTBOARD SPOILER TORSION BAR OUTBOARD SUPPORT FITTING CRACKED AT THE UPPER END. *S/D* REPLACED TORSION BAR IAW DC9 SRM 51-30-1 AND 51-30-8.SDR ABXA9701269Frame · crackedDURING C-CHECK, FOUND THE RT MAIN FRAME AT FS 699 FWD UPPER FLANGE CRACKED AT THE SEAT TRACK ATTACH ZEE ANGLE OUTBOARD ATTACH HOLE. *S/D* REPAIRED IAW DC9 SRM 51-30-2.SDR ABXA9701268Tr Link · crackedDURING C-CHECK, FOUND THE NR 1 ENGINE THRUST REVERSER LOWER INBOARD DRIVE LINK CRACKED AT THE FORWARD GREASE FITTING. *S/D* REPLACED DRIVE LINK IAW DC9 MM 78-31-5.SDR ABXA9701267Cusp Web · crackedDURING C-CHECK, FOUND THE LT CUSP WEB CRACKED BETWEEN FS 598 AND 617. *S/D* REPAIRED CUSP WEB IAW DC9 SRM 51-30-1 AND 51-30-2.SDR ABXA9701266Pressure Panel · crackedDURING C-CHECK, FOUND THE UPPER PRESSURE PANEL CRACKED TWO PLACES AT FS 83 AT THE LT CUSP AND RT CUSP. *S/D* REPAIRED IAW DC9 SRM 53-21-0.SDR ABXA9701264Longeron · crackedDURING C-CHECK, FOUND APPROXIMATE 6 INCH CRACK IN THE FLANGE OF LONGERON 30 AT STA 362. *S/D* REPLACED LONGERON FROM FS 354 TO 409 IAW DC9 SRM 53-02.SDR ABXA9701263Angle · crackedDURING C-CHECK, FOUND THE TOP ANGLE FOR THE 4TH WEB FORWARD FROM THE END OF THE LT PYLON TRAILING EDGE CRACKED. *S/D* REPAIRED IAW DC9 SRM 54-50.SDR ABXA9701262Intercostal · crackedDURING C-CHECK, FOUND THE UPPER CARGO COMPARTMENT FLOORBEAM INTERCOSTAL CRACKED ON THE AFT SIDE OF FLOORBEAM AT FS 218 AND BL 0. *S/D* REPAIRED IAW DC9 SRM 53-15-0.SDR ABXA9701261Intercostal · crackedDURING C-CHECK, FOUND THE UPPER CARGO FLOORBEAM INTERCOSTAL CRACKED AT THE FORWARD SIDE OF THE FLOORBEAM AT FS 256 AND THE ZERO BUTT LINE. *S/D* REPAIRED IAW DC9 SRM 53-15-0.SDR ABX9701265Floor Panel · crackedDURING C-CHECK, FOUND THE FLOOR PANEL AT STA 218 BETWEEN SEAT TRACK BL 0.0 AND RBL 9.0 CRACKED. REPAIRED IAW DC9 SRM 53-21-0.SDR ABXA9701116Window · stuckFIRST OFFICER'S CLEARVIEW WINDOW WOULD NOT OPEN. (EMERGENCY COCKPIT EXIT). OPENED AND CLOSED FIRST OFFICER'S WINDOW SEVERAL TIMES. OPS CHECKED NORMAL.SDR ABXA9700451Window · lack of lubeFIRST OFFICER'S CLEARVIEW EMERGENCY EXIT WINDOW WOULD NOT OPEN. CLEANED AND LUBED UPPER LOCKING MECHANISM, OPERATION CHECKS GOOD IAW DC-9 MM 56-10-3.SDR ABXA9600671Unsafe Light · illuminatedUPON GEAR RETRACTION, LEFT GEAR UNSAFE LIGHT WOULD NOT EXTINGUISH. FERRIED AIRCRAFT FROM MEM TO ILN. WORK IN PROGRESS AT THIS TIME.SDR ABXA9600670Roller Assy · defectiveDURING GEAR UPLATCH CHECK, LEFT GEAR UNSAFE LIGHT ILLUMINATED AND COULD NOT BE EXTINGUISHED USING THE ABNORMAL PROCEDURE. REPLACED LEFT MAIN LANDING GEAR DOOR LATCH ROLLER ASSEMBLY IAW DC9 OHM 32-11-5, OPS CHECKED GOOD.SDR ABXA9600668Bushing · wornRIGHT GEAR UNSAFE LIGHT WOULD NOT GO OUT IN FLIGHT. COMPLETED ABNORMAL PROCEDURE BUT GEAR LIGHT WOULD NOT GO OUT. REPLACED RIGHT MAIN LANDING GEAR DOOR HINGE BUSHING AND ADJUSTED THE MAIN LANDING GEAR DOOR LATCH ASSEMBLY IAW DC-9 MM 32-31-4.SDR ABXA9600667Connector · corrodedRIGHT GEAR UNSAFE LIGHT CAME ON DURING UPLATCH CHECK, RECYCLED GEAR, LIGHT WAS STILL ON, RIGHT HYDRAULIC SYSTEM 3000 PSI.\N\N\N\N\NCLEANED WIRING TERMINALS AT TERMINAL STRIP IN RIGHT WING ROOT. LUBRICATED GEAR. PERFORMED GEAR INDICATION TEST IAW DC-9 SUPP M.M.SDR ABXA9600666Batteries · dischargedON PRE-DEPARTURE CHECK, FOUND COCKPIT EMERGENCY LIGHTING INOPERATIVE. REPLACED EMERGENCY LIGHTING BATTERIES IAW DC-9 M.M. 33-10-00.SDR ABXA9600336Spar Cap · corrodedDURING C-CHECK INSPECTION, FOUND RIGHT WING AFT SPAR LOWER CAP CORRODED 12 INCHES FROM THE OUTBOARD AILERON HINGE. REPAIRED IAW DC-9 SRM 57-09, FIGURE 11 AND ABX REA D957-14179.SDR ABXA9600334Pressure Panel · corrodedDURING C-CHECK INSPECTION, FOUND CORROSION ON THE PRESSURE PANEL BETWEEN RBL 37 AND LBL 37 STA 737 TO 756. REPAIRED IAW ABX REA D953-14154-MR.SDR ABXA9600331Seat Track · crackedDURING C-CHECK INSPECTION, FOUND THE MAIN CABIN SEAT TRACKS CRACKED, WORN AND CORRODED AT PERMANENT LOCK ATTACH POINTS. REPAIRED IAW ABX REA RE-14184-MR.
Back to N908AX, cancelled Mar 31, 2016