N671AA, cancelled Feb 4, 2023
Service difficulty reports · 44
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 = 'N671AA' AND deregistration_id = 'N671AA-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 = 'N671AA' AND deregistration_id = 'N671AA-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 AALA20120625009Light · inoperativeBULLNOSE EMERGENCY LIGHT AT 5EF INOPERATIVE. REPLACED LAMP FOR BULLNOSE EMERGENCY LIGHT AT 5EF. OPS CHECK NORMAL.SDR AALA20120625008Lens · damagedROW 9DEF EMERGENCY LIGHT LENS DAMAGED. REPLACED LENS FOR ROW 9DEF EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120625007Light · inoperativeROW 36DEF EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 36DEF EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120622011Light · inoperativeRIGHT NUMBER 1 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 1 DOOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120427003Light · inoperative21D SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR 21D SEAT MOUNTED EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120111DWH01Bushing · corrodedRIGHT MAIN LANDING GEAR TRUNNION SUPPORT ASSEMBLY CORRODED. REPLACED BUSHING PER EA B757-57-021178.SDR AALA20110825TUL01Plate · corrodedDUE TO MULTIPLE AREAS OF CORROSION AND MULTIPLE REPAIRS, THE AFT DECK PLATE FROM STATIONS 1681 TO 1720 WILL REQUIRE REPLACEMENT. INSTALLED NEW DECK PLATE PER AARD 51-10-05-1.SDR AALA20110130DFW02Lens · missingEMERGENCY LIGHT ON ROW 27 MISSING LENS. INSTALLED LENS ON ROW 27 EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110130DFW01Lens · missingEMERGENCY LIGHT ON ROW 24 MISSING LENS. INSTALLED LENS ON ROW 24 EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110117TUL10Angle · crackedBELOW THE CABIN FLOOR IN THE AFT CARGO STATIONS 1580 TO 1600 AT BUTTLINE 0 THE INTERCOSTALS TOP L-ANGLE IS CRACKED BY THE FORWARD NUT PLATE. REMOVED AND INSTALLED NEW UPPER "L" ANGLE ON WEB STATIONS 1580 TO 1600 BUTTLINE 0 IAW SRM 52-10-02-0G.SDR AALA20101029TUL05Floor Support · damagedCABIN, STATIONS 324 TO 345, LEFT BUTTLINE 40, FLOORBOARD SUPPORT HAS HOLE IN IT. REMOVED AND REPLACED FLOORBOARD SUPPORT PER AARD 51-10-05-1 REPAIR 1.SDR AALA20100813SJU01Governor · leakingSJU - DURING CLIMBOUT LEFT ENGINE OIL PRESSURE LIGHT ILLUMINATED. CAPTAIN SHUT DOWN LEFT ENGINE. SINGLE ENGINE TIME 10 MINUTES. EMERGENCY DECLARED, RETURNED SJU LANDED WITHOUT INCIDENT. FOUND FUEL GOVERNOR LEAKING. REPLACED FUEL FLOW GOVERNOR. SYSTEM GROSDR AALA20091127JFK02Lens · missingEMERGENCY BULL NOSE LENS COVER AT SEAT ROW 21 RIGHT SIDE MISSING. REPLACED MISSING BULL NOSE LIGHT COVER.SDR AALA20091013DFW11Battery Pack · dischargedFOUND CONNECTOR DISCONNECTED AT BATTERY PACK STATION 1678 RIGHT. EMERGENCY LIGHTS INOPERATIVE. INSTALLED NEW BATTERY PACK AT STATION 1678 RIGHT AND OPS CHECKED GOOD.SDR AALA20091013DFW10Connector · disconnectedFOUND CONNECTOR DISCONNECTED AT BATTERY PACK STATION 1678. EMERGENCY LIGHTS INOPERATIVE. INSTALLED NEW BATTERY PACK AT STATION 1678 LEFT. RECONNECTED CONNECTOR AND OPS CHECKED GOOD.SDR AALA20091013DFW09Connector · disconnectedFOUND CONNECTOR FOR BATTERY PACK AT STATION 1243 (M735) DISCONNECTED, EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AND RECONNECTED CONNECTOR. OPS CHECKS GOOD.SDR AALA20091013DFW08Light · inoperativeEMERGENCY LIGHT AT SET 36D INOPERATIVE. REPLACED LAMP, OPS CHECKS GOOD.SDR AALA20091013DFW07Light · inoperativeLEFT DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP.SDR AALA200802498AConnector · looseDFW - EMERGENCY LIGHT AT SEAT 25D INOPERATIVE. SECURED LOOSE CONNECTOR AS SIDEWALL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800684Relief Valve · poppedJFK INFLIGHT T1375/21MAR BDL TO SJU - TOWER REPORTED FUEL LEAKING FROM RIGHT WING. LANDED JFK WITHOUT INCIDENT. FOUND PRESSURE RELIEF VALVE POPPED IN PANEL NUMBER SIX POSITION FROM OUTBOARD. RELOCATED PRESSURE RELIEF VALVE TO NUMBER FIVE POSITION. SYSTEM SDR AALA200800066Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT SEAT ROWS 16 TO 26 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 16 TO 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072126Transmission · trippedAUA INFLIGHT T1013/02NOV - TRAILING EDGE FLAP DISAGREE LIGHT ILLUMINATED ON APPROACH. LANDED AUA WITHOUT INCIDENT. FOUND LEFT INBOARD TRAILING EDGE FLAP TRANSMISSION TRIPPED. RESET AND LUBED FLAP ROLLERS AND JACK SCREW. SYSTEM CHECKED NORMAL OPERATION.SDR AALA20072046Lamp · missingDFW - SEAT MOUNTED EMERGENCY LIGHT AT SEAT ROW 11D MISSING LAMP. REPLACED LAMP FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT ROW 11D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072045Lens · missingDFW - SEAT MOUNTED EMERGENCY LIGHT AT SEAT ROW 11D MISSING LENS. REPLACED LENS FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT ROW 11D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071926Battery Pack · inoperativeDFW - EMERGENCY LIGHTS IN AFT CABIN INOPERATIVE. REPLACED BATTERY PACK M10801 FOR EMERGENCY LIGHTS AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071376Battery Pack · inoperativeDFW - EMERGENCY AISLE LIGHTS AT AFT CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY AISLE LIGHTS AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060989Connector · disconnectedORD - EMERGENCY PATH LIGHT AT SEAT ROW 34D RIGHT SIDE INOPERATIVE. FOUND PLUG AT WALL DISCONNECTED. CONNECTED EMERGENCY LIGHT PLUG AT ROW 36. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060988Light · inoperativeORD - EMERGENCY LIGHTS ABOVE ROW 34ABC INOPERATIVE. RELAMPED EMERGENCY LIGHTS ABOVE ROW 34ABC. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060819Battery Pack · unsecureTUL - CEILING EMERGENCY LIGHTS IN AFT CABIN INOPERATIVE. SECURED BATTERY PACK AND CHARGER TRAY TO CEILING PANEL FOR CEILING EMERGENCY LIGHTS IN AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040666Controller · arcedLIM - INFLIGHT T0947 RIGHT FORWARD WINDSHIELD ARCHED AND SMALL FIRE OCURRED AT BASE OF WINDSHIELD. TURNED RIGHT WINDOW HEAT SWITCH OFF TO STOP ARCING. REPLACED WINDOW AND WINDOW HEAT CONTROL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040055Line · leakingORD T2095/11 CARGO REPORTED EVIDENCE OF FLUID LEAK FROM THE RIGHT HAND ENGINE UPON ARRIVAL AT GATE. INVESTIGATION REVEALED LP FUEL PUMP LINE HAD CHAFED AGAINST THE HYDRAULIC LINE CAUSING A HOLE IN THE FUEL PUMP LINE. REPLACED FUEL LINE ON NR 2 ENGINE. LEAKSDR 2004F00041Line · chafedENGINE HYDRAULIC LINES WERE RUBBING ON FUEL LINE. HYDRAULIC PRESSURE LINE WORE A HOLE IN THE LOW PRESSURE FUEL LINE. SHOULD HAVE STANDOFF FOR HYDRAULIC LINES AND OR MORE FREQUENT INSPECTION.SDR AALA20031257Transmitter · inoperativeEN ROUTE LT HYD QTY LIGHT ILLUMINATED. LANDED ORD WITHOUT INCIDENT. REPLACED LT HYD QTY TRANSMITTER PER MM 29-33-01-4. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030492Oven · inoperativeFLIGHT ATTENDANTS REPORTED SMOKE AND A BURNING SMELL FROM FORWARD GALLEY OVEN. RETURNED AND LANDED JFK WITHOUT INCIDENT. REMOVED DEBRIS FROM FIRT CLASS OVEN. SYTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA970870Floor Beam · corrodedAFW - FLOOR BEAM AT STA 1640 HAS SEVERAL AREAS OF CORROSION BLENDED BEYOND SRM LIMITS. REF E 58 NR'S 1697035, 1697033, 1697032, 1697036, AND 1697034. TST: 15,561.43 HOURS. CYCLES: 5,712. (X)SDR AALA970878Rib · corrodedAFW - AILERON ATTACH RIB NR 1 HAS CORROSION REMOVAL AROUND GROUNDING ATTACH BOLT HOLE. MATERIAL REMAINING IS BEYOND SRM LIMITS. REF: E 58 NR 1697121. TST: 15,516.36 HOURS. CYCLES: 5,712. (X)SDR AALA970873Seat Track · corrodedAFW - SEAT TRACK AT STA 377, LBL 45, HAS CORROSION REMOVAL MATERIAL REMAINING BEYOND SRMS LIMITS. REF E 58 NR 1697043. TST: 15,516.36 HOURS. CYCLES: 5,712. (X)SDR AALA970872Angle · corrodedAFW - ANGLE BY L-1 DOOR OPENING HAS CORROSION REMOVAL MATERIAL REMAINING AND IS BEYOND SRM LIMITS. REF E 58 NR 1697136. TST: 15,516.36 HOURS. CYCLES: 5,712. (X)SDR AALA970869Deck Plate · corrodedAFW - DECK PLATE HAD CORROSION BLENDED BEYOND SRM LIMITS. REF E 58 NR'S 9037033 AND 9037052. (X)SDR AALA970877Pan · gougedAFW - R1 DOOR PAN HAS GOUGE THAT IS BEYOND SRM LIMITS. REF E 58 NR 1696987. TST: 15,516.43 HOURS. CYCLES: 5,712. (X)SDR AALA970876Floor Beam · corrodedAFW - FLOOR BEAM AT STA 365 HAS CORROSION REMOVAL ON UPPER SURFACE. MATERIAL REMAINING IS BEYOND SRMS LIMITS. REF E 58 NR 1697052. TST: 15,561.43 HOURS. CYCLES: 5,712. (X)SDR AALA970875Floor Beam · corrodedAFW - FLOOR BEAM AT STA 377 HAS CORROSION REMOVAL ON UPPER SURFACE. MATERIAL REMAINING IS BEYOND SRM LIMITS. REF E 58 NR'S 1697054 AND 1697062. TST: 15,561.43 HOURS. CYCLES: 5,712. (X)SDR AALA970874Floor Beam · corrodedAFW - FLOOR BEAM AT STA 324 HAS CORROSION REMOVAL ON UPPER SURFACE MATERIAL REMAINING IS BEYOND SRM LIMITS. REF E 58 NR'S 1697049 AND 1697047. TST: 15,561.43 HOURS. CYCLES: 5,712. (X)SDR AALA970871Structure · corrodedAFW - FLOOR SUPPORT STRUCTURE SEC 41 HAS CORROSION REMOVAL ON UPPER SURFACE. MATERIAL REMAINING BEYOND SRM LIMITS REF E 58 NR'S 1697045, 1697051, 1697057, 1697058, 1697139. TST: 15,561.43 HOURS. CYCLES: 5,712. (X)
Back to N671AA, cancelled Feb 4, 2023