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 AALA20130531052Skin · damagedFOUND FRESH SCRATCHES, GOUGES WITH RAISED METAL ON FUSELAGE SKIN, LOCATED AFT OF THE FWD CARGO DOOR CUTOUT AT LOWER CORNER. BLENDED AND TREATED IAW SRM 53-00-01-1A.SDR AALA20130531056Light · inoperativeESCAPE PATH LIGHT AT SEAT 25C INOPERATIVE. REPLACED LAMPS FOR SEAT 25C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130531055Light · inoperativeESCAPE PATH LIGHT AT SEAT 22C INOPERATIVE. REPLACED LIGHT ASSY FOR SEAT 22C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130531034Light · inoperativeRIGHT NR 3 DOOR OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RT NR 3 DOOR OVERHEAD EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130322010Light · inoperativeROW 25C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 25C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130322009Light · inoperativeROW 21C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 21C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130206001Battery Pack · dischargedLEFT NUMBER 3 DOOR EMERGENCY EXIT SIGN INOPERATIVE. INSTALLED NEW BATTERY PACK M33405. OPS CHECK NORMAL.SDR AALA20121019016Light · inoperativeSEAT 21C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 21C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121019015Light · inoperativeSEAT 20C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 20C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121019014Light · inoperativeSEAT 25C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 25C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121019013Light · inoperativeSEAT 39C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 39C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121019012Light · inoperativeSEAT 32C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 32C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121019011Light · inoperativeSEAT 32G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 32G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121019010Light · inoperativeSEAT 33G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 33G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121019009Light · inoperativeSEAT 2D ESCAPE PATH LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT 2D ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121019008Light · inoperativeSEAT 21G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 21G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121019007Light · inoperativeSEAT 31G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 31G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120921005Light · inoperativeRIGHT NUMBER 3 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. ADJUSTED RIGHT NUMBER 3 DOOR EXTERIOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120608022Battery Pack · dischargedBATTERY PACK M33401 FAILED CHECK. REPLACED BATTERY PACK M33401. OPS CHECK NORMAL.SDR AALA20120608021Battery Pack · dischargedBATTERY PACK M33400 FAILED CHECK. REPLACED BATTERY PACK M33400. OPS CHECK NORMAL.SDR AALA20120608020Battery Pack · dischargedBATTERY PACK M33096 FAILED CHECK. REPLACED BATTERY PACK M33096. OPS CHECK NORMAL.SDR AALA20111222MIA02Light · inoperativeRIGHT NUMBER 1 DOOR CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 1 DOOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20111222MIA01Light · inoperativeSEAT 24C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 24C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20111214TUL06Light · inoperativeEMERGENCY PATH LIGHT AT SEAT 33C INOPERATIVE. REPLACED LAMP FOR SEAT 33C EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111214TUL05Light · inoperativeCEILING EMERGENCY PATH LIGHT AT SEAT 9L INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111211MIA02Light · inoperativeSEAT 13D AFT ESCAPE PATH LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT 13D AFT ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111211MIA01Light · inoperativeEMERGENCY PATH LIGHT AT SEAT 26C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 26C. OPS CHECK NORMAL.SDR AALA20111001LHR01Light · damagedFLOOR PROXIMITY EMERGENCY LIGHT ASSEMBLY AT LEFT NUMBER 1 DOOR CLOSET FOUND DAMAGED. REPLACED EMERGENCY LIGHT ASSEMBLY. OPS CHECK NORMAL.SDR AALA20110823JFK01Light · inoperativeSEAT 21A EMERGENCY PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 21A EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110504TUL01Battery Pack · overheatedYQM - INFLIGHT LHR-ORD. CREW REPORTED MAIN SHIP BATTERY SMOKING. EMERGENCY DECLARED FLIGHT DIVERTED YQM LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED MAIN SHIP BATTERY AND CHARGER. INSPECTED MAIN BATTERY CONNECTOR AND NO DAMAGE NOTED. SDR AALA20110323MIA02O-Ring · leakingMIA - INFLIGHT EXE-JFK. CREW REPORTED CENTER HYDRAULIC FLUID LOSS. EMERGENCY DECLARED FLIGHT DIVERTED MIA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND HYDRAULIC FLUID LEAKING FROM FILTER MODULE FOR AC PUMP. REPLACED C2 PUMP FILTER MODULE OSDR AALA20101213TUL02Lens · missingSEAT 21C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 21C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20101212DFW01Light · missingSEAT 21C EMERGENCY LIGHT MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 21C. OPS CHECK NORMAL.SDR AALA20101025DFW05Light · inoperativeSEAT 10G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR ESCAPE PATH LIGHT AT SEAT 10G. OPS CHECKS NORMAL.SDR AALA20101025DFW04Lens · missingSEAT 22G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 22G ESCAPAE PATH LIGHT. OPS CHECKS NORMAL.SDR AALA20101025DFW03Lens · missingSEAT 32G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 32G ESCAPE PATH LIGHT. OPS CHECKS NORMAL.SDR AALA20101025DFW02Lens · missingSEAT 40G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 40G ESCAPE PATH LIGHT. OPS CHECKS NORMAL.SDR AALA20101025DFW01Lens · missingSEAT 25C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 25C ESCAPE PATH LIGHT. OPS CHECKS NORMAL.SDR AALA20100916TUL06Lamp · burned outSEAT MOUNTED EMERGENCY LIGHT AT 30D INOPERATIVE. REPLACED LAMP FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT 30D. OPS CHECKED NORMAL.SDR AALA20100914DFW05Cover · missingLEFT NUMBER 4 DOOR UTILITY OUTLET COVER MISSING. INSTALLED LEFT NUMBER 4 DOOR UTILITY OUTLET COVER.SDR AALA20100629DFW02Light · inoperativeLEFT NUMBER 2 DOOR MID GALLEY LEFT SIDE MIDDLE ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP LEFT NUMBER 2 DOOR MID GALLEY LEFT SIDE MIDDLE ESCAPE PATH LIGHT. OPS CHECKED NORMAL.SDR AALA20100415DFW02Light · inoperativeLAMP IN EMERGENCY EGRESS LIGHT AT REAR GALLEY RIGHT OF RIGHT FLIGHT ATTENDANT JUMPSEAT OUT. REPLACED LAMP FOR EMERGENCY LIGHT NEXT TO AFT GALLEY RIGHT JUMPSEAT. OPS CHECKED NORMAL.SDR AALA20100227MIA02Connector · looseROW 22 EMERGENCY EXIT LIGHTS INOPERATIVE. SECURED CONNECTOR FOR ROW 22 EMERGENCY EXIT LIGHTS. OPS CHECKED NORMAL.SDR AALA20100227MIA03Light · inoperativeROW 26C EMERGENCY EXIT LIGHT OUT. REPLACED LAMP FOR ROW 26C EMERGENCY EXIT LIGHT. OPS CHECKED NORMAL.SDR AALA20100227MIA04Lens · crackedSEAT 24C EMERGENCY EXIT LIGHT LENS CRACKED. REPLACED LENS FOR EMERGENCY EXIT LIGHT AT SEAT 24C. OPS CHECKED NORMAL.SDR AALA20100216LGW01Unknown · malfunctionedCREW REPORTED COMPLETE BLACKOUT OF THE MAIN FLIGHT DECK INSTRUMENTS TWICE FOR TWO SECONDS DURING AN EIGHT MINUTE PERIOD. AIRCRAFT LANDED LHR WITHOUT INCIDENT. AIRCRAFT WAS TAKEN OUT OF SERVICE AND AN EVALUATION IS IN PROGRESS. (OPEN)SDR AALA20100210GRU01Fan · failedGRU - PILOT REPORTED APPROXIMATELY ONE HOUR INTO FLIGHT RECIRCULATION FAN STATUS MESSAGE ILLUMINATED AND FLIGHT ATTENDANTS REPORTED SMOKE AND FUMES IN CABIN. TURNED OFF RECIRC FANS PER SMOKE AND FUMES PROCEDURE AND SMOKE DISSIPATED. FLIGHT LANDED GRU WITHOUT SDR AALA20091208MIA02Lens · missingEMERGENCY LIGHT AT SEAT 3B MISSING LENS. REPLACED LENS.SDR AALA20091208MIA01Light · inoperativeEMERGENCY LIGHT AT SEAT 24B INOPERATIVE. REPLACED LAMP.SDR AALA20090928DFW01Light · inoperativeROW 26C EMERGENCY PATH LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY PATH LIGHT ASSEMBLY. OPS CHECKED GOOD.
Back to N793AN