Boeing 767-223
Service difficulty reports · 2,039
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '767223' 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 aircraft_model_key = '767223' 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 AALA200800109Light · brokenJFK - EMERGENCY LIGHT AT MID GALLEY BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT MID GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072476Wire · looseJFK - EMERGENCY LIGHT AT FIRST CLASS CLOSET HAS LOOSE WIRING. REPOSITIONED WIRING FOR EMERGENCY LIGHT AT FIRST CLASS CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072286Lamp · inoperativeLAX - EXTERNAL EMERGENCY LIGHT AT LEFT AFT WING INOPERATIVE. REPLACED LAMP FOR EXTERNAL EMERGENCY LIGHT AT LEFT AFT WING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072170Capacitor · missingJFK - EMERGENCY LIGHT AT MID GALLEY MISSING CAPACITOR. REPLACED CAPACITOR FOR EMERGENCY LIGHT AT MID GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072172Light · inoperativeJFK - EMERGENCY LIGHT AT OVERWING ON LEFT SIDE FORWARD BULB INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERWING ON LEFT SIDE FORWARD POSITION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072171Light · inoperativeJFK - EMERGENCY LIGHT AT OVERWING ON RIGHT SIDE AFT BULB INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERWING ON RIGHT SIDE AFT POSITION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072160Battery Pack · inoperativeLAX - EMERGENCY LIGHT AT OVERHEAD SEAT 36B INOPERATIVE. REPLACED BATTERY PACK M379 FOR EMERGENCY LIGHT AT OVERHEAD SEAT 36B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072159Pseu · inoperativeJFK INFLIGHT T2/05NOV - DURING INITIAL APPROACH CREW RECEIVED LEADING EDGE SLAT ASYMMETRY. CAPTAIN EXECUTED A MISSED APPROACH AND LANDED ON SECOND APPROACH WITHOUT INCIDENT. AIRCRAFT TAXIED TO GATE. FOUND PROXIMITY SENSOR ELECTRONICS UNIT CARD FAULTED. REPSDR AALA20072166Relay · inoperativeJFK - LEFT OVERWING SLIDE GREEN SQUIB INOPERATIVE. REPLACED RELAY FOR LEFT OVERWING SLIDE GREEN SQUIB. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072075Control Module · inoperativeSFO - EMERGENCY LIGHTS AT LEFT SEAT ROWS 9 TO 19 INOPERATIVE. REPLACED MODULE FOR EMERGENCY LIGHTS AT LEFT SEAT ROWS 9 TO 19. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072076Connector · looseORD - SEAT MOUNTED EMERGENCY LIGHT AT SEAT 38H INOPERATIVE. RECONNECTED CONNECTOR FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT 38H. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072056Battery Pack · inoperativeJFK - EMERGENCY LIGHTS AT LEFT NUMBER THREE AND LEFT NUMBER FOUR DOOR EXIT SIGNS INOPERATIVE. REPLACED BATTERY PACK AND CHARGER M1210 FOR EMERGENCY LIGHTS AT LEFT NUMBER THREE AND LEFT NUMBER FOUR DOOR EXIT SIGNS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072018Battery Pack · inoperativeJFK - EMERGENCY LIGHTS AT LEFT AND RIGHT NUMBER ONE DOORS INOPERATIVE. REPLACED BATTERY PACK AT LEFT NUMBER ONE DOOR FOR EMERGENCY LIGHTS AT LEFT AND RIGHT NUMBER ONE DOORS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072010Lamp · inoperativeJFK - FORWARD EXTERIOR EMERGENCY LIGHT AT AFT CARGO DOOR INOPERATIVE. REPLACED LAMP FOR FORWARD EXTERIOR EMERGENCY LIGHT AT AFT CARGO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072009Battery Pack · inoperativeJFK - EMERGENCY LIGHTS AT LEFT AND RIGHT OVERWING EXIT SIGNS INOPERATIVE. REPLACED BATTERY PACK M01209 FOR EMERGENCY LIGHTS AT LEFT AND RIGHT OVERWING EXIT SIGNS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071996Lens · missingJFK - EMERGENCY LIGHT AT SEAT 30H MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 30H. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071997Lamp · inoperativeJFK - EMERGENCY LIGHT AT SEAT 30H MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 30H. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071992Battery Pack · inoperativeJFK - EMERGENCY LIGHTS AT SEAT ROWS 9B TO 11B, 17B AND 19B INOPERATIVE. REPLACED BATTERY PACK M9030 AISLE FOR EMERGENCY LIGHTS AT SEAT ROWS 9B TO 11B, 17B AND 19B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071939Battery Pack · inoperativeJFK - EMERGENCY LIGHT AT RIGHT AFT SECTION OF BUSINESS CLASS AND FORWARD SECTION OF COACH INOPERATIVE. REPLACED BATTERY PACK AT M9029 FOR EMERGENCY LIGHT AT RIGHT AFT SECTION OF BUSINESS CLASS AND FORWARD SECTION OF COACH. SYSTEM GROUND CHECKED NORMAL OPERATSDR AALA20071938Battery Pack · inoperativeJFK - EMERGENCY LIGHTS AT RIGHT AFT SECTION OF COACH INOPERATIVE. REPLACED BATTERY PACK AT FOR EMERGENCY LIGHTS AT RIGHT AFT SECTION OF COACH. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071920Wire · inoperativeJFK - EMERGENCY LIGHT AT MID GALLEY LEFT INOPERATIVE. REPAIRED WIRING FOR EMERGENCY LIGHT AT MID GALLEY LEFT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071834Light · inoperativeJFK - EMERGENCY LIGHT AT SEAT ROW 3HJ INOPERATIVE. REPAIRED EMERGENCY LIGHT AT SEAT ROW 3HJ. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071761Battery Pack · inoperativeLAX - EMERGENCY LIGHTS AT SEAT 17AB AND LEFT FORWARD OVERWING INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT 17AB AND LEFT FORWARD OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071714Connector · looseLAX - EMERGENCY LIGHT AT SEAT 30B INOPERATIVE. SECURED LOOSE CONNECTOR FOR EMERGENCY LIGHT AT SEAT 30B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071713Connector · looseLAX - EMERGENCY LIGHT AT SEAT 28H INOPERATIVE. SECURED LOOSE CONNECTOR FOR EMERGENCY LIGHT AT SEAT 28H. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071550Circuit Card · inoperativeLAX INFLIGHT T003/15AUG - ON APPROACH WHEN SELECTING FLAPS 20 DEGREES THE MASTER CAUTION LIGHT AND LEADING EDGE SLAT ASYMMETRY EICAS MESSAGE ILLUMINATED. LANDED LAX WITHOUT INCIDENT. BITE CHECK OF PROXIMITY SENSOR ELECTRONIC UNIT FOUND FAULT OF CARDS 001 ANDSDR AALA20071476Module · inoperativeJFK - EMERGENCY LIGHTS AT LEFT AND RIGHT NUMBER ONE DOORS INOPERATIVE. REPLACED CONTROL MODULE FOR EMERGENCY LIGHTS AT LEFT AND RIGHT NUMBER ONE DOORS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071425Battery Pack · inoperativeJFK - EMERGENCY LIGHTS AT SEAT ROWS 10 AND 11 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 10 AND 11. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071426Light · inoperativeJFK - EMERGENCY LIGHT AT SEAT ROW 19B INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 22D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071408Light · inoperativeJFK - EMERGENCY LIGHT AT SEAT 19B INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 19B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071407Battery Pack · inoperativeJFK - EMERGENCY LIGHTS FROM SEATS ROWS 10AB TO 11AB INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS FROM SEAT ROWS 10AB TO 11AB. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071311Connector · looseLAX - EMERGENCY FLOOR LIGHT AT MID GALLEY INOPERATIVE. SECURED LOOSE CONNECTOR FOR EMERGENCY FLOOR LIGHT AT MID GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071306Lens · looseJFK - EMERGENCY LIGHT AT RIGHT FIRST CLASS GALLEY FLOOR HAS BROKEN LENS. LENS NOT BROKEN. SECURED LENS FOR EMERGENCY LIGHT AT RIGHT FIRST CLASS GALLEY FLOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070711Acm · seizedJFK INFLIGHT T40/12APR FLIGHT ATTENDANT REPORTED LOUD NOISE UNDER BUSINESS CLASS GALLEY FOLLOWED BY VIBRATION AND SMOKE IN CABIN. LANDED JFK WITHOUT INCIDENT. FOUND LEFT HAND AIR CYCLE MACHINE SEIZED. REPLACED LEFT HAND AIR CYCLE MACHINE. ALSO REPLACED ASDR AALA20070616Battery Pack · dischargedLAX - EMERGENCY LIGHT AT SEAT 31AB INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT 31AB. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070549Unknown · unknownWHEN SELECTING LANDING FLAPS EICAS TRAILING EDGE FLAP ASYMMETRY MESSAGE ILLUMINATED. PERFORMED CHECKLIST AND EICAS MESSAGE WENT AWAY. STATUS MESSAGE FOR TRAILING EDGE FLAP SHUTDOWN STAYED ILLUMINATED. LANDED BDA WITHOUT INCIDENT. PERFORMED BITE TEST ON FLASDR AALA20070496Battery Pack · inoperativeJFK - SEAT MOUNTED EMERGENCY LIGHTS ON RIGHT SIDE OF FIRST CLASS AND BACK TO HALF OF BUSINESS CLASS INOPERATIVE. REPLACED BATTERY PACK FOR SEAT MOUNTED EMERGENCY LIGHTS ON RIGHT SIDE OF FIRST CLASS AND BACK TO HALF OF BUSINESS CLASS. SYSTEM GROUND CHECKED NOSDR AALA20070363Battery Pack · inoperativeLAX - SEAT MOUNTED EMERGENCY LIGHTS AT LEFT CABIN INOPERATIVE. REPLACED BATTERY PACK FOR SEAT MOUNTED EMERGENCY LIGHTS AT LEFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070351Light · inoperativeJFK - EMERGENCY LIGHT AT SEAT 2B INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 2B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070137Bulb · shortedJFK - SEAT MOUNTED EMERGENCY LIGHTS AT SEATS 9AB TO 19AB INOPERATIVE. FOUND SEAT 19AB LIGHT BULBS SHORTED OUT CAUSING POWER SUPPLY TO SHORT TO GROUND. RELAMPED EMERGENCY LIGHTS AT SEAT 19AB. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070096Battery Pack · inoperativeLAX - EMERGENCY LIGHTS AT RIGHT FORWARD DOOR AND OVERWING EXIT INOPERATIVE. REPLACED BATTERY PACK M731 FOR EMERGENCY LIGHTS AT RIGHT FORWARD DOOR AND OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070050Battery Pack · inoperativeLAX - EMERGENCY LIGHTS AT SEAT ROWS 10AB, 11AB, 17AB AND 19AB COME ON WHEN POWER AND BATTERY ARE TURNED OFF. REPLACED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS AT SEAT ROWS 10AB, 11AB AND 19AB. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070173Skin · corrodedAFW - FUSELAGE SKIN AT STATION 1582 AT BUTT SPLICE BETWEEN SECTION 46 AND 48 HAD CORROSION. CUT OUT CORROSION AT STATION 1582 AT BUTT SPLICE BETWEEN SECTION 46 AND 48 AND INSTALLED REPAIR DOUBLER PER DRAWING 146T3340.SDR AALA20061328Skin · corrodedMCI - LEFT SKIN PANEL HAS CORROSION ON SURFACE OF PANEL AT LOWER AFT CORNER UNDER LAP SEAM AT STATION 434 LEFT STRINGER 37. AREA OF DISCREPANCY IS 1.75 INCHES BY 3.75 INCHES WITH A DEPTH OF APPROXIMATELY 50 PERCENT OF PANEL THICKNESS. TRIMMED DISCREPANT ARESDR AALA20061260Battery Pack · inoperativeLAX - EMERGENCY LIGHTS AT RIGHT NUMBER ONE DOOR AND OVERWING INOPERATIVE. REPLACED BATTERY PACK AT M731 FOR EMERGENCY LIGHTS AT RIGHT NUMBER ONE DOOR AND OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061122Battery Pack · inoperativeSFO - EMERGENCY EXIT LIGHTS AT LEFT AND RIGHT OVERWING INOPERATIVE. REPLACED BATTERY PACK AT M1209 FOR INOPERATIVE EMERGENCY EXIT LIGHTS AT LEFT AND RIGHT OVERWING. SYSTEM GROUND CHEKCED NORMAL OPERATION.SDR AALA20061048Lens · missingJFK - EMERGENCY LIGHT AT SEAT 27B MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 27B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060957Light · brokenLAX - EMERGENCY LIGHT AT FORWARD GALLEY RIGHT SIDEWALL BROKEN. REPLACED EMERGENCY LIGHT ASSEMBLY AT FORWARD GALLEY RIGHT SIDEWALL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060719Connector · inoperativeLAX - EMERGENCY LIGHTS IN FORWARD RIGHT AISLE INOPERATIVE. REPLACED BATTERY PACK CONNECTOR D2746 FOR EMERGENCY LIGHTS IN FORWARD RIGHT AISLE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060707Module · inoperativeLAX - SEAT MOUNTED AND AFT LEFT LAVATORY BULKHEAD MOUNTED EMERGENCY LIGHTS FROM 31AB THROUGH 38AB INOPERATIVE. REPLACED MODULE M9034 AND BATTERY PACK FOR INOPERATIVE SEAT MOUNTED AND AFT LEFT LAVATORY BULKHEAD MOUNTED EMERGENCY LIGHTS. SYSTEM GROUND CHECKED
Back to Boeing 767-223