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 AALA20090916MIA05Lamp · burned outEMERGENCY LIGHT AT SEAT 1J INOPERATIVE. RELAMPED SEAT 1J. OPS CHECK OK.SDR AALA20090916MIA01Lamp · burned outEMERGENCY LIGHT AT SEAT 25C INOPERATIVE. RELAMPED SEAT 25C. OPS CHECK OK.SDR AALA20090916MIA03Light · inoperativeEMERGENCY LIGHT AT SEAT 5G INOPERATIVE. RELAMPED SEAT 5G. OPS CHECK OK.SDR AALA20090916MIA02Light · inoperativeEMERGENCY LIGHT AT SEAT 4A INOPERATIVE. RELAMPED SEAT 4A. OPS CHECK OK.SDR AALA2009060600002Light · inoperativeDFW - CAPTAINS EMERGENCY DOME LIGHT IN COCKPIT INOPERATIVE. REPLACED LAMP FOR CAPTAINS EMERGENCY DOME LIGHT IN COCKPIT.SDR AALA2009060600001Light · inoperativeDFW - EMERGENCY LIGHT FLOOR PROXIMITY EDGE MOUNTED AT RIGHT FORWARD GALLEY INOPERATIVE. REPLACED LAMP.SDR AALA20090709TUL13Seat Track · damagedSEAT TRACK GOUGED. REPAIRED IAW AARD 53-00-52-01.SDR AALA2009032800680Battery Pack · dischargedDFW - R3 DOOR FORWARD EXIT EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT R3 DOOR FORWARD EXIT EMERGENCY.SDR AALA2009032800679Battery Pack · dischargedDFW - OVERHEAD EMERGENCY LIGHTS ON RIGHT SIDE OF ROWS 19 TO 26 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS ON RIGHT SIDE OF ROWS 19 TO 26.SDR AALA2009032800678Battery Pack · dischargedDFW - SEAT MOUNTED EMERGENCY LIGHTS FOR ROWS 20G TO 26G INOPERATIVE. REPLACED BATTERY PACK FOR SEAT MOUNTED EMERGENCY LIGHTS AT ROWS 20G TO 26G.SDR AALA200802385ALight · missingLHR - EMERGENCY LIGHT MISSING ON FIRST CLASS COAT COMPARTMENT NEAR LEFT NUMBER ONE DOOR. REPLACED EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802384Light · brokenNRT EMERGENCY LIGHT AT FIRST CLASS CLOSET BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT FIRST CLASS CLOSET. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200801952Pressure Switch · inoperativeORD INFLIGHT T70/24JUL DFW TO FRA. CREW REPORTED RT HAND ENGINE OIL SCAVENGE FILTER CLOG LIGHT ILLUMINATED. LANDED ORD WITHOUT INCIDENT. REPLACED DIFFERENTIAL PRESSURE SWITCH. SYSTEM GROUND CHECKED NORMAL OPS. (CLOSED)SDR AALA200801597Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 34C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 34C. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801596Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 25C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801595Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 24C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 24C. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801540Fuse · inoperativeJFK - EMERGENCY LIGHTS AT SEAT ROWS 20 TO 26 INOPERATIVE. REPLACED BATTERY PACK FUSE FOR EMERGENCY LIGHTS AT SEAT ROWS 20 TO 26. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801345Lens · missingDFW EMERGENCY LIGHT AT LT NUMBER ONE CLOSET DOOR MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT LT NUMBER ONE CLOSET DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED) (A)SDR AALA200801147Fitting · damagedAFW - DRIVE ARM FITTING ASSEMBLY JOINT 2A HAS BEEN BORED TO 1.714 INCH. BEYOND ALLOWABLE DIMENSION OF CMM 27 57 97 REPAIR 2.2. REPAIRED PER ENGINEERING INSTRUCTIONS.SDR AALA200800717Lens · brokenDFW - EMERGENCY LIGHT AT LEFT NUMBER ONE FORWARD GALLEY CLOSET HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT LEFT NUMBER ONE FORWARD GALLEY CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072413Lens · missingJFK - EMERGENCY LIGHT AT SEAT 23G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070693Switch · faultyLHR INFLIGHT T134/16APR DURING FLIGHT ALL EMERGENCY LIGHTS CAME ON. CYCLED EMERGENCY LIGHT SWITCH SEVERAL TIMES UNTIL LIGHT EXTINGUISHED AND SYSTEM WORKED NORMAL. LANDED LHR WITHOUT INCIDENT. TESTED ALL EMERGENCY LIGHTS. COULD NOT DUPLICATE FAULT. SYSTEMSDR AALA20061389Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 24C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 24C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061391Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 42C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 42C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061390Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 39G INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 39G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061388Light · brokenDFW - EMERGENCY LIGHT ASSEMBLY AT LEFT NUMBER ONE DOOR CLOSET IS BROKEN. REPLACED EMERGENCY LIGHT ASSEMBLY AT LEFT NUMBER ONE DOOR CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061395Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 37G INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 37G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061393Lens · looseDFW - EMERGENCY LIGHT AT SEAT 26G HAS LOOSE LENS. SECURED LENS FOR EMERGENCY LIGHT AT SEAT 26G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061394Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 32G INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 32G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061392Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 35C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 35C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060562Light · damagedDFW - EMERGENCY LIGHT AT BULKHEAD BEHIND SEATS 45BC DAMAGED. REPLACED EMERGENCY LIGHT ASSEMBLY FOR DAMAGED LIGHT AT BULKHEAD BEHIND SEATS 45BC. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060810Battery Pack · activatedAFW - EMERGENCY LIGHTS AT RIGHT NUMBER ONE DOOR AND FIRST CLASS SEATS FAILED FUNCTIONAL TEST. REPLACED BATTERY PACKS FOR EMERGENCY LIGHTS AT RIGHT NUMBER ONE DOOR AND FIRST CLASS SEATS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060224Battery Pack · dischargedAFW - EMERGENCY ESCAPE PATH LIGHTING AT AFT COACH SEATS AND AT RIGHT NUMBER 3 DOOR AFT EXIT SIGN AND AT RIGHT NUMBER 1 DOOR AND FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK AT RIGHT NUMBER ONE DOOR AND RIGHT NUMBER 3 DOOR FOR EMERGENCY ESCAPE PATH LIGHTING SDR AALA20041244Girt Bar · misinstalledDFW - FOUND RIGHT NR 2 SLIDE GIRT BAR INSTALLED UPSIDE DOWN. REPLACED SLIDE FOR RIGHT NUMBER 2 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20030295Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, FORWARD ENTRY EMERGENCY EXIT LIGHT ASSEMBLY INOPERATIVE. REPLACED FORWARD ENTRY EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20001891Light · brokenDFW - DURING OVERNIGHT MAINTENANCE, LEFT SIDE FIRST CLASS EMERGENCY EXIT LIGH AT GALLEY BROKEN. REPLACED LEFT SIDE FIRST CLASS EMERGENCY EXIT LIGHT ASSEMBLY AT GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20001565Oxygen Bottle · leakingLHR - FLT 0217 - AC 7BB AA PIR.11 'ALERT' SYS 3510 MDIS, 17SEP/LHR T-0217. EMPL CREW. CREW OXYGEN SYSTEM LEAKS ABOUT 10 PSI EVERY 10 MINUTES. REPLACED CREW OXYGEN BOTTLE ACCOMPANIED BY OPS CHECK OF CREW OXYGEN MASKS, ALL OKAY. ACCOMPLISHED LEAK CHECK OF OX
Back to N793AN