N946AN
Service difficulty reports · 187
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 = 'N946AN' 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 = 'N946AN' 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 AALA202303060674Fitting · 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 EA 342705.SDR AALA202303068875Fitting · 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 EA 342705.SDR AALA202303061566Fitting · 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 EA 342705.SDR AALA202303069189Fitting · 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 EA 342705.SDR AALA202303064000Fitting · 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 EA 342705.SDR AALA202303063555Fitting · 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 EA 342705.SDR AALA202303062033Fitting · 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 EA 342705.SDR AALA202303060704Fitting · 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 EA 342705.SDR AALA202303061358Fitting · 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 EA 342705.SDR AALA202301117623Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY ENTRY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LEFT AFT LAVATORY DOOR OPERATIONS CHECK GOOD.SDR AALA202301037491Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LATCH STICKS CLOSED. ADJUSTED AND LUBRICATED DOOR LATCH PER CMM 25-47-21.SDR AALA202212132267Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: L1 DOOR DIFFICULT TO OPEN FROM EXTERIOR. LUBRICATED DOOR HINGES PER AMM 25-40-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202203159202Mechanism · lack of lubeAIRCRAFT WAS NOT GROUNDED: AGENT REPORTED THAT 1L DOOR WAS DIFFICULT TO OPEN FROM JET BRIDGE. 1L DOOR MECHANISM LUBRICATED. OPERATIONAL CHECK GOOD PER AMM 12-25-11-640-802.SDR AALA202201122361Housing · out of positionAIRCRAFT WAS NOT GROUNDED: SEAT 29C EMERGENCY EXIT LIGHT SHROUD UNDER SEAT RAIL AT AISLE IS HANGING UNATTACHED WITH LIGHTING WIRE. UNIT HAS BEEN SHOVED INTO LIFE VEST BAG TO PREVENT LOSS. **SUPPLEMENTAL REPORT FOR AALA202201072361: REMOVED AND REPLACED EMERGENSDR AALA202201072361None · noneAIRCRAFT WAS NOT GROUNDED: SEAT 29C EMERGENCY EXIT LIGHT SHROUD UNDER SEAT RAIL AT AISLE IS HANGING UNATTACHED WITH LIGHTING WIRE. UNIT HAS BEEN SHOVED INTO LIFE VEST BAG TO PREVENT LOSS. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202109203288Cover · out of positionAIRCRAFT WAS NOT GROUNDED: OVER WING EMERGENCY EXIT LIGHT COVER FELL OFF LIGHT AND BROKE. LOCATION ROW 16 FACING AFT. REATTACHED LIGHT COVER ON OVERWING 16F EMERGENCY LIGHTS AS REQUIRED PER AMM 25-60-00.SDR AALA202107280062Door · stickingAIRCRAFT WAS GROUNDED: DURING DOOR INSPECTION OF L1 FORWARD ENTRY DOOR INSIDE HANDLE WHEN OPENING CREATES A LOUD THUD SOUND AND POP. INSIDE AND OUTSIDE HANDLES DOES NOT OPERATE SMOOTHLY. REPAIRED L1 DOOR PER AMM 52-11-00 OPERATIONS CHECK GOOD.SDR AALA202105259013Attach Fitting · out of adjustAIRCRAFT IN BASE MAINTENANCE: LAVAROTY E HARDPOINT FITTING OUT OF ALIGNMENT. REPLACED PER EA 327658.SDR AALA202006059001Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. AFT EMERGENCY LIGHT BATTERY PACK FAILED FUNCTIONAL CHECK PER TASK CARD 08T21033001. REPLACED AFT EMERGENCY LIGHT BATTERY PACK PER AMM 33-51-06.SDR AALA202004069014Fmc · faultyAIRCRAFT WAS GROUNDED: DUAL FMC FAILURE-CRUISE SEGMENT DUAL VTK AND MAP FAILURE FLAGS. SYSTEM AUTO RESET SIX TIMES. FINAL TIME, RESET DUMPED ALL FLIGHTS DATA. MANUAL INPUT DATA BOTH FMC FUNCTION NORMAL ON APPROACH. ACCOMPLISHED FIM 34-61-00-810-801 RH FMC HASDR AALA201907179005Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED LAVATORY E SMOKE DETECTOR ACTIVATED THEN SILENCED ON ITS OWN. LAVATORY WAS UNOCCUPIED AT THE TIME. MAINTENANCE INSPECTED, RESEATED SMOKE DETECTOR, AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 26-12-0SDR AALA201904129007Yoke · out of adjustAIRCRAFT WAS GROUNDED: PILOT REPORTS YOKE POSITIONED ALL THE WAY LEFT DIFFICULT TO POSITION OTHER THAN LEFT. TURNED ON HYDRAULICS AND NO CHANGE. LOOKED OUTSIDE WINDOW AT WINGS, LEFT SPOILERS WERE MOSTLY ALL THE WAY UP. RIGHT WING NO SPOILERS. MAINTENANCE FOUNSDR AALA201904119003Switch · malfunctionedAIRCRAFT WAS NOT GROUNDED: PILOT REPORTS AFTER LANDING STAB TRIM RAN UNCOMMANDED CONTINUALLY IN BOTH DIRECTIONS. TURNED OFF BOTH STAB TRIM PEDESTAL SWITCHES, STOPPED STARTED AGAIN WITH BOTH SWITCHES ON. MAINTENANCE PERFORMED TASK 27-41-00-810-804 AND GOUND NO SDR AALA201807196008Intercostal · corrodedCORROSION ON INTERCOSTAL WEB, BS 807 TO 827, STRINGER 26R. REPLACED THE INTERCOSTAL IAW 51-00-05, DRAWING 146A8130.SDR AALA20180716009Frame · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION FOUND ON FRAME CHORD AT STATION 335 STRINGER 23L. REPLACED FRAME CHORD PER EA 281917.SDR AALA201807179035Intercostal · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION FOUND ON INTERCOSTAL WEB AT STATION 319 STRINGER 23L. REPLACED INTERCOSTAL WEB PER EA 281917 DRAFT 2.SDR AALA20180716011Frame · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION FOUND ON FRAME CHORD AT STATION 319 STRINGER 23L. REPLACED FRAME CHORD PER EA 281917 DRAFT 2.SDR AALA201807175002Floor Support · corrodedRIGHT LAVATORY FLOOR SUPPORT WAS CORRODED AT BS 951, RBL 51. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201807165007Floorbeam · corrodedCORRODED FLOORBEAM, BS 947, RBL 51. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R, PROCEDURE 5.SDR AALA20180714002Shear Web · crackedTHE AIRCRAFT IS IN BASE MAINTENANCE. RIGHT HAND AFT SHEAR WEB CRACKED AT FASTENER HOLE BETWEEN STATIONS 986-1006, RIGHT HAND SIDE. REPLACED SHEAR WEB PER 51-00-05-1.SDR AALA20180714003Shear Web · crackedTHE AIRCRAFT IS IN BASE MAINTENANCE. FOUND CRACK AT FASTENER HOLE ON ONBOARD EDGE OF SHEAR WEB AT STATION 1002, RBL 41 (UNDER R2 CREASE ANGLE AND AFT R2 CREASE ANGLE OVERLAP). REPLACED SHEAR WEB PER 51-00-05-1.SDR AALA201807193002Angle · corrodedCORROSION ON ANGLE WALL SUPPORT, BS 992, RBL 31 TO RBL 35. REPLACED ANGLE WALL SUPPORT IAW 51-00-05-1 AND DRAWING 147A5700.SDR AALA20180711002Doubler · crackedTHE AIRCRAFT IS IN BASE MAINTENANCE. EXHAUST CUT OUT DOUBLER CRACKED AT INBOARD ATTACH FLANGE ON RIGHT HAND VAPOR BARRIER WEB. REPLACED DOUBLER PER 51-00-05.SDR AALA2018071111001Angle · crackedHORIZONTAL ANGLE CRACKED AT INBOARD END. IN THE RIGHT AIR CONIDITIONING BAY BULKHEAD WEB. REPLACED THE HORIZONTAL ANGLE IAW 51-00-05, AND DRAWING 111A1000.SDR AALA20180709007Strap · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION AFT RIGHT HAND WEB STRAP BETWEEN STA1016 TO STA 1028, RBL 18. REPLACED WEB STRAP PER 51-00-05-1 AND DRAWING 147A5714.SDR AALA20180709006Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION AFT CABIN LAVATORY D FLOOR INTERCOSTAL AT STA 951, LBL 25. REPLACED INTERCOSTAL PER SRM 51-10-02-OG AND SRM 51-40-02.SDR AALA201807098008Angle · corrodedCORROSION FOUND ON THE FORWARD SERVICE DOOR CREASE ANGLE AT BS 294.5. REPLACED THE ANGLE IAW 51-00-05-1.SDR AALA201807098006Strap · corrodedR1 CREASE ANGLE ATTACH STRAP CORRODED. REPLACED THE STRAP IAW 51-00-05-1.SDR AALA201807098005Bulkhead Web · crackedDURING ACCOMPLISHMENT OF SURFACE SCAN OF VERTICAL PRESSURE DECK ON THE RIGHT SIDE, OTBD BAY, A CRACK WAS CONFIRMED BETWEEN RBL 40 AND RBL 45.64 MULTIPLE CRACKS AND APPEARS TO SPIDER WEB. REPAIRED PRESSURE BULKHEAD WEB IAW SRM 57-10-10-2R-3, REPAIR ALTERNATE SDR AALA201807098004Strap · corrodedCORROSION ON THE WEB STRAP BETWEEN BS 1016 TO 1028, RBL 18. REPLACED THE WEB STRAP IAW 51-00-05-1, AND DRAWING 147A5714.SDR AALA201807098002Angle · corrodedCORROSION FOUND ON THE ZEE ANGLE AT BS 1014, RBL 31. REPLACED THE ANGLE IAW 51-00-05-1 AND DRAWING 147A5710.SDR AALA201807098001Angle · corrodedCORROSION FOUND ON THE ZEE ANGLE AT BS 992, LBL 38. REPLACED THE ANGLE IAW 51-00-05-1 AND DRAWING 147A5700.SDR AALA201807097001Angle · corrodedCORROSION FOUND ON THE ZEE ANGLE AT BS 1011, LBL 32. REPLACED THE ANGLE IAW 51-00-05, AND DRAWING 147A5700.SDR AALA201807096007Rib · crackedRIGHT HORIZONTAL STABILIZER INTERNAL RIB AT HSS 92.7 WAS FOUND CRACKED AT THE VERTICAL STIFFENERS. REPAIRED THE RIB IAW SRM 55-10-09-2R-4.SDR AALA201807096006Rib · crackedLEFT HORIZONTAL STABILIZER INTERNAL RIB AT HSS 92.7 WAS FOUND CRACKED AT THE FORWARD TWO VERTICAL STIFFENERS. REPAIRED THE RIB IAW SRM 55-10-09-2R-4.SDR AALA2018071103009Angle · corrodedAFT LOWER DOOR SILL ANGLE CORRODED OUT OF LIMITS. REPLACED THE ANGLE IAW 51-00-05-1.SDR AALA2018071103004Attach Angle · corrodedFORWARD ENTRY LOWER DOOR SILL , UPPER ATTACH ANGLE WAS CORRODED OUT OF LIMITS. REPLACED THE ATTACH ANGLE IAW SRM 51-40-02.SDR AALA2018071103003Angle · crackedL1 DOOR SILL ANGLE CORRODED OUT OF LIMITS. REPLACED THE ANGLE IAW 51-40-02, AND 51-00-05-1.SDR AALA201807093017Angle · corrodedLEFT ZEE ASEEMBLY, LEFT HAND TRANSITION ANGLE CORRODED FROM BS 727 - 847. REPLACED THE ANGLE IAW 51-00-05-1, SRM 53-00-53-2R, AND DRAWING 146A- 0081.SDR AALA201807093010Angle · corrodedAFT GALLEY SERVICE LOWER DOOR SILL ANGLE WAS CORRODED OUT OF LIMITS BETWEEN BS 963 - 992, RIGHT SIDE. REPLACED THE ANGLE IAW 51-00-05-1 AND DRAWING 147A8501.
Back to N946AN