N761AJ
Service difficulty reports · 228
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 = 'N761AJ' 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 = 'N761AJ' 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 AALA20072070Lens · missingJFK - EMERGENCY LIGHT AT SEAT 20C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 20C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071746Lens · missingJFK - EMERGENCY LIGHT AT SEAT 4G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 4G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071745Lens · missingJFK - EMERGENCY LIGHT AT SEAT 2D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 2D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071744Bulb · inoperativeJFK - EMERGENCY LIGHT AT SEAT 2D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 2D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070989Battery Pack · inoperativeMIA - EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070988Battery Pack · inoperativeMIA - EMERGENCY LIGHTS AT AFT CABIN CENTER INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT AFT CABIN CENTER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070943Light · inoperativeNRT - EMERGENCY LIGHT AT FIRST CLASS CLOSET LOWER LEFT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT FIRST CLASS CLOSET LOWER LEFT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070941Lens · brokenLHR - EMERGENCY LIGHT AT FIRST CLASS CLOSET FLOOR HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT FIRST CLASS CLOSET FLOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070723Light · inoperativeNRT EMERGENCY LIGHT AT SEAT 3D AFT INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 3D AFT. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20061204Bulb · burned outDFW - EMERGENCY LIGHT AT FORWARD LEFT NUMBER TWO DOOR INOPERATIVE. RELAMPED EMERGENCY LIGHT AT FORWARD LEFT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061203Bulb · burned outDFW - EMERGENCY LIGHT AT RIGHT NUMBER THREE DOOR INOPERATIVE. RELAMPED EMERGENCY LIGHT AT RIGHT NUMBER THREE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061202Bulb · burned outDFW - EMERGENCY LIGHT AT SEAT 43G INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 43G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061201Bulb · burned outDFW - EMERGENCY LIGHT AT SEAT 32G INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 32G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061200Bulb · burned outDFW - EMERGENCY LIGHT AT SEAT 2D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 2D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061199Bulb · burned outDFW - EMERGENCY LIGHTS AT SEAT 3D FORWARD, CENTER, AND AFT INOPERATIVE. RELAMPED EMERGENCY LIGHTS AT SEAT 3D FORWARD, CENTER, AND AFT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061198Bulb · burned outDFW - EMERGENCY LIGHTS FROM SEAT ROWS 21C TO 24C INOPERATIVE. RELAMPED EMERGENCY LIGHTS FROM SEAT ROWS 21C TO 24C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061197Bulb · burned outDFW - EMERGENCY LIGHTS AT SEAT ROWS 21G TO 24G INOPERATIVE. RELAMPED INOPERATIVE EMERGENCY LIGHTS AT SEAT ROWS 21G TO 24G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061209Bulb · burned outDFW - EMERGENCY LIGHT AT SEAT 37C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 37C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061208Bulb · burned outDFW - EMERGENCY LIGHT AT SEAT 34C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 34C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061207Bulb · burned outDFW - EMERGENCY LIGHT AT SEAT 31C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 31C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061206Bulb · burned outDFW - EMERGENCY LIGHT AT SEAT 26C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061205Bulb · burned outDFW - EMERGENCY LIGHTS AT LEFT AISLE ROW 13 INOPERATIVE. RELAMPED EMERGENCY LIGHTS AT LEFT AISLE ROW 13. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060566Bulb · inoperativeMIA - EMERGENCY LIGHT AT SEAT 3D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 3D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060132Connector · inoperativeAFW - LEFT HAND NUMBER THREE DOOR (STATION 1522) EMERGENCY ESCAPE LIGHT INOPERATIVE. REPLACED EMERGENCY ESCAPE LIGHT SQUIBB CONNECTOR AT LEFT NUMBER THREE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA2060133Hinge · inoperativeAFW - PASSENGER SERVICE UNIT OXYGEN BOX AT SEAT ROW 9JH INOPERATIVE. REPLACED OXYGEN DOOR HINGE AT SEAT 9JH. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060064Battery Pack · inoperativeAFW - CABIN EMERGENCY LIGHT BATTERY PACKS AT STATIONS 2042, 1476, 1522, AND 1600 FAILED FUNCTION TEST. REPLACED CABIN EMERGENCY LIGHT BATTERY PACKS AT STATIONS 2041, 1476, 1522, AND 1600. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031044Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY ESCAPE PATH LIGHTING WAS OBSERVED TO BE INOPERATIVE AT CLOSET L1. REPLACED LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20020987Connector · disconnectedDURING OVERNIGHT MAINTENANCE FOUND SEAT 4D EMERGENCY ESCAPE LIGHT INOPERATIVE. CONNECTED CANNON PLUG AT HARNESS. SYSTEM GROUND CHECKED NORMAL OPERATIONS.
Back to N761AJ