N917AN
Service difficulty reports · 171
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 = 'N917AN' 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 = 'N917AN' 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 AALA202304108781Windshield · scratchedAIRCRAFT WAS GROUNDED: CAPTAIN WINDSHIELD INSIDE PANE HAS A DEEP SHAPE SCRATCH WHICH PARTIALLY IMPEDES VISION. REPLACED WINDSHIELD PER JOB CARD 08L21056003.SDR AALA202212012790Slide · out of positionAIRCRAFT WAS GROUNDED: SERVICE DOOR SLIDE HANGING DOWN. REPOSITIONED SLIDE PACK ON SERVICE DOOR PER AMM 25-66-01.SDR AALA202210110243Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: ROW 16 ABC AFT EMERGENCY EXIT LIGHT BULB OUT. REMOVED AND REPLACED LAMP AT ROW 16 ABC AFT EMERGENCY EXIT LIGHT PER B737 NG AMM 33-51-01SDR AALA202210076247Connector · not seatedAIRCRAFT IN BASE MAINTENANCE: OVERHEAD EMERGENCY LIGHT AT RIGHT HAND SEATS ROW 23 AND 24 IS INOPERATIVE. RESEATED EMERGENCY LIGHT CONNECTOR BETWEEN RIGHT HAND SEATS ROW 23 AND 24 PER AMM 33-51-03-960-805. PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51SDR AALA202210057003Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND PASSENGER CABIN MAIN DECK PREVIOUS REPAIR DOUBLER LOCATED AT BS 992.8 AND LBL 64. REPLACED REPAIR DOUBLER UNDERLYING SHEAR WEB PER SRM 53-70-51-1A PROCEDURE 1.SDR AALA202210055704Floor Support · dentedAIRCRAFT IN BASE MAINTENANCE: FLIGHT CONTROL COMPARTMENT AFT FLOOR STRUCTURE ADJACENT TO AFT SECTION OF CENTER PEDESTAL HAS DENT LOCATED AT BS 252, LBL 5. REPAIRED PER SRM 53-10-51-2R FIGURE 203.SDR AALA202210050638Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND MAIN DECK FLOOR SUPPORT LOCATED AT BS 992.8 AND RBL 25. REPLACED SUPPORT PER SRM 51-40-02-0G.SDR AALA202210050228Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN RIGHT HAND MAIN DECK FLOORBEAM LOCATED AT BS 986, FROM RLB 45 TO LBL 45. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-4 ALT 1.SDR AALA202210058833Floor Support · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES IN AFT PASSENGER CABIN INTERCOSTAL LOCATED FROM BS 986.5 TO BS 1006 AT LBL 33. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202210059369Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND INTERCOSTAL LOCATED FROM BS 500H TO BS 500G AT S25R. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202210056590Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND FLOOR TRANSITION PANEL LOCATED FROM BS 767 TO BS 787 AT RBL 25. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202210052542Structure · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGED HOLE IN CHORD LOCATED AT BS 986.5 AND LBL 33. REPAIRED PER SRM 53-70-51-2R.SDR AALA202210058017Doubler · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND PASSENGER CABIN MAIN DECK REPAIR DOUBLER LOCATED AT BS 992 AND RBL 30. REPAIRED DOUBLER PER SRM 51-40-02-0G.SDR AALA202210059291Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN INTERCOSTAL LOCATED AT BS 947 AND LBL 15. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202211157209Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND SEVERAL FASTENER HOLES IN THE LEFT WING TRAILING EDGE LOWER ACCESS PANELS SUPPORT STRUCTURE BEAM ASSEMBLY LOCATED BETWEEN LEFT WING STA 335 AND STA 440. REPLACED BEAM ASSEMBLY PER SRM 57-51-02-1A PROCEDURE 1 AND SSDR AALA202211153637Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR SUPPORT STRUCTURE LOCATED BETWEEN BS 500C AND BS 500I AT S25R. REPLACED Z CHANNEL PLATE PER SRM 53-00-53-2R-5.SDR AALA202211154757Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR SUPPORT STRUCTURE LOCATED BETWEEN BS 460 AND BS 500I AT S25L. REPLACED Z CHANNEL PLATE PER SRM 51-40-02-OG.SDR AALA202210057209Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND SEVERAL FASTENER HOLES IN THE LEFT WING TRAILING EDGE LOWER ACCESS PANELS SUPPORT STRUCTURE BEAM ASSEMBLY LOCATED BETWEEN LEFT WING STA 335 AND STA 440. REPLACED BEAM ASSEMBLY PER SRM 57-51-02-1A PROCEDURE 1 AND SSDR AALA202210053637Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR SUPPORT STRUCTURE LOCATED BETWEEN BS 500C AND BS 500I AT S25R. REPLACED Z CHANNEL PLATE PER SRM 53-00-53-2R-5.SDR AALA202210054757Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR SUPPORT STRUCTURE LOCATED BETWEEN BS 460 AND BS 500I AT S25L. REPLACED Z CHANNEL PLATE PER SRM 51-40-02-OG.SDR AALA202209239134Pivot · gougedAIRCRAFT IN BASE MAINTENANCE: MAIN DECK STA 520 LEFT BUTT LINE 45 SEAT TRACK GOUGED. SEAT TRACK PIVOT LINK REPLACED PER SRM 53-00-51-1A-1.SDR AALA202211157789Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND INTERCOSTAL LOCATED FROM BS 500G TO BS 500F AT S25L. REPLACED INTERCOSTAL PER SRM 53-00-53-1A AND SRM 53-10-02-0G.SDR AALA202210057789Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND INTERCOSTAL LOCATED FROM BS 500G TO BS 500F AT S25L. REPLACED INTERCOSTAL PER SRM 53-00-53-1A AND SRM 53-10-02-0G.SDR AALA2020021109059Anti-Ice Valve · faultyAIRCRAFT WAS GROUNDED: AIR INTERRUPTED BACK TO DFW AT 390 R/H COWL ANTI-ICE CMAE ON. RAN THE CHECKLIST LIGHT, DID NOT EXTINGUISH. DECLARED AN EMERGENCY. REMOVED AND REPLACED # 2 ENGINE COWL ANTI-ICE VALVE IAW AMM 30-21-11. SECURE CONNECTOR ENG.ANTI - ICE ON #2SDR AALA202001239007Warning Horn · activatedAIRCRAFT NOT GROUNDED: AUTOMATIC AURAL ALERT FOR V1 CALL OCCURS 4 KNOTS PRIOR TO V1. ALL AIRSPEED INDICATORS CONCUR CA/FO/HUD. ACCOMP TAKE OFF WARNING BITE TEST REF FIM 31-51-00 AND ADIRS BITE IAW FIM 34-21-00 WITH NO FAULTS.SDR AALA201909159001Wire Harness · damagedAIRCRAFT IN BASE VISIT: FOUND 5 PINS BURNED/DAMAGED AT DP0901 PINS 2, 5, 79, 10 AND CONNECTOR T3-A HAS EXCESSIVE AMOUNT OF CORROSION COMING OUT. REQUIRES J9 HAR0049 REPLACEMENT. REPLACED J9 ENGINE HARNESS RT ENGINE, PER AMM 73-21-06, CHECKS OK.SDR AALA201907039004Latch · unreliableAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS L1 DOOR SLIDE LATCH BLOCK FAILED RELEASE TESTS. REMOVED AND REPLACED L1 DOOR SLIDE LATCH BLOCK IAW AMM 25-66-01, ACCOMPLISHED PULL CHECK, OPS CHECK NORMAL.SDR AALA201907039014Unknown · malfunctionedAIRCRAFT WAS GROUNDED: AFTER TAKEOFF RAISED LANDING GEAR TO UP POSITION. ALL LIGHTS (BOTH RED AND GREEN) LANDING GEAR LIGHTS REMAINED ILLUMINATED. FOLLOWED QRH PROCEDURE AND SUCCESSFULLY RETRACTED LANDING GEAR. MAINTENANCE ACCOMPLISHED LANDING GEAR SWING TEST SDR AALA201906179029Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FLOOR BOARD INTERCOSTAL CRACKED BETWEEN BS 328 AND BS 344. REPLACED INTERCOSTAL PER AARD 53-00-05.SDR AALA201906179028Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FLOOR BOARD INTERCOSTAL CRACKED BETWEEN BS 312 AND BS 328. REPLACED INTERCOSTAL PER AARD 53-00-05.SDR AALA20180918003Hydraulic Line · rupturedAIRCRAFT WAS GROUNDED. PHL-TPA DIVERTED CLT ACCOUNT HYDRAULIC SYSTEM-A LOSS ENROUTE. EMERGENCY WAS DECLARED AND AIRCRAFT LANDED WITHOUT FURTHER INCIDENT. HYDRAULIC SYSTEM A FAILED IN FLIGHT, ALTERNATE LANDING GEAR EXTENSION USED. FOUND LEFT ELEVATOR PCA OUTBOASDR AALA201807309023Vapor Barrier · crackedAIRCRAFT WAS NOT GROUNDED: DURING CHECK FOR HYDRAULIC LEAK IN WHEEL WELL AREA ,NOTICED A CRACK IN VAPOR BARRIER DIRECTLY BEHIND HYDRAULIC SERVICING PUMP IN RIGHT HAND WHEEL WELL. REPAIRED VAPOR BARRIER PER 57-10-10-9.SDR AALA201803129027Window Shade · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT DOOR WINDOW SHADE 14F BROKEN. MAINTENANCE REPLACED EMERGENCY EXIT DOOR WINDOW SHADE 14F PER AMM 25-21-12 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201801029045Lens · missingEMERGENCY EXIT SIGN LENS IS MISSING AT SEAT 15DEF. REPLACED THE SIGN ASSEMBLY IAW MM 33-51-01. OPS CHECKED OK.SDR AALA201710239041Lens · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE FLIGHT DECK HAS A LOOSE LENS COVER. REPLACED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201708299044Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT ASSEMBLY AT FORWARD SERVICE DOOR DAMAGED. REPLACED LIGHT ASSEMBLY PER AMM 25-63-00, GOOD FOR SERVICE.SDR AALA201707079019Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN COVER MISSING FROM LEFT AFT GALLEY. REPLACED LEFT AFT GALLEY DOOR EMERGENCY LIGHT PER AMM 33-51-00. OPS CHECKS GOOD.SDR AALA201707039037Light · brokenTHE AIRCRAFT WAS NOT GROUNDED. EXIT SIGN IN RT AFT GALLEY IS BROKEN. REPLACED EMER LIGHT ASSY AT RT AFT GALLEY PER AMM 33-51-00 OPS OK.SDR AALA201704189010Skin · debondedRIGHT WING NR 12 OTBD GROUND SPOILER HAS AREA OF DISBONDING 5 X 19.75 ON THE LEADING EDGE. REMOVED AND REPLACED THE SPOILER IAW AMM 27-62-91. ADJUSTED IAW AMM 27-62-00. OPERATIONAL CHECK GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201704049019Cover · unsecureR1 DOOR 1L EXIT SIGN COVER FELL OFF. REMOVED AND REPLACED R1 DOOR EXIT SIGN IAW AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170105016Slide · out of positionAIRCRAFT NOT GROUNDED. L2 DOOR EMERGENCY EVACUATION SLIDE POSITIONED LOWER THAN NORMAL. ACCOMPLISHED Z FOLD OF GIRT IAW AMM 25-66-01. OPERATIONAL CHECK GOOD.SDR AALA20160714012Bracket · corrodedLOWER ROLLER CASTING SUPPORT BRACKET AT AFT CARGO DOOR CUTOUT AFT END IS CORRODED. REMOVED AND REPLACED BRACKET IAW AARD 51-00-05-1.SDR AALA20160713006Skin · crackedDURING ACCOMPLISHMENT OF J1724AB_002, THE AFT FASTENER ROW, THIRD DOWN, HAS A CRACK INDICATION IN THE SKIN. REPAIRED THE SKIN IAW SB 737-53-1294 REV2 AND EA 261258.SDR AALA20160712012Stringer · corrodedSTRINGER 23R IS CORRODED JUST AFT OF BS 847. REPAIRED THE STRINGER IAW SRM 53& 8208-00, & 8208- 03, & 8208-2R1, EA 261857, EA 261905 AND EA 261950.SDR AALA20160711001Floorbeam · corrodedFORWARD CARGO COMPARTMENT AFT FLOORBEAM AT BS 500I IS CORRODED BETWEEN S26R AND S26L. REMOVED AND REPLACED THE FLOORBEAM IAW AARD 51-00-05 REPAIR 1.SDR AALA20160710004Support Beam · wornCENTER WING SUPPPORT BEAM WORN BY DOOR 192DR LATCH. REPAIRED BEAM IAW EA 261489.SDR AALA20160710002Angle · corrodedAFT CARGO COMPARTMENT RIGHT TRANSITION ANGLE IS CORRODED BETWEEN BS 727F AND 767. REMOVED AND REPLACED TRANSITION ANGLE SECTION IAW SRM 53-00-53-2R.SDR AALA20160709003Cargo Track · crackedFORWARD CARGO COMPARTMENT RIGHT CARGO TRACK IS CRACKED AT BS 500H + 19. REPAIRED THE CARGO TRACK IAW SRM 53-00-53-2R AND EA 261851.SDR AALA20160705011Transition Panel · corrodedLEFT TRANSITION PANEL CORRODED IN SEVERAL AREAS FROM BS 727- 847. INSTALLED A NEW TRANSITION PANEL IAW SRM 51-10-02-0G PARA 9, SRM 53-00-53-2R AND EA 261675.SDR AALA20160705008Floor Support · corrodedRIGHT FLOOR SUPPORT AT RBL 13.84 BETWEEN BS 787 AND 807 HAS CORROSION ON EDGE AND FASTENER HOLES. INSTALLED A NEW FLOOR SUPPORT IAW SRM 53-00-53-2R-3.
Back to N917AN