N956AN
Service difficulty reports · 190
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 = 'N956AN' AND registry_match = 'registration' 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 = 'N956AN' AND registry_match = 'registration' 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 AALA20181029008Shield · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION FOUND ON FORWARD CARGO RIGHT HAND TRANSITION (SHIELD) PANEL LOCATED AT STA 500-500A. REPLACED TRANSITION PANEL (SHIELD) PER SRM 51-10-2 PAR 9 AND DRAWING 143A8126-30.SDR AALA20181029007Shield · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION FOUND ON RIGHT HAND FORWARD CARGO TRANSITION PANEL LOCATED BETWEEN STA 420-440. REPLACED TRANSITION PANEL (SHIELD) PER SRM 51-10-02 PAR 9 AND DRAWING 143A8126-30.SDR AALA2018103090006Angle · corrodedCORROSION ON L2 CREASE ANGLE BETWEEN BS 893 TO 1016, LBL 51. REPLACED THE ANGLE IAW 51-00-05.SDR AALA2018103009004Web · corrodedCORROSION ON LEFT WEB BETWEEN BS 986 TO 1016, LBL 51. REPLACED THE WEB IAW 51-00-05.SDR AALA201810309003Angle · corrodedCORROSION FOUND ON THE R2 CREASE ANGLE BETWEEN BS 893 TO 1016, RBL 51. REPLACED THE ANGLE IAW 51-00-05.SDR AALA201810306003Support · corrodedCORROSION FOUND ON THE LEFT GALLEY SUPPORT, BETWEEN BS 986 TO 1016, LBL 35. REPLACED THE SUPPORT IAW 51-00-05.SDR AALA201810296007Floorbeam · corrodedCORROSION FOUND ON THE LOWER LIP OF THE RIGHT FLOORBEAM BS 992.8, RBL 32 - 48, REPLACED THE FLOORBEAM ANGLE IAW 51-00-05.SDR AALA201810296006Web · corrodedCORROSION FOUND ON THE RIGHT SUBFLOOR WEB JUST AFT OF FLOORBEAM BETWEEN BS 986 - 992.8, RBL 32-48. REPLACED THE WEB IAW 51-00-05.SDR AALA201810296005Support · corrodedCORROSION FOUND ON THE GALLEY SUPPORT BETWEEN BS 992.8 - 1006, RBL 35. REPLACED THE SUPPORT IAW 51-00-05.SDR AALA20181026004Floor Support · corrodedCORROSION ON THE TOP FACE OF THE FLOOR SUPPORT BETWEEN BS 986.5 TO 1006, RBL 30. REPLACED THE FLOOR SUPPORT IAW 51-00-0505-1, PRINT 147A5700, AND SRM 51-40-02.SDR AALA2018102690003Angle · corrodedCORROSION FOUND ON THE G4 ZEE ANGLE BETWEEN BS 986 TO 1016, LBL 35. REPLACED THE ANGLE IAW 51-00-05, AND PRINT 147A8501.SDR AALA20181026002Floor Support · corrodedCORROSION FOUND ON THE FLOOR SUPPORT BETWEEN BS 947 TO 967, RBL 25. REPLACED THE FLOOR SUPPORT IAW 51-40-02.SDR AALA201810265003Angle · corrodedCORROSION WAS FOUND ON R1 DOOR CREASE ANGLE AT BS 312 - 328, RBL 51. REPLACED THE CREASE ANGLE IAW 51-00-05.SDR AALA201810265009Transition Panel · corrodedCORROSION ON THE LT TRANSITION PANEL BETWEEN BS 467 TO 500I. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R, AND SRM51-10-2, PARAGRAPH 9.SDR AALA201810265006Transition Panel · corrodedCORROSION TO FORWARD CARGO RIGHT TRANSITION PANEL BETWEEN BS 500A TO 500I. REPLACED FORWARD CARGO RIGHT TRANSITION PANEL IAW SRM 53-00-53-2R, AND SRM 51-10-2 PARAGRAPH 9.SDR AALA201810254007Transition Panel · corrodedCORROSION ON AFT CARGO BAY RIGHT TRANSITION PANEL BETWEEN BS 847 AND 867. REPLACED THE TRANSITION PANEL IAW SRM 51-10-02 AND 51-00-05.SDR AALA201810254004Floorbeam · corrodedCORROSION ON THE CABIN FLOORBEAM AT BS 947.5 BETWEEN LBL 51 AND RBL 51. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-5.SDR AALA201810254003Angle · crackedA PREVIOUSLY REPAIRED ANGLE WAS FOUND TO BE CRACKED BETWEEN BS 291 AND 300 JUST FORWARD OF THE R1 DOOR, RBL 52. REPLACED THE ANGLE IAW 51-00-05 AND SRM 51-40-02.SDR AALA201810243003Floorbeam · corrodedCORROSION ON THE AFT CABIN FLOORBEAM, BS 987 BETWEEN LBL 51 AND RBL 51. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-4.SDR AALA201810232003Angle · corrodedCORROSION ON THE L1 DOOR THRESHOLD CREASE ANGLE BETWEEN BS 313 AND 348, LBL 52. REPLACED CREASE ANGLE IAW 51-00-05.SDR AALA201810232004Web · corrodedCORROSION ON THE AFT CARGO DOOR CUTOUT THRESHOLD WEB BETWEEN BS 793 AND 847, RBL 20 TO RBL 28. REPLACED THE THRESHOLD WEB IAW 51-00-05 AND SRM 51-40-02.SDR AALA201810198002Floor Support · crackedCRACKED CABIN FLOOR FLOOR SUPPORT BETWEEN BS 328 AND 348, LBL 46. REPLACED THE FLOOR SUPPORT IAW 51-00-05.SDR AALA201810198001Floor Support · crackedCRACKED CABIN FLOOR SUPPORT BETWEEN BS 312 AND 328, LBL 46. REPLACED THE FLOOR SUPPORT IAW 51-00-05.SDR AALA201808249005Actuator · inoperativeAFTER TAKEOFF LOST ALL STABILIZER TRIM FROM THE YOKE SWITCHES. TRIED USING AUTOPILOT, TRIM STILL INOPERATIVE. EMERGENCY WAS DECLARED AND LANDED WITHOUT FURTHER INCIDENT. THE AIRCRAFT WAS GROUNDED. REPLACED STABILIZER TRIM ACTUATOR. ACCOMPLISHED AN OPS CHECK. OSDR AALA2018080879018Bulkhead Web · crackedCRACK ON THE VAPOR BARRIER OF THE LEFT HAND WHEEL WELL. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9 & EA 283162. AIRCRAFT WAS GROUNDED.SDR AALA201802089015Light · detachedEMERGENCY LIGHT AT SEAT 30D IS DANGLING AND PULLED OUT. PERFORMED AN OPS CHECK AND INSTALLED THE SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY IAW MM 33-51-11. OK FOR FURTHER SERVICE.SDR AALA201710069007Lens · detachedEMERGENCY EXIT SIGN BY THE R4 DOOR HAS A DETACHED LENS. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201706139018Sign · missingEMERGENCY EXIT SIGN COVER MISSING AT 15DEF. REPLACED THE SIGN COVER, OK FOR SERVICE.SDR AALA201706129062Lens · missingEMERGNECY EXIT SIGN COVER MISSING AT 15DEF. INSTALLED A NEW SIGN, OK FOR SERVICE.SDR AALA201706129061Lens · brokenF/A REPORTED THE L2 DOOR EMERGENCY LIGHT LENS, ON SIDEWALL, BROKEN OFF. REPLACED THE SIDEWALL EXIT SIGN ASSY IAW AMM 33-51-01, OPS CHECKED GOOD. OK FOR SERVICE.SDR AALA20170529002Hose · rupturedDURING DESCENT AIRCRAFT EXPERIENCED HYDRAULIC SYSTEM A PSI LOSS. THE HYDRAULIC SYSTEM A ENGINE DRIVEN PUMP LIGHT ILLUMINATED. THE PUMP WAS SHUT OFF PER CHECKLIST. SYSTEM A HYDRAULIC QUANTITY EVENTUALLY DROPPED TO ZERO. DECLARED AN EMERGENCY AND LANDED WITHOSDR AALA201706089032Pressure Switch · faultyCENTER TANK FUEL PUMP LOW PRESSURE LIGHT DISAGREES WITH PUMP STATUS. MAINTENANCE REPLACED PRESSURE SWITCH IAW FIM 28-22-99-810-801, AND 28-22-00-810-802. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201705289014Pump · malfunctionedCENTER TANK FUEL PUMPS LOW PRESSURE LIGHT DISAGREES WITH PUMP STATUS. MAINTENANCE REPLACED CENTER FUEL PUMP IAW FIM 28-22-99-810-801, AND 28-22-00-810-802. ACCOMPLISHED SATISFACTORY OPS CHECK.SDR AALA20170118018Warning System · activatedAIRCRAFT WAS NOT GROUNDED. DURING TAKEOFF THE MASTER CAUTION AND AFT ENTRY DOOR LIGHTS ILLUMINATED. ABORTED TAKEOFF. CABIN CREW RECHECKED DOOR HANDLE. WARNING LIGHTS EXTINGUISHED. SUBSEQUENT TAKEOFF WAS UNEVENTFUL.SDR AALA20170113018Lens · missingEMERGENCY EXIT LIGHT OUTSIDE OF GALLEY WALL IS MISSING IT`S LENS. REMOVED AND REPLACED THE LIGHT IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170113019Slide · dislodgedL1 DOOR SLIDE FOUND DISLODGED FROM THE COVER. RESTORED SLIDE IAW AMM 25-66-00-840-801. OPERATIONAL CHECKED GOOD.SDR AALA20161220010Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE. CABIN FLOOR INTERCOSTAL CRACKED AT FUSELAGE STATION 328 TO 344 LBL 46. REMOVED AND REPLACED INTERCOSTAL IAW SRM 53-10-51-01-2 AND DRAWING 141A5410.SDR AALA20161219002Pressure Panel · crackedAIRCRAFT IN BASE MAINTENANCE. VERTICAL PRESSURE WEB CRACKED AT FUSELAGE STATION 663 LBL 40 TO LBL 45.64. REPAIRED IAW SRM 57-10-10-2R-3.SDR AALA20161219001Skin · crackedAIRCRAFT IN BASE MAINTENANCE. LEFT HORIZONTAL STABILIZER HAS 3 CRACKS IN LOWER SKIN ALONG OUTBOARD EDGE OF RIB AT HORIZONTAL STABILIZER STATION 120.3. REPAIRED IAW SRM 55-10-01-2-R11.SDR AALA20161214022Intercostal · crackedCRACKED INTERCOSTAL BETWEEN BS 312-328 AND LBL 46. REPLACED THE INTERCOSTAL.SDR AALA20161107046Power Supply · failedAIRCRAFT NOT GROUNDED. EMERGENCY LIGHTING POWER SUPPLY PACK M1673 FAILED. REMOVED AND REPLACED POWER SUPPLY IAW 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20161107045Power Supply · failedAIRCRAFT NOT GROUNDED. EMERGENCY LIGHTING POWER SUPPLY PACK M1672 FAILED. REMOVED AND REPLACED POWER SUPPLY IAW 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20161107044Power Supply · failedAIRCRAFT NOT GROUNDED. EMERGENCY LIGHTING POWER SUPPLY PACK M1671 FAILED. REMOVED AND REPLACED POWER SUPPLY IAW 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20161107043Power Supply · failedAIRCRAFT NOT GROUNDED. EMERGENCY LIGHTING POWER SUPPLY PACK M1695 FAILED. REMOVED AND REPLACED POWER SUPPLY IAW 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20161107042Power Supply · failedAIRCRAFT NOT GROUNDED. EMERGENCY LIGHTING POWER SUPPLY PACK M1670 FAILED. REMOVED AND REPLACED POWER SUPPLY IAW 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20160809008Engine · seizedDURING DESCENT THROUGH 10,000 VIBRATION IN NOSE OF AIRCRAFT WAS NOTED. VIBRATION CONTINUED TO INCREASE. NR 2 ENGINE EGT ROSE TO 640-690. NR 2 ENGINE SHUT DOWN IAW CHECKLIST. EMERGENCY DECLARED. LANDING UNEVENTFUL. AIRCRAFT GROUNDED. MAINTENANCE REPORTS N1 SDR AALA20150315001Battery Pack · dischargedPASSENGER COMPARTMENT EXIT SIGN LIGHT INOPERATIVE. REPLACED M1695 EMER BATTERY PACK. SYS CHECKED NORMAL.SDR AALA20141112012Skin · corrodedCORROSION ON LT WING LOWER SKIN BENEATH DRAG BRACE FITTING NEAR STATION 540. REMOVED CORROSION & REPAIRED IAW EA B737-57-037285.SDR AALA20140521014Module · inoperativeDFW INFLIGHT LAX TO RDU. CREW REPORTED FIRST OFFICER`S ALTIMETER & AIRSPEED WERE INOPERATIVE. FLIGHT DIVERTED DFW LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED STATIC AIR DATA MODULE. SYS GND CHECKED NORMAL, OPERATION CLOSED.SDR AALA20140315012Motor · failedMIA CREW REPORTED STABILIZER TRIM FAILURE. EMERGENCY DECLARED FLIGHT LANDED MIA WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED STABILIZER TRIM MOTOR. SYS GND CHECKED NORMAL OPERATION CLOSED.
Back to N956AN