N953AN
Service difficulty reports · 205
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 = 'N953AN' 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 = 'N953AN' 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 AALA20121024009Strap · crackedSPLICE STRAP CRACKED UNDER LEFT OUTBOARD SEAT TRACK AT STATION 727B, LEFT BUTTLINE 45.50. REPAIRED SPLICE STRAP PER CARD J1707 AND EA.SDR AALA20121024008Seat Track · crackedFORWARD SEAT TRACK AT RIGHT BUTTLINE 24.75, STATION 727B, FORWARD SPLICE PLATE HOLE, INBOARD SIDE SHOW CRACK INDICATION. INSTALLED SPLICE REPAIR FOR FORWARD SEAT TRACK AT RIGHT BUTTLINE 24.75, STATION 727B PER EA.SDR AALA20121024007Seat Track · crackedFORWARD SEAT TRACK AT RIGHT BUTTLINE 45.5, ALL 4 SPLICE PLATE HOLES HAVE CRACK INDICATIONS. REPAIRED SEAT TRACK INBOARD AND OUTBOARD SIDES WITH REPAIR SPLICE PER EA.SDR AALA20121024006Strap · crackedSPLICE STRAP UNDER RIGHT OUTBOARD SEAT TRACK, STATION 727B, RIGHT BUTTLINE 45.50 CRACKED BOTH SIDES OF SEAT TRACK. INSTALLED SPLICE STRAP REPAIR PER J1707AB 0003 AND EA.SDR AALA20121016008Sill · corrodedAFT CARGO DOOR SILL WEB HAS HOLE CORRODED THROUGH AND ALONG OUTER EDGE. REPLACED WEB PER AARD 51-00-05.SDR AALA20121015014Door Frame · crackedRIGHT NUMBER 1 DOOR CUTOUT, FORWARD FRAME STATION 294.5 IS CRACKED AT LOWEST MOST FASTENER HOLE (FRAME TO FLOORBOARD FASTENER). REPAIRED PER SRM 51-70-11 AND EA.SDR AALA20121010003Stiffener · corrodedSTIFFENER AT STATION 1120 CORRODED. REPLACED STIFFENER AT STATION 1120.SDR AALA20121026022Skin · corrodedFUSELAGE SKIN FROM STATIONS 1016 TO 1040, LONGERONS 24 TO 25 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026021Skin · corrodedFUSELAGE SKIN FROM STATIONS 1016 TO 1040, LONGERONS 23 TO 24 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026020Skin · corrodedFUSELAGE SKIN FROM STATIONS 1006 TO 1016, LONGERONS 25 TO 26 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026019Skin · corrodedFUSELAGE SKIN FROM STATIONS 1006 TO 1016, LONGERONS 24 TO 25 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026017Skin · corrodedFUSELAGE SKIN FROM STATIONS 1006 TO 1016, LONGERONS 23 TO 24 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026016Skin · corrodedFUSELAGE SKIN FROM STATIONS 986.5 TO 1006, LONGERONS 25 TO 26 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026015Skin · corrodedFUSELAGE SKIN FROM STATIONS 986.5 TO 1006, LONGERONS 24 TO 25 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026014Skin · corrodedFUSELAGE SKIN FROM STATIONS 986.5 TO 1006, LONGERONS 21 TO 22 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026013Skin · corrodedFUSELAGE SKIN FROM STATIONS 967 TO 986.5, LONGERONS 25 TO 26 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026012Skin · corrodedFUSELAGE SKIN FROM STATIONS 967 TO 986.5, LONGERONS 24 TO 25 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026011Skin · corrodedFUSELAGE SKIN FROM STATIONS 967 TO 986.5, LONGERONS 21 TO 22 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026010Skin · corrodedFUSELAGE SKIN FROM STATIONS 947.5 TO 967, LONGERONS 25 TO 26 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026009Skin · corrodedFUSELAGE SKIN FROM STATIONS 947.5 TO 967, LONGERONS 24 TO 25 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026008Skin · corrodedFUSELAGE SKIN FROM STATIONS 947.5 TO 967, LONGERONS 21 TO 22 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121026007Skin · corrodedFUSELAGE SKIN FROM STATIONS 927 TO 947.5, LONGERONS 24 TO 25 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121025006Skin · corrodedFUSELAGE SKIN FROM STATIONS 927 TO 947, LONGERONS 21 TO 22 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026770.SDR AALA20121029015Skin · dentedFUSELAGE SKIN HAS DENT AT APPROXIMATE STATION 436, LONGERONS 23 TO 24 LEFT (BELOW EXSITING DOUBLER). REPAIRED WITH EXTERNAL DOUBLER AND TRIPLER PER EA.SDR AALA20120218002Transmitter · inoperativeCREW REPORTED TRAILING EDGE FLAP DISAGREE. EMERGENCY DECLARED FLIGHT DIVERTED & LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT FLAP POSITION TRANSMITTER. SYSTEM GROUND CHECKED NORMAL.SDR AALA20111109ORD01Fseu · malfunctionedORD - CREW REPORTED FLAPS STUCK AT 15 DEGREES. FLIGHT LANDED ORD WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED FLAP SLAT ELECTRONICS UNIT. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20101230TUL04Sensor · out of positionCREW REPORTED FLAP ASYMMETRY MESSAGE. FLIGHT DIVERTED IAD LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. CLEANED AND ADJUSTED NUMBER 2 INBOARD SLAT PROXIMITY SENSOR THAT HAD FAULTED. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20101003TUL02Skin · dentedFORWARD CARGO DOOR SKIN DENTED SEVERAL PLACES. REPLACED SKIN.SDR AALA20100925TUL04Support · corrodedTHE AFT GALLEY ZEE ANGLE WALL SUPPORTS AT STATION 992 AND LEFT BUTTLINES 32 TO 40 AND RIGHT BUTTLINES 32 TO 40 ARE CORRODED. REMOVED AND REPLACED THE Z-ANGLES PER SRM 51-10-02-0G.SDR AALA20100925TUL02Skin · damagedAFT CARGO DOOR SKIN HAS SEVERAL SCRATCHES. INSTALLED NEW OUTER SKIN AFT CARGO DOOR PER ESO 60651.SDR AALA20100924TUL12Angle · corrodedCREASE ANGLE STATIONS 949 TO 996 RIGHT CORRODED.SDR AALA20100922TUL05Floorbeam · corrodedTHE CABIN STRUCTURE FLOORBEAM UPPER FLANGE IS CORRODED AT STATION 986 AND LEFT BUTTLINE 29 ON FORWARD SIDE OF BEAM. REPAIRED PER SRM 53-00-51-2R1.SDR AALA20100922TUL04Floorbeam · corrodedTHE CABIN STRUCTURE FLOORBEAM UPPER FLANGE AT STATION 986 AND LEFT BUTTLINE 21 HAS CORROSION ON AFT SIDE OF BEAM. REPAIRED PER SRM 53-00-51-2R1.SDR AALA20100921TUL01Intercostal · crackedINTERCOSTAL CRACKED BETWEEN FLOORBEAMS AT STATIONS 328 TO 344 LEFT BODY LINE 36. INSTALLED NEW INTERCOSTAL PER SRM 51-10-2.SDR AALA20100920TUL17Floorbeam · corrodedFLOORBEAM AT STATION 986 AND RIGHT BUTTLINE 29 IS CORRODED OUT OF SRM LIMITS. REPAIRED THE FLOORBEAM PER SRM 53-00-51-2R 1.SDR AALA20100917TUL18Intercostal · crackedFRAME INTERCOSTAL CRACKED STATIONS 312 TO 328 AND LEFT BUTTLINE 36. REMOVED AND REPLACED THE INTERCOSTAL PER SRM 51-10-02.SDR AALA20101004TUL01Vapor Barrier · crackedVAPOR BARRIER CRACKED STATION 663 FORWARD SIDE. FIRST BAY OUTBOARD OF KEEL BEAM LEFT SIDE. REPAIRED PER AARD 57-10-10-8.SDR AALA20100922TUL12Bulkhead · corrodedSTATION 1088 BULKHEAD CORRODED ON TOP FLANGE OF AUXILIARY POWER UNIT INLET DUCT. REMOVED CORRODED ANGLE AND INSTALLED UPPER ANGLE (FILLER) ON AUXILIARY POWER UNIT INLET AT STATION 1088 PER SRM 51-10-02 PARAGRAPH 8.SDR AALA20100908MIA06Battery Pack · dischargedESCAPE PATH LIGHT BATTERY PACK FAILED TEST PER SIC WORK CARD 2908. REPLACED BATTERY PACK. OPS CHECK NORMAL.SDR AALA20100908MIA05Battery Pack · dischargedESCAPE PATH LIGHT BATTERY PACK FAILED TEST PER WORK CARD 2908. REPLACED BATTERY PACK. OPS CHECK NORMAL.SDR AALA20100908MIA04Battery Pack · dischargedESCAPE PATH LIGHT BATTERY PACK FAILED TEST PER SIC WORK CARD 2908. REPLACED BATTERY PACK.SDR AALA20100908MIA03Battery Pack · dischargedESCAPE PATH LIGHT BATTERY PACK FAILED TEST PER SIC WORK CARD 2908. REPLACED BATTERY PACK.SDR AALA20101004TUL04Beam · crackedFORWARD CARGO DOOR NUMBER 1 BEAM HAS A 1.5 INCH CRACK AT THE LOWER END OF THE DOOR CENTER INTERCOSTAL ATTACH POINTS. REPLACED NUMBER 1 BEAM ON THE FORWARD CARGO DOOR PER ESO60654.SDR AALA20090902DFW01Light · missingEMERGENCY PATH LIGHTING AT SEAT 8D MISSING BULBS AND LENS COVER. INSTALLED NEW BULBS AND LENS COVER FOR EMERGENCY LIGHT AT SEAT 8D.SDR AALA2009080100003Lens · missingMIA - EMERGENCY LIGHT LENS AT SEAT 21 ABC MISSING. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 21 ABC.SDR AALA2009080100002Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT 8 DEF BURNED OUT. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 8 DEF.SDR AALA20090630PHL01Lens · missingUPON ENTERING AIRCRAFT FOR OVERNIGHT MAINTENANCE FOUND EMERGENCY LIGHT LENS MISSING FROM FORWARD GALLEY WALL. REPLACED LENS FOR EMERGENCY LIGHT AT FORWARD GALLEY WALL.SDR AALA2009011200308Light · inoperativeDFW- EMERGENCY PATH LIGHTING ASSEMBLY AT SEAT 21D AND 16D INOPERATIVE. REPLACED LAMP AT SEAT 21D AND SEAT 16D.SDR AALA2009011200307Light · inoperativeDFW- EMERGENCY PATH LIGHTS AT SEAT 18D INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AT SEAT 18D.SDR AALA20070683Wire Harness · disconnectedMIA - EMERGENCY LIGHT AT SEAT 14D INOPERATIVE. RESECURED WIRES AND CONNECTOR FOR EMERGENCY LIGHT AT SEAT 14D. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N953AN