N794AN
Service difficulty reports · 276
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 = 'N794AN' 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 = 'N794AN' 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 AALA201703239028Light · missingEMERGENCY LIGHTS AFT COACH SOME MISSING AT 21C. INSTALLED EMERGENCY LIGHT IAW AMM 33-51-05-360-801, TEST OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170201011Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 20D IS MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20170201010Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 38C IS MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20170201009Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 32C IS MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161110016Power Supply · no testAFTER PERFORMING THE POWER SUPPLY DEEP CYCLE AND RESTORATION PROCEDURE IAW CARD 2735 THE CEILING EMERGENCY LIGHTS BETWEEN ROW 1D AND 30 FAILED TO REMAIN ILLUMINATED FOR THE 15 MINUTE TIME REQUIREMENT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M33098 AMM 33-5SDR AALA20161110015Power Supply · no testAFTER PERFORMING THE POWER SUPPLY DEEP CYCLE AND RESTORATION PROCEDURE IAW CARD 2735 THE CEILING EMERGENCY LIGHTS BETWEEN ROW 1D AND 30 FAILED TO REMAIN ILLUMINATED FOR THE 15 MINUTE TIME REQUIREMENT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY AMM 33-51-06.SDR AALA20161110014Power Supply · no testAFTER PERFORMING THE POWER SUPPLY DEEP CYCLE AND RESTORATION PROCEDURE IAW CARD 2735 THE CEILING EMERGENCY LIGHTS BETWEEN ROW 1D AND 30 FAILED TO REMAIN ILLUMINATED FOR THE 15 MINUTE TIME REQUIREMENT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M33404 AMM 33-SDR AALA20161107047Power Supply · no testEMERGENCY LIGHTS FOR CENTER SEATS BETWEEN ROWS 30 AND 45 FAIL TO MEET 15 MINUTE ILLUMINATION REQUIRMENT. REMOVE AND REPLACED POWER SUPPLY IAW AMM 33-51-06.SDR AALA20161107002Power Supply · no testAFTER PERFORMING THE POWER SUPPLY DEEP CYCLE AND RESTORATION PROCEDURE IAW CARD 2735 THE L2 DOOR EXTERIOR EMERGENCY LIGHTS FAILED TO REMAIN ILLUMINATED FOR THE 15 MINUTE TIME REQUIREMENT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M33099 IAW AMM 33-51-06.SDR AALA20161107001Power Supply · no testAFTER PERFORMING THE POWER SUPPLY DEEP CYCLE AND RESTORATION PROCEDURE IAW CARD 2735 THE CEILING EMERGENCY LIGHTS BETWEEN ROW 1D AND 30 FAILED TO REMAIN ILLUMINATED FOR THE 15 MINUTE TIME REQUIREMENT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M33094 AMM 33-5SDR AALA20160621017Unknown · vibrationAIRCRAFT WAS GROUNDED. AIR INTERRUPT, EMERGENCY DECLARED, LANDING UNEVENTFUL, ACFT OVERWEIGHT. DURING CLIMB, CONTROL WHEEL VIBRATION WAS ENCOUNTERED. VIBRATION INCREASED AS GEAR AND FLAPS WERE RETRACTED AND SPEED INCREASED THEN DECREASED AS ACFT WAS CONFIGUSDR AALA20160510009Fan · faultyAIRCRAFT WAS NOT GNDED. FLIGHT ATTENDANT REPORTED ELEC SMOKE SMELL IN AFT GALLEY. FIRE, SMOKE & FUMES CHECKLIST WAS ACCOMPLISHED & SOURCE DETERMINED TO BE RECIRCULATION FAN. RECIRCULATION FANS TURNED OFF & ODOR DISSIPATED. R & R AFT UPPER RECIRCULATION FANSDR AALA20151202005Power Supply · inoperativeSIX EMER ESCAPE PATH LIGHTS ON SIDE OF THE M4 GALLEY ARE INOPERATIVE. R & R M30396 EMER ESCAPE PATH POWER SUPPLY ASSEMBLY IAW MM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20151018006Slide · low pressureDURING A CHECK, FOUND DOOR 3L SLIDE BOTTLE WITH LOW PRESS. PLACARDED 3L DOOR INOPERATIVE IAW MEL 10-568DC-A. R & R 3L DOOR ESCAPE SLIDE IAW MM 26-66-01. ALL CHECKED NORMAL. REMOVED MEL 10-568DC-A.SDR AALA20150730001Skin · delaminatedLEFT INBOARD AFT FLAP TRAILING EDGE UPPER SURFACE FOUND DELAMINATED. COMPOSITE REPAIR ACCOMPLISHED IAW SRM 51-70-05 REPAIR 2.SDR AALA20150727013Battery Pack · discharged2R DOOR EMERGENCY POWER SUPPLY BATTERY DEAD. R & R M33097 BATTERY PACK & PERFORMED OPERATIONAL TEST IAW AMM 33-51-06. SYSTEM CHECKED NORMAL.SDR AALA20150727004Lens · cracked4R DOOR FORWARD FLOOR PROXIMITY EXIT SIGN LENS CRACKED. R & R EXIT SIGN LENS. PERFORMED OPERATIONAL TEST IAW AMM 33-51-01. SYSTEM CHECKED NORMAL.SDR AALA20150726007Power Supply · failed3R DOOR EMERGENCY POWER SUPPLY M33401 FAILED BATTERY CAPACITY CONFIRMATION CHECK. R & R POWER SUPPLY AND PERFORMED OPERATIONAL TEST IAW AMM 33-51-06. SYS CHECKED NORMAL.SDR AALA20150726005Power Supply · failedL1 DOOR EMERGENCY POWER SUPPLY M33093 FAILED BATTERY CAPACITY CONFIRMATION CHECK. R & R THE POWER SUPPLY AND PERFORMED OPERATIONAL TEST IAW AMM 33-51-06. SYS CHECKED NORMAL.SDR AALA20150726004Fuse · inoperativeL3 DOOR EMERGENCY EXIT SIGN INOPERATIVE. R & R FUSE ON POWER SUPPLY M33406. PERFORMED OPERATIONAL TEST IAW AMM 33-51-06. SYS CHECKED NORMAL.SDR AALA20150725004Connector · unsecureCENTER ROW SEAT 42 FLOOR PROXIMITY EMERGENCY LIGHTS INOPERATIVE. CONNECTED & SECURED CONNECTOR IAW SWPM 20-10-11. PERFORMED OPERATIONAL TEST IAW AMM 33-51-00. SYS CHECKED NORMAL.SDR AALA20150727010Light · brokenAFT GALLEY PARTITION RT & LT WALL MOUNTED FLOOR PROXIMITY EMERGENCY LIGHTS ARE BROKEN. R & R AFT GALLEY PARTITION RT WALL MOUNTED FLOOR PROXIMITY EMERGENCY LIGHT. PERFORMED OPERATIONAL TEST IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20150727006Panel · brokenCOCKPIT P8 AISLE STAND EMERGENCY EVACUATION PANEL BUZZER FOUND BROKEN. R & R COCKPIT P8 AISLE STAND EMERGENCY EVACUATION PANEL. PERFORMED OPERATIONAL TEST IAW AMM 25-63-02. SYS CHECKED NORMAL.SDR AALA20150726009Sign · brokenL1 DOOR FWD FLOOR PROXIMITY LIGHT EXIT SIGN ASSEMBLY FOUND BROKEN. R & R FLOOR PROXIMITY LIGHT EXIT SIGN ASSEMBLY. PERFORMED OPERATIONAL TEST IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20150725007Sign · brokenL2 DOOR AFT FLOOR PROXIMITY LIGHT EXIT SIGN ASSEMBLY FOUND BROKEN. R & R FLOOR PROXIMITY LIGHT EXIT SIGN ASSEMBLY. PERFORMED OPERATIONAL TEST IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20150725005Light · brokenAFT GALLEY PARTITION RT & LT WALL MOUNTED FLOOR PROXIMITY EMER LIGHTS ARE BROKEN. R & R AFT GALLEY PARTITION LT WALL MOUNTED FLOOR PROXIMITY EMER LIGHT. PERFORMED OPERATIONAL TEST IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20150715013Lens · detachedL1 DOOR EMER EXIT LIGHT LENS IS DETACHED. REPLACED L1 DOOR EMER EXIT LIGHT LENS IAW AMM 33-51-04.SDR AALA20150608011Drain Line · blockedAIR INTERRUPT, EMER DECLARED, LANDING UNEVENTFUL & ACFT OVERWEIGHT. DURING CLIMB ALL BUT THREE LAVATORIES BECAME INOPERATIVE. CLEARED BLOCKAGE IN DRAIN LINE AFT OF LAVATORY 2L - 1L. PERFORMED OPERATIONAL CHECK IAW AMM 38-32-00-160-802. SYS CHECKED NORMAL.SDR AALA20150325001Light · inoperativeNO EMER FLOOR PROXIMITY LIGHTING IN ALL SEATS AT ROWS 20 - 26. TROUBLE SHOT IAW FIM 33-51-00-810-806. R & R EMER LIGHT FILAMENTS ON SEAT ROWS 20 - 26 C, D, E, F & G. SYS CHECKED NORMAL.SDR AALA20150218008Battery Pack · failedEMERGENCY BATTERY PACK AT 3R DOOR FOR SEAT ROWS 20 - 26 FAILED. REPLACED EMER LIGHT BATTERY PACK AT 3R DOOR IAW AMM 33-51-06 FOR SEATS 20 - 26. SYS CHECKED NORMAL.SDR AALA20141029008Lens · missingEMERGENCY PATH LIGHT AT SEAT 39G IS MISSING LENS. INSTALLED NEW LENS IAW AMM 33-51-05. OPERATIONS CHECKED NORMAL.SDR AALA20141024008Light · missingEMERGENCY PATH LIGHT AT SEAT 39G IS MISSING LAMPS. INSTALLED NEW LAMPS IAW AMM 33-51-05. OPERATIONS CHECKED NORMAL.SDR AALA20141024007Light · brokenEMERGENCY PATH LIGHT BROKEN AT LT AFT GALLEY. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-05. OPERATIONS CHECKED NORMAL.SDR AALA20140807008Light · inoperativeLEFT NR 2 DOOR EXTERNAL EMER LIGHT INOPERATIVE. REPLACED LAMP FOR LT NR 2 DOOR EXTERNAL EMER LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140807007Lens · missingSEAT MOUNTED EMER LIGHT AT 26G MISSING LENS. REPLACED LENS FOR SEAT MOUNTED EMER LIGHT AT 26G. OPERATIONS CHECKED NORMAL.SDR AALA20140225012Power Supply · inoperativeEMERGENCY POWER SUPPLY M33406 INOPERATIVE. REPLACED POWER SUPPLY M33406, OPERATIONS CHECKED NORMAL.SDR AALA20140225011Power Supply · inoperativeEMERGENCY LIGHTS AT RT NR 3 DOOR INOPERATIVE. REPLACED POWER SUPPLY M33404 FOR EMERGENCY LIGHTS AT RT NR 3 DOOR, OPERATIONS CHECKED NORMAL.SDR AALA20140225010Power Supply · inoperativeEMERGENCY LIGHTS AT LT NR 1 DOOR INOPERATIVE. REPLACED POWER SUPPLY M33424 FOR EMERGENCY LIGHTS AT LT NR 1 DOOR, OPERATIONS CHECKED NORMAL.SDR AALA20140225009Power Supply · inoperativeEMERGENCY LIGHTS AT LT NR 4 DOOR INOPERATIVE. REPLACED POWER SUPPLY M33407 AT LT NR 4 DOOR. OPERATIONS CHECKED NORMAL.SDR AALA20140225006Power Supply · inoperativeEMERGENCY POWER SUPPLY M33405 INOPERATIVE. REPLACED POWER SUPPLY M33405, OPERATIONS CHECKED NORMAL.SDR AALA20130816007Light · inoperativeSEAT 3B EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 3B EMERGENCY LIGHT. OPERATIONS CHECKED NORMALSDR AALA20130731015Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT SEAT 23C INOPERATIVE. REPLACED LAMP FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT 23C. OPERATIONS CHECKED NORMAL.SDR AALA20130731014Lens · missingOVERHEAD EMERGENCY LIGHT AT SEAT 3D MISSING LENS. REPLACED LENS FOR OVERHEAD EMERGENCY LIGHT AT SEAT 3D. OPERATIONS CHECKED NORMAL.SDR AALA20130731011Light · inoperativeSEAT 25C SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 25C EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130731010Lens · missingSEAT 25C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 25C EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130731009Lens · missingSEAT MOUNTED EMERGENCY LIGHT AT 23C MISSING LENS. REPLACED LENS FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT 23C. OPERATIONS CHECKED NORMAL.SDR AALA20130731008Light · inoperativeOVERHEAD EMERGENCY LIGHT AT RT NR 4 DOOR INOPERATIVE. REPLACED LAMP FOR OVERHEAD EMERGENCY LIGHT AT RT NR 4 DOOR. OPERATIONS CHECKED NORMAL.SDR AALA20130731007Light · inoperativeOVERHEAD EMERGENCY LIGHT AT RT NR 2 DOOR INOPERATIVE. REPLACED LAMP FOR OVERHEAD EMERGENCY LIGHT AT RT NR 2 DOOR. OPERATIONS CHECKED NORMAL.SDR AALA20130731006Light · inoperativeOVERHEAD EMERGENCY LIGHT AT SEAT 3D INOPERATIVE. REPLACED LAMP FOR OVERHEAD EMERGENCY LIGHT AT SEAT 3D. OPERATIONS CHECKED NORMAL.SDR AALA20130328015Light · inoperativeROW 36C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 36C ESCAPE PATH LIGHT. OPS CHECK NORMAL.
Back to N794AN