N816NN
Service difficulty reports · 91
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 = 'N816NN' 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 = 'N816NN' 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 AALA202110018983Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND IN LOWER SKIN OF RIGHT HORIZONTAL STABILIZER LOCATED AT STA 193.9, RIGHT BUTT LINE 151. ACCOMPLISHED EXTERNAL DOUBLER REPAIR PER SRM 55-10-01-2R-11.SDR AALA202110010314Panel · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK ON BREAK ASSEMBLY LOCATED AT STA 540 AND LEFT BUTT LINE 0 -24. REMOVED AND REPLACED PANEL AND PLATE PER SRM 51-10-02.SDR AALA202110012245Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL BETWEEN STA 294 AND STA 312 AT BL 0, MEASURING L=0.25 IN, W=0.5 IN, D=0.04 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-00-05-1.SDR AALA202110017202Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL BETWEEN STA 312 AND STA 328 AT RBL 32, MEASURING L=0.25 IN, W=0.5 IN, D=0.04 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-00-05-1.SDR AALA202105319009Guide Arm · out of adjustAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR WILL NOT CLOSE. HANGS UP WHEN DOOR HANDLE NEARS CLOSED POSITION. REQUIRES EXTRA FORCE TO CLOSE COMPLETELY. REPLACED GUIDE ARM AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-11-21 AND 52-11-00.SDR AALA202012299004Switch · inoperativeAIRCRAFT WAS GROUNDED. UPON SELECTING TO GO, THROTTLES ADVANCED SYMMETRICALLY. NO ACCELERATION, SUDDENLY STARTED TURNING RIGHT. PULLED POWER BACK AND USED NOSE WHEEL STEERING TO GO LEFT. ABORTED TAKEOFF. BURNT RUBBER SMELL IN CABIN AND FLIGHT DECK. NO DESDR AALA202010199026Mount · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF LT FWD MOUNT OF AFT GALLEY AT STA 986 AND LBL34, MEASURING L=3.0 IN, W=2.5 IN, D=0.012 IN. ACCOMPLISHED PERMANENT REINFORCING REPAIR, IAW SRM 53-70-51-1A-1.SDR AALA202010199025Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF FLOOR SUPPORT AT STA 986 AND LBL 43, MEASURING L=1.3 IN, W=1.0 IN, D=0.026 IN. ACCOMPLISHED PERMANENT REINFORCING REPAIR, IAW SRM 53-70-51-2R-6.SDR AALA2020091549007Lamp · wrong partAIRCRAFT WAS GROUNDED: DURING FINAL APPROACH PRIOR TO GEAR EXTENSION, THE GEAR UNSAFE LIGHTS FLICKER FOR ABOUT 10 SECONDS WITH THE HORN. A BURNING SMELL ACCOMPANIED THE FLICKERING. REPLACED LOW RANGE RADIO ALTIMETER ANTENNA NR 2 AND ACCOMPLISHED A SATISFACTOSDR AALA2020091539015Antenna · defectiveAIRCRAFT WAS GROUNDED: DURING FINAL APPROACH PRIOR TO GEAR EXTENSION, THE GEAR UNSAFE LIGHTS FLICKER FOR ABOUT 10 SECONDS WITH THE HORN. A BURNING SMELL ACCOMPANIED THE FLICKERING. REPLACED LOW RANGE RADIO ALTIMETER ANTENNA NR 2 AND ACCOMPLISHED A SATISFACTSDR AALA201912099003Autothrottle Sys · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS ON T/O ROLL THE AUTO THROTTLES TURNED OFF TWICE AND WE COULD NOT ENGAGE V NAV AT 1000FT. TRIED THE AUTOTHTOTTLES AGAIN AT 1500 FT AND THEY STAYED ON AND VNAV WORKED OK. AUTO THROTTLES QUIT AGAIN AND VNAV QUIT AT 3000FT IN DSDR AALA2019112759022Computer · unreliableAIRCRAFT WAS GROUNDED: FLIGHT AIR RETURNED TO MIA ON ACCOUNT OF NAVIGATION ISSUES AND NOISES FROM THE AVIONICS BAY. AN EMERGENCY WAS DECLARED. MAINTENANCE GAINED ACCESS TO E&E BAY. CHECKED EQUIPMENT FOR SECURITY. PERFORMED GVI OF E&E BAY. FOUND NO OBVIOUS SIGNSDR AALA2019111329013Adiru · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS AUTO THROTTLE & AUTO PILOT DISCONNECT UNCOMMANDED. MAINTENANCE REPLACED #1 AIR DATA INERTIAL REFERENCE UNIT IAW AMM 34-21-01. ALL CHECKS ARE NORMAL.SDR AALA201909059004Transceiver · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS DESCENDING THROUGH 8000 (LVL CHG, POWER IDLE). ALL RED LIGHTS ON GEAR INDICATORS AND WARNING HORN ON. FLAPS 5 AIRSPEED 210 KIAS. MAINTENANCE REPLACED #1 & #2 R/A R/TS IAW AMM 34-33-21. REPLACED ALL R/A ANTENNA IAW AMM 34-33SDR AALA201909059016Transceiver · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS DESCENDING THROUGH 8000 (LVL CHG, POWER IDLE). ALL RED LIGHTS ON GEAR INDICATORS AND WARNING HORN ON. FLAPS 5 AIRSPEED 210 KIAS. MAINTENANCE REPLACED #1 & #2 R/A R/TS IAW AMM 34-33-21. REPLACED ALL R/A ANTENNA IAW AMM 34-33SDR AALA201909059017Antenna · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS DESCENDING THROUGH 8000 (LVL CHG, POWER IDLE). ALL RED LIGHTS ON GEAR INDICATORS AND WARNING HORN ON. FLAPS 5 AIRSPEED 210 KIAS. MAINTENANCE REPLACED #1 & #2 R/A R/TS IAW AMM 34-33-21. REPLACED ALL R/A ANTENNAS IAW AMM 34-3SDR AALA201904199006Light · inoperativeAIRCRAFT NOT GROUNDED: PILOT REPORTS EMERGENCY EXIT NOT ARMED LIGHT WILL NOT ILLUMINATE WHEN TESTED. MAINTENANCE REPLACED THE EMERGENCY EXIT NOT ARMED LIGHT IAW SWPM 20-84-15. OPS CHECK GOOD.SDR AALA2019022869001Smoke Detector · false activationFLIGHT CREW REPORTED THE LEFT AFT LAVATORY SMOKE DETECTOR WARNING ILLUMINATED IN THE COCKPIT WITH NO SMOKE OR FIRE INDICATION IN THE LAVATORY. THE WARNING EXTINGUISHED ON ITS OWN. ACCOMPLISHED A LEFT AFT LAVATORY SMOKE DETECTOR TESTED IAW AMM 26-14-00. TESTESDR AALA201712279014Fan · out of balanceNR 2 ENGINE VIBRATION OF 1.5 UNITS FROM TAKEOFF TO START OF DESCENT, 2 HOURS. MAINTENANCE ACCOMPLISHED FAN TRIM BALANCE IAW MCM CARD 77-95-12SDR AALA20171010008Floor Support · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACKED FLOOR SUPPORT BETWEEN BS 328 AND 344 AT LBL 46. REMOVED AND REPLACED FLOOR SUPPORT IAW SRM 51-10-05, DRAWINGS 141A5400 AND 141A5410.SDR AALA20171010007Intercostal · crackedCRACKED INTERCOSTAL BETWEEN BS 312 AND 328, LBL 46. REMOVED AND REPLACED INTERCOSTAL IAW SRM 51-10-05, DRAWINGS 141A5400 AND 141A5410.SDR AALA201708309019Sign · unsecureAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN FALLING OFF NEAR 4R. REPLACED EMERGENCY LIGHT ASSEMBLY AFT OF 4R PER AMM 33-51-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707279025Sign · detachedEXIT SIGN AT R2 DOOR WILL NOT STAY IN PLACE. REPLACED EXIT SIGN ASSY AT R2 DOOR. OPERATIONAL CHECK GOOD IAW MM 33-51-01.SDR AALA201706249005Light · missingTHE AIRCRAFT WAS NOT GROUNDED. EXIT PLACARD MISSING AT FWD PART OF DOOR 1R. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT 1R DOOR IAW AMM 33-51-01, OPS CHECK GOOD.SDR AALA201703249013Ballast · inoperativeRIGHT WING EMERGENCY EXIT SIDEWALL LIGHT INOPERATIVE. SEAT 15F. REMOVED AND REPLACED THE BALLAST IAW AMM 33-21-00. OPS CHECKED GOOD.SDR AALA20170106001Warning Message · false activationSPEED TRIM FAIL LIGHT CAME ON AND OFF 3 TIMES DURING CLIMB. AUTO PILOT FAILED TO ENGAGE. FLIGHT DIVERTED. LANDING UNEVENTFUL. AIRCRAFT WAS GROUNDED. ACCOMPLISHED LAND VERIFY TEST IAW AMM 22-11-00-700, NO FAULTS FOUND. OPS CHECKED GOOD.SDR AALA20161228019Lens · missingEMERGENCY EXIT SIGN NEAR L1 DOOR FORWARD GALLEY BULKHEAD FLOOR HAS A MISSING LENS COVER. INSTALLED NEW LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20161202001Light · inoperativeEMERGENCY LIGHT AT SEAT 27D IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY.SDR AALA20160620004Warning Switch · faultyAIRCRAFT WAS GROUNDED. DURING TAKEOFF ROLL, RECEIVED A TAKEOFF CONFIGURATION WARNING. TAKEOFF WAS ABORTED AT APPROXIMATELY 40 KNOTS.
MAINTENANCE REMOVED AND REPLACED SPEED BRAKE TAKE OFF CONFIGURATION WARNING SWITCH IAW AMM 27-62-00. OPERATIONAL CHECK NORSDR AALA20151027006Skin · crackedSKIN CRACK IN LT LOWER HORIZONTAL STABILIZER SKIN AT STATION 175.5. COMPLETED REPAIR IAW SRM 55-10-09-2R, SRM 55-10-01-2R REPAIR 11 & EA 255304.SDR AALA20151027005Rib · crackedFOUND CRACK IN RT STABILIZER RIB, STATION 92.7 ON 2ND VERTICAL STIFFENER, AFT LOWER RADIUS, ON VISUAL INSPECTION. PERFORMED REPAIR IAW SRM 55-10-09-2R-4 & EA 255304.SDR AALA20151026007Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD FLANGES CRACKED UNDER SEAT TRACKS AT STATION 727B, LBL 24, LBL 45, RBL 24 & RBL45. ACCOMPLISHED REPAIR IAW EA 255452 & ECO J1698AC.SDR AALA20151025004Web · corrodedAFT CABIN WEB CORRODED OUT OF LIMITS AT STATION 986, BETWEEN LBL 31 - 35. INSTALLED WEB DOUBLER REPAIR IAW SRM 51-70-13-2R.SDR AALA20151025003Web · corrodedAFT CARGO LOWER DOORWAY WEB, BETWEEN STATIONS 802 - 840 RT, CORRODED & DENTED, SEVERAL PLACED OUT OF SRM LIMITS. INSTALLED NEW SERVICEABLE WEB IAW AARD 20-00-00-1R1, AARD 51-00-05-1 & EA 255522 DATED 10 23 2015.SDR AALA20151024001Rib · crackedCRACK IN LT STABILIZER RIB AT STATION 166.3, ON THE 3RD VERTICAL STIFFENER AFT LOWER RADIUS. INSTALLED DOUBLER REPAIR IAW SRM 55-10-09-2R-4 & EA 255565.SDR AALA20151020015Intercostal · crackedINTERCOSTAL CRACKED AT CLIP NUT HOLE, BETWEEN STATIONS 344 - 360, LBL12. R & R CABIN FLOOR INTERCOSTAL 141A5410-22 IAW SRM 51-40-02 & PRINT 141A540-12.SDR AALA20151020014Intercostal · crackedINTERCOSTAL CRACKED AT CLIP NUT HOLE, BETWEEN STATIONS 344 - 360, BL0. R & R INTERCOSTAL 141A5410-23 WITH NEW IAW SRM 51-40-23 & PRINT 141A5400-32.SDR AALA20151020013Intercostal · crackedINTERCOSTAL 141A5410-12 CRACKED AT STATION 312 - 328, LBL 46. R & R INTERCOSTAL 141A5410-12 IAW SRM 51-40-02 & PRINT 141A5400 PAGE 26.SDR AALA20150706010Trim Motor · faultyAIR INTERRUPT, EMER DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. STABILIZER TRIM INOPERATIVE. R & R STABILIZER TRIM MOTOR IAW AMM 27-41-11. PERFORMED OPERATIONAL CHECK. SYS CHECKED NORMAL.SDR AALA20141020006Outlet · brokenINFLIGHT FLIGHT ATTENDANTS REPORTED ACRID FUME SMELL FROM AFT CABIN ROWS 25 & 26. FOLLOWED QRH & SMELL IMMEDIATELY DISSIPATED AFTER IFE & PASS SET SWITCH IN COCKPIT WAS DEACTIVATED. EMER DECLARED FLIGHT DIVERTED & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SDR AALA20120601005Light · brokenEMERGENCY LIGHT ASSEMBLY AT ROW 14ABC BROKEN. REPLACED LIGHT ASSEMBLY AT ROW 14ABC. OPS CHECK NORMAL.
Back to N816NN