N767AJ
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 = 'N767AJ' 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 = 'N767AJ' 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 AALA200800704Lens · missingJFK EMERGENCY LIGHT AT SEAT 26C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800703Lamp · missingJFK - EMERGENCY LIGHT AT SEAT 26C MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800257Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT FORWARD GALLEY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800158Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT SEAT ROWS 20 TO 26 INOPERATIVE. REPLACED BATTERY PACK AT RIGHT NUMBER THREE DOOR FOR EMERGENCY LIGHTS AT SEAT ROWS 20 TO 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800154Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 38C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 38C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800157Cover · brokenDFW - EMERGENCY LIGHT AT OVERHEAD AISLE LEFT NUMBER THREE DOOR HAS BROKEN COVER. REPLACED COVER FOR EMERGENCY LIGHT AT OVERHEAD AISLE LEFT NUMBER THREE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800156Cover · brokenDFW - EMERGENCY LIGHT AT OVERHEAD AISLE RIGHT NUMBER THREE DOOR HAS BROKEN COVER. REPLACED COVER FOR EMERGENCY LIGHT AT OVERHEAD AISLE RIGHT NUMBER THREE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800155Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 43G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 43G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800148Light · damagedDFW - EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR LOWER CLOSET DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR LOWER CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800147Lamp · inoperativeDFW - EXTERIOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR INOPERATIVE. REPLACED LAMP FOR EXTERIOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800153Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 36C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 36C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800152Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 31C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 31C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800151Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 25C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800150Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 23C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800149Light · damagedDFW - EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR LOWER GALLEY DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR LOWER GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072300Light · inoperativeEMERGENCY LIGHT AT FIRST CLASS LEFT COAT CLOSET INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT FIRST CLASS LEFT COAT CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071758Light · inoperativeNRT - EMERGENCY LIGHT AT GALLEY NUMBER FIVE LEFT AISLE CENTER INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT GALLEY NUMBER 5 LEFT AISLE CENTER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071759Light · missingNRT - EMERGENCY LIGHT AT FIRST CLASS GALLEY WALL MISSING. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT FIRST CLASS GALLEY WALL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071541Connector · looseDFW - EMERGENCY LIGHT AT SEAT ROW 13D INOPERATIVE. SECURED LOOSE CONNECTOR FOR EMERGENCY LIGHT AT SEAT ROW 13D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070620Light · inoperativeMIA - EMERGENCY LIGHT AT FIRST CLASS GALLEY LEFT SIDE INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY AT FIRST CLASS GALLEY LEFT SIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070400Valve · inoperativeDFW INFLIGHT - DURING CLIMB, RECEIVE ENGINE FUEL VALVE RT NR 4 EICAS MESSAGE. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED SPAR RT VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070116Bulb · burned outDFW - EMERGENCY LIGHT AT LEFT NUMBER THREE DOOR ABOVE FLIGHT ATTENDANT SEAT INOPERATIVE. RELAMPED EMERGENCY LIGHT AT LEFT NUMBER THREE DOOR ABOVE FLIGHT ATTENDANT SEAT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061373Battery Pack · dischargedMIA - EMERGENCY LIGHTS AT FIRST CLASS GALLEY AROUND CLOSET AREA INOPERATIVE. REPLACED BATTERY PACK M33093 FOR EMERGENCY LIGHTS AT FIRST CLASS GALLEY AROUND CLOSET AREA. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061372Connector · looseMIA - EMERGENCY LIGHT AT SEAT 2C FORWARD INOPERATIVE. SECURED CONNECTOR FOR EMERGENCY LIGHT AT SEAT 2C FORWARD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061371Lens · missingMIA - EMERGENCY LIGHT AT FORWARD SEAT 26C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT FORWARD SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061370Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT 26C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061369Lens · missingMIA - EMERGENCY LIGHT AT SEAT 24C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 24C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061368Light · inoperativeMIA- EMERGENCY LIGHT AT SEAT 13D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 13D. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N767AJ