N942AN
Service difficulty reports · 210
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 = 'N942AN' 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 = 'N942AN' 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 AALA202312133209Handle · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY "A" DOOR HARD TO OPEN AND CLOSE. CLEANED AND LUBED FORWARD LAVATORY DOOR HANDLE ASSEMBLY PER AMM 12-25-41.SDR AALA202312014512Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR GETS STUCK IN FLIGHT VERY HARD TO OPEN AND CLOSE. READJUSTED LOCK ASSEMBLY AND LUBRICATED HING ON LAV. FUNCTIONAL CHECK GOOD. AMM 25-41-00.SDR AALA202310045850Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. LUBRICATED DOOR HINGE AS REQUIRED. PER AMM 25-40-00. FUNCTIONAL CHECK GOOD.SDR AALA202309254093Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE IN FLIGHT. ADJUSTED UPPER DOOR MOLDING AT FORWARD LAVATORY. PER AARD 25-40-10. FUNCTIONAL CHECK GOOD.SDR AALA202309266158Handle · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS DIFFICULT TO OPEN. RESECURED DOOR HANDLE.SDR AALA202309209637Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN. ADJUSTED LATCH.SDR AALA202308095428Light · brokenAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING BROKEN AT 29C. REINSTALLED EMERGENCY LIGHT ASSEMBLY AT 29C.SDR AALA202306203205Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT CABIN FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT (AFT CABIN).SDR AALA202305312486Slide Raft · unknownAIRCRAFT WAS GROUNDED: DUE TO SLIDE PACK EXPANSION REPLACE SLIDE. REPLACED L1 SLIDE.SDR AALA202303151683Unknown · looseAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAV DOOR STICKS. SECURED LOOSE TRIM AT TOP OF DOOR. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302230700Cover · looseAIRCRAFT WAS NOT GROUNDED: EXIT PATH LIGHTING AT ROW 19C LOOSE. **SUPPLEMENTAL REPORT FOR AALA202302200700: REPLACED EXIT PATH LIGHT COVER.** (CLOSED)SDR AALA202302200700None · noneAIRCRAFT WAS NOT GROUNDED: EXIT PATH LIGHTING AT ROW 19C LOOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202211304264Fitting · 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 340464.SDR AALA202211306637Fitting · 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 340464.SDR AALA202211300452Fitting · 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 340464.SDR AALA202211308059Fitting · 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 340464.SDR AALA202211308842Fitting · 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 340464.SDR AALA202211309649Fitting · 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 340464.SDR AALA202211309349Fitting · 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 340464.SDR AALA202211302411Fitting · 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 340464.SDR AALA202211300097Fitting · 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 340464.SDR AALA202211302308Fitting · 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 340464.SDR AALA202210319641Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT RIGHTHAND FLIGHT ATTENDANT JUMP SEAT FLASHLIGHT #1 INOPERATIVE. REPLACED BATTERY PER AMM 25-64-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202210310287Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT RIGHTHAND FLIGHT ATTENDANT JUMP SEAT FLASHLIGHT #2 INOPERATIVE. REPLACED BATTERY PER AMM 25-64-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202210204262Light · damagedAIRCRAFT WAS NOT GROUNDED: SEAT 10C FLOOR PROXIMITY EMERGENCY LIGHT DAMAGED. REPLACED SEAT 10C FLOOR PROXIMITY LIGHT PER AMM 33-51-11. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202208097896Pump · inoperativeAIRCRAFT WAS GROUNDED: AFTER TAKE-OFF FUEL IMBALANCE BETWEEN WING TANKS. APPEARED THAT FUEL WAS FEEDING FROM LEFT FUEL TANK. THE MEL INDICATED THE LOW PRESSURE LIGHT INOPERATIVE HOWEVER- SEEMS THE PUMP ITSELF IS THE ISSUE. AIRCRAFT DIVERTED TO STL. ON LANDINSDR AALA202208099172Pump · inoperativeAIRCRAFT WAS GROUNDED: AFTER TAKE-OFF FUEL IMBALANCE BETWEEN WING TANKS. APPEARED THAT FUEL WAS FEEDING FROM LEFT FUEL TANK. THE MEL INDICATED THE LOW PRESSURE LIGHT INOPERATIVE HOWEVER- SEEMS THE PUMP ITSELF IS THE ISSUE. AIRCRAFT DIVERTED TO STL. ON LANDINSDR AALA202208099550None · inoperativeAIRCRAFT WAS GROUNDED: AFTER TAKE-OFF FUEL IMBALANCE BETWEEN WING TANKS. APPEARED THAT FUEL WAS FEEDING FROM LEFT FUEL TANK. THE MEL INDICATED THE LOW PRESSURE LIGHT INOPERATIVE HOWEVER- SEEMS THE PUMP ITSELF IS THE ISSUE. AIRCRAFT DIVERTED TO STL. ON LANDINSDR AALA202208094979Relay · inoperativeAIRCRAFT WAS GROUNDED: AFTER TAKE-OFF FUEL IMBALANCE BETWEEN WING TANKS. APPEARED THAT FUEL WAS FEEDING FROM LEFT FUEL TANK. THE MEL INDICATED THE LOW PRESSURE LIGHT INOPERATIVE HOWEVER- SEEMS THE PUMP ITSELF IS THE ISSUE. AIRCRAFT DIVERTED TO STL. ON LANDINSDR AALA202208098329Relay · inoperativeAIRCRAFT WAS GROUNDED: AFTER TAKE-OFF FUEL IMBALANCE BETWEEN WING TANKS. APPEARED THAT FUEL WAS FEEDING FROM LEFT FUEL TANK. THE MEL INDICATED THE LOW PRESSURE LIGHT INOPERATIVE HOWEVER- SEEMS THE PUMP ITSELF IS THE ISSUE. AIRCRAFT DIVERTED TO STL. ON LANDINGSDR AALA202206211495Windshield · delaminatedAIRCRAFT WAS GROUNDED: FIRST OFFICER'S WINDSHIELD APPEARS CRACKED / DELAMINATED IN TOP LEFT CORNER. REPLACED WINDSHIELD PER JOB CARD 08C21256001.SDR AALA202201198917Latch · inoperativeAIRCRAFT WAS NOT GROUNDED: DOOR TO COCKPIT WILL NOT OPEN. REMOVED AND REPLACED COCKPIT DOOR LATCH ASSEMBLY PER AMM 52-51-02.SDR AALA202201037466Cover · missingAIRCRAFT WAS NOT GROUNDED: OVERWING EMERGENCY EXIT SIGN COVER MISSING. REPLACED SIGN PER AMM 33-50-00.SDR AALA202110045448Cover · detachedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT COVER AT SEAT 10C IS DETACHED. RESECURED SEAT 10C ESCAPE PATH LIGHT COVER PER AMM 20-00-00.SDR AALA202109219508Sign · inoperativeAIRCRAFT WAS NOT GROUNDED: EXIT ROW SIGN FELL DOWN. RE SECURED EXIT ROW SIGN AS REQUIRED.SDR AALA202108186605Sensor · inoperativeAIRCRAFT WAS GROUNDED: LEADING EDGE SLAT INDICATION FAULT, FLIGHT DECLARED EMERGENCY AND DIVERTED TO SJU. REPLACED #4 SLAT RETRACT SENSOR WITH SERVICEABLE UNIT IAW AMM 27-88-11, OPS CHECK GOOD.SDR AALA202108020835Door · displacedAIRCRAFT WAS NOT GROUNDED: LH AFT LAVATORY DOOR DISPLACED FROM TRACK. REINSTALLED DOOR ON TRACK, OPS CHECK GOOD.SDR AALA202107192750Slide · inoperativeAIRCRAFT IN BASE MAINTENANCE: L1 DOOR SLIDE LATCH ASSEMBLY REQUIRES REPLACEMENT. REPLACED SLIDE.SDR AALA202106029009Screw · looseAIRCRAFT WAS NOT GROUNDED: FWD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. TIGHTENED FWD LAV DOOR HINGE SCREWS TO DOOR FRAME AND THRESHOLD MOUNT SCREWS, OPS CHECK GOOD.SDR AALA202105149009Warning Switch · inoperativeAIRCRAFT WAS GROUNDED: TAKE OFF WARNING HORN SOUNDED AND TAKE OFF CONFIGURATION LIGHT ILLUMINATED WHEN THRUST LEVERS ADVANCED FOR TAKEOFF. REMOVED AND REPLACED THE SPEED BRAKE TAKEOFF WARNING SWITCH S651 IAW WDM 31-53-11.SDR AALA202107138303Fitting · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES ON SEAT TRACK VERTICAL SPLICE FITTING LOCATED AT STA 887 AND LBL 45.5.SDR AALA202107133131Angle · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES ON MAIN CABIN FLOOR SEAT TRACK CARRY THRU ANGLE LOCATED AT STA 887 AND LBL 24.75. REPAIRED PER EA 326152.SDR AALA202102019036Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT BATTERY PACKS AT STA 727C+13 LT AND RT NOT WORKING PROPERLY. REPLACED RT AND LT AALA202102019029 BATTERY PACKS IAW AMM 33-51-06, OPS CHECK GOOD.SDR AALA202102019029Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT BATTERY PACKS AT STA 727C+13 LT AND RT NOT WORKING PROPERLY. REPLACED LT AND RT AALA202102019036 BATTERY PACKS IAW AMM 33-51-06, OPS CHECK GOOD.SDR AALA202007159023Sensor · faultyAIRCRAFT WAS GROUNDED: ON APROACH INTO DFW LEADING EDGE FLAPS TRANSIT LIGHT CAME ON WHEN FLAPS 10 DEGREES SELECTION. LEADING EDGE FLAP 1 CYCLED ON APPROACH CAUSING LEADING EDGE FLAP TRANSIT TO CYCLE FROM AMBER TO GREEN. NO ROLL ENCOUNTERED. AN EMERGENCY WASSDR AALA2020070879011Fuel Filter · cloggedAIRCRAFT GROUNDED - AFTER TAKEOFF, LEFT FILTER BYPASS LIGHT ILLUMINATED FOR 10 MINUTES WITH MASTER CAUTION. DID NOT REOCCUR AGAIN DURING FLIGHT, ENGINE INDICATIONS ALL NORMAL. REMOVED AND REPLACED #1 FUEL FILTER DIFFERENTIAL PRESSURE SWITCH (AALA202007079001) SDR AALA2020070879001Pressure Switch · defectiveAIRCRAFT GROUNDED - AFTER TAKEOFF, LEFT FILTER BYPASS LIGHT ILLUMINATED FOR 10 MINUTES WITH MASTER CAUTION. DID NOT REOCCUR AGAIN DURING FLIGHT, ENGINE INDICATIONS ALL NORMAL. REMOVED AND REPLACED #1 FUEL FILTER DIFFERENTIAL PRESSURE SWITCH (AALA202007079001) SDR AALA202006189001Charger · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT ROW 21ABC EMERGENCY LIGHT BATTERY CHARGER NOT CHARGING. REPLACED EMERGENCY LIGHT BATTERY CHARGER AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA2020061979008Snubber · wornAIRCRAFT WAS NOT GROUNDED: L1 DOOR SNUBBER WORN OUT AND HAS TOO MUCH PLAY. REPLACED L1 DOOR SNUBBER PER AMM 52-11-51** (CLOSED)SDR AALA2020061979001Guide Arm · wornAIRCRAFT WAS NOT GROUNDED: L1 DOOR GUIDE ARM HOLD OPEN MECHANISM NOT HOLDING DOOR IN OPEN POSITION. REPLACED WORN GUIDE ARM ASSEMBLY PER AMM 52-11-21.
Back to N942AN