N791AN
Service difficulty reports · 325
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 = 'N791AN' 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 = 'N791AN' 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 AALA20170410007Battery Pack · dischargedDOOR R4 EMER LT POWER PACK M33409 FOUND LOW CAPACITY. DOOR R4 EMER LT POWER PACK M33409 REPLACED. INSTALLATION TEST CARRIED OUT AND RESULT NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170410006Battery Pack · dischargedDOOR R3 EMER LT POWER PACK M33401 FOUND LOW CAPACITY. DOOR R3 EMER LT POWER PACK M33401 REPLACED. INSTALLATION TEST CARRIED OUT AND RESULT NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170410005Battery Pack · dischargedDOOR L3 EMER LT POWER PACK M33406 FOUND LOW CAPACITY. DOOR L3 EMER LT POWER PACK M33406 REPLACED. INSTALLATION TEST CARRIED OUT AND RESULT NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170410004Battery Pack · dischargedDOOR R1 EMER LT POWER PACK M33094 FOUND LOW CAPACITY. DOOR R1 EMER LT POWER PACK M33094 REPLACED. INSTALLATION TEST CARRIED OUT AND RESULT NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170410003Power Supply · dischargedDOOR R4 EMER LT POWER PACK M33408 FOUND LOW CAPACITY. DOOR R4 EMER LT POWER PACK M33408 REPLACED. INSTALLATION TEST CARRIED OUT AND RESULT NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170406005Guard · damagedCABIN - L1 DR ATTENDANT PANEL "EVAC" SWITCH GUARD SPRING FOUND BROKEN. L1 DR ATTENDANT PANEL "EVAC" SWITCH GUARD REPLACED IAW SWPM 20-84-15, AMM 33-22-06 & AMM 25-63-02. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170406003Guard · damagedCABIN - R4 DOOR AREA CONTROL PANEL "EMER LIGHT TEST" SWITCH GUARD FOUND DAMAGED. R4 DOOR AREA CONTROL PANEL "EMER LIGHT TEST" SWITCH GUARD REPLACED IAW SWPM 20-84-15 AND AMM 33-22-06 & AMM 33-51-00. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170406017Sign · damagedCABIN DOOR R1 EXIT INDICATOR (AFT) FOUND DAMAGED. EXIT INDICATOR (AFT) REPLACED & TEST NORMAL IAW AMM 33-51-01. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170406016Sign · damagedCABIN - DOOR R2 EXIT INDICATOR (AFT) FOUND DAMAGED, CABIN - DOOR R2 EXIT INDICATOR (AFT) REPLACED & TEST CARRIED OUT NORMAL IAW AMM 33-51-01. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170206004Elt · faultyDURING FLIGHT, DISPATCH REPORTED THE EMERGENCY LOCATOR TRANSMITTER WAS ACTIVE. NO INDICATIONS IN THE COCKPIT. AIRCRAFT WAS GROUNDED. TROUBLESHOOTING DISCOVERED A FAULTY ELT ON A DOOR EVACUATION SLIDE. REMOVED AND REPLACED L1 DOOR SLIDE (AALA20170202030) AND RSDR AALA20170202030Elt · faultyDURING FLIGHT, DISPATCH REPORTED THE EMERGENCY LOCATOR TRANSMITTER WAS ACTIVE. NO INDICATIONS IN THE COCKPIT. AIRCRAFT WAS GROUNDED. TROUBLESHOOTING DISCOVERED A FAULTY ELT ON A DOOR EVACUATION SLIDE. REMOVED AND REPLACED L1 DOOR SLIDE AND R4 DOOR SLIDE OPERATSDR AALA20170116017Power Supply · inoperativeAIRCRAFT WAS GROUNDED. CAPTAINS COCKPIT INTERIOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33424 IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170116005Power Supply · inoperativeAIRCRAFT NOT GROUNDED. L1 DOOR EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33430 IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20161213018Power Supply · no testEMERGENCY LIGHTS AT R2 DOOR AREA DO NOT TEST. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M33097 IAW AMM 33-51-00. SYSTEM CHECKS NORMAL.SDR AALA20161003002Power Supply · inoperativeEMERGENCY EXIT SIGN AT L3 DOOR IS INOPERATAIVE. REMOVED ANAD REPLACED EMERGENCY LIGHT POWER SUPPLY M33405 IAW AMM 33-51-06. SYSTEM TESTS GOOD.SDR AALA20160202008Module · faultyLANDING GEAR HANDLE WOULD NOT MOVE TO UP ON FIRST ATTEMPT AFTER TAKEOFF. SECOND ATTEMPT NORMAL. DID NOT HAVE TO USE LOCK OVERRIDE BUTTON. NO EMER WAS DECLARED & THE FLIGHT CONTINUED TO DESTINATION WITHOUT INCIDENT. R & R LG CONTROL MODULE IAW AMM 32-31-01.SDR AALA20150406002Skin · bentFORWARD CARGO DOOR AFT LOWER CORNER BENT. FWD CARGO DOOR SKIN REPAIR ACCOMPLISHED IAW SRM 52-30-01-2R-17 FIG 202.SDR AALA20150406001Skin · deformedFORWARD CARGO DOOR SKIN DEFORMED AT FWD LOWER CORNER. FWD CARGO DOOR SKIN REPAIR ACCOMPLISHED IAW SRM 52-30-01-2R-17 FIG 202.SDR AALA20150408028Light · crackedCABIN G3 EMERGENCY LIGHTS NR 1 - 4, COUNT FROM LT TO RT, LENS ARE CRACKED. R & R NR 4 LIGHT ASSEMBLY. PERFORMED OPERATIONAL TEST IAW AMM: 33-51-05. SYS CHECKED NORMAL.SDR AALA20150408027Light · crackedCABIN G3 EMERGENCY LIGHTS NR 1 - 4, COUNT FROM LT TO RT, LENS ARE CRACKED. R & R NR 3 LIGHT ASSEMBLY. PERFORMED OPERATIONAL TEST IAW AMM 33-51-05. SYS CHECKED NORMAL.SDR AALA20150408026Light · crackedCABIN G3 EMERGENCY LIGHTS NR 1 - 4, COUNT FROM LT TO RT, LENS ARE CRACKED. R & R NR 2 LIGHT ASSEMBLY. PERFORMED OPERATIONAL TEST IAW AMM 33-51-05. SYS CHECKED NORMAL.SDR AALA20150404003Power Supply · inoperativeL2 DOOR M33099 EMERGENCY LIGHT POWER SUPPLY ASSEMBLY FOUND INOPERATIVE. R & R POWER SUPPLY ASSEMBLY. PERFORMED OPERATIONAL TEST IAW AMM 33-51-06. SYS CHECKED NORMAL.SDR AALA20150403010Lens · crackedCABIN G3 EMERGENCY LIGHTS NR 1 - 4, LENS ARE CRACKED. R & R NR 1 LIGHT ASSEMBLY. PERFORMED OPERATIONAL TEST IAW AMM: 33-51-05. SYS CHECKED NORMAL.SDR AALA20150403009Switch · failedR4 PAX ENTRY DOOR EMERGENCY POWER ASSIST SYS CIRCUITRY FUNCTIONAL CHECK FAILED. WIRING CONTINUITY CHECKED. FOUND SWITCH DOOR MODE SELECT SWITCH AT DOOR OPEN, SWITCH FAILED. R & R SWITCH. PERFORMED EMER POWER ASSIST SYS BATTERY. OPERATIONAL TESTED IAW AMM SDR AALA20150402012Sign · crackedL2 DOOR FWD EMER EXIT SIGN CRACKED. REPLACED L2 DOOR FWD EMER EXIT SIGN. OPERATIONAL CHECKED IAW AMM 33-51-00 WITH NO DEFECTS NOTED.SDR AALA20150402011Sign · crackedR4 DOOR AFT EXIT SIGN FOUND CRACKED. REPLACED R4 DOOR AFT EXIT SIGN & TESTED OK IAW AMM 33-51-00.SDR AALA20150402010Sign · crackedR4 DOOR FWD EXIT SIGN FOUND CRACKED. REPLACED R4 DOOR FWD EXIT SIGN. TESTED OK IAW AMM 33-51-00.SDR AALA20150402009Sign · crackedR1 DOOR AFT CUT OUT EXIT SIGN FOUND CRACKED. REPLACED R1 DOOR AFT EXIT SIGN. TESTED OK IAW AMM 33-51-00.SDR AALA20150402008Sign · crackedR3 DOOR AFT EXIT SIGN FOUND CRACKED. REPLACED R3 DOOR AFT EXIT SIGN. TESTED OK IAW AMM 33-51-00.SDR AALA20150401011Sign · crackedR1 DOOR FWD CUT OUT EXIT SIGN FOUND CRACKED. REPLACED R1 DOOR FWD CUT OUT EXIT SIGN. TESTED OKAY AMM 33-51-01.SDR AALA20150401010Sign · crackedL2 DOOR AFT EXIT SIGN FOUND CRACKED. REPLACED L2 DOOR AFT EXIT SIGN. TESTED OKAY AMM 33-51-01.SDR AALA20150331007Light · inoperativeDOOR L3 EXTERIOR EMER LIGHT INOPERATIVE. REPLACED DOOR L3 EXTERIOR EMER LIGHT, TESTED OK IAW AMM 33-51-01.SDR AALA20150106019Transmitter · faultyEMERGENCY DECLARED, LANDING UNEVENTFUL. ACFT NOT OVERWEIGHT. DURING CRUISE CREW NOTED NR 8 MAIN TIRE PRESS INDICATED 194 PSI. CAPTAIN REQUESTED TIRE BE CHECKED ON LANDING. CHECKED TIRE PESS & FOUND IT TO BE WITHIN LIMITS. R & R NR 8 MAIN TIRE & TIRE PRESSSDR AALA20140724002Light · inoperativeRIGHT NR 4 DOOR EMER LIGHT INOPERATIVE. REPLACED LAMP FOR RT NR 4 DOOR EMER LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140705006Battery Pack · failedEMERGENCY LIGHTS BATTERY PACK M33400 FAILED. REPLACED BATTERY PACK M33400. OPERATIONS CHECKED NORMAL.SDR AALA20140705005Battery Pack · failedEMERGENCY LIGHTS BATTERY PACK 33096 FAILED. REPLACED BATTERY PACK M33096. OPERATIONS CHECKED NORMAL.SDR AALA20140705004Battery Pack · failedEMERGENCY LIGHTS BATTERY PACK M33404 FAILED. REPLACED BATTERY PACK M33404. OPERATIONS CHECKED NORMAL.SDR AALA20140705003Battery Pack · failedEMERGENCY LIGHTS BATTERY PACK M33093 FAILED. REPLACED BATTERY PACK M33093. OPERATIONS CHECKED NORMAL.SDR AALA20140705002Battery Pack · failedEMERGENCY LIGHTS BATTERY PACK M33407 FAILED. REPLACED BATTERY PACK M33407. OPERATIONS CHECKED NORMAL.SDR AALA20140616031Lens · missingESCAPE PATH LIGHT AT SEAT 32C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 32C. OPERATIONS CHECKED NORMAL.SDR AALA20140616030Light · missingESCAPE PATH LIGHT AT SEAT 32C MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 32C. OPERATIONS CHECKED NORMAL.SDR AALA20140616029Light · brokenESCAPE PATH LIGHT AT SEAT 43C IS BROKEN. REPLACED LIGHT ASSEMBLY FOR ESCAPE PATH LIGHT AT SEAT 43C. OPERATIONS CHECKED NORMAL.SDR AALA20140616028Lens · missingESCAPE PATH LIGHT AT SEAT 22C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 22C. OPERATIONS CHECKED NORMAL.SDR AALA20140616027Light · missingESCAPE PATH LIGHT AT SEAT 22C MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 22C. OPERATIONS CHECKED NORMAL.SDR AALA20140616026Lens · missingESCAPE PATH LIGHT AT SEAT 20C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 20C. OPERATIONS CHECKED NORMAL.SDR AALA20140616025Light · missingESCAPE PATH LIGHT AT SEAT 20C MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 20C. OPERATIONS CHECKED NORMAL.SDR AALA20140616024Light · inoperativeESCAPE PATH LIGHT AT SEAT 38C INOPERATIVE. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 38C. OPERATIONS CHECKED NORMAL.SDR AALA20140616023Light · inoperativeESCAPE PATH LIGHT AT SEAT 35C INOPERATIVE. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 35C. OPERATIONS CHECKED NORMAL.SDR AALA20140616022Light · missingESCAPE PATH LIGHT AT SEAT 32G MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 32G. OPERATIONS CHECKED NORMAL.SDR AALA20140616021Lens · missingESCAPE PATH LIGHT AT SEAT 32G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 32G. OPERATIONS CHECKED NORMAL.
Back to N791AN