N789AN
Service difficulty reports · 262
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 = 'N789AN' 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 = 'N789AN' 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 AALA202105089007Smoke Detector · malfunctionedAIRCRAFT WAS NOT GROUNDED: SMOKE INDICATION DISAGREES WITH LAVATORY CONDITION. PASSENGER SMOKING POT IN LAVATORY 3F1R SMOKE PRESENT NO ALARM. ACCOMPLISHED LAVATORY SMOKE DETECTION - OPERATIONAL TEST. OPERATIONS CHECK GOOD, FOR LAVATORY 3F1R.SDR AALA202103139002Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: SEAT 5D FWD EMERGENCY PATH LIGHT INOPERATIVE. REPLACED LIGHT WITH NEW IAW AMM 33-51-05, OPS CHECK GOOD.SDR AALA202103129010Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF FUSELAGE SKIN AROUND AFT LAVATORY EXHAUST VENT AT STA 1968 BETWEEN STR 35L AND STR 36L, MEASURING L=5.0 IN, W=2.5 IN, D=0.1 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW B777 SRM 53-70-01-2R-1. (DUPLICATE SDR AALA202103029026Skin · corrodedAIRCRAFT WAS GROUNDED: CORROSION AROUND AFT LAVATORY EXHAUST VENT. CORROSION OF FUSELAGE SKIN AROUND AFT LAVATORY EXHAUST VENT AT STA 1968 BETWEEN STR 35L AND STR 36L, MEASURING L=5.0 IN, W=2.5 IN, D=0.1 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR ISDR AALA202101179006Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED. REAR MOST AFT LAV SMOKE WARNING WITH COINCIDING EICAS MESSAGE, BUT NO SMOKE DETECTED. ACCOMPLISHED SMOKE DETECTOR OPERATIONS TEST, IAW AMM 26-13-00. OPERATIONS CHECK GOOD.SDR AALA201910049004Light · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS DURING EMERGENCY LIGHT CHECK HAS BEEN FOUND FLOOR PROXIMITY LIGHTS INOP AT PARTITION CLOSET ZONE 2, STA 1140. MAINTENANCE REPLACED LEFT AND RT SIDE EMERGENCY LIGHT AT ROW 17 PARTITION IAW AMM 33-51-05, ALL CHECKS NOSDR AALA2019032879035Wire · brokenFIRST OFFICER`S WINDSHIELD HAD EVIDENCE OF ARCING ON THE LOWER BUSS BAR AND DELAMINATION AT THE UPPER AND LOWER BUSS BARS. THE AIRCRAFT WAS GROUNDED. FOUND A BROKEN WIRE CONNECTION TO BE THE CAUSE OF THE ARCING. REPAIRED AND THE WINDSHIELD WAS REPLACED PERSDR AALA2019032879024Windshield · arcedFIRST OFFICER`S WINDSHIELD HAD EVIDENCE OF ARCING ON THE LOWER BUSS BAR AND DELAMINATION AT THE UPPER AND LOWER BUSS BARS. THE AIRCRAFT WAS GROUNDED. FOUND A BROKEN WIRE CONNECTION TO BE THE CAUSE OF THE ARCING. REPAIRED AND THE WINDSHIELD WAS REPLACED IAW SDR AALA2018123128004Sensor · defectiveSHORTLY AFTER TAKE OFF FORWARD CARGO EICAS MESSAGE ANNUNCIATED LEVELED AT 3000FT, COMPLETED CHECK LIST. WHEN AIRCRAFT DEPPRESURIZED ANNUNCIATION WENT AWAY UNTIL 2000 FT ON FINAL WHEN IT CAME BACK ON. AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DEPASDR AALA201811079009Battery · inoperativeEMERGENCY POWER ASSIST SYSTEM ON R1 DOOR DID NOT HAVE A GREEN LIGHT. REPLACED THE BATTERY IAW 52-11-20. OPS CHECKED NORMAL.SDR AALA201810029019Window Shade · defectiveGRU - THE AIRCRAFT WAS NOT GROUNDED. R3 WINDOW SHADE HAS DIFFICULTY RETRACTING. MAINTENANCE REPLACED WINDOW SHADE, N3 WINDOW IAW AMM 56-11-00 CHECK OK GOOD FOR SVC.SDR AALA2018082879029Sign · looseEXIT SIGN BY THE L3 DOOR WAS LOOSE ON ONE SIDE. INSTALLED A PIN AT EXIT SIGN AND APPLIED RTV IAW AMM 33-51-01. OK FOR SERVICE.SDR AALA201808019005Skin · damagedLEFT WING, OTBD AILERON HAS WATER INGRESSION, 30 INCHES FROM THE INBD EDGE, AND 14 INCHES FROM THE TRAILING EDGE. REPLACED THE LT AILERON IAW AMM 27-11-13.SDR AALA2018070659001Actuator · inoperativeRUDDER TRIM ISSUE. EMERGENCY DECLARED, AND LANDED. THE AIRCRAFT WAS GROUNDED. NUMEROUS EICAS MESSAGES DISPLAYED AFTER TAKEOFF. CONFIG SYS, THRUST ASYM COMP, AND RUDDER TRIM ALL WERE INOPERATIVE. INSTALLED RUDDER TRIM ACTUATOR IAW AMM 27-21-07. OPS CHECKESDR AALA20170330008Battery Pack · dischargedDOOR 1 RT FWD EMER LIGHT POWER PACK INOP. DOOR 1 RT FWD EMER LIGHT POWER PACK REPLACED AND TEST NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170331011Battery Pack · dischargedDOOR 2 L/H FWD EMERGENCY LT POWER PACK REPLACED AND TEST FAILED. DOOR 2 L/H FWD EMERGENCY LT POWER PACK REPLACED AGAIN AND TEST NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE. (SEE ALSO SDR AALA20170331009)SDR AALA20170331009Battery Pack · dischargedDOOR 2 LT FWD EMER LIGHT POWER PACK INOP. DOOR 2 LT FWD EMR LT POWER PACK. REPLACED AND TEST CARRY OUT AND TEST FAILED. DOOR 2 LT FWD EMERGENCY LT POWER PACK REPLACED AGAIN AND TEST NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE. (SEE ALSO SDR AALA20170SDR AALA20170207021Connector · looseAIRCRAFT WAS NOT GROUNDED. CEILING EMERGENCY LIGHTS AT ROWS 36H, 39H, AND 42H ARE INOPERATIVE. SECURED LOOSE CONNECTOR TO POWER SUPPLY M33409 IAW WDM 33-51-54. OPERATIONAL CHECK GOOD.SDR AALA20170207008Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN AFT GALLEY RIGHT SIDE OF CENTRAL WALL HAS A DETACHED LENS COVER. SECURED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20170106014Shade · unsecureAIRCRAFT NOT GROUNDED. R4 DOOR WINDOW SHADE SLIDES DOWN DURING TAXI. RESECURED WINDOW SHADE. OPERATIONAL CHECK GOOD.SDR AALA20170106013Shade · unsecureAIRCRAFT NOT GROUNDED. L4 DOOR WINDOW SHADE SLIDES DOWN DURING TAXI. RESECURED WINDOW SHADE. OPERATIONAL CHECK GOOD.SDR AALA20170103007Light · damagedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT FIRST CLASS CLOSET IS DAMAGED. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161220018Battery Pack · faultyR4 DOOR EMERGENCY POWER ASSIST SYSTEM BATTERY GREEN LIGHT DOES NOT BLINK. REMOVED AND REPLACED EPAS BATTERY PACK IAW AMM 52-11-00. OPERATIONAL CHECKED GOOD.SDR AALA20161018004Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FLASHLIGHT AT L1 DOOR FLIGHT ATTENDANT JUMPSEAT WILL NOT TEST. REMOVED AND REPLACED FLASHLIGHT BATTERY. FLASHLIGHT TESTS NORMAL INSTALLED SECURITY SEAL IAW AMM 25-64-01.SDR AALA20161014009Fire Loop · faultyAIRCRAFT WAS GROUNDED. MIA, AIR INTERRUPT, MIA-GIG. EMERGENCY DECLARED. LANDING UNEVENTFUL. AIRCRAFT OVERWEIGHT. DURING CLIMB RECEIVED A LT ENGINE OVERHEAT EICAS MESSAGE. ENGINE SHUT DOWN BY FLIGHT CREW. REMOVED AND REPLACED BOTH LT ENGINE FIRE DETECTIOSDR AALA20161012001Fire Loop · faultyAIRCRAFT WAS GROUNDED. MIA, AIR INTERRUPT, MIA-GIG. EMERGENCY DECLARED. LANDING UNEVENTFUL. AIRCRAFT OVERWEIGHT. DURING CLIMB RECEIVED A LEFT ENGINE OVERHEAT EICAS MESSAGE. ENGINE SHUT DOWN BY FLIGHT CREW. REMOVED AND REPLACED BOTH LEFT ENGINE FIRE DETESDR AALA20160627006Fan · inoperativeAIRCRAFT WAS NOT GROUNDED. DURING CRUISE, A BURNING ELECTRICAL ODOR WAS REPORTED IN THE LT 2 AND RT 2 DOOR AREAS AND IN FIRST CLASS AND A RECIRCULATION FAN STATUS MESSAGE DISPLAYED. THE SMOKE, FIRE OR FUMES CHECKLIST WAS ACCOMPLISHED AND THE ODOR DISSIPATED.SDR AALA20160519004Power Supply · failedAIRCRAFT WAS IN BASE MX. EMER POWER SUPPLY AT LOCATION M33401 FAILED TEST IAW TASK CARD 2735. R & R POWER SUPPLY IAW AMM 33-51-06-960-802 & ACCOMPLISHED OPERATIONAL CHECK. SYS CHECKED NORMAL.SDR AALA20151105004Blade · crackedDURING TAXI IN, FIRE & SMOKE WAS REPORTED FROM APU AFTER SHUTDOWN. NO FLIGHT DECK WARNING, INDICATION RECEIVED. APU FIRE EXTINGUISHER WAS DISCHARGED. APU ENGINEERING REPORTS T1K-TI BLADE CRACKING.SDR AALA20150824010Lens · missingEMERGENCY LIGHT AT SEAT 22G IS MISSING LENS. R & R EMER LIGHT ASSEMBLY AT SEAT 22G IAW AMM 33-51-05. SYS CHECKED NORMAL.SDR AALA20150304004Powerpack · failedDOOR 3L EMER LIGHT POWER PACK M33406 OPERATIONAL TEST FAILED. REPLACED DOOR 3L EMER LIGHT POWER PACK M33406 IAW AMM 33-51-06. SYS CHECKED NORMAL.SDR AALA20150304003Skin · damagedLIGHTNING STRIKE DAMAGE TO THE FUSELAGE SKIN BETWEEN STATIONS 421 & 450 AT WASTE DRAIN VLV LOCATION. REPAIRED SKIN IAW EA 53-038777.SDR AALA20150306001Battery · failedDOOR 1 LT EMER LIGHT BATTERY M33093 CAPACITY CHECK FAILED. REPLACED M33093 BATTERY IAW AMM 33-51-06. SYS CHECKED NORMAL.SDR AALA20150305012Battery · failedDOOR 2 RT EMER LIGHT BATTERY M33097 CAPACITY CHECK FAILED. REPLACED M33097 BATTERY IAW AMM 33-51-06. SYS CHECKED NORMAL.SDR AALA20150305011Sign · damaged4R DOOR EMER LIGHT FWD DOOR EXIT SIGN ASSEMBLY FOUND IN POOR CONDITION. REPLACED IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20150226029Sign · defective4L DOOR EMERGENCY LIGHT AFT DOOR EXIT SIGN ASSEMBLY FOUND IN POOR CONDITION. REPLACED 4L DOOR EMER LIGHT AFT DOOR EXIT SIGN ASSEMBLY IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20150226028Sign · defective3R DOOR EMER LIGHT AFT DOOR EXIT SIGN ASSEMBLY FOUND POOR CONDITION. REPLACED 3R DOOR EMER LIGHT AFT DOOR EXIT SIGN ASSEMBLY IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20150226027Light · brokenCABIN ZONE C AFT PARTITION RT EMER LIGHT BROKEN. REPLACED CABIN ZONE C AFT PARTITION RT EMER LIGHT IAW AMM 33-51-05. SYS CHECKED NORMAL.SDR AALA20150226026Sign · defective3R DOOR EMER LIGHT FWD DOOR EXIT SIGN ASSEMBLY FOUND IN POOR CONDITION. REPLACED 3R DOOR EMER LIGHT FWD DOOR EXIT SIGN ASSEMBLY IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20150225012Sign · damagedDOOR 2 RT EXIT SIGN COVER LATCH DAMAGED. REPLACED DOOR 2 RT EXIT SIGN ASSEMBLY IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20150226025Switch · faultyCABIN DOOR 3R PAX ENTRY DOOR BATTERY TEST FAILED. REPLACED CABIN 3R MODE SELECT SWITCH IAW AMM 52-11-28. SYS CHECKED NORMAL.SDR AALA20140818006Light · inoperativeSEAT MOUNTED EMER LIGHT AT 3G INOPERATIVE. REPLACED LAMP FOR SEAT MOUNTED EMER LIGHT AT 3G. OPERATIONS CHECKED NORMAL.SDR AALA20140815006Light · inoperativeSEAT MOUNTED EMER LIGHT AT 25C INOPERATIVE. REPLACED LAMP FOR SEAT MOUNTED EMER LIGHT AT 25C. OPERATIONS CHECKED NORMAL.SDR AALA20140815005Power Supply · inoperativeLEFT SIDE FLOOR PROXIMITY EMER LIGHTS IN BUSINESS CLASS INOPERATIVE. RESEATED POWER SUPPLY FOR BUSINESS CLASS LT SIDE FLOOR PROXIMITY EMER LIGHTS. OPERATIONS CHECKED NORMAL.SDR AALA20140714012Lens · missingESCAPE PATH LIGHT AT SEAT 25C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 25C. OPERATIONS CHECKED NORMAL.SDR AALA20140714011Light · missingESCAPE PATH LIGHT AT SEAT 25C MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 25C. OPERATIONS CHECKED NORMAL.SDR AALA20140714010Lens · missingESCAPE PATH LIGHT AT SEAT 23C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 23C. OPERATIONS CHECKED NORMAL.SDR AALA20140714009Light · missingESCAPE PATH LIGHT AT SEAT 23C MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 23C. OPERATIONS CHECKED NORMAL.SDR AALA20140714008Light · missingESCAPE PATH LIGHT AT SEAT 23G MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 23G. OPERATIONS CHECKED NORMAL.SDR AALA20140714007Lens · missingESCAPE PATH LIGHT AT SEAT 23G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 23G. OPERATIONS CHECKED NORMAL.
Back to N789AN