N958AN
Service difficulty reports · 236
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 = 'N958AN' 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 = 'N958AN' 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 AALA201711269012Pcu · failedAIRCRAFT WAS GROUNDED. ON FINAL APPROACH AT APPROX. 500 THE RUDDER KICKED TO THE RIGHT CAUSING NOSE OF AIRCRAFT TO SWING RAPIDLY WITHOUT PILOT RUDDER PEDAL INPUT. YAW DAMPER THEN DISENGAGED WITH AN AMBER CAUTION LIGHT. REMOVED AND REPLACED PRIMARY RUDDER POWSDR AALA201709219014Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L2 DOOR HAS A MISSING LENS COVER. REPLACED LENS COVER PER AMM 33-51-01-960-802. OPERATIONAL CHECK GOOD.SDR AALA201704079018Block · bentR1 DOOR SLIDE BLOCK ASSEMBLY BINDING. REMOVED AND REPLACED BLOCK ASSEMBLY IAW 25-94-11. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201703289032Lens · unsecureEXIT LIGHT LENS COVER AT FWD GALLEY DOOR WILL NOT STAY IN PLACE. REPLACED LIGHT ASSY L01186 AT FWD GALLEY DOOR IAW AMM 33-51-01. OP CK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170207016Rib · crackedCRACK IN RIB, 36 INCHES FROM BASE OF LEFT HORIZONTAL STABILIZER. REPAIRED THE RIB IAW SRM 55-10-09-2R.SDR AALA20170206020Intercostal · crackedCRACK ON INTERCOSTAL IN E/E BAY AT BS 312-328, LBL 46, INSTALLED A NEW INTERCOSTAL IAW 51-00-05-1, REPAIR 1.SDR AALA20170206019Intercostal · crackedCRACK ON INTERCOSTAL IN E/E BAY AT BS 324 - 344, LBL 46. INSTALLED A NEW INTERCOSTAL IAW 51-00-05-1, REPAIR 1.SDR AALA20170206018Skin · crackedCRACKS ON LOWER SKIN OF LEFT HORIZONTAL STABILIZER AT ABOUT 3 FEET FROM THE BASE. REPAIRED THE SKIN IAW SRM 55-10-01-2R-11.SDR AALA20170116010Skin · crackedAIRCRAFT WAS NOT GROUNDED. RIGHT HORIZONTAL STABILIZER LOWER SKIN HAS 3 CRACKS BETWEEN STABILIZER STATION 175.5 AND 184.7 AND FROM 20" TO 39" AFT OF THE FRONT SPAR. REPAIRED IAW SRM 55-10-01-2R-11.SDR AALA20161130010Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN RIGHT SIDE AFT GALLEY HAS DETACHED LENS COVER. REINSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20160419003Transmitter · faultyAIRCRAFT WAS GNDED. EMER DECLARED & LANDING UNEVENTFUL. DURING APPROACH A FLAP ASYMMETRY WHEN FLAPS 1 SELECTED. ACCOMPLISHED BITE OF FSEU IAW 27-52-259. R & R LT FLAP POSITION TRANSMITTER IAW AMM 27-58-01. SYS CHECKED NORMAL.SDR AALA20150610006Sensor · faultyEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING APPROACH FLAPS FAILED TO EXTEND. R & R LT INBD FLAP INBD SKEW SENSOR IAW AMM 27-59-01. PERFORMED OPERATIONAL CHECK. SYS CHECKED NORMAL.SDR AALA20141218012Holder · inoperativeAFT GALLEY MEGA PHONE HOLDER INOPERATIVE. R & R MEGA PHONE HOLDER IAW MM 25-64-00. SYS CHECKED NORMAL.SDR AALA20141110004Skin · damagedDAMAGE TO FUSELAGE SKIN AT FUSELAGE STATION 500H & STRINGER 27 LT. REPAIRED STRINGER IAW SRM 53-00-03 REPAIR 1 & EA B737-53-037325 DATED 10-30-14.SDR AALA20141108014Skin · damagedDAMAGE TO FUSELAGE SKIN AT FUSELAGE STATION 500H & STRINGER 27 LT. REPAIRED SKIN IAW SRM 53-00-03 REPAIR 1 & EA B737-53-037325 DATED 10-30-14.SDR AALA20130711013Pressure Switch · faultyRT ENGINE FUEL FILTER BYPASS INDICATION. REPLACED RT ENGINE FUEL FILTER DIFFERENTIAL PRESSURE SWITCH. SYSTEM GROUND CHECKED NORMALSDR AALA20121212018Skin · scratchedSCRATCHES ABOVE THE FORWARD ENTRY DOOR BETWEEN STATIONS 315 TO 325 AND STRINGERS 3 AND 4 LEFT. INSTALLED REPAIR DOUBLER PER SRM 53-00-01 REPAIR 3.SDR AALA20121212010Seat Track · crackedSEAT TRACK AT RIGHT BUTTLINE 24.75 HAS CRACK AT SPLICE PLATE ATTACH HOLES. INSTALLED REPAIR SPLICES PER EA B737-53-027512.SDR AALA20121212009Seat Track · crackedSEAT TRACK 48.5 RIGHT BUTTLINE SHOWS CRACKS AROUND SPLICE PLATE ATTACH HOLES. INSTALLED REPAIR SPLICES PER EA B737-53-027512.SDR AALA20121211019Angle · damagedEXTRUDED ANGLE ON BOTTOM SIDE OF LOWER HORIZONTAL BEAM JUST AFT OF AUXILIARY POWER UNIT INLET OPENING, HAS APPROXIMATE 1.25 INCH TRIMMED FROM FREE FLANGE. INSTALLED FILLER AND REPAIR ANGLE ON BOTTOM SIDE OF LOWER HORIZONTAL BEAM AFT OF AUXILIARY POWER UNIT INSDR AALA20121211001Stiffener · crackedLOWER WEB AREA CRACKED AT RIGHT VERTICAL STIFFENER JUST OUTBOARD OF PACK EXHAUST DUCT. INSTALLED CROSS BRACE REPAIR PER SRM 57-10-10-2R AND EA B737-52-027496.SDR AALA20121209001Stiffener · crackedRIGHT VERTICAL STIFFENER JUST OUTBOARD OF PACK EXHAUST DUCT CUTOUT IS CRACKED AT LOWER END. REMOVED CRACKED STIFFENER AND INSTALLED RIGHT VERTICAL STIFFENER PER AARD 51-10-05-R1 AND BOEING PRINTS 111A1000 AND 149A-7210.SDR AALA20121207005Floor Support · corrodedNUMBER 3 AFT CARGO FLOORBOARD SUPPORT T CORRODED. REPLACED NUMBER 3 AFT CARGO FLOORBOARD SUPPORT T PER AARD 51-10-05-R1.SDR AALA20121206010Floor Support · corrodedAFT CARGO FLOORBOARD SUPPORT T AT STATION 887 IS CORRODED. REPLACED SUPPORT T PER AARD 53-60-15.SDR AALA20121206007Floor Support · corrodedCORROSION ON FLOOR SUPPORT BEAM FROM STATIONS 793 TO 947 AND RIGHT BUTTLINE 17. INSTALLED REPAIR STRAP PER EA B737-53-027405.SDR AALA20121205007Transition Panel · wornFASTENERS WOKING THRU LEFT TRANSITION PANEL AT STATIONS 727G TO 727H. REPLACED LEFT TRANSITION PANEL FROM STATIONS 727H TO 727F PLUS 12 INCHES PER SRM 53-00-53-2R-5.SDR AALA20121205006Transition Panel · corrodedCORROSION ON RIGHT TRANSITION PANEL FROM STATIONS 727I TO 787. REPLACED RIGHT TRANSITION PANEL FROM STATIONS 727I TO 847 PER SRM 53-00-53-2R-5.SDR AALA20121205005Transition Panel · corrodedCORROSION ON LEFT TRANSITION PANEL FROM STATIONS 727I TO 847. REPLACED LEFT TRANSITION PANEL FROM STATIONS 727I TO 847 PER SRM 53-00-53-2R-5.SDR AALA20121203022Threshold · corrodedCORROSION ON AFT CARGO DOORWAY THRESHOLD. REPLACED THRESHOLD PER AARD 51-10-05-R1.SDR AALA20121201018Intercostal · crackedINTERCOSTAL CRACKED FROM STATIONS 312 TO 328 AT RIGHT BUTTLINE 30. REMOVED AND REPLACED THE INTERCOSTAL PER AARD 51-00-05.SDR AALA20121203014Frame · crackedAIR CONDITIONER RAIL FRAME CRACKED LEFT SIDE AT STATION 500D. INSTALLED REPAIR DOUBLER PER ECO J1159AE.SDR AALA20121203013Frame · crackedAIR CONDITIONER RAIL FRAME CRACKED LEFT SIDE AT STATION 480. INSTALLED REPAIR DOUBLER PER ECO J1159AE.SDR AALA20121130011Frame · crackedAIR CONDITIONER RAIL FRAME CRACKED LEFT SIDE AT STATION 440. INSTALLED REPAIR DOUBLER PER ECO J1159AE.SDR AALA20121130010Frame · crackedAIR CONDITIONER RAIL FRAME CRACKED LEFT SIDE AT STATIONS 727B. INSTALLED REPAIR DOUBLER PER ECO J1159AE.SDR AALA20121130021Stringer · crackedLEADING EDGE STRINGER FROM WING STATIONS 156 TO 180 CRACKED. REPLACED STRINGER.SDR AALA20121129030Support Bracket · bentTHE RIGHT INBOARD MAIN FLAP HAS A BENT SUPPORT BRACKET 18 INCHES FROM INBOARD EDGE OF THE FLAP ALONG THE AFT 6 INCHES OF THE FLAP LOWER SKIN. REMOVED AND REPLACED THE SUPPORT BRACKET PER AARD 51-00-05-1.SDR AALA20121127007Stiffener · crackedLEFT VERTICAL STIFFENER OUTBOARD OF PACK EXHAUST DUCT CUTOUT IS CRACKED AT LOWER END. REPLACED STIFFENER PER AARD 51-10-05-R1 AND BOEING DWG 149A7210 AND 111A1000.SDR AALA20121127009Stiffener · corrodedRIGHT SIDE VERTICAL STIFFENER AT STATION 1125 AT AUXILIARY POWER UNIT INLET IS CORRODED. REPLACED VERTICAL STIFFENER PER SRM 51-10-02 AND BOEING DWG 148A8650.SDR AALA20121127008Stiffener · corrodedHORIZONTAL STIFFENER NEAR STATION 1123 AT BOTTOM OF AUXILIARY POWER UNIT INLET CUTOUT HAS CORROSION AROUND FASTENER HOLES. REPLACED HORIZONTAL STIFFENER PER SRM 51-10-02 AND BOEING DRAWING 148A8650.SDR AALA20121126010Intercostal · crackedINTERCOSTAL CRACKED AT STATION 284, BUTTLINE 0. INSTALLED NEW INTERCOSTAL PER AARD 51-10-05-1R.SDR AALA20121211007Skin · gougedGOUGES IN CROWN SKIN AT STATION 603 BETWEEN STRINGERS 2 AND 3 RIGHT. INSTALLED REPAIR DOUBLER PER EA B737-53-027503 AND SRM 53-00-01-2R 3.SDR AALA20121204006Shield · corrodedSEVERAL AREAS OF CORROSION ON TOP AND UNDERNEATH THE RIGHT SHIELD FROM STATIONS 767 TO 793. REPLACED SHIELD PER AARD 51-10-05-R1.SDR AALA20121201015Angle · crackedCABIN FLOOR ANGLE FROM STATIONS 291 TO 295 CRACKED. REPLACE ANGLE AARD 51-00-05-1.SDR AALA20121213006Splice · crackedVISUAL INDICATION OF CRACK AT SPLICE STRAP AT INBOARD FORWARD HOLE LOCATED AT STATION 727A + 17 INCHES AND RIGHT BUTTLINE 48. INSTALLED SPLICE REPAIR PER EA B737-53-027512.SDR AALA20121210012Reveal · groovedWEAR GROOVE ON FORWARD CARGO DOOR REVEAL. REPLACED FORWARD CARGO DOOR REVEAL.SDR AALA20121201014Angle · corrodedCABIN FLOOR RIGHT AND CREASE ANGLE HAS CORROSION. REPLACED RIGHT CREASE ANGLE AND STRAP (141A8316U6) PER AARD 51-00-05-1.SDR AALA20121128007Intercostal · crackedINTERCOSTAL FROM STATIONS 328 TO 344, LEFT BUTTLINE 45 CRACKED. REPLACED INTERCOSTAL PER AARD 51-10-05-1.SDR AALA20121201016Skin · scratchedFUSELAGE SKIN HAS SCRATCHES ABOVE FOWARD ENTRY DOOR. CUT OUT DAMAGE AND INSTALLED EXTERNAL REPAIR DOUBLER PER BOEING SRM 53-00-01-2R.SDR AALA20121211008Skin · gougedGOUGES IN CROWN SKIN FROM STATIONS 594 TO 596 BETWEEN STRINGERS 2 AND 3 RIGHT. INSTALLED DOUBLER REPAIR PER EA B737-53-027503.SDR AALA20121015012Frame · crackedRIGHT FRAME WEB CRACKED AT BIN ATTACH BRACKET FASTENER STATION 500A. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.
Back to N958AN