N915AN
Service difficulty reports · 241
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 = 'N915AN' 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 = 'N915AN' 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 AALA20131024014Seat Track · crackedLBL 24.74 & STATION 727B SEAT TRACK CRACKED ON INBD & OTBD SIDES. ACCOMPLISHED REPAIR IAW EA B737-53-032156.SDR AALA20131023004Structure · corrodedFOUND CORROSION ON T-CAP. R & R T-CAP ON STATION 986.SDR AALA20131021003Floorbeam · corrodedCORROSION FOUND ON STATION 947 FLOORBEAM FROM RBL 43 TO 53. T-CAP REPAIRED FROM STATIONS 947 & RBL 0 TO 53.SDR AALA20130313032Plate · brokenPLATE UNDERNEATH EXIT SIGN LENS IS BROKEN LEFT SIDE OF AFT GALLEY. REMOVED AND REPLACED EXIT SIGN LIGHT ASSEMBLY. OPS CHECK NORMAL.SDR AALA20120315011Skin · corrodedAFT LAVATORY VENT AREA SKIN FROM STATIONS 1006 TO 1016 LONGERON 23 TO 27 LEFT CORRODED. REMOVED CORROSION PER SRM 51-10-02. INSTALLED FASTENERS PER EA B737-53-022317.SDR AALA20120315010Skin · corrodedAFT LAVATORY VENT AREA SKIN FROM STATIONS 1064 TO 1088 STRINGERS 17 TO 24 LEFT CORRODED. REMOVED CORROSION PER SRM 51-10-02. INSTALLED FASTENERS PER EA B737-53-022317.SDR AALA20120315008Skin · corrodedAFT LAVATORY VENT AREA SKIN FROM STATIONS 1040 TO 1064 STRINGERS 21 LEFT TO 27 RIGHT CORRODED. REMOVED CORROSION PER SRM 51-10-02. INSTALLED FASTENERS PER EA B737-53-022317.SDR AALA20120315007Skin · corrodedAFT LAVATORY VENT AREA SKIN FROM STATIONS 1016 TO 1040 STRINGERS 21 LEFT TO 27 RIGHT CORRODED. REMOVED CORROSION PER SRM 51-10-02. INSTALLED FASTENERS PER EA B737-53-022317.SDR AALA20120308016Skin · corrodedAFT LAVATORY VENT AREA SKIN FROM STATIONS 868 TO 888 LONGERON 26 LEFT TO 27 RIGHT CORRODED. REMOVED CORROSION PER SRM 51-10-02. INSTALLED FASTENERS PER EA B737-53-022317.SDR AALA20120304008Intercostal · crackedFLOORBEAM STABILIZATION INTERCOSTAL STATIONS 328 TO 344 LEFT BUTTLINE 46 CRACKED. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20120304007Intercostal · crackedFLOORBEAM STABILIZATION INTERCOSTAL STATIONS 312 TO 328 LEFT BUTTLINE 46 CRACKED. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20120304006Intercostal · crackedFLOORBEAM STABILIZATION INTERCOSTAL STATIONS 344 TO 360 LEFT BUTTLINE10 CRACKED. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20120304005Intercostal · crackedFLOORBEAM STABILIZATION INTERCOSTAL, BUTTLINE 0 STATIONS 344 TO 360 CRACKED. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20120308005Skin · damagedEMERGENCY EQUIPMENT DOOR SKIN LEFT FORWARD SIDE SCRAPED. INSTALLED NEW OUTER SKIN PER EA COMP 52-022239 THEN RE-INSTALLED INNER SKIN PER ESO 60381.SDR AALA20110426MIA01Probe · inoperativeMIA - CREW REPORTED TAT PROBE TEMPERATURE INDICATION ERRATIC. FLIGHT LANDED MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED TAT PROBE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20100810TUL05Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK M1691 FAILED PER 2908 CARD. REPLACED BATTERY PACK M1691. OPS CHECKED NORMAL.SDR AALA20100810TUL04Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK M1694 FAILED PER 2908 CARD. REPLACED BATTERY PACK M1694. OPS CHECKED NORMAL.SDR AALA20100807MIA01Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK M1695 FAILED PER 2908 CARD. REPLACED BATTERY PACK M1695. OPS CHECKED NORMAL.SDR AALA20100115TUL05Skin · dentedDENT IN UPPER SKIN OF TRAILING EDGE WEDGE 28.5 INCHES FROM INBOARD END. HOT BONDED DOUBLER OVER DAMAGED AREAS PER SRM 51-70-102R 4.SDR AALA20100115TUL04Skin · dentedDENT IN UPPER SKIN OF TRAILING EDGE WEDGE 13 INCHES FROM INBOARD END. HOT BONDED DOUBLER OVER DAMAGED AREAS PER SRM 51-70-102R 4.SDR AALA20100111TUL03Floorboard · damagedFLOORBOARD DAMAGED. REMOVED AND SERVICEABLE FLOORBOARD INSTALLED.SDR AALA20100108TUL24Bracket · crackedFRAME CRACKED AT AIR CONDITIONING RAIL BRACKET STATION 727B LEFT SIDE AT INBOARD FASTENER. REPAIRED BRACKET PER ECO J1159AC AND EA B727-53-008586.SDR AALA20100108TUL23Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL BRACKET STATION 480 LEFT SIDE AT INBOARD FASTENER. REPAIRED BRACKET PER ECO J1159AC AND EA B727-53-008586.SDR AALA20100108TUL22Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL BRACKET, STATION 500C LEFT SIDE AT INBOARD FASTENER. REPAIRED BRACKET PER ECO J1159AC AND ENGINEERING AUTHORIZATION B727-53-008586.SDR AALA20100108TUL12Frame · crackedFRAME AT STATION 360 CRACKED. WORK ACCOMPLISHED UNDER ENGINEERING AUTHORITY B737-53-008557.SDR AALA20100108TUL14Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM STATION 294.5, RIGHT BUTTLINE 28 TO 34. REPLACED UPPER "T" CAP PER ENGINEERING AUTHORIZATION B737-53-008449 AND B737-53-008405.SDR AALA20100108TUL13Intercostal · crackedINTERCOSTAL CRACKED AT BUTTLINE 0 STATION 285.5. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02-0G.SDR AALA20100108TUL09Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM STATION 294.5 RIGHT BUTTLINE 13 TO RIGHT BUTTLINE 21. REPLACED UPPER "T" CAP PER ENGINEERING AUTHORIZATION B737-53-008449 AND B737-53-008405.SDR AALA20100108TUL11Intercostal · crackedINTERCOSTAL CRACKED AT SCREW HOLE FORWARD OF STATION 328 IN FWD ENTRY AREA. REMOVED AND REPLACED PART PER SRM 51-10-02-OG.SDR AALA20100108TUL10Frame · crackedFRAME 500F RIGHT CRACKED. REPAIRED FRAME 500F RIGHT PER ENGINEERING CHANGE ORDER J1159AC.SDR AALA20100108TUL08Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL BRACKET AT STATION 727D LEFT SIDE AT INBOARD FASTENER. REPAIRED FRAME PER ENGINEERING CHANGE ORDER J1159AC.SDR AALA20100108TUL07Frame · crackedFRAME 440 LEFT CRACKED. REPAIRED FRAME 440 LEFT PER ENGINEERING CHANGE ORDER J1159ACSDR AALA20100108TUL06Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL BRACKET STATION 440, LEFT SIDE AT INBOARD FASTENER. REPAIRED FRAME 440 LEFT PER ECO J1159AC.SDR AALA20100108TUL05Frame · crackedFRAME 500C RIGHT CRACKED. REPAIRED FRAME 500C RIGHT PER ENGINEERING CHANGE ORDER 1159AC.SDR AALA20100108TUL03Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL BRACKET STATION 827 LEFT SIDE AT INBOARD FASTENER. REPAIRED FRAME 827 LEFT SIDE PER ECO J1159AC.SDR AALA20100108TUL02Floor Support · corrodedAFT CARGO FLOOR SUPPORT CORRODED. REMOVED CORROSION BY BLENDING PER SRM 51-10-2, FOUND TO BE OUT OF MANUAL LIMITS. FABRICATED REPAIR STRAP, ALODINED AND PRIMED REPAIR PARTS AND SUPPORT STRUCTURE, INSTALLED REPAIR STRAP ONTO FLANGE LOWER SURFACE PER ENGINEERISDR AALA20100108TUL01Intercostal · crackedINTERCOSTAL CRACKED RIGHT BUTT LINE 30, STATION 328. INSTALLED INTERCOSTAL PER SRM 51-10-02-OG.SDR AALA20100108TUL04Floor Support · corrodedCORROSION ON RIGHT FLOOR SUPPORT STATION 794 TO 847 INBOARD OF SILL WEB PLATE. REMOVED CORROSION PER SRM 51-1-02, WITHIN LIMITS PER SRM 53-60-15-1A.SDR AALA20100105TUL01Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL BRACKET STATION 380 LEFT SIDE AT INBOARD FASTENER. REPAIRED CRACKED FRAME UNDER ECO J1159AC.SDR AALA20091221TUL02Angle · corrodedCORROSION ON FORWARD GALLEY DOOR OPENING LOWER CREASE ANGLE AT STATION 325.5. REMOVED AND REPLACED CREASE ANGLE PER SRM 51-10-02-0G.SDR AALA20091221TUL01Web · corrodedCORROSION ON AFT CARGO DOOR SILL WEB. REPLACED WEB PER 51-10-02.SDR AALA20091218TUL10Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM AT STATION 986 LEFT BUTTLINE 28 TO LEFT BUTTLINE 30. REPAIRED UNDER SRM 51-00-51-2R.SDR AALA20091218TUL05Angle · corrodedCORROSION ON TOP OF Z-ANGLE STATION 991 AT LEFT BUTTLINE 40.5 TO LBL 43. REPLACED Z-ANGLE PER SRM 51-10-2.SDR AALA20091218TUL04Angle · corrodedCORROSION ON TOP OF Z-ANGLE AT LEFT BUTTLINE 30 AT STATION 1014.5. INSTALLED NEW Z-ANGLE PER SRM 51-10-2.SDR AALA20091217TUL12Skin · corrodedAREAS OF CORROSION ON RIGHT INBOARD FLAP TRAILING EDGE SECTION UPPER SURFACE. FABRICATED FILLER AND DOUBLER FOR SKIN REPAIR AND HOT BONDED PER 51-70-10-2R4 FIG 202A.SDR AALA20091217TUL11Skin · dentedDENT ON UPPER SKIN HONEYCOMB TRAILING EDGE NEAR INBOARD END. FABRICATED FILLER AND DOUBLER THEN HOT BONDED PER SRM 51-70-10.SDR AALA20091217TUL10Vane · corrodedLEFT WING INBOARD FLAP AFT VANE TRAILING EDGE CORRODED ON UPPER SURFACE. FABRICATED FILLERS AND DOUBLERS. HOT BONDED REPAIR PER 51-70-10 2R4 FIG 202A.SDR AALA20091217TUL02Skin · dentedFORWARD CARGO DOOR HAS MULTIPLE DENTS AND SCRATCHES ON OUTER DOOR SKIN. REMOVED AND REPLACED OUTER SKIN ON FWD DOOR PER ESO 60654.SDR AALA20091218TUL01Web · wornACCESS DOOR TO ELECTRICAL COMPARTMENT WEB IS WORN LEFT SIDE OF DOOR FRAME. INSTALLED REPAIR FILLER AND DOUBLER PER SRM 51-70-13-2R-1.SDR AALA20091216TUL17Skin · damagedAFT CARGO DOOR HAS MULTIPLE DENTS AND SCRATCHES. NEED SKIN TO BE CHANGED. INSTALLED NEW OUTER SKIN ON AFT CARGO DOOR PER ESO 60651.
Back to N915AN