N781AN
Service difficulty reports · 293
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 = 'N781AN' 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 = 'N781AN' 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 AALA20101201TUL08Light · brokenEMERGENCY LIGHT LAMP AT SEAT 20C BROKEN. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 20C. OPS CHECK NORMAL.SDR AALA20101201TUL07Lens · brokenEMERGENCY LIGHT LENS AT SEAT 20C BROKEN. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 20C. OPS CHECK NORMAL.SDR AALA20101201TUL06Light · brokenEMERGENCY LIGHT LAMP AT SEAT 40G BROKEN. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 40G. OPS CHECK NORMAL.SDR AALA20101201TUL05Lens · brokenEMERGENCY LIGHT LENS AT SEAT 40G BROKEN. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 40G. OPS CHECK NORMAL.SDR AALA20101201TUL04Light · brokenEMERGENCY LIGHT LAMP AT SEAT 36G BROKEN. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 36G. OPS CHECK NORMAL.SDR AALA20101130ORD01Lens · brokenEMERGENCY LIGHT LENS AT SEAT 36G BROKEN. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 36G. OPS CHECK NORMAL.SDR AALA20100916TUL05Lens · missingESCAPE PATH LIGHT LENS MISSING AT SEAT 22C. REPLACED ESCAPE PATH LIGHT LENS AT SEAT 22C.SDR AALA20100916DFW02Battery Pack · dischargedESCAPE PATH LIGHTS AT ROWS 20 TO 26 ON BOTH SIDES INOPERATIVE. REPLACED BATTERY PACK AT RIGHT NUMBER 3 DOOR. OPS CHECKED NORMAL.SDR AALA20100831TUL03Lens · missingSEAT 22C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 22C EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100830DFW03Light · missingSEAT 22C EMERGENCY LIGHT MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 22C. OPS CHECKED NORMAL.SDR AALA20100830TUL06Light · missingSEAT 40G EMERGENCY LIGHT MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 40G. OPS CHECKS OK. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 40G. OPS CHECKED NORMAL.SDR AALA20100830DFW04Lens · missingSEAT 40G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 40G EMERGENCY LIGHT.SDR AALA20100824JFK01Light · damagedEMERGENCY LIGHT AT LEFT NUMBER 1 CLOSET DAMAGED. REPLACED LIGHT CAPSULE.SDR AALA20100508MIA01Lens · missingAFT GALLEY LEFT SIDE EMERGENCY LIGHT LENS CAP MISSING LAST PORTION. REPLACED LENS CAP. OPS CHECK NORMAL.SDR AALA20100803TUL18Light · missingROW 26G ESCAPE PATH LIGHT IS MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT ROW 26G. OPS CHECKED NORMAL.SDR AALA20100421DFW03Lens · missingROW 26G ESCAPE PATH LIGHT IS MISSING LENS. REPLACED LENS FOR ROW 26G ESCAPE PATH LIGHT. OPS CHECKED NORMAL.SDR AALA20100727TUL29Light · inoperativeESCAPE PATH LIGHT AT ROW 26G HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT ROW 26G. OPS CHECKED NORMAL.SDR AALA20100209DFW05Light · inoperativeESCAPE PATH LIGHT AT ROW 44G HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT ROW 44G. OPS CHECK NORMAL.SDR AALA20100209DFW04Light · inoperativeROW 3D FORWARD ESCAPE PATH LIGHT HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT ROW 3D FORWARD. OPS CHECKED NORMAL.SDR AALA20100210TUL07Light · missingEMERGENCY LIGHT AT SEAT 40C MISSING LAMP. REPLACED LAMP AT SEAT 40C.SDR AALA20091225DFW01Lens · missingEMERGENCY LIGHT AT SEAT 40C MISSING LENS. REPLACED LENS AT SEAT 40C.SDR AALA20091113MIA01Shroud · missingEMERGENCY LIGHT AT SEAT 22C HAS SHROUD MISSING. REPLACED SHROUD AT 22C.SDR AALA2009031600601Housing · missingLHR - EMERGENCY FLOOR PROXIMITY LIGHT OUTBOARD OF FIRST CLASS GALLEY MISSING LAMP HOUSING. REPLACED HOUSING.SDR AALA200802543AConnector · looseDFW - EMERGENCY LIGHTS AT SEAT ROWS 41G TO 45G FAILED TEST. SECECURED CONNECTOR AT SEAT ROW 40G FOR EMERGENCY LIGHTS AT SEAT ROWS 41G TO 45G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802542AConnector · looseDFW - EMERGENCY LIGHTS AT SEAT ROWS 41C TO 45C FAILED TEST. SECURED CONNECTION AT SEAT ROW 40 FOR EMERGENCY LIGHTS AT SEAT ROWS 41C TO 45C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802541ALamp · burned outDFW - EMERGENCY LIGHT AT SEAT 26C INOPERATIVE. REPLACED LAMP AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802540ALamp · burned outDFW - EMERGENCY LIGHT AT SEAT 23C INOPERATIVE. REPLACED LAMP AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802539ALamp · burned outDFW - EMERGENCY LIGHT AT OVERHEAD L3 DOOR INOPERATIVE. REPLACED LAMP AT OVERHEAD L3 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802538ALamp · burned outDFW - EMERGENCY LIGHT AT SEAT 23G INOPERATIVE. REPLACED LAMP AT SEAT 23G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802537ALamp · burned outDFW - EMERGENCY LIGHT AT SEAT 26G INOPERATIVE. REPLACED LAMP AT SEAT 26G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802536ALens · missingDFW - EMERGENCY LIGHT AT SEAT 30G MISSING LENS. REPLACED LENS AT SEAT 30G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801779Light · looseDFW - EMERGENCY LIGHT ASSEMBLY AT LT NR ONE CLOSET LOOSE. SECURED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LT NR ONE CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801300Connector · looseMIA - EMERGENCY LIGHT AT SEAT 9D INOPERATIVE. SECURED CONNECTOR FOR EMERGENCY LIGHT AT SEAT 9D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801219Light · brokenMIA - MOUNTED EMERGENCY LIGHT AT FIRST CLASS GALLEY CLOSET BROKEN. REPLACED LIGHT FOR MOUNTED EMERGENCY LIGHT AT FIRST CLASS GALLEY CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800055Lamp · missingDFW - EMERGENCY LIGHT AT SEAT 26C MISSING LAMPS. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800054Lens · missingDFW - EMERGENCY LIGHT AT SEAT 26C HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072513Wire · brokenJFK - EMERGENCY LIGHT AT SEAT 9D INOPERATIVE. REPLACED BROKEN WIRE FOR EMERGENCY LIGHT AT SEAT 9D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070837Light · brokenLHR LGA - EMERGENCY LIGHT AT FIRST CLASS COAT CLOSET BROKEN. SECURED RIGHT LOWER EMERGENCY LIGHT LENS INTO FRAME MOUNT AT FIRST CLASS COAT CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070533Lens · missingDFW - EMERGENCY LIGHT AT SEAT 3D HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 3D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070534Bulb · missingDFW - EMERGENCY LIGHT AT SEAT 3D HAS BULB MISSING. RELAMPED EMERGENCY LIGHT AT SEAT 3D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061147Light · damagedDFW - EMERGENCY EXIT LIGHT AT LEFT FORWARD CORNER OF FORWARD COAT CLOSET DAMAGED. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT LEFT FORWARD CORNER OF FORWARD COAT CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060288Engine · shutdownGRU - AT 8000 FEET LEFT ENGINE HAD AN UNCOMMANDED SHUTDOWN AFTER A STRONG BANG. RETURNED TO GRU AND LANDED WITHOUT INCIDENT. INSPECTED LEFT ENGINE INLET AND EXHAUST AND NO DAMAGE FOUND. DURING INSPECITONS FOUND SEVERAL METALIC DEBRIS ON EXHAUST. REPLACED NSDR AALA20000595Compressor · stalledSFO - FLT 0129 - DURING INITIAL CLIMB, COMPRESSOR STALLED. CREW REPORTED THROTTLE BACK, THEN PUSH POWER UP. SHUT DOWN ENGINE, DIVERTED TO SFO AND LANDED WITHOUT INCIDENT. CURENTLY UNDER INVESTIGATION. (X)
Back to N781AN