N139AN
Service difficulty reports · 83
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 = 'N139AN' 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 = 'N139AN' 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 AALA202107027322Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: L = 0.996 INCH CRACK IN SHEAR PLATE. REPLACED SHEAR PLATE LOCATED BETWEEN FR69 TO FR70 AND STR23 RH SIDE IN PASSENGER CABIN, IAW A321 SRM 51-72-11-911-001 AND DWG D53474180.SDR AALA202106255833Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK AT SHEAR PLATE LOCATED BETWEEN FR 69 TO FR 70 STR 23L. LENGTH =1.604 INCHES. REPLACED SHEAR PLATE AND FASTENERS NEAR GALLEY AREA PER A321 SRM 51-42-11-801.SDR AALA202106142949Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED AREA FOUND ON CENTER FITTING LOCATED BETWEEN STA FR66 TO FR68, STR 23L. L=0.970 INCHES, W=0.605 INCHES, D=0.019 IN. REPLACED CENTER FITTING PER SRM A321 51-42-11-801.SDR AALA202106141077Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED AREA AT LOWER SILL BETWEEN FR 67 TO FR 68 AT LEVEL OF STR 23 L IN PASSENGER CABIN. L=0.876 INCH, W=0.792 INCH, D=0.058 INCH. REPAIRED LOWER SILL PER A321 SRM 53-41-14-300-001.SDR AALA202106140143Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED AREA FOUND ON CENTER FITTING LOCATED BETWEEN FR66 TO FR68, STR 23R. L=0.980 INCHES, W=0.607 INCHES, D=0.018 INCHES. REPLACED CENTER FITTING PER SRM 51-42-11-801.SDR AALA202010049006Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: INTERMITTENT LAVATORY SMOKE MESSAGE, VERIFIED NO SMOKE PRESENT. PERFORMED CABIN INTERCOMMUNICATION DATA SYSTEM RESET IAW FIM 24-00-00, OPS CHECK GOOD.SDR AALA202007139012Computer · defectiveAIRCRAFT WAS GROUNDED: CLIMBING THRU 15000 FIRST OFFICERS WINDSHIELD SHATTERED DUE TO A BIRD STRIKE. AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO SFO WHERE IT LANDED SAFELY WITHOUT FURTHER INCIDENT. MAINTENANCE FOUND NO EVIDENCE OF A BIRD STRIKE, SUSSDR AALA202007139002Windshield · failedAIRCRAFT WAS GROUNDED: CLIMBING THRU 15000 FIRST OFFICERS WINDSHIELD SHATTERED DUE TO A BIRD STRIKE. AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO SFO WHERE IT LANDED SAFELY WITHOUT FURTHER INCIDENT. MAINTENANCE FOUND NO EVIDENCE OF A BIRD STRIKE, SUSSDR AALA201911229007Smoke Warning · false activationAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE DETECTOR AURAL ALERT. NO SMOKE REPORTED IN ANY LAVATORY. MAINTENANCE TROUBLE SHOT AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER TSM 26-15-00.SDR AALA2019110869009Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT BROKEN AT LAVATORY D AND LAVATORY L. MAINTENANCE REPLACED EMERGENCY LIGHT PER AMM 33-51-18.SDR AALA201910029015Unknown · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS INFLIGHT F/O SIDE STICK WHEN ROLLING TO THE RIGHT, THERE IS NO RESPONSE FOR 1/2 OF SIDE STICK MOVEMENT, LEFT ROLL IS NORMAL. MAINTENANCE ACCOMPLISHED POST FLIGHT REPORT, NO FAULTS MESSAGES OR WARNINGS. ACCOMPLISHED OPERATISDR AALA201909239036Power Supply · inoperativeAIRCRAFT NOT GROUNDED: EPSU 12 WL INOPERATIVE. REMOVED AND REPLACED EPSU 12WL IAW AMM 33-51-38. OPS CHECK GOOD.SDR AALA201909239037Power Supply · inoperativeAIRCRAFT NOT GROUNDED: EPSU 11 WL INOPERATIVE. REMOVED AND REPLACED EPSU 11WL IAW AMM 33-51-38. OPS CHECK GOOD. OK FOR SERVICE.SDR AALA2019080549010Damper · low pressureAIRCRAFT WAS NOT GROUNDED: AFT RIGHT HAND EMERGENCY PRESSURE DAMPER NEEDED SERVICING. MAINTENANCE SERVICED DAMPER TO PROPER PRESSURE IAW AMM 52-22-00.SDR AALA2019080549009Damper · low pressureAIRCRAFT WAS NOT GROUNDED: AFT LEFT HAND EMERGENCY PRESSURE DAMPER NEEDED SERVICING. MAINTENANCE SERVICED DAMPER TO PROPER PRESSURE PER AMM 52-22-00.SDR AALA201812269024Wire · detachedEMERGENCY LIGHT ON SEAT 33-34 RT WAS INOPERATIVE. THE AIRCRAFT WAS GROUNDED. MAINTENANCE PINNED THE CONNECTOR WIRE FOR TERMINAL B IAW 33-51-08 & ESPM 20. OPS CHECKED OF SEAT MOUNTED EMER. LIGHTS AT ROE 33&34 RH OK IAW AMM33-51-00.SDR AALA201804029019Floor Panel · delaminatedAFT CARGO FLOOR PANEL 151LF AT FRAME 42 JUST AFT OF THE DOOR WAS FOUND SOFT AND DELAMINATED ACROSS ENTIRE SURFACE OF THE PANEL. REPAIRED THE FLOOR PANEL IAW AMM 25-25-00.SDR AALA201802269064Light · inoperativeSEAT 33C EMERGENCY LIGHT IS OUT. REPLACED SEAT 33C EMERGENCY LIGHT IAW AMM 33-51-19.SDR AALA20180130007Control Switch · faultyAIRCRAFT WAS GROUNDED: DURING CRUISE, CREW REPORTED A GREEN HYDRAULIC SYSTEM LOW PRESSURE INDICATION AND PERFORMED MANUAL GEAR EXTENSION. EMERGENCY DECLARED AND UNEVENTFUL LANDING CONTINUED TO DFW. MAINTENANCE REPLACED FLIGHT CONTROL SWITCH 1151GN, SERVICED GRSDR AALA201801049013Connector · looseEMERGENCY LIGHT ON SEAT 34C INOPERATIVE. FOUND THE WIRE CONNECTOR TO BE LOOSE. CONNECT THE CONNECTOR. OPS TESTED NORMAL.SDR AALA201801049012Connector · looseEMERGENCY LIGHT ON SEAT 33C INOPERATIVE. FOUND THE WIRE CONNECTOR TO BE LOOSE, CONNECTED THE CONNECTOR. OPS TESTED NORMAL.SDR AALA201712219020Bottle · low pressureR2 EMERGENCY EXIT DOOR DAMPER IN YELLOW BAND AT 56 DEGREES F. CHARGED THE R2 DOOR DAMPER TO GREEN BAND IAW AMM 52-22-00.SDR AALA201709269009Smoke Detector · false activationDURING CRUISE, ECAM WARNING FOR LAVATORY SMOKE LAV-D SOUNDED. WARNING LASTED A SECOND OR TWO, WENT OFF, AND THEN ANOTHER WARNING FOR A SECOND OR TWO . FLIGHT ATTENDANTS CHECKED LAVATORY D, NO SMOKE OR ANY INDICATION OF FIRE WAS FOUND. NO WARNINGS DURING LAST HSDR AALA201709269019Cylinder · low pressureR4 DOOR ASSIST CYLINDER REQUIRES NITROGEN SERVICE. SERVICED R4 DOOR DAMPER CYLINDER IAW AMM 52-10-00.SDR AALA201709269018Damper · low pressureL4 DOOR ASSIST CYLINDER REQUIRES NITROGEN SERVICE. SERVICED THE L4 DOOR DAMPER IAW AMM 52-10-00.SDR AALA201709269017Bottle · low pressureL1 DOOR ASSIST CYLINDER NITROGEN REQUIRES SERVICE. SERVICED L1 DOOR DAMPER IAW AMM 52-10-00.SDR AALA201709269016Light · detachedL1 DOOR AFT LOWER EMERGENCY LIGHT, LOWER ASSEMBLY DETACHED FROM SIDEWALL. REPLACED THE LIGHT IAW AMM 35-51-13.SDR AALA201709269011Lamp · inoperativeR1 DOOR, FORWARD LOWER EMERGENCY EXIT LIGHT MARKER, LOWER LAMP IS INOPERATIVE AND LOWER PART OF LIGHT ASSEMBLY IS DETACHED FROM SIDE WALL. REPLACED THE EMERGENCY LIGHT AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170826001Outflow Valve · inoperativeRETURNED DEPARTURE DUE TO A VENT SKIN VALVE FAULT AFTER TAKEOFF. THE OUTFLOW VALVE WAS INOPERATIVE & UNABLE TO PRESSURIZE CABIN. NO EMERGENCY DECLARED. LANDED WITHOUT INCIDENT. MAINTENANCE PERFORMED TSM 21-26-00-810-804-A AND AMM 21-26-00-710-001-A. ALL TESTSDR AALA20170205003Flashlight · failedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BEHIND AFT LAVATORY E FAILED TEST. REMOVED AND REPLACED FLASHLIGHT IAW AMM 25-65-00. OPERATIONAL CHECK GOOD.SDR AALA20161227003Power Supply · failedEMERGENCY EXIT LIGHTS FAILED TEST. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT 12WL IAW AMM 33-51-38. OPERATIONAL CHECKED GOOD.SDR AALA20160705009Floor Panel · delaminatedFOUND AFT CARGO COMPARTMENT FLOOR PANEL 151CF DELAMINATED. REMOVED AND REPLACED AFT CARGO FLOOR PANEL 151CF IAW MM 53-22-14. THE AIRCRAFT WAS GROUNDED.SDR AALA20160705007Floor Panel · delaminatedFOUND FORWARD CARGO COMPARTMENT FLOOR PANEL 131AF DELAMINATED. REMOVED AND REPLACED FORWARD CARGO FLOOR PANEL IAW MM 53-22-14. THE AIRCRAFT WAS GROUNDED.
Back to N139AN