N766AN
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 = 'N766AN' 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 = 'N766AN' 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 AALA20100703MIA01Lamp · burned outCEILING EMERGENCY LIGHT BULB OUT AT ROW 23 RIGHT. REPLACED LAMP FOR CEILING EMERGENCY LIGHT AT ROW 23 RIGHT. OPS CHECKED NORMAL.SDR AALA20100727TUL21Light · inoperativeESCAPE PATH LIGHT AT SEAT 41G HAS ONE LAMP OUT. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 41G. OPS CHECKED NORMAL.SDR AALA20100727TUL20Light · inoperativeESCAPE PATH LIGHT AT SEAT 45G HAS ONE LAMP OUT. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 45G. OPS CHECKED NORMAL.SDR AALA20100727TUL19Light · inoperativeESCAPE PATH LIGHT AT SEAT 31G INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 31G. OPS CHECKED NORMAL.SDR AALA20100727TUL18Lens · missingESCAPE PATH LIGHTING AT SEAT 31G HAS MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHTING AT SEAT 31G. OPS CHECKED NORMAL.SDR AALA20100727TUL16Light · missingESCAPE PATH LIGHTING AT SEAT 32G HAS MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHTING AT SEAT 32G. OPS CHECKED NORMAL.SDR AALA20100305DFW03Lens · missingSEAT 4G AFT ESCAPE PATHWAY LIGHT MISSING LENS. REPLACED LENS FOR AFT ESCAPE PATHWAY LIGHT AT SEAT 4G. OPS CHECKED NORMAL.SDR AALA20100305DFW02Lens · missingESCAPE PATH LIGHTING AT SEAT 32G HAS MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHTING AT SEAT 32G. OPS CHECKED NORMAL.SDR AALA20100305DFW01Housing · damagedLEFT NUMBER ONE DOOR ESCAPE PATH LIGHTING HOUSING IS DAMAGED. REPLACED LIGHT ASSEMBLY FOR ESCAPE PATH LIGHTING AT LEFT NUMBER ONE DOOR. OPS CHECKED NORMAL.SDR AALA2009033100002Cooling Fan · inoperativeNRT OIL FILTER BLOCKED MESSAGE. LEFT HAND ENGINE BUG LEAKING. REPLACED EQUIPMENT COOLING FAN AND LEFT HAND ENGINE BUG. SYSTEM GROUND CHECK NORMAL OPERATION. (CLOSED)SDR AALA200803086Apu · leakingDFW INFLIGHT - CREW REPORTED SMOKE IN CABIN. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. FOUND APU OIL IN PNEUMATICS. REPLACED APU ON 11DEC AT DFW DUE TO OIL LEAK. REPLACED BOTH LEFT AND RIGHT HEAT EXCHANGER AND CONDENSER. REPLACED BOTH LEFT AND RIGHT OZSDR AALA200802247Lens · missingDFW EMERGENCY LIGHT AT SEAT 25C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802249Light · missingDFW EMERGENCY LIGHT AT SEAT 35C MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 35C. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802248Light · missingDFW EMERGENCY LIGHT AT SEAT 25C MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802250Lens · missingDFW EMERGENCY LIGHT AT SEAT 35C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 35C. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200800691Battery Pack · inoperativeJFK - EMERGENCY LIGHT AT FORWARD GALLEY FLOOR INOPERATIVE. REPLACED BATTERY PACK AT LEFT NUMBER ONE DOOR FORWARD GALLEY FOR EMERGENCY LIGHT AT FORWARD GALLEY FLOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800239Lens · missingORD - EMERGENCY LIGHT AT SEAT 23C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800238Lens · missingORD - EMERGENCY LIGHT AT SEAT 19C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 19C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072407Lamp · inoperativeDFW - EXTERNAL EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR INOPERATIVE. REPLACED LAMP FOR EXTERNAL EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072406Lens · missingDFW - EMERGENCY LIGHT AT SEAT 21C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072264Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 30 CDEF INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 30 CDEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072017Lens · missingDFW - EMERGENCY LIGHT AT SEAT ROW 12F MISSING LENS INOPERATIVE. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 12F. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071107Bulb · burned outORD - EMERGENCY EXIT LIGHT AT SEAT ROW 30 CENTER AISLE INOPERATIVE. RELAMPED EMERGENCY EXIT LIGHT AT SEAT ROW 30 CENTER AISLE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071050Battery Pack · inoperativeAFW - EMERGENCY LIGHT BATTERY PACK M33098 FAILED OPERATIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK M33098. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071048Battery Pack · inoperativeAFW - EMERGENCY LIGHT BATTERY PACK M33096 FAILED OPERATIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK M33096. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071049Battery Pack · inoperativeAFW - EMERGENCY LIGHT BATTERY PACK M33401 FAILED OPERATIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK M33401. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071047Battery Pack · inoperativeAFW - EMERGENCY LIGHT BATTERY PACK M33093 FAILED OPERATIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK M33093. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071052Battery Pack · inoperativeAFW - EMERGENCY LIGHT BATTERY PACK M33094 FAILED OPERATIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK M33094. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071051Battery Pack · inoperativeAFW - EMERGENCY LIGHT BATTERY PACK M33400 FAILED OPERATIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK M33400. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070419Light · brokenMIA - EMERGENCY LIGHT AT SEAT 21C BROKEN. REPLACED EMERGENCY LIGHT ASSEMBLY AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070409Lens · missingMIA - FOUND EMERGENCY LIGHT AT SEAT 25C HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070408Bulb · burned outMIA - EMERGENCY LIGHT AT SEAT 25C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061066Bulb · inoperativeEMERGENCY LIGHT IN CEILING NEXT TO RT NR 3 DOOR INOPERATIVE. RELAMPED EMERGENCY LIGHT IN CEILING NEXT TO RT NR 3 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20041094Battery Pack · inoperativeEZE - EMERGENCY LIGHT PATH FROM ROW 20 TO 26 INOPERATIVE. REPLACED BATTERY PACK AT 3R DOOR FOR EMERGENCY LIGHT PATH FROM ROW 20 TO 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040512Socket · shortedDFW AFT CABIN EMERGENCY ESCAPE PATH LIGHTING INOPERATIVE. REPAIRED SHORTED LIGHT SOCKET AT SEAT ROW 4 FOR AFT CABIN EMERGENCY ESCAPE PATH LIGHTING. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20040231Battery Pack · inoperativeMIA - EMERGENCY EGRESS SEAT MOUNTED LIGHTS AT ROWS 20 THROUGH 28 INOPERATIVE. FOUND CONNECTOR OFF UNDER ROW 22 FOR ROWS 20-22. REPLACED BATTERY PACK FOR EGRESS SEAT MOUNTED EMERGENCY LIGHTS FOR ROWS 20 THROUGH 28 AND REPLACED CANNON PLUG AT ROW 22 FOR SEAT MSDR AALA20030978Battery · failedEMERGENCY EXIT LIGHT INOPERATIVE AT SEAT ROWS 20 THROUGH 25. BATTERY PACK FAILED DUAL FEED CHECK. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N766AN