N959AN
Service difficulty reports · 189
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 = 'N959AN' 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 = 'N959AN' 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 AALA2019121109019Battery · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT AFT SEATS FLASHLIGHT FAILED TEST. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA201905149017Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR WAS VERY HARD TO OPEN. MAINTENANCE LUBED LOCK AND HINGE OF FLIGHT COMPARTMENT DOOR. DOOR OPENS AND CLOSES NORMALLY PER AMM 52-51-01.SDR AALA201902069024Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL WEB AT BS 304 AND S22L. REPAIRED INTERCOSTAL WEB PER EA 289129SDR AALA20190205005Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CHORD ANGLE AT BS 305 AND S22L. REPAIRED CHORD ANGLE PER EA 289129.SDR AALA201901232003Floorbeam · corrodedCORROSION ON FORWARD CARGO BAY FLOORBEAM ANGLE AT BS 500I BETWEEN LBL 24 AND RBL 24. REPLACED THE FLOORBEAM ANGLE IAW SRM 51-10-02.SDR AALA201901231004Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO BAY LEFT TRANSITION PANEL BETWEEN BS 400 AND 420. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53, AND 51-10-2.SDR AALA201901231003Transition Panel · corrodedCORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN BS 500A AND BS 500B. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R.SDR AALA201901231002Baffle · crackedTHE FORWARD CARGO BAY LEFT BAFFLE WAS CRACKED BETWEEN BS 400 AND 420. REPLACED THE BAFFLE IAW RD 51-00-05.SDR AALA20190118001Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN WAS FOUND CRACKED AT HSS 147.90. 25 INCHES AFT OF THE FRONT SPAR. REPAIRED THE SKIN IAW SRM 55-10-01-2R-11.SDR AALA20190116003Beam · crackedFORWARD SERVICE DOOR THIRD BEAM FORWARD AND BELOW DOOR HANDLE RADIUS WAS CRACKED. REPLACED THE DOOR BEAM IAW RD 51-00-05, REPAIR 1.SDR AALA201901165008Skin · crackedLEFT HORIZONTAL STABILIZER LOWER SKIN WAS FOUND CRACKED AT HSS 147.90, 25 INCHES FROM THE FRONT SPAR. REPAIRED THE HORIZONTAL STABILIZER SKIN IAW SRM 55-10-01-2R-11, FIGURE 204, FIGURE 4, SHEET 2, DETAIL B.SDR AALA201901154010Angle · corrodedCORROSION FOUND ON THE AFT GALLEY FLOOR ANGLE BETWEEN BS 893 AND 1016, RBL 51. REPLACED THE FLOOR ANGLE IAW RD 51-00-05.SDR AALA201901154009Angle · corrodedCORROSION FOUND ON THE AFT GALLEY FLOOR ANGLE BETWEEN BS 893 AND 1016, LBL 51. REPLACED THE FLOOR ANGLE IAW RD 51-00-05.SDR AALA201901154008Web · corrodedCORROSION ON AFT GALLEY FLOOR WEB BETWEEN BS 986 AND 1016, RBL 45 AND RBL 51. REPLACED THE WEB IAW RD 51-00-05.SDR AALA201901154007Web · corrodedCORROSION FOUND ON THE AFT GALLEY FLOOR WEB AT BS 1016 AND RBL 32. REPLACED THE WEB IAW RD 51-00-05.SDR AALA201901154005Floor Support · corrodedCORROSION FOUND ON THE AFT GALLEY FLOOR SUPPORT AT BS 993, LBL 33. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05.SDR AALA201901154004Floor Support · corrodedCORROSION ON AFT GALLEY FLOOR SUPPORT BETWEEN BS 993 AND 1016, LBL 32. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05.SDR AALA201901154003Floorbeam · corrodedCORROSION FOUND ON THE AFT GALLEY FLOORBEAM, BS 993 BETWEEN RBL 33 AND RBL 46. REPLACED THE FLOORBEAM ANGLE IAW RD 51-00-05.SDR AALA201901154002Floor Support · corrodedCORROSION ON THE AFT GALLEY FLOOR SUPPORT BETWEEN BS 993 AND 1016, RBL 32. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05.SDR AALA201901141008Floor Support · corrodedCORROSION ON THE AFT CABIN FLOOR SUPPORT BETWEEN BS 947 AND 967, LBL 49. REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02.SDR AALA201901141004Floorbeam · corrodedCORROSION FOUND ON THE AFT CABIN FLOORBEAM UPPER TEE AT BS 986.5, BETWEEN LBL 51 AND RBL 51. REPAIRED THE FLOORBEAM IAW SRM 53-7051-2R-4.SDR AALA20190123003Rib · crackedRIGHT HORIZONTAL STABILIZER RIB WAS FOUND CRACKED AT HSS 92.70. REPLACED THE RIB IAW RD 51-00-05.SDR AALA2019011009001Floor Support · crackedCRACKED CABIN FLOOR SUPPORT BETWEEN BS 312 AND 328, LBL 44. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05SDR AALA201804269037Cover · detachedL4 DOOR EXIT SIGN COVER DETACHED. REPLACED THE EXIT SIGN ASSEMBLY IAW AMM 33-51-01.SDR AALA20170802006Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. CREW REPORTED RIGHT FWD OVERWING EMERGENCY LIGHT ASSY LIGHT COVER MISSING. REPLACED RIGHT FWD OVERWING EMERGENCY LIGHT ASSY IAW AMM 33-51-01. OPS CHECKS NORMAL.SDR AALA201706059069Cover · brokenPAX CABIN: EMERGENCY LIGHT COVER BROKEN ON GALLEY NR 1. REMOVED AND REPLACED COVER IAW AMM 33-51-01.SDR AALA201705099038Guide Arm · out of adjustFWD ENTRY DOOR DIFFICULT TO CLOSE FROM INSIDE WITHOUT MANIPULATION. ADJUSTED GUIDE ARM PER AMM 52-11-00 OPS CKS GOOD. THE AIRCRAFT WAS GROUNDED.SDR AALA201704259009Vapor Barrier · crackedAIRCRAFT WAS NOT GROUNDED. CENTER WING REAR SPAR VAPOR BARRIER 13 INCH CRACK WAS FOUND IN LEFT MAIN WHEEL WELL DURING PREFLIGHT. ACCOMPLISHED INTERIM REPAIR IAW AARD 57-10-00-1.SDR AALA20170222028Proximity Sensor · out of adjustAIRCRAFT WAS GROUNDED. EMERGENCY DECLARED. ON DESCENT, LEADING EDGE FLAP TRANSIT LIGHT ILLUMINATED. UNEVENTFUL LANDING. ADJUSTED NR 8 LEADING EDGE OUTBOARD SLAT PROXIMITY SENSOR IAW AMM 27-88-11. OPERATIONAL CHECK GOOD.SDR AALA20170208004Support Beam · wornAIRCRAFT IN BASE MAINTENANCE. GROUND PNEUMATIC DOOR OUTBOARD LATCH HAS WORN INTO THE CENTER WING SUPPORT BEAM. REPAIRED BEAM IAW EA 267127.SDR AALA20170201017Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK ON CABIN FLOOR SUPPORT INTERCOSTAL AT STATION 328-344 AND LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20161215013Pressure Switch · faultyAIRCRAFT NOT GROUNDED. NR 1 TANK FORWARD FUEL BOOST PUMP LOW PRESSURE LIGHT ILLUMINATED APPROXIMATELY 3 MINUTES AFTER TAKEOFF AND REMAINED ON FOR APPROXIMATELY 4 MINUTES. AFTER SHUTDOWN THE LIGHT CAME ON WITH THE SWITCH IN THE ON POSITION. REMOVED AND REPLASDR AALA20161206008Sign · brokenAIRCRAFT GROUNDED. R1 DOOR EMERGENCY EXIT IDENTIFIER BROKEN. REMOVED AND REPLACED IDENTIFIER ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20160927005Snubber · brokenAIRCRAFT WAS GROUNDED. L1 DOOR LOWER SNUBBER ASSEMBLY BROKE AT PUSHROD ON DOOR END CAUSING DAMAGE TO DOOR EXTERIOR SKIN. DOOR SKIN INTERIM REPAIR ACCOMPLISHED IAW EA #264048. REMOVED AND REPLACED SNUBBER ASSEMBLY IAW AMM 52-11-51 PAGE BLOCK 401. OPERATIONAL CSDR AALA20160802003Transmitter · faultyDURING APPROACH WHEN FLAPS SELECTED TO 10, FLAPS STOPPED AT 2. EMERGENCY DECLARED. LANDING UNEVENTFUL. AIRCRAFT GROUNDED. MAINTENANCE REMOVED AND REPLACED THE RIGHT FLAP POSITION TRANSMITTER IAW AMM 27-58-01. OPS CHECKED NORMAL.SDR AALA20160603027Skin · crackedNR 7 LE SLAT SKIN IS CRACKED AT THE ACTUATOR FITTING LOCATION. REPAIRED IAW SRM 57-42-01-2R-8. AIRCRAFT WAS GROUNDED.SDR AALA20160603026Skin · crackedNR 3 LE SLAT SKIN IS CRACKED AT THE ACTUATOR FITTING LOCATION. REPAIRED IAW SRM 57-42-01-2R-8 AND EA 261163. AIRCRAFT WAS GROUNDED.SDR AALA20160603025Skin · crackedNR 1 LE SLAT SKIN IS CRACKED AT THE ACTUATOR FITTING LOCATION. REPAIRED IAW SRM 57-42-01-2R-8. AIRCRAFT WAS GROUNDED.SDR AALA20160502012Controller · faultyAIRCRAFT WAS GNDED. DURING TAKEOFF ROLL, THE CAPTAIN`S L2 WINDOW CRACKED SEVERELY. TAKEOFF WAS ABORTED AT APPROX 65 KNOTS. R & R WINDOW HEAT CONTROLLER M322 IAW AMM 30-41-11.SDR AALA20150819004Unknown · malfunctionedAIR INTERRUPT, EMER DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING APPROACH, CREW NOTED AIRSPEED ISSUE & ABORTED APPROACH. DURING GO AROUND, NOTED FLAPS STUCK AT 9 DEGREES. AIR INTERRUPTED DUE TO FLAPS STUCK AT 9 DEGREES & A LE FLAP ASYMMETRY MSSDR AALA20150817008Probe · faultyAIR INTERRUPT, EMER DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING APPROACH, CREW NOTED AIRSPEED ISSUE & ABORTED APPROACH. DURING GO AROUND, NOTED FLAPS STUCK AT 9 DEGREES. AIR INTERRUPTED TO IAD DUE TO FLAPS STUCK AT 9 DEGREES & LE FLAP ASYMMETSDR AALA20150320012Skin · damagedDAMAGE TO THE FUSELAGE SKIN AT STATION 867 & STRINGER 23 RT. DOUBLER REPAIR ACCOMPLISHED IAW EA B737-53-038979, DATED 19 MAR 15.SDR AALA20141216007Light · damagedRIGHT FWD OVERWING EMER EXIT LIGHT DAMAGED. REPLACED RT FWD OVERWING EMER EXIT LIGHT ASSEMBLY. OPERATIONS CHECKED GOOD.SDR AALA20130116007Skin · dentedDENT WITH GOUGE AT STATION 353 BEWTEEN STRINGERS 17 AND 18 RIGHT. ACCOMPLISHED REPAIR PER SRM 53-00-01-2R 20.SDR AALA20130116005Bonding Strap · corrodedLEFT WING NUMBER 1 FUEL BOOST PUMP, UPPER BOND STRAP HAS CORROSION. REPAIRED PER EA B737-57-027879.SDR AALA20130115007Strap · crackedFLOOR SPLICE STRAP LEFT SIDE INBOARD AND OUTBOARD AFT FASTENER HOLES HAS CRACK INDICATION AT RIGHT BUTTLINE 24.75. ACCOMPLISHED REPAIR PER EA B737-53-027795.SDR AALA20130115006Strap · crackedVISUAL INDICATION OF CRACK IN THE SPLICE STRAP AT STATION 727A +18" AND RIGHT BUTTLINE 26. ACCOMPLISHED REPAIR PER EA B737-53-027795.SDR AALA20130112010Fastener · crackedFLOOR SPLICE STRAP FASTENERS 2 FORWARD AND AFT HAVE CRACK INDICATIONS AT LEFT BUTTLINE 44.5. ACCOMPLISHED REPAIR PER ENGINEERING AUTHORIZATION.SDR AALA20130113003Angle · corrodedRIGHT CREASE ANGLE CORRODED FROM STATIONS 322 TO 342. REMOVED AND REPLACED CREASE ANGLE PER AARD 51-00-05.SDR AALA20130113002Angle · corrodedFORWARD SERVICE DOOR THRESHOLD SUPPORT STRUCTURE CORRODED FROM STATIONS 298 TO 328. REMOVED AND REPLACED CREASE ANGLE PER AARD 51-00-05.
Back to N959AN