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 AALA200802154Frame · damagedAFW RT OUTER CHORD AT STATION 1809 HAD HOLES REAMED TO 0.285 INCH AND 0.280 INCH. REPAIRED PER MRB 767 3264.SDR ABXR080225Skin · damagedSCREW AND COUNTERSINK WASHER INSTALLED IN FUSELAGE SKIN OVER PREVIOUSLY BLENDED AREA AT APPROX STA 615 LONGERON STRINGER 34 RT. DAMAGED AREA COMPLIED WITH ON PREVIOUS REPAIR. (S)SDR AALA200802328Stringer · corrodedAFW FORWARD CARGO STRINGER WAS CORRODED. AREA OF DISCREPANCY WAS 21 INCHES IN LENGTH. REPAIRED PER SRM 53-00-03 2R2 WITH EXCEPTIONS PER MRB 767 3256.SDR AALA200802327Stringer · corrodedAFW FORWARD CARGO STRINGER WAS CORRODED. AREA OF DISCREPANCY WAS 22 INCHES IN LENGTH. REPAIRED PER SRM 53-00-03 2R2 WITH EXCEPTIONS PER MRB 767 3260.SDR AALA200802326Stringer · corrodedAFW FORWARD CARGO STRINGER WAS CORRODED. AREA OF DISCREPANCY WAS 22 INCHES IN LENGTH. REPAIRED PER SRM 53-00-03 2R2 WITH EXCEPTIONS PER MRB 767 3258.SDR AALA200802153Floorbeam · corrodedAFW FLOOR BEAM AT STATION 325 HAD CORROSION REMOVAL ON UPPER SURFACE OF HORIZONTAL FLANGES. AREA OF DISCREPANCY IS 2.0 INCH BY 1.5 INCH WITH A DEPTH OF 0.027 INCH AND 0.028 INCH. REPAIRED PER MRB 767 3254.SDR AALA200802152Stringer · corrodedAFW STRINGER 37 RT WAS CORRODED FROM STATION 424 TO STATION 445. REPAIRED IN ACCORDANCE WITH SRM 53-00-03-1R2 AND MRB 757 3259.SDR AALA200801896Battery Pack · inoperativeJFK - EMERGENCY LIGHT SIGN AT FIRST CLASS RT AISLE INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT SIGN AT FIRST CLASS RT AISLE. SYSTEM GROUND CHECKED NORMAL OPERATION. (S)SDR AALA200801880Light · inoperativeJFK - EMERGENCY LIGHT AT RT SIDE BUSINESS CLASS INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT RT SIDE BUSINESS CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION. (S)SDR AALA200801771Lens · missingJFK - EMERGENCY LIGHT AT AFT LAVATORY MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT AFT LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801736Battery Pack · inoperativeJFK - EMERGENCY EXIT SIGN LIGHTS AT LT AND RT OVERWING EXITS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT SIGN LIGHTS AT LT AND RT OVERWING EXITS. SYSTEM GROUND CHECKED NORMAL OPERATION. (S)SDR AALA200801735Battery Pack · inoperativeJFK - EMERGENCY LIGHTS AT OVERHEAD MID COACH CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT MID COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION. (S)SDR AALA200801725Control Unit · inoperativeAFW INFLIGHT T9660/28JUN. LT NR 1 OUTER WINDSHIELED CRACKED DURING FLIGHT. RETURNED TO AFW AND LANDED WITHOUT INCIDENT. REPLACED LT FORWARD WINDOW HEAT CONTROL UNIT. REPLACED LT FORWARD WINDSHIELD AND WIPER. SYSTEM GROUND CHECKED NORMAL OPERATION. (S)SDR AALA200801833Keelbeam · corrodedAFW - KEEL BEAM AT STATION 1219 HAD CORROSION REMOVED FROM THE VERTICAL AND HORIZONTAL FLANGES. REPAIRED PER MRB 767-3237. VERTICAL FLANGE: 0.4 INCH BY 0.9 INCH WITH A DEPTH OF 0.050 INCH. HORIZONTAL FLANGE: 0.8 INCH BY 2.4 INCH WITH A DEPTH OF 0.160 INCH. SDR AALA200801834Sill · corrodedAFW FORWARD CARGO DOOR CUT OUT, LOWER MAIN SILL, OUTER CHORD HAS CORROSION REMOVAL BETWEEN STA 615 AND 610. MATERIAL REMAINING IS BEYOND SRM LIMITS. REPAIRED PER MRB 767 3213. AREA OF DISCREPANCY IS 2.7 INCHES LONG AND IS THE WIDTH OF THE FLANGE WITH A DEPTSDR AALA200801626Light · brokenLAX - EMERGENCY LIGHT AT AFT CENTER FLIGHT ATTENDANT SEAT BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT AFT CENTER FLIGHT ATTENDANT SEAT. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801585Engine · shutdownJFK INFLIGHT T20/11JUN. AT FLIGHT LEVEL 230 NR ONE ENGINE UNCOMMANDED SHUT DOWN. LANDED JFK WITHOUT INCIDENT. SINGLE ENGINE TIME 20 MINUTES. REPLACED NR ONE ENGINE ON 11JUN AT JFK. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801545Battery Pack · dischargedJFK - EMERGENCY EXIT SIGN LIGHT AT OVERHEAD RT BY MID LAVATORY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT SIGN LIGHT AT OVERHEAD RT ON BY MID LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801835Web · corrodedAFW - CLOSURE PANEL WEB, PRESSURE DECK HAS CORROSION REMOVAL. MATERIAL REMAINING IS BEYOND SRM LIMITS. REPAIRED PER MRB 767 3214. AREA OF DISCREPANCY IS A DEPTH OF 0.082 INCHES. (S)SDR AALA200801832Floorbeam · corrodedAFW - FLOORBEAM UPPER CAP AT STATION 325 HAD CORROSION. REMOVED FROM THE HORIZONTAL FLANGES FROM RT BUTTLINE 11 TO RT BUTTLINE 50. REPAIRED PER MRB 767-3220. (S)SDR AALA200801467Lamp · inoperativeLAX - EXTERIOR EMERGENCY LIGHT AT LEFT NR ONE DOOR INOPERATIVE. REPLACED LAMP FOR EXTERIOR EMERGENCY LIGHT AT LT NR ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801466Shroud · damagedLAX - EMERGENCY LIGHT AT SEAT 20B SHROUD DAMAGED. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 20B. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801465Lens · missingLAX - EMERGENCY LIGHT AT SEAT 20B MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 20B. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801464Lamp · missingLAX - EMERGENCY LIGHT AT SEAT 20B MISSING LAMPS. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 20B. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801836Seat Track · corrodedAFW - SEAT TRACK HAS CORROSION REMOVAL. REPAIRED PER MRB 767 3216. (S)SDR AALA200801837Seat Track · corrodedAFW - SEAT TRACK HAS CORROSION REMOVAL. REPAIRED PER MRB 767 3216. (S)SDR AALA200801838Seat Track · corrodedAFW - SEAT TRACK HAS CORROSION REMOVAL. REPAIRED PER MRB 767 3216. (S)SDR AALA2008017373Switch · inoperativeJFK INFLIGHT T117/23MAY. CREW REPORTED BOTH ENGINE FUEL FILTER CLOG INDICATIONS. RETURNED TO JFK AND LANDED WITHOUT INCIDENT. REPLACED LT AND RT ENGINE FUEL FILTERS. REPLACED LT AND RT ENGINE FUEL FILTER DIFFERENTIAL PRESSURE SWITCHES. SYSTEM GROUND CHECKSDR AALA200801282Light · inoperativeLAX - EMERGENCY LIGHT IN COCKPIT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT IN COCKPIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801284Lens · missingJFK - EMERGENCY LIGHT AT LEFT SIDE MID GALLEY MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT RIGHT SIDE MID GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801310Floorbeam · corrodedAFT CARGO FLOOR BEAM J CHANNEL INNER CHORD AT STATION 1285 HAS CORROSION REMOVAL ON UPPER HORIZONTAL FLANGE. MATERIAL REMAINING IS BEYOND SRM LIMITS. REPAIRED IN ACCORDANCE WITH MRD 767 3196. CHORD SHOULD BE REPLACED BY THE NEXT C CHECK FOLLOWING 05 09 2008SDR AALA200801255Light · inoperativeJFK - EMERGENCY LIGHT AT SEAT 30H INOPERATIVE. REPLACED EMERGENCY LIGHT AT SEAT 30H. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801087Metering Valve · defectiveJFK INFLIGHT T686/25APR - DURING TAKEOFF AIRCRAFT PULLED TO LEFT. REQUIRED .75 RUDDER PEDAL TO KEEP AIRCRAFT ON CENTERLINE. AFTER TAKEOFF ANOTHER AIRCRAFT REPORTED SMOKE FROM NOSE TIRES AND OBSERVED NOSE WHEEL TURNED LEFT OF CENTER. RETURNED TO JFK AND LANDSDR AALA200801030Lens · missingJFK - EMERGENCY FLOOD LIGHT AT FORWARD GALLEY NEAR RIGHT NUMBER ONE DOOR MISSING LENS. REPLACED LENS FOR EMERGENCY FLOOD LIGHT AT FORWARD GALLEY NEAR RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800931Web · damagedAFW - NOSE WHEEL WELL AFT WEB AT STATION 287 RBL 25 DAMAGED. AREA OF DISCREPANCY IS 1 INCH BY 1 INCH. REPAIRED NOSE WHEEL WELL AFT WEB PER MRB 767 3178.SDR AALA200800932Web · damagedAFW - NOSE WHEEL WELL RIGHT WEB AT STATION 287 RBL 25 BETWEEN WATER LINE 170 TO 180 DAMAGED. AREA OF DISCREPANCY IS 1.8 INCH BY 1.2 INCH. REPAIRED NOSE WHEEL WELL RIGHT WEB IN ACCORDANCE WITH MRB 767 3178.SDR AALA200800920Skin · corrodedAFW - FUSELAGE SKIN AT STATION 1084 TO 1093 BETWEEN STRINGER 37 LEFT AND 38 LEFT HAD CORROSION ON THE OUTER AND INNER SURFACE OF SKIN. AREA OF DISCREPANCY IS 11.8 INCH BY 2 INCH. REPAIRED PER MRB 767 3179 DATED 3 APR 2008.SDR AALA200800895Fitting · damagedAFW - LEFT PYLON INBOARD SIDE CORE COWL HINGE FITTING AT STATION 305 FORWARD LUG HAS ELONGATED HOLE, SIZE OF DISCREPANCY IS .6932 INCH BY .6932 INCH. REPAIRED PER MRB 767 3176.SDR AALA200800779Skin · damagedAFW - FUSELAGE SKIN AT STATION 437 STRINGER 32 RIGHT HAD DAMAGE. AREA OF DISCREPANCY WAS 13.2 INCHES BY 2.2 INCHES. REPAIRED PER SRM 53 00 01 2R AND MRB 767 3160.SDR AALA200800498Battery Pack · inoperativeLAX - EMERGENCY EXIT SIGN LIGHTS AT LEFT AND RIGHT OVERWING INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT SIGN LIGHTS AT LEFT AND RIGHT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800454Lens · missingLAX - EMERGENCY LIGHT AT SEAT 27B HAS LENS MISSING. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 27B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800453Lamp · missingLAX - EMERGENCY LIGHT AT SEAT 27B HAS LAMP MISSING. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 27B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800452Shroud · brokenLAX - EMERGENCY LIGHT AT SEAT 27B HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 27B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800359Battery Pack · inoperativeJFK - EMERGENCY LIGHT AT OVERHEAD FIRST CLASS GALLEY INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 2HJ FOR EMERGENCY LIGHT AT OVERHEAD FIRST CLASS GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800263Light · inoperativeLAX - EMERGENCY EXIT LIGHT IN COCPIT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY EXIT LIGHT IN COCKPIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800331Skin · corrodedAFW - FUSELAGE SKIN HAS CORROSION ON INNER SURFACE AT STATION 412 TO 434 UNDER S37L. BLENDED OUT CORROSION USING A MINIMUM TAPER RATIO OF 20 TO 1. VISUALLY CONFIRMED NO FURTHER CORROSION. PERFORMED HIGH FREQUENCY EDDY CURRENT ON BLENDED AREAS AND HOLES SURRSDR AALA200800330Skin · corrodedAFW - FUSELAGE SKIN AT STATION 1081 TO 1087 BETWEEN S39R AND S39L HAD CORROSION BLENDED ON INNER SURFACE BEYOND SRM LIMITS. BLENDED CORROSION FROM PARENT THICKNESS OF 0.316 INCH WITH REMAINING THICKNESS NO LESS THAN 0.252 INCH AND 0.233 INCH. INSPECTED BLENDSDR AALA200800198Skin · noneAFW - FUSELAGE SKIN AT STATION 1582 HAD A TEMPORARY REPAIR. AREA OF DISCREPANCY IS 3.8 INCH BY 2.7 INCH. ACCOMPLISHED PERMANENT REPAIR FOR FUSELAGE SKIN AT STATION 1582 STRINGER 25L.SDR AALA200800329Stringer · corrodedAFW - STRINGER 37L AT STATION NUMBER 1300 WAS CORRODED JUST FORWARD OF A PRODUCTION SPLICE. FABRICATED AND INSTALLED EXTENDED SPLICE.SDR AALA200800112Lens · missingJFK - EMERGENCY LIGHT AT SEAT 31B MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 31B. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Boeing 767-223