N672AA, cancelled Feb 4, 2023
Service difficulty reports · 47
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 = 'N672AA' AND deregistration_id = 'N672AA-2023-02-04' 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 = 'N672AA' AND deregistration_id = 'N672AA-2023-02-04' 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 AALA2011F00175Battery Pack · weakSEAT MOUNTED EMERGENCY EGRESS LIGHTS INOP.SDR AALA20101204AFW02Light · defectiveEMERGENCY LIGHT IN CABIN DIM. REPLACED LAMP FOR EMERGENCY LIGHT IN CABIN. OPS CHECK NORMAL.SDR AALA20101204AFW01Light · defectiveCABIN EMERGENCY LIGHT DIM. REPLACED LAMP FOR EMERGENCY LIGHT IN CABIN. OPS CHECK NORMAL.SDR AALA20100808LGA01Warning System · malfunctionedFLIGHT DECK EMERGENCY EVACUATION AURAL WARNING DEVICE WILL NOT TEST. RESET SYSTEM CIRCUIT BREAKER. OPS CHECKED NORMAL.SDR AALA20100707DFW01Battery Pack · dischargedEMEREGENCY EXIT PATH LIGHT AFT SECTION OF COACH INOPERATIVE. REPLACED FORWARD BATTERY PACK FOR AFT COACH EMERGENCY LIGHTS. OPS CHECKED NORMAL.SDR AALA20101007TUL07Battery Pack · dischargedEMERGENCY EXIT PATH LIGHT AFT SECTION OF COACH INOPERATIVE. REPLACED AFT BATTERY PACK FOR AFT COACH EMERGENCY LIGHTS. OPS CHECKED NORMAL.SDR AALA20100730TUL12Light · inoperativeEMERGENCY LIGHT UNDER OVERHEAD COMPARTMENT AT 23ABC INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT UNDER OVERHEAD COMPARTMENT AT 23ABC. OPS CHECKED NORMAL.SDR AALA20100303SJU01Light · inoperativeEMERGENCY LIGHT UNDER OVERHEAD COMPARTMENT AT 31ABC INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT UNDER OVERHEAD COMPARTMENT AT 31ABC. OPS CHECKED NORMAL.SDR AALA20100214DFW01Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 16 TO 25 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS FROM ROWS 16 TO 25, OPS CHECK NORMAL.SDR AALA20091009SJU01Battery Pack · dischargedEMERGENCY SEAT MOUNTED LIGHTS AT SEAT ROWS 9DEF TO 17DEF INOPERATIVE. REPLACED BATTERY PACK.SDR AALA2009051300003Power Supply · odorCREW REPORTED ELECTRIC ODOR IN MID CABIN. EMERGENCY DECLARED RETURNED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND POWER SUPPLY POSTA AT 17ABC INOPERATIVE. REPLACED POWER SUPPLY AT ROW 17ABC. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA200802597ACharger · failedEMERGENCY LIGHT FROM SEAT ROWS 14 TO 36 INOPERATIVE. REPLACED BATTERY CHARGER FOR SEAT ROWS 14 TO 36. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200820019Beam · corrodedTOP OF LATERAL I BEAM CORRODED. REPAIRED IAW SRM 53-00-51-2R.SDR AALA200820018Floor Support · corrodedFLOOR SUPPORT CORRODED BELOW G1B GALLEY. REPLACED FLOOR SU[PPORT IAW SRM 53-60-51SDR AALA200820017Floor Support · corrodedFLOOR SUPPORT CORRODED FOR G1B GALLEY. REPLACED SUPPORT IAW SRM 51-00-51-0G.SDR AALA200820016Floor Support · corrodedFLOOR SUPPORT CORRODED FOR G1B GALLEY. REPLACED SUPPORT IAW SRM 53-00-00-0G.SDR AALA200820012Floor Panel · corrodedAFT MAIN DECK FLOOR STRUCTURE IS CORRODED. REPAIRED IAW SRM 53-60-51-2R2.SDR AALA200820011Structure · corrodedAFT MAIN DECK FLOOR STRUCTURE IS CORRODED. REPAIRED IAW SRM 53-60-51-2R2.SDR AALA200820010Plate · corrodedAFT MAIN DECK IS CORRODED. DOUBLER INSTALLED IAW SRM 53-60-51-2R2.SDR AALA200820009Plate · corrodedAFT MAIN DECK PLATE IS CORRODED. DOUBLER INSTALLED IAW SRM 53-60-51-2R2.SDR AALA200820008Structure · corrodedMAIN DECK FLOOR STRUCTURE IS CORRODED. REMOVED CORROSION AND INSTALLED DOUBLER IAW SRM 53-60-51-2R2.SDR AALA200801721Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 31D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 31D. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801720Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 18A INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 18A. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AAL200801719Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 4B BULLNOSE INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 4B BULLNOSE. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200800963Lamp · inoperativeDFW - EMERGENCY LIGHT AT AFT OVERWING DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT AFT OVERWING DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061283Battery Pack · inoperativeDFW - SEAT MOUNTED EMERGENCY LIGHTS FROM SEAT ROWS 16 TO 26 INOPERATIVE. REPLACED BATTERY PACK FOR SEAT MOUNTED EMERGENCY LIGHTS FROM SEAT ROWS 16 TO 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061277Bulb · burned outDFW - EMERGENCY LIGHT AT LEFT AISLE BULLNOSE SEAT ROW 1AB INOPERATIVE. RELAMPED EMERGENCY LIGHT AT LEFT HAND AISLE BULLNOSE SEAT ROW 1AB. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061276Bulb · burned outDFW - EMERGENCY LIGHT AT RIGHT AISLE BULLNOSE SEAT 25D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT RIGHT AISLE BULLNOSE SEAT 25D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061281Bulb · burned outDFW - EMERGENCY FLOOD LIGHT AT INTERIOR OVERWING EXIT HATCH FORWARD EMERGENCY HANDLE INOPERATIVE. RELAMPED EMERGENCY FLOOD LIGHT AT INTERIOR OVERWING EXIT HATCH FORWARD EMERGENCY HANDLE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061280Light · brokenDFW - SEAT MOUNTED EMEGENCY LIGHT AT SEAT 35D HAS BROKEN LIGHT ASSEMBLY. REPLACED LIGHT ASSEMBLY FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT 35D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061282Guard · brokenDFW - EMERGENCY LIGHT SWITCH GUARD AT FLIGHT DECK IS BROKEN. REPLACED THE EMERGENCY LIGHT SWITCH GUARD AT FLIGHT DECK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040795Pitot Tube · missingORD - INFLIGHT T725/25 AT INTERMEDIATE LEVEL OFF AT FL280 RIGHT ENGINE BEGAN TO SURGE BETWEEN 1.53 AND 1.66 EPR 91.5 TO 94.0 PERCENT N1 AT 670 TO 700C. EGT AND 87 TO 89 PERCENT SURGING CONTINUED AFTER AUTOTHROTTLE DISCONNECTED. NO THROTTLE MOVEMENT NOTED. RSDR AALA20031336Battery Pack · dischargedSFO AFT RIGHT HAND INBOARD ATTENDANT EMERGENCY FLASHLIGHT LED INOPERATIVE. REPLACED BATTERY PACK FOR AFT RIGHT HAND INBOARD ATTENDANT EMERGENCY FLASHLIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031024Battery Pack · dischargedDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY ESCAPE PATH LIGHTING WAS OBSERVED TO BE INOPERATIVE AT SEAT ROWS 24 THROUGH 34. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20031008Battery Pack · dischargedLAX - DURING OVERNIGHT MAINTENANCE, EMERGENCY ESCAPE PATH LIGHTING WAS OBSERVED TO BE INOPERATIVE AT SEAT ROWS 24 THROUGH 34. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030385Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMREGENCY EXIT SEAT MOUNTED LIGHT AT 11D INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20004090Sill · corrodedAFW - AFT CARGO LOWER SILL OUTBOARD CHORD HAD CORROSION BLENDED ON THE OUTBOARD VERTICAL LEG. BLENDOUT CORROSION AND VERIFY NO CRACKS. ALODINE AND APPLY 2 COATS OF PRIMER AND DYNATROL TO BLENDED AREA. IT IS ACCEPTABLE FOR RETURNED SERVICE WITH NOTED CONDITISDR AALA20004091Sill · corrodedAFW - FOUND AFT CARGO LOWER SILL ''T'' CHORD HAD CORROSION BLENDED TOP OUTBOARD SURFACE BEYOND SRM LIMITS. BLENDOUT CORROSION AND VERIFY NO CRACKS. ALODINE AND APPLY 2 COATS OF PRIMER AND SEAL THE BLENDED AREA WITH BM5-5-95. IT IS ACCEPTABLE FOR RETURNED SESDR AALA20000491Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT ESCAPE PATH LIGHTS AT 9D, 17D, AND 16D INOPERATIVE. REPLACED EMERGENCY EXIT ESCAPE PATH LIGHT STRIP AT 9D, 17D, AND 16D. SYSTEM GROUND CHECK NORMAL OPERATION. (M)SDR AALA991671Light · failedTUL - FLT 1998 - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FLOOR PATH LIGHTING FROM ROW 9 TO ROW 17 INOPERATIVE. REPLACED EMERGENCY EXIT FLOOR PATH LIGHT STRIP. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA970242Floor Beam · corrodedAFW - FLOOR BEAM STA 365, RBL 63 AND RBL 10 HAD CORROSION BLENDED BEYOND SRM LIMITS. E58 NR 1803710 AND 1803708. REPAIRED PER MRB NR 757-1054. TST: 14,920.38 HOURS. CYCLES: 5,447. (X)SDR AALA970239Floor Beam · corrodedAFW - FLOOR BEAM STA 310, RBL 4 AND RBL 41 HAD CORROSION BLENDED BEYOND SRM LIMITS. E58 NR 1803682 AND 1803683. REPAIRED PER MRB NR 757-1055. TST: 14,920.38 HOURS. CYCLES: 5,447. (X)SDR AALA970236Floor Beam · corrodedAFW - FLOOR BEAM STA 324, RBL 60 HAD CORROSION BLENDED BEYOND SRM LIMITS. E58 NR 1803687. REPAIRED PER MRB NR 757-1056. TST: 14,920.38 HOURS. CYCLES: 5,447. (X)SDR AALA970234Structure · corrodedAFW - FLOOR STRUCTURE AT STA 407 TO STA 418, RBL 45 HAD CORROSION BLENDED BEYOND SRM. E58 NR 1803716. REPAIRED PER MRB NR 757-1057. TST: 14,920.38 HOURS. CYCLES: 5,447. (X)SDR AALA970232Floor Beam · corrodedAFW - FLOOR BEAM AT STA 345, RBL 63, HAD CORROSION BLENDED BEYOND SRM LIMITS. E58 NR 1803707. REPAIRED PER MRB NR 757-1058. TST: 14,920.38 HOURS. CYCLES, 5,447. (X)SDR AALA970229Floor Beam · corrodedAFW - FLOOR BEAM AT STA 1640 HAD SEVERAL AREAS OF CORROSION BLENDED BEYOND SRM LIMITS. E58'S NR 1803648, 1803564 (ITEM 2), AND 1803650. REPAIRED PER MRB NR 757-1059. TST: 14,920.38 HOURS. CYCLES, 5,447. (X)SDR AALA970227Sill · corrodedAFW - AFT CARGO DOOR SILL INNER CHORD HAD CORROSION BLENDED BEYOND SRM LIMITS. E58 NR 1813131. REPAIRED PER MRB NR 757-1063. TST: 14,920.38 HOURS. CYCLES, 5,447. (X)
Back to N672AA, cancelled Feb 4, 2023