N793AN
Service difficulty reports · 237
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 = 'N793AN' 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 = 'N793AN' 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 AALA20170522006Wire · looseREPORT OF ELECTRICAL ODOR ON PUSHBACK WITH APU RUNNING. MAINTENANCE ACCESSED THE E&E BAY AND SAW VISIBLE SMOKE COMING FROM THE BATTERIES. THE FLIGHT CREW SHUT DOWN THE AIRCRAFT ELECTRICAL POWER. NO CIRCUIT BREAKERS HAD POPPED. MAINTENANCE FOUND THE RIGHT TERMISDR AALA20170315001Retainer · leakingAIRCRAFT WAS GROUNDED. EMERGENCY DECLARED. NRT-DFW FLIGHT RETURNED TO NRT ACCOUNT NO POTABLE WATER IN THE MID GALLEY AND MID LAVATORIES. OVERWEIGHT LANDING UNEVENTFUL. FOUND WATER LEAK FROM FORWARD CARGO WATER DRAIN LINE. REPLACED RETAINER AND REINSTALLEDSDR AALA20170201012Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT IN CREW REST AREA IS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-01. OPERATIONAL CHECK GOOD.SDR AALA20170109024Sign · dislodgedEMERGENCY EXIT SIGN IS DISLODGED AND BLOCKING THE USE OF THE BAGGAGE BIN. RESEATED EXIT SIGN. OPS CHECKED GOOD.SDR AALA20161231014Light · inoperativeAIRCRAFT IN BASE MAINTENANCE. EMERGENCY FLOOR PROXIMITY LIGHT AT SEAT 5D IS DIM AND DRAWING SLIGHTLY HIGHER THAN OTHERS. REMOVED AND REPLACED LIGHT IAW 33-51-05 AND POWER SUPPLY M33094 IAW AMM 33-51-06 (AALA20161231012). OPERATIONAL CHECK GOOD.SDR AALA20161231012Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. EMERGENCY FLOOR PROXIMITY LIGHT AT SEAT 5D IS DIM AND DRAWING SLIGHTLY HIGHER THAN OTHERS. REMOVED AND REPLACED LIGHT IAW 33-51-05(AALA20161231014) AND POWER SUPPLY M33094 IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20161231010Housing · damagedAIRCRAFT IN BASE MAINTENANCE. L2 DOOR FORWARD MAIN AISLE EMERGENCY EXIT SIGN HOUSING IS DAMAGED. REMOVED AND REPLACED HOUSING IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161231006Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. EMERGENCY POWER SUPPLY M33406 INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20161229019Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. MIDDLE CABIN DOOR 3L EMERGENCY LIGHT POWER PACK M33406 FOUND INOPERABLE. REPLACED POWER PACK M33406 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161229017Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. FORWARD CABIN DOOR 2R EMERGENCY LIGHT POWER PACK M33097 FOUND INOPERABLE. REPLACED POWER PACK M33097 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170101002Ground Wire · shortedAIRCRAFT IN BASE MAINTENANCE. G4 AND G5 GALLEY EMERGENCY EXIT FLOOR PROXIMITY LIGHTS AND CEILING LIGHTS FAILED TEST DUE TO INTERNAL GROUND TO WIRE SHORTAGE. REPAIRED WIRE IAW WDM 33-51-52, ESO 21404, AND AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20161228032Powerpack · inoperativeAIRCRAFT IN BASE MAINTENANCE. FORWARD CABIN R4 DOOR EMERGENCY LIGHT POWER PACK M33408 FOUND INOPERABLE. REPLACED POWER PACK M33408 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161228031Powerpack · inoperativeAIRCRAFT IN BASE MAINTENANCE. FORWARD CABIN DOOR 1L EMERGENCY LIGHT POWER PACK M33093 FOUND INOPERABLE. REPLACED POWER PACK M33093 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161228030Powerpack · inoperativeAIRCRAFT IN BASE MAINTENANCE. FORWARD CABIN DOOR 3L EMERGENCY LIGHT POWER PACK M33400 FOUND INOPERABLE. REPLACED POWER PACK M33400 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161228029Sign · brokenAIRCRAFT IN BASE MAINTENANCE. AFT CABIN 4R DOOR CUTOUT, ATTACHED EXIT IDENTIFIER BASE FOUND BROKEN. REPLACE EXIT IDENTIFIER BASE PER AMM 33-51-01 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161228028Powerpack · inoperativeAIRCRAFT IN BASE MAINTENANCE. AFT CABIN DOOR 1L EMERGENCY LIGHT POWER PACK M33424 FOUND INOPERABLE. REPLACED POWER PACK PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161228027Powerpack · inoperativeAIRCRAFT IN BASE MAINTENANCE. CABIN - DOOR 4R AFT EMERGENCY LIGHT POWER PACK M33409 FOUND INOPERABLE. REPLACED POWER PACK M33409 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161229018Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. AFT CABIN DOOR 2R EMERGENCY LIGHT POWER PACK M33098 FOUND INOPERABLE. REPLACED POWER PACK M33098 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161226001Spring · weakAIRCRAFT IN BASE MAINTENANCE. CABIN L3 PASSENGER DOOR GIRT BAR FLOOR FITTING SPRING FOUND TO BE WEAK. REPLACED PER AMM 52-11-18 AND ACCOMPLISHED SATISFACTORY OPERATION CHECK.SDR AALA20161227015Hinge · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON LEFT WING AILERON NR 5 RIB HINGE BONDING JUMPER INTERFACE AREA. REPAIRED NR 5 RIB HINGE INTERFACE AREA PER SRM 51-10-02,SRM 57-51-02-1A, AND SRM FIG 57-51-02-2R-3 REPAIR 3.SDR AALA20161124001Battery · dischargedFLASHLIGHT BATTERY DISCHARGED. REMOVED AND REPLACED THE BATTERY IAW AMM 25-64-01. OPS CHECKED NORMAL.SDR AALA20161013011Wire Harness · shortedAIRCRAFT WAS GROUNDED. NRT, AIR INTERRUPT, PVG-LAX. EMERGENCY DECLARED. LANDING UNEVENTFUL. AIRCRAFT OVERWEIGHT. DURING CRUISE RECEIVED SPOILERS EICAS MESSAGE BUFFETING AT AIRFRAME. VISUALLY CONFIRMED SPOILER 4 AND 11 RAISED FROM WING. MAINTENANCE FOUNDSDR AALA20160126014Fmu · faultyAIRCRAFT WAS GNDED. LT ENG SHUTDOWN WHEN TAKEOFF POWER WAS SELECT. TAKEOFF ABORTED AT LOW SPEED. PERFORMED FIM 73-21-20-810-812-R00. R & R LT ENG FUEL METERING UNIT IAW AMM 73-21-13 & MCM CARD 71-95-17. PERFORMED FUEL & OIL LEAK TEST. SYS CHECKED NORMAL.SDR AALA20151231004Light · damagedEMERGENCY LIGHT ASSEMBLY DAMAGED. R & R 12G SEAT EMER LIGHT ASSEMBLY IAW AMM 33-51-05. OPERATIONAL CHECK FOUND NORMAL. THE ACFT WAS NOT GNDED.SDR AALA20150802006Connector · looseAISLE SEAT EMERGENCY LIGHTS AT ROWS 20C - 23C INOPERATIVE. FOUND LOOSE CONNECTOR UNDER SEAT ROW 23 CENTER SECTION. SECURED CONNECTOR & PERFORMED OPERATIONAL CHECK IAW MM 33-51-05. SYSTEM CHECKED NORMAL.SDR AALA20150802005Connector · looseAISLE SEAT EMERGENCY LIGHTS AT ROWS 20G - 23G INOPERATIVE. FOUND LOOSE CONNECTOR UNDER SEAT ROW 23 CENTER SECTION. SECURED CONNECTOR & PERFORMED OPERATIONAL CHECK IAW MM 33-51-05. SYSTEM CHECKED NORMAL.SDR AALA20150710002Fan · odorPASSENGERS REPORTED BURNING ODOR & ELEC ODOR AT ROW 42. ECAM STATUS MSG, RECIR FAN, ALSO GENERATED. FOUND CIRCUIT BREAKER TRIPPED FOR LOWER LT RECIRCULATION FAN. R & R LT LOWER RECIRCULATION FAN & ACCOMPLISHED ALL REQUIRED TESTS IAW AMM 21-25-07. SYS CHECKSDR AALA20150508010Battery Pack · failedEMERGENCY LIGHT BATTERY PACK M33401 FAILED CAPACITY CHECK. DEEP CYCLE CHARGED EMER LIGHT BATTERY PACK M33401 & CAPACITY CHECK, OKAY IAW AMM 33-51-06.SDR AALA20150508003Battery Pack · failedEMERGENCY LIGHT BATTERY PACK M33096 AT L2 DOOR FAILED CAPACITY CHECK. REPLACED EMER LIGHT BATTERY PACK WITH GOOD OPERATIONAL CHECK IAW AMM 33-51-06.SDR AALA20150508002Battery Pack · failedEMERGENCY LIGHT BATTERY PACK M33094 AT R1 DOOR FAILED CAPABILITY CHECK. REPLACED EMER LIGHT BATTERY PACK WITH GOOD OPERATIONAL TEST IAW AMM 33-51-06.SDR AALA20150502006Sign · crackedR1 DOOR EXIT SIGN CRACKED. REPLACED LENS WITH GOOD OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA20150502005Lens · deterioratedL3 DOOR EXIT SIGN IN POOR CONDITION. R & R SIGN WITH GOOD OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA20150509009Lens · missingSEAT 21C EMER LIGHT LENS MISSING. R & R CABIN SEAT 21C EMER LIGHT ASSEMBLY & PERFORMED OPERATIONAL TEST IAW AMM 33-51-05. SYS CHECKED NORMAL.SDR AALA20150503008Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK M33099 FAILED CAPACITY CHECK. REPLACED BATTERY PACK IAW AMM 33-51-00. GOOD OPERATIONAL CHECK.SDR AALA20150430010Sign · crackedL1 DOOR AFT EXIT SIGN CRACKED. REPLACED SIGN LENS IAW AMM 33-51-01 WITH GOOD OPERATIONAL CHECKS.SDR AALA20150416014Light · crackedGALLEY 3 FWD LT & RT EMERGENCY LIGHT CRACKED. REPLACED & TESTED OK, AMM 33-51-00.SDR AALA20150416013Lamp · inoperativeCABIN SEAT 36C CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED & TESTED OK, AMM 33-51-00.SDR AALA20150416012Lens · crackedAFT PARTITION RT EMERGENCY LIGHT LENS CRACKED. AFT PARTITION RT EMERGENCY LIGHT REPLACED & TESTED OK, AMM 33-51-00.SDR AALA20141224007Light · missingSEAT 25C MISSING EMER LIGHTS & LENS. INSTALLED LAMPS & LENS IAW AMM 33-51-05. OPERATIONS CHECKED GOOD.SDR AALA20141205008Skin · dentedFUSELAGE SKIN DENTED AT STATION 804 BETWEEN STRINGERS 46 LT & 48 LT. REPAIRED SKIN IAW SRM 53-00-01-2R-4.SDR AALA20140926003Pin · looseSEAT MOUNTED EMER LIGHT AT 23G INOPERATIVE. FOUND PIN THAT WAS LOOSE IN CONNECTOR, NOT SEATED. SEATED PIN IN CONNECTOR & SECURED. OPERATIONS CHECKED NORMAL.SDR AALA20140817012Light · inoperativeFLOOR PROXIMITY EMER LIGHT ON SEAT 31C INOPERATIVE. REPLACED LAMP FOR SEAT 31C FLOOR PROXIMITY EMER LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140817011Power Supply · inoperativeFLOOR PROXIMITY EMER LIGHTS ON ALL SEATS, ROWS 30 & AFT ARE INOPERATIVE. REPLACED FLOOR PROXIMITY EMER LIGHT POWER SUPPLY M33401. OPERATIONS CHECKED NORMAL.SDR AALA20140425002Light · inoperativeLEFT NR 2 DOOR AFT EMERGENCY EXIT MARKER INOPERATIVE. REPLACED LAMP FOR LT NR 2 DOOR AFT EMERGENCY EXIT MARKER, OPERATIONS CHECKED NORMAL.SDR AALA20140425001Lens · missingESCAPE PATH LIGHT AT SEAT 37G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 37G, OPERATIONS CHECKED NORMAL.SDR AALA20131014010Light · inoperativeCEILING EMERGENCY LIGHT AT SEAT 22C INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT AT SEAT 22C. OPERATIONS CHECKED NORMAL.SDR AALA20130531060Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 30 TO 45 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS FROM ROWS 30 TO 45. OPS CHECK NORMALSDR AALA20130531059Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 30 TO 45 INOPERATIVE. REPLACED RT AFT BATTERY PACK FOR EMERGENCY LIGHTS FROM ROWS 30 TO 45. OPS CHECK NORMAL.SDR AALA20130531058Light · inoperativeESCAPE PATH LIGHT AT SEAT 42C INOPERATIVE. REPLACED LAMPS FOR SEAT 42C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130531057Light · inoperativeESCAPE PATH LIGHT AT SEAT 22G INOPERATIVE. REPLACED LAMPS FOR SEAT 22G ESCAPE PATH LIGHT. OPS CHECK NORMAL.
Back to N793AN