N927NN
Service difficulty reports · 121
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 = 'N927NN' 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 = 'N927NN' 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 AALA202505015446Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM UPPER CHORD (T-CAP) AT BS 947.5, RBL 52. REPAIRED FLOOR BEAM UPPER CHORD PER SRM 53-70-2R-5 AND EA 363511.SDR AALA202505013865Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM UPPER CHORD (T-CAP) AT BS 947, LBL 24. REPAIRED FLOOR BEAM UPPER CHORD PER SRM 53-70-2R-5 AND EA 363511.SDR AALA202504142620Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED FORWARD GIRT BAR TIEDOWN AT BS 312, LBL 54. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202504143451Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED AFT GIRT BAR TIEDOWN AT BS 344, LBL 59. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202504078201Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED AFT GIRT BAR TIEDOWN AT BS 344, LBL 59. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202502104420Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: AFTER LEFT OVERWING EMERGENCY LIGHT INOPERATIVE. RELAMPED AFT LEFT OVERWING EMERGENCY LIGHT. OPERTIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202407019486Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LOCK GETS STUCK WHEN IN THE LOCKED POSITION. VERY DIFFICULT TO UNLOCK ONCE LOCKED. APPLIED LUBRICATION TO AFT LAVATORY DOOR LOCK HINGES, PERFORMED OPERATIONAL TEST OF DOOR LOCK. OPERTIONAL CHECK GOOD. PER CMM 5SDR AALA202406274112Drain Valve · cloggedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ORDER FUME IN AFT OF PLANE, WORSE IN AFT GALLEY OILY MUSTY SMELL THAT MADE EYES WATER. COULD NOT DETERMINE SOURCE; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT ELP. ACCOMPLISHED SOF TROUBLESHOOTING WORKCARDSDR AALA202406253517Toilet · leakingAIRCRAFT WAS GROUNDED: FLIGHT ATTANDENT REPORT AN ODER FROM AFT GALLEY DURING TAKEOFF AND CLIMB. ODER AFFECTED NOSE AND THROAT AND REQUIRED MOVING AFT ROW PASSENGERS FORWARD.**SUPPLEMENTAL REPORT FOR (AALA202406243517): FOUND TOILET LEAKING, REMOVED AND REPLACSDR AALA202406243517Unknown · odorAIRCRAFT WAS GROUNDED: FLIGHT ATTANDENT REPORT AN ODOR FROM AFT GALLEY DURING TAKEOFF AND CLIMB. ODOR AFFECTED NOSE AND THROAT AND REQUIRED MOVING AFT ROW PASSENGERS FORWARD. (OPEN).SDR AALA202405205966Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY DOOR JAMMED. LUBED DOOR LATCH.SDR AALA202404297560Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR GETS STUCK AND HARD TO OPEN AND CLOSE. ADJUSTED AFT LAVATORY-D DOOR. PER AMM 25-40-00.SDR AALA202309131364Bracket · looseAIRCRAFT WAS NOT GROUNDED: LEFT FORWARD ENTRY DOOR GIRT BAR BRACKET ON THE RIGHT SIDE IS LOOSE. REPOSITIONED LEFT HAND FORWARD ENTRY DOOR GIRT BAR BRACKET. PER AFMM 17.03.9.SDR AALA202309050339Guide Arm · wornAIRCRAFT WAS GROUNDED: L2 DOOR DIFFICULT TO OPERATE, WILL NOT CLOSE PROPERLY. BUSHING IS WORN TO LIMITS. REMOVED AND REPLACED L2 DOOR GUIDE ARM AND ROLLER ASSEMBLY PER AMM 52-13-21.SDR AALA202307189051Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: L1 DOOR FLASHLIGHT INOPERATIVE. REPLACED L1 DOOR FLASHLIGHT BATTERY.SDR AALA202304120761Door · stickingAIRCRAFT WAS NOT GROUNDED: LAVATORY D PASSENGER STUCK IN LAVATORY HAD TO REMOVE DOOR FROM TRACK TO REMOVE PASSENGER. USED TOOLS FROM BLACK GEAR PIN BOX TO FREE PASSENGER. DOOR HAD DAMAGED UPPER TRIM CAUSING BINDING. REPLACED DOOR.SDR AALA202304148598Shroud · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT AT 14C DAMAGED, INOPERATIVE. SHROUD MISSING. **SUPPLEMENTAL REPORT FOR AALA202303298598: REPLACED EMERGENCY LIGHT SHROUD PER CMM 25-23-67.** (CLOSED)SDR AALA202303298598Unknown · unknownAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT AT 14C DAMAGED, INOPERATIVE. SHROUD MISSING. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202303072258Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LATCH GETS STUCK IN LOCKED POSITION INTERMITTENTLY. **SUPPLEMENTAL REPORT FOR AALA202303062258: ADJUSTED LAVATORY DOOR PER CMM 25-40-64. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.** (CLOSED)SDR AALA202303062258None · noneAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LATCH GETS STUCK IN LOCKED POSITION INTERMITTENTLY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202302015650Regulator Valve · abnormalAIRCRAFT WAS GROUNDED: LEFT ENGINE DUCT PRESSURE INDICATES 0 ON CLIMB AND CRUISE. FLIGHT ATTENDANT REPORT NO AIRFLOW IN CABIN. FLIGHT AIR INTERRUPTED BACK TO MIA. NO EMERGENCY DECLARED. REMOVED AND REPLACED PRESSURE REGULATING SHUT OFF VALVE (AALA202302015650)SDR AALA202302018831Valve · abnormalAIRCRAFT WAS GROUNDED: LEFT ENGINE DUCT PRESSURE INDICATES 0 ON CLIMB AND CRUISE. FLIGHT ATTENDANT REPORT NO AIRFLOW IN CABIN. FLIGHT AIR INTERRUPTED BACK TO MIA. NO EMERGENCY DECLARED. REMOVED AND REPLACED PRESSURE REGULATING SHUT OFF VALVE (AALA202302015650)SDR AALA202302012675Regulator · abnormalAIRCRAFT WAS GROUNDED: LEFT ENGINE DUCT PRESSURE INDICATES 0 ON CLIMB AND CRUISE. FLIGHT ATTENDANT REPORT NO AIRFLOW IN CABIN. FLIGHT AIR INTERRUPTED BACK TO MIA. NO EMERGENCY DECLARED. REMOVED AND REPLACED PRESSURE REGULATING SHUT OFF VALVE (AALA202302015650)SDR AALA202301313112Window · scratchedAIRCRAFT WAS GROUNDED: TWO DEEP SCRATCHES ON CAPTAIN WINDSHIELD INSIDE PANE. IMPLEADS VISION. REMOVED AND REPLACED LEFT COCKPIT WINDOW NO 1.SDR AALA202212216462Oven · odorAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY OVEN #2 GALLEY HAS PLASTIC ODOR WHEN IN USE. REPLACED OVEN PER AMM 25-32-03.SDR AALA202212076336Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR (02 DEC) VERY DIFFICULT TO CLOSE CHECK WITH LOCKING DEVICE ENGAGED. LUBED AND INSPECTED FLIGHT DECK DOOR CHECKS GOOD AS PER AMM 52-51-01.SDR AALA202209077868Window · delaminatedAIRCRAFT IN BASE MAINTENANCE: DELAMINATED OUTER WINDOWS FWD AND AFT ENTRY DOOR AT PASSENGER CABIN. REPLACED OUTER WINDOWS FORWARD (AALA202209067868) AND AFT (AALA202209077877) ENTRY DOOR AT PASSENGER CABIN PER AMM 56-31-00-400-801.SDR AALA202209077877Window · delaminatedAIRCRAFT IN BASE MAINTENANCE: DELAMINATED OUTER WINDOWS FWD AND AFT ENTRY DOOR AT PASSENGER CABIN. REPLACED OUTER WINDOWS FORWARD (AALA202209067868) AND AFT (AALA202209077877) ENTRY DOOR AT PASSENGER CABIN PER AMM 56-31-00-400-801.SDR AALA202209061723Sleeve · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY, RIGHT HAND HORIZONTAL STABILIZER MAST ARM BEARING. REPLACED MAST ARM BEARING (AALA202209066801) AND SLEEVE (AALA202209061723) PER CMM 55-20-17 MAST ARM ASSEMBLY REPAIR 2-1, SOPM 20-50-03 AND DWG 183A1200 REV B. ACCSDR AALA202209061083Sleeve · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY, LEFT HAND HORIZONTAL STABILIZER MAST ARM BEARING. REPLACED MAST ARM BEARING (AALA202209061930) AND SLEEVE (AALA202209061083) PER CMM 55-20-17 MAST ARM ASSEMBLY REPAIR 2-1, SOPM 20-50-03 AND DWG 183A1200 REV B. ACCOSDR AALA202209061930Bearing · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY, LEFT HAND HORIZONTAL STABILIZER MAST ARM BEARING. REPLACED MAST ARM BEARING (AALA202209061930) AND SLEEVE (AALA202209061083) PER CMM 55-20-17 MAST ARM ASSEMBLY REPAIR 2-1, SOPM 20-50-03 AND DWG 183A1200 REV B. ACCOSDR AALA202209066801Bearing · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY, RIGHT HAND HORIZONTAL STABILIZER MAST ARM BEARING. REPLACED MAST ARM BEARING (AALA202209066801) AND SLEEVE (AALA202209061723) PER CMM 55-20-17 MAST ARM ASSEMBLY REPAIR 2-1, SOPM 20-50-03 AND DWG 183A1200 REV B. ACCSDR AALA202206010665Shroud · brokenAIRCRAFT WAS NOT GROUNDED: ROW 26 ABC EMERGENCY LIGHT SHROUD BROKEN. REMOVED AND REPLACED ROW 26ABC EMERGENCY LIGHT SHROUD PER CMM 25-23-67.SDR AALA202205313479Light · looseAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT AT SEAT 26C LOOSE. RE SECURED ESCAPE PATH LIGHT AT SEAT 26C OK FOR SERVICE PER AMM 33-51-02.SDR AALA202205162744Cover · detachedAIRCRAFT WAS NOT GROUNDED: 21C EMERGENCY LIGHT COVER WONT STAY ATTACHED. REPLACED EMERGENCY LIGHT COVER ON SEAT 21C PER ESO 61106 AND CMM 25-23-67.SDR AALA202205167367Shroud · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT SEAT 27 C IS DAMAGED. REPLACED BROKEN SHROUD AT SEAT 21C ESCAPE LIGHT ASSEMBLY PER AMM 33-51-11.SDR AALA202203096272Controller · faultyAIRCRAFT WAS NOT GROUNDED: CLIMBING THROUGH FLIGHT LEVEL 300 WE FELT A RAPID CHANGE TO CABIN PRESSURE. CABIN WAS DESCENDING 4000 FEET PER MINUTE GREEN ALTITUDE LIGHT WAS ILLUMINATED. SWITCHED SELECTOR FROM AUTO TO ALTERNATE PER PROCEDURE. REMOVED AND REPLACED SDR AALA202112017436Guide Arm · out of adjustAIRCRAFT WAS GROUNDED: 1L DOOR HANDLE POPPED UP AFTER LANDING. NOT ON LANDING. BUMP WHILE CROSSING ANOTHER RUNWAY TRIGGERED THE EVENT. ADJUSTED L1 DOOR GUIDE ARM AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-11-00-820-801.SDR AALA202111243689Door · out of adjustAIRCRAFT WAS GROUNDED: UPON LANDING W/ REVERSER THRUST ACTUATION. 1L DOOR HANDLE POPPED UP. DOOR LIGHT IN FLIGHT DECK WITH CAUTION LIGHT LIGHT UNTIL HANDLE SECURED. **SUPPLEMENTAL REPORT FOR AALA202111233689: ACCOMPLISHED ADJUSTMENT / RIG OF THE L1 DOOR AND ASDR AALA202111233689None · noneAIRCRAFT WAS GROUNDED: UPON LANDING W/ REVERSER THRUST ACTUATION. 1L DOOR HANDLE POPPED UP. DOOR LIGHT IN FLIGHT DECK WITH CAUTION LIGHT LIGHT UNTIL HANDLE SECURED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202111228489Target · wornAIRCRAFT WAS GROUNDED: REPEAT WRITEUP AFTER LANDING AND DURING REVERSE THRUST THE FORWARD ENTRY DOOR LIGHT AND MC ILLUMINATED. NUMBER 1 FLIGHT ATTENDANT SAID SHE NOTICED THE L1 DOOR HANDLE MOVED. ACCOMPLISHED CLEARANCE CHECK OF ROLLERS AND FITTINGS, CLEARANCESSDR AALA202111155430Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: RH AFT LAVATORY DOOR LATCH DIFFICULT TO OPERATE. ADJUSTED DOOR LATCH IAW AMM 25-00-00, OPS CHECK GOOD.SDR AALA202108169946Housing · brokenAIRCRAFT WAS GROUNDED: FOUND FLOOR LIGHT HOUSING PANEL AT 9ABC BROKEN. REPLACED HOUSING PER CMM 25-23-67.SDR AALA202108165931Housing · looseAIRCRAFT WAS GROUNDED: ON PREFLIGHT, FLIGHT ATTENDANT FOUND FLOOR LIGHT AT 16C HANGING LOOSE. REPLACED HOUSING PER CMM 25-23-67.SDR AALA202108163864Lens · brokenAIRCRAFT WAS GROUNDED: 18C ESCAPE PATH LENS COVER BROKEN. REMOVED AND REPLACED ESCAPE PATH LENS COVER IN SEAT 18C PER AMM 33-20-00.SDR AALA202105069013Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS "NOT ARMED" LIGHT HAS ONE BULB BURNED OUT. RELAMPED, TEST OK, OK FOR SERVICE.SDR AALA202104229023Valve · faultedAIRCRAFT WAS GROUNDED: LH BLEED TRIP OFF DURING CLIMB AND WOULD NOT RESET, DUCT PRESSURE REMAINED AT 8 PSI FOR RETURN TO MIA. REPLACED LH ENG HI STAGE VALVE (AALA202104229022) IAW AMM 36-11-06 AND PRECOOLER VALVE IAW AMM 36-12-02, OPS CHECK GOOD.SDR AALA202104229022Valve · faultyAIRCRAFT WAS GROUNDED: LH BLEED TRIP OFF DURING CLIMB AND WOULD NOT RESET, DUCT PRESSURE REMAINED AT 8 PSI FOR RETURN TO MIA. REPLACED LH ENG HI STAGE VALVE IAW AMM 36-11-06 AND PRECOOLER VALVE (AALA202104229023) IAW AMM 36-12-02, OPS CHECK GOOD.SDR AALA202103229022Shroud · looseAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING ASSEMBLY CAME LOOSE AT 17C. REPLACED EMERGENCY PATH LIGHT SHROUD AT 17C PER ESO61106.SDR AALA202102089015Light · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT DAMAGED BELOW SEAT 13C. SECURED ESCAPE PATH LIGHT AT 13C.
Back to N927NN