N924AN
Service difficulty reports · 212
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 = 'N924AN' 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 = 'N924AN' 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 AALA202308212863Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, FOURTH VERTICAL STIFFENER FROM FRONT ON RIB, 10 INCHES AFT OF SPAR, LOCATED AT STABILIZER STA 92.70. REPAIRED RIB PER SRM 55-10-09-2R-4.SDR AALA202308108178Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, FIRST STIFFENER FROM FRONT, LOCATED AT STABILIZER STA 92.70. REPAIRED RIB PER SRM 55-10-09-2R.SDR AALA202308091619Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM BS 312 TO BS 328 AT RBL 30. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND SRM 51-10-02.SDR AALA202308097197Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM BS 277 TO BS 294 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202309011519Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENERS HOLES IN FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 950, FROM RBL 24 TO RBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202308149193Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES ON FLOORBOARD SUPPORT INTERCOSTAL LOCATED AT BS 950, RBL 34.75. REPLACED INTERCOSTAL PER AARD 51-00-05 1.SDR AALA202308105565Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED AT BS 961 AND LBL 24.75. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202308103780Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED AT BS 953 AND LBL 24.75. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202308103889Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOORBEAM OUTBOARD OF RIGHT HAND AFT LAVATORY MOUNT, LOCATED AT BS 947 AT RBL 51. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-5.SDR AALA202308101815Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500H TO BS 500I AT LBL 25. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 5..SDR AALA202308095939Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED AT BS 550G + 8 AND RBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202309016259Slat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT WING NUMBER 5 SLAT INBOARD MAIN TRACK FLANGE HAS CORROSION. REMOVED AND REPLACE RIGHT HAND NUMBER 5 INBOARD MAIN SLAT TRACK PER AMM 27-81-21-400-802.SDR AALA202305317032Unknown · unknownAIRCRAFT WAS NOT GROUNDED: ON TAKEOFF FROM JFK, AIRCRAFT HIT BLOWN TIRE DEBRIS FROM PRIOR DEPARTING AIRCRAFT. EMERGENCY DECLARED ON APPROACH TO AUS. AIRCRAFT LANDED SAFELY. MAINTENANCE ACCOMPLISHED ENGINE FOREIGN OBJECT DAMAGE AND BIRDSTRIKE INSPECTION PER AMMSDR AALA202211086264Pseu · faultedAIRCRAFT WAS NOT GROUNDED: ON MULTIPLE OCCASIONS R1 DOOR WARNING CAME ON IN FLIGHT. DOOR HANDLE WAS DOWN. REPLACED PROXIMITY SWITCH ELECTRONICS UNIT (PSEU) PER AMM 32-09-10 AND ACCOMPLISHED FIM TASK 52-10-00-810-801.SDR AALA202211081286Pseu · faultedAIRCRAFT WAS NOT GROUNDED: ON MULTIPLE OCCASIONS L1 DOOR WARNING CAME ON IN FLIGHT. ACCOMPLISHED PROXIMITY SWITCH ELECTRONICS UNIT (PSEU) BITE PROCEDURE PER AMM 32-09-00. FOUND PSEU INTERNAL FAULT. REPLACED PSEU PER AMM 32-09-10 AND ACCOMPLISHED SATISFACTORY OSDR AALA202210251009Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210259395Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210254860Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210258808Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210256605Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210256909Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210253669Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202211157021Shear Tie · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER EA 339611. **SUPPLEMENTAL REPORT FOR AALA202210257021: UPDATED CRACK LOCATION TO CORRECT LOCATION SECTION 4 AND 7 UPDASDR AALA202210254576Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210257021Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210250921Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202208230315Hydraulic System · reads lowAIRCRAFT WAS GROUNDED: IN CRUISE HYDRAULIC QUANTITY A CONTINUED TO FALL. LOWEST LEVEL WAS 60%. FLIGHT RETURNED TO DFW, LANDING SAFELY. SERVICED HYDRAULIC SYSTEM A TO 93% PER AMM 12-12-00. RAN ELECTRIC AND ENGINE DRIVEN PUMPS, OPERATED FLIGHT CONTROLS AND FLAPSSDR AALA202208167686Window · delaminatedAIRCRAFT WAS GROUNDED: R1 LOWER CENTER WINDSHIELD DELAMINATED AREA GROWS 3X LARGER IN FLIGHT -6 INCHES X 1 INCH AT ALTITUDE. REMOVED AND REPLACED R1 WINDOW PER JOB CARD 08L21056004.SDR AALA202205102488Battery · not seatedAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE INOPERATIVE. RESEATED BATTERIES. OPERATIONAL CHECK OK PER AMM 25-64-00.SDR AALA202205049217None · reads lowAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK FIRE EXIT IN FLIGHT- POP HIS GAUGE BELOW GREEN ZONE. REMOVED AND REPLACED FLIGHT DECK FIRE EXIT.SDR AALA202112108765Warning Light · illuminatedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR LIGHT CAME ON DURING DESCENT INTERMITTENT. **SUPPLEMENTAL REPORT FOR AALA202112098765: PERFORMED OPERATIONAL CHECKS PER AMM 32-09-10-C AND 33-18-00 WITH NO FAULTS NOTED, MAINTENANCE COULD NOT DUPLICATE ISSUE ON THESDR AALA202112098765None · noneAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR LIGHT CAME ON DURING DESCENT INTERMITTENT. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202112082681Sliding Window · stickingAIRCRAFT WAS GROUNDED: L2 WINDOW DIFFICULT TO OPEN AND CLOSE. REPLACED L2 SLIDING WINDOW WITH SERVICEABLE UNIT IAW WORKCARD 56-94-01, OPS CHECK GOOD.SDR AALA202111290601Sliding Window · crackedAIRCRAFT WAS GROUNDED: ON PRE FLIGHT, CAPTAIN'S SLIDING WINDSHIELD FOUND CRACKED. REPLACED #2 LEFT CAPTAIN WINDOW ASSEMBLY PER JOB CARD 08C21156002.SDR AALA202107221124Circuit Breaker · trippedAIRCRAFT WAS NOT GROUNDED: AT BEGINNING OF TAKE OFF ROLL BOTH RIGHT AFT AND FWD OVERWING EXIT LIGHTS ILLUMINATED. FOUND CIRCUIT BREAKER D1 ON P6-2 OUT. RESET CIRCUIT BREAKER PER AMM 20-60-01-2 AND PER FIM 32-09-00-810-801. SYSTEM CHECKED GOOD. LIGHTS ARE OUT. SDR AALA202107019003Sign · looseAIRCRAFT WAS NOT GROUNDED: AFT GALLEY EMERGENCY EXIT SIGN OVERHEAD REPORTED LOOSE. SECURED SIGN PER AMM 33-51-00.SDR AALA202106229008Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED AT STA 360 AND S28L. REPARIED PER AARD 51-20-01-1 AND EA 328108.SDR AALA202106079016Slide · damagedAIRCRAFT WAS NOT GROUNDED: SLIDE EXPANDED DURING REINSTALL. ACCOMPLISHED REMOVAL AND REPLACEMENT OF R2 DOOR SLIDE ASSEMBLY.SDR AALA202103119009Pump · low pressureAIRCRAFT WAS GROUNDED: LH ENGINE HYDRAULIC PUMP LOW PRESSURE LIGHT ILLUMINATED, FLIGHT DECLARED EMERGENCY AND LANDED WITHOUT FURTHER INCIDENT. REPLACED LH ENGINE DRIVEN PUMP WITH SERVICEABLE UNIT IAW AMM 29-11-11-400-801-001, OPS CHECK GOOD.SDR AALA202101219008Support Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE. MAIN LANDING GEAR FORWARD TRUNNION SUPPORT FITTING HAS CORROSION. REPLACED SUPPORT FITTING, IAW MCM 32-94-24.SDR AALA202101209021Support Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE. FORWARD TRUNNION SUPPORT FITTING HAS CORROSION. REPLACED LEFT MAIN LANDING GEAR SUPPORT FITTING, IAW MCM 32-94-24.SDR AALA2020081969022Seat Track · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND TANGS CRACKED OFF SEAT TRACK AT STA 360-480 AND BL 24.75 WITH DIMENSIONS 1" X 1/2". REMOVED AND REPLACED SEAT TRACK IAW SRM 51-40-02-0G-0.SDR AALA202003279006Pump · faultyAIRCRAFT WAS GROUNDED: DURING AFTER LANDING TAXI RIGHT ENGINE WOULD NOT RESPOND TO THROTTLE INCREASE THRUST VECTOR ADVANCED BUT ENGINE WOULD NOT ACCELERATE. INSPECTED AND ACCOMPLISHED FUEL PUMP PACKAGE REMOVAL AND INSTALLATION IAW 73-11-01. ENGINE RUN TEST ANSDR AALA202003279008Pump · faultyAIRCRAFT WAS GROUNDED: DURING AFTER LANDING TAXI RIGHT ENGINE WOULD NOT RESPOND TO THROTTLE INCREASE THRUST VECTOR ADVANCED BUT ENGINE WOULD NOT ACCELERATE. INSPECTED AND ACCOMPLISHED FUEL PUMP PACKAGE REMOVAL AND INSTALLATION IAW 73-11-01. ENGINE RUN TEST ANSDR AALA201912229008Anti-Ice Valve · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS RIGHT AFTER AUTO THROTTLE ENGAGEMENT, ANTI-ICE CAUTION LIGHT CAME ON. TAKE OFF WAS ABORTED AT ABOUT 30 KNOTS, ENGINE ANTI-ICE WAS ON FOR TAKE OFF. MAINTENANCE REMOVED & REPLACED ENG ANTI-ICE VALVE ON #1 & #2 ENG IAW AMM 30-SDR AALA201912239023Anti-Ice Valve · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS RIGHT AFTER AUTO THROTTLE ENGAGEMENT, ANTI-ICE CAUTION LIGHT CAME ON. TAKE OFF WAS ABORTED AT ABOUT 30 KNOTS, ENGINE ANTI-ICE WAS ON FOR TAKE OFF. MAINTENANCE REMOVED & REPLACED ENG ANTI-ICE VALVE ON #1 & #2 ENGINE IAW AMM SDR AALA201909159011Smoke Detector · false activationAIRCRAFT NOT GROUNDED: FORWARD LAV SMOKE ALARM AND LIGHT WAS ON WITH AUDIBLE ALARM. SMOKE LIGHT IN COCKPIT ILLUMINATED. VISUAL INSPECTION FOUND NO SMOKE, ALARM / LIGHT WENT OUT AFTER 3 MINS. RESET FWD LAV SMOKE GET C/B. RESET SYS. GREEN LIGHT ON, ON DECTECSDR AALA201807199015Filter · dirtyAIRCRAFT WAS NOT GROUNDED. TRANSIENT ODOR DURING AND AFTER TAKEOFF REPORTED BY CABIN CREW. MOLD, MILDEW, WET DOG SMELL, MOSTLY FORWARD TO MID CABIN. PERFORMED ENGINE RUN PER CARD MCM 05-96-70. SLIGHT ODOR NOTICED ON TAXI BUT DISSIPATED QUICKLY. REPLACED RECIRCSDR AALA201802089004Smoke Detector · false activationFORWARD LAVATORY SMOKE DETECTOR ACTIVATED WITH NO SMOKE PRESENT. REPLACED THE FORWARD LAVATORY SMOKE DETECTOR IAW AMM 26-14-01.SDR AALA201706089003Fitting · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON VERTICAL STABILIZER FRONT SPAR TERMINATION FITTING, LEFT FORWARD LUG ON AFT SIDE, FORWARD SIDE, INSIDE OF BORE AND RIGHT FORWARD LUG INSIDE OF BORE. REPAIRED IAW EA 269829.
Back to N924AN