N947AN
Service difficulty reports · 202
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 = 'N947AN' 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 = 'N947AN' 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 AALA202404268445Slide · dislodgedAIRCRAFT WAS GROUNDED: AFTER GATE ARRIVAL UPON OPENING 1L PASSENGER DOOR, THE SLIDE FELL OUT OF THE BUSTLE AND ONTO THE RAMP.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202402079323Pin · out of positionAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDENT FOUND A PIN DOOR SLIDE INSTALLATION IN AIRCRAFT BY DOOR R1. INSTALLED R1 DOOR SLIDE SAFETY PIN INTO POCKET AS REQUIRED. PER AMM 25-66-01.SDR AALA202402068505Pin · misinstalledAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISH JOB CARD TEST EMERGENCY LIGHT 08T20033001 FOUND EMERGENCY AISLE LIGHT LOCATED ON THE CEILING BETWEEN STA 787 AND STA 907 INOPERATIVE FOUND PINS IN AISLE LIGHT INSTALLED IN THE WRONG POSITIONS. PUT WIRES IN CORRECT POSDR AALA202401298505Light · inoperativeAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISH JOB CARD TEST EMERGENCY LIGHT 08T20033001 FOUND EMERGENCY AISLE LIGHT LOCATED ON THE CEILING BETWEEN STA 787 AND STA 907 INOPERATIVE.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401111385Door · out of adjustAIRCRAFT WAS GROUNDED: L1 DOOR OUT OF RIG, VERY DIFFICULT TO CLOSE FROM THE INSIDE. ADJUSTED UPPER GUIDE ARM. PER AMM 52-11-00-820-801 (STEP H). OPERATIONAL CHECK GOOD.SDR AALA202312261095Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: COCKPIT ENTRY DOOR ONLY OPENS APPROX 70% OF FULL OPEN. LUBRICATED COCKPIT DOOR . PER 52-51-01-200-801 OPERATIONAL CHECK GOOD.SDR AALA202308010640Door · misalignedAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO SLIDE OPEN OR CLOSE. ADJUSTED LEFT AFT LAVATORY DOOR PER CMM 25-47-21.SDR AALA202305199006Door · out of adjustAIRCRAFT WAS NOT GROUNDED. AFT LEFT LAVATORY DOOR OFF TRACK. READJUSTED AFT LEFT LAVATORY DOOR. CHECKS GOOD PER CMM 25-40-64.SDR AALA202305191321Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR LATCH HARD TO OPEN. ADJUSTED LAVATORY D DOOR PER AMM 25-40-14.SDR AALA202304039447Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER SRM 51-40-02-0G AND EA 343131A.SDR AALA202304039461Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER SRM 51-40-02-0G AND EA 343131A.SDR AALA202304034017Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER SRM 51-40-02-0G AND EA 343131A.SDR AALA202304030306Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER SRM 51-40-02-0G AND EA 343131A.SDR AALA202304035199Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER SRM 51-40-02-0G AND EA 343131A.SDR AALA202304035138Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER SRM 51-40-02-0G AND EA 343131A.SDR AALA202304039726Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER SRM 51-40-02-0G AND EA 343131A.SDR AALA202304032905Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER SRM 51-40-02-0G AND EA 343131A.SDR AALA202304039034Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER SRM 51-40-02-0G AND EA 343131A.SDR AALA202304030323Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER SRM 51-40-02-0G AND EA 343131A.SDR AALA202211309851Skin · crackedAIRCRAFT WAS GROUNDED: L1 DOOR LOWER HINGE CUTOUT OUTER SKIN TEAR DAMAGED. CRACK LOCATED AT STA 312 AND WATERLINE 227.54. CUT OUT DAMAGE AND TREATED SKIN PER SRM 52-10-01.SDR AALA202211087722Fairing · delaminatedAIRCRAFT WAS GROUNDED: DURING WALK AROUND FOUND LEFT HAND WING TO BODY FAIRING PANEL 194GL WITH CLUSTERED DELAMINATION. REPAIRED FAIRING PER EA 340315.SDR AALA202209198808Pin · looseAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR 1L DIFFICULT TO OPEN. FOUND GUIDE ARM UPPER RADIUS LINK PIN LOOSE. RE-TIGHTENED GUIDE ARM UPPER RADIUS LINK PER IAW AMM 52-11-21, OPERATIONAL CHECK GOOD PER AMM 52-11-21.SDR AALA202209146994Handle · lack of lubeAIRCRAFT WAS NOT GROUNDED: 1L BOARDING DOOR DIFFICULT TO OPEN FROM OUTSIDE AND INSIDE LEVER SEEMS TO BE DIFFICULT TO OPERATE AS WELL. SERVICED FORWARD ENTRY DOOR HANDLE PER AMM 12-25-11.SDR AALA202208127378Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND AFT OVERWING EMERGENCY EXIT EXTERNAL LIGHT INOPERATIVE. REMOVED AND INSTALLED SERVICEABLE BATTERY PACK AT LOCATION 727C+13 IN ACCORDANCE WITH AMM 33-51-06, WDM 33-51-14.SDR AALA202207298312Door · stickingAIRCRAFT WAS GROUNDED: L1 DOOR DIFFICULT TO CLOSE COMPLETELY. UPON ARRIVAL DOOR WAS UNABLE TO OPEN FROM EXTERIOR. FLIGHT ATTENDANTS REPORT THAT THE DOOR DOES NOT FEEL NORMAL IN CLOSING. TRIMMED L1 DOOR TO ALLOWABLE LIMITS PER AMM 52-11-00 REF FORM 10194A.SDR AALA202207186595Door Latch · stickingAIRCRAFT WAS NOT GROUNDED: L1 DOOR VERY HARD TO OPEN LATCH FROM OUTSIDE. LUBED L1 DOOR LATCH OPERATIONS CHECK GOOD PER AMM 12-20.SDR AALA202201100993Lock · stickingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY LOCK DIFFICULT TO LOCK/UNLOCK. ADJUSTED LOCK MECHANISM AT AFT LAVATORY PER AMM 52-50-00.SDR AALA202112209419Position Switch · inoperativeAIRCRAFT WAS GROUNDED: NOSE GEAR INDICATOR GREEN LIGHT INOPERATIVE. ALSO ON OVERHEAD NOSE GEAR GREEN INOPERATIVE (WHEN GEAR SELECTED DOWN BOTH MAIN AND OVERHEAD GREEN). REMOVED AND REPLACED ASSEMBLY L6 ON P2-3 PANEL. FOUND FUSE BLOWN.SDR AALA202112140048Latch · stickingAIRCRAFT WAS NOT GROUNDED: LAVATORY L4 DOOR LATCH HARD TO OPEN AND CLOSE. CHECKED AND LUBRICATED AFT LEFT LAVATORY DOOR LATCH. NO DEFECTS NOTED, OPERATIONS CHECK NORMALSDR AALA202112106812Sign · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN NEXT TO LEFT AFT EMERGENCY DOOR BROKEN. REMOVED AND REPLACED EMERGENCY EXIT SIGN ASSEMBLY. OPERATIONS CHECK OK FOR SERVICE PER AMM 33-51-01.SDR AALA202111181273Lens · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT INDICATOR ON THE AISLE AT SEAT 17C IS MISSING. INSTALLED LEFT EXIT SIGN LENS AT 17C.SDR AALA202108301740Actuator · inoperativeAIRCRAFT WAS GROUNDED: RIGHT WING NUMBER 8 SPOILER SHAKES WHEN DEPLOYED TO FLIGHT DETENT. REMOVED AND REPLACED RIGHT WING NUMBER 8 SPOILER ACTUATOR PER B737NG AMM 27-61-51 AND AMM 27-61-00.SDR AALA202108311872Skin · damagedAIRCRAFT IN BASE MAINTENANCE: REPLACEMENT OF TEMPORARY SKIN REPAIR AT STA 1088 BETWEEN STR 24R AND STR 25R, MEASURING L=0.75 IN, 0.5 IN, D=0.25 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW EA329907A.SDR AALA202108273931Stringer · tornAIRCRAFT IN BASE MAINTENANCE: TORN STRINGER AT ATTACH FITTING FASTENER HOLE AT STA 1086 AND STR 24R, MEASURING L=0.25 IN, W=0.25 IN, D=0.032 IN. ACCOMPLISHED PERMANENT REINFORCING REPAIR WITH NESTED ANGLES IAW SRM 53-00-03-2R-1.SDR AALA202108273643Keelbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CLIP ON KEEL BEAM LOWER LOWER SURFACE AT STA 549 AND LBL5. REPLACED CLIP WITH NEW IAW SRM 51-40-02.SDR AALA202108273018Keelbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CLIP ON KEEL BEAM LOWER LOWER SURFACE AT STA 549 AND RBL5. REPLACED CLIP WITH NEW IAW SRM 51-40-02.SDR AALA202107218911Lanyard · unsecureAIRCRAFT WAS NOT GROUNDED: 16 A RED LANYARD COVER NOT SECURE AT OVERWING EXIT. RE SECURED LANYARD FOR OVERWING WINDOW EXIT AT 16A.SDR AALA202006049003Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED. SMOKE ALERT FOR AFT RIGHT LAVATORY. SUSPECT PERFUME SPRAY. ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK OF THE AFT RIGHT LAVATORY SMOKE DETECTOR PER AMM 26-14-00.SDR AALA202004109005Filter · cloggedAIRCRAFT WAS GROUNDED: DIVERTED TO DFW ACCOUNT LEFT ENGINE FUEL FILTER BYPASS ILLUMINATED ON,CLIMBOUT. ALL ENGINE INDICATIONS NORMAL. LIGHT WENT,OFF/ON TWICE IN FLIGHT. REMOVED AND REPLACED #1 ENG FUEL FILTER PER 73-11-02, RUN AND LEAK CHECK ACCOMPLISHED AS RESDR AALA201911229012Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND L2 DOOR EMERGENCY ESCAPE SLIDE LIGHT INOPERABLE. MAINTENANCE REPLACED LAMP ON ESCAPE LIGHT PER AMM 33-51-04.SDR AALA201902139004Fire Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FOUND AFT HALON FIRE EXTINGUISHER WEIGHT BELOW LIMITS PER MCM CARD 0913. MAINTENANCE REPLACED FIRE EXTINGUISHER BOTTLE PER AMM 26-26-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201902049009Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY SMOKE DETECTOR CHIME WENT OFF. MAINTENANCE REPLACED LEFT AFT LAVATORY SMOKE DETECTOR PER AMM 26-14-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201902019008Smoke Detector · false activationFWD LAVATORY SMOKE DETECTOR CHIME, AND LIGHT ON IN THE COCKPIT. REPLACED THE FWD LAVATORY SMOKE DETECTOR IAW AMM 26-14-01. OPS CHECKED NORMAL.SDR AALA201806185005Web · corrodedCORROSION FOUND ON THE WEB RUNNING ALONG STRINGER 23L, BETWEEN BS 299 TO 335. REPLACED THE WEB IAW EA 281320, DRAWING 141A8131, AND 51-00-05.SDR AALA201806054002Floor Support · corrodedCORROSION FOUND ON FLOOR SUPPORT, BS 292, RBL 11. INSTALLED A REPAIR DOUBLER IAW EA 280897, DRAFT 1.SDR AALA201806063002Angle · corrodedCORROSION FOUND ON THE LEFT CREASE ANGLE BETWEEN BS 992 TO 951, LBL 51. REPLACED THE CREASE ANGLE IAW 51-00-05.SDR AALA201806052007Support Angle · corrodedCORROSION FOUND ON THE SUPPORT ANGLE AT BS 1016, LBL 32. REPLACED THE SUPPORT ANGLE IAW 51-00-05.SDR AALA201806052006Angle · corrodedCORROSION FOUND ON GALLEY FLOORBEAM ANGLE AT BS 993, BETWEEN LBL 32 - 46. REPLACED THE FLOORBEAM ANGLE IAW 51-00-05.SDR AALA201806052001Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM ANGLE AT BS 993, BETWEEN RBL 32-46. REPLACED THE FLOORBEAM ANGLE IAW 51-00-05.SDR AALA2018060691003Transition Panel · corrodedDURING INSPECTION, FOUND NUMEROUS CORROSION AREAS ON THE LEFT TRANSITION PANEL BETWEEN BS 807 - 827. REMOVED AND REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R.
Back to N947AN