N640A, cancelled Feb 4, 2023
Service difficulty reports · 73
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 = 'N640A' AND deregistration_id = 'N640A-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 = 'N640A' AND deregistration_id = 'N640A-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 AALA20150626001Slide · faultyCREW OPENED THE L1 DOOR & THE EMER SLIDE FELL OUT. THE GIRT BAR WAS ATTACHED TO THE ACFT. SLIDE DID NOT DEPLOY. R & R SLIDE.SDR AALA20150410006Skin · corrodedNUMBER 2 PYLON SKIN CORRODED AT OTBD PANEL FWD OF ACCESS PANEL 443AR. REPAIRED IAW EA B757-54-039349.SDR AALA20150331008Slide · unsecureDOOR L1 EMER SLIDE FELL OUT OF CRADLE. REPLACED DOOR L1 EMER SLIDE & ASSIST BOTTLE.SDR AALA20141126001Power Supply · defectiveSEAT MOUNTED EMER PATH LIGHTS DIM BETWEEN SEATS 16D & 25D. R & R EMER PATH LIGHT POWER SUPPLY IAW AMM 33-51-07. SYS CHECKED NORMAL.SDR AALA20141022017Unknown · odorELECTRICAL ODOR IN THE CABIN & COCKPIT. ODOR STOPPED WHEN UTILITY BUSES WERE TURNED OFF. EMER DECLARED FLIGHT RETURNED & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. INSPECTED ACFT WITH UTILITY BUSES & RECIRCULATION FANS ON WITH NO FAULTS NOTED. SYSDR AALA20140509002Light · inoperativeRIGHT NR 2 DOOR EXTERNAL SLIDE SPOT LIGHT INOPERATIVE. R & R RT NR 2 DOOR EXTERNAL SLIDE SPOT LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20131116002Light · inoperativeBULLNOSE EMERGENCY LIGHT AT 5E INOPERATIVE. REPLACED LAMP FOR BULLNOSE EMERGENCY LIGHT AT 5E. OPERATIONS CHECKED NORMAL.SDR AALA20130921013Support Fitting · corrodedRT WW AFT BULKHEAD RBL 29 INBD MAIN FLAP TRACK SUPPORT FITTING CORRODED. ACCOMPLISHED REPAIR TO RT WW AFT BULKHEAD RBL 29 INBD MAIN FLAP TRACK SUPPORT FITTING IAW REO-G16658 REVISION C FIG 3 & AA EA B757-57-031566.SDR AALA20120914003Connector · dirtySEAT 25D EMERGENCY LIGHT INOPERATIVE. CLEANED AND RESEATED CONNECTORS UNDER SEAT AREA. OPS CHECK NORMAL.SDR AALA20110928TUL07Slat · damagedNUMBER 4 LEADING EDGE SLAT HAS A TEAR IN THE TRAILING EDGE, IN SAME AREA OF YELLOW LIFE RAFT BRACKET ON TOP OF LEFT WING. HOT BONDED CORE AND DOUBLERS PER SRM 51-70-10.SDR AALA20110711LAX01Terminal · faultyLAX - CREW REPORTED IMMEDIATELY AT ROTATION BATTERY DISCHARGE LIGHT STARTED FLASHING, TEMPORARY LOSS OF SOME INSTRUMENT LIGHTING, AND SEVERAL AMBER EICAS MESSAGES. EMERGENCY DECLARED FLIGHT RETURNED LAX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE.SDR AALA20110608JFK01Transmitter · inoperativeJFK - CREW REPORTED LOSS OF CENTER HYDRAULIC SYSTEM. EMERGENCY DECLARED FLIGHT RETURNED JFK LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED CENTER HYDRAULIC FLUID QUANTITY TRANSMITTER. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20110510MIA01Control Module · faultyMIA - CREW REPORTED STAB TRIM EICAS DURING CLIMBOUT. FLIGHT RETURNED MIA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT STABILIZER TRIM CONTROL MODULE THAT WAS FAULTY. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20110407DFW05Charger · inoperativeCEILING EMERGENCY LIGHTS ABOVE AFT FLIGHT ATTENDANT SEAT INOPERATIVE. REPLACED CHARGER AND BATTERIES FOR CEILING EMERGENCY LIGHTS ABOVE AFT FLIGHT ATTENDANT SEAT. OPS CHECKS OK.SDR AALA20101011DFW10Connector · burnedDFW - CREW REPORTED RIGHT WING SPOILERS WOULD NOT STOW ON APPROACH. EMERGENCY DECLARED LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND BURNED PLUG ON NUMBER 3 SPEED BRAKE POWER CONTROL MODULE. REPLACED PLUG. SYSTEM GROUND CHECK NORMAL OPSDR AALA20100914LGA02Connector · looseSEATS 1EF ESCAPE PATH LIGHT INOPERATIVE. SECURED LOOSE CONNECTOR AT SEATS 1EF. OPS CHECKED NORMAL.SDR AALA20100806TUL04Skin · damagedRIGHT WING HAS SEVERAL PITS IN THE EXTERNAL SKIN AT THE INBOARD END OF LEADING EDGE SLAT. REMOVED PITTED SKIN AND INSTALLED NEW SKIN ON INBOARD END OF SLAT PER ESO 90401.SDR AALA20100806TUL03Slat · corrodedLEFT WING THERE IS CORROSION AROUND A RIVET HEAD ON THE NUMBER FOUR SLAT AT THE OUTBOARD DRIVE TRACK. REMOVED FASTENER AND REMOVED CORROSION BY BLENDING THEN INSTALLED STRAP DOUBLER PER EA 757-27-012256.SDR AALA20100804TUL28Skin · damagedLEFT WING: THERE IS DELAMINATION OF THE TRAILING EDGE WEDGE ON THE NUMBER ONE SLAT AT THE INBOARD END OF THE SLAT. CUT OUT DAMAGED AREA OF SKIN AND CORE. SHAPED NEW SECTION OF CORE. READY TO HOT BOND THE FIRST STAGE OF A TWO STAGE CURE PER SRM 51-70-10-2R SDR AALA20100804TUL17Slat · corrodedLEFT WING THERE IS CORROSION ON THE NUMBER ONE SLAT APPROXIMATELY 2 INCHES FROM THE OUTBOARD END OF THE SLAT. REMOVED CORROSION AND INSTALLED FLUSH DOUBLER PER AARD 57-43-00-1.SDR AALA20100804TUL16Wedge · delaminatedLEFT WING THERE IS DELAMINATION OF THE TRAILING EDGE WEDGE ON THE NUMBER FOUR SLAT APPROXIMATELY 4 INCHES FROM THE OUTBOARD END OF THE SLAT. REMOVED DAMAGE AND INSTALL NEW TRAILING EDGE WEDGE PER ESO 90248.SDR AALA20100802TUL05Slat · damagedNUMBER 7 SLAT HAS A BLIND FASTENER AT RIB WHERE A PREVIOUS BLEND-OUT WAS ACCOMPLISHED. CUT OUT DAMAGED AREA AND INSTALLED REPAIR PER AARD 57-43-00-1 PAGE TWO.SDR AALA20100407TUL15Floorbeam · crackedFLOORBEAM CRACKED STATION 700 LEFT BUTTLINE 24 TO LEFT BUTTLINE 45.5. INSTALLED DOUBLER PER AARD 53-30-51-2.SDR AALA20100407TUL14Transition Panel · corrodedRIGHT TRANSITION PANEL CORRODED STATIONS 636 TO 644. REMOVED AND REPLACED TRANSITION PANEL WITH SERVICEABLE PANEL PER SRM 51-70-00-06.SDR AALA20100403TUL07Angle · corrodedCORROSION ON CREASE ANGLE STATIONS 760 TO 864. REMOVED AND REPLACED CREASE ANGLE PER AARD 53-30-13-1.SDR AALA20100403TUL06Angle · corrodedCORROSION ON CREASE ANGLE STATION 680 TO 740. REMOVED CREASE ANGLE AND INSTALLED NEW SECTION ON CARD 53-98-01 ITEM 63.SDR AALA20100403TUL01Intercostal · crackedINTERCOSTAL CRACKED AT STATION 660 LEFT BUTTLINE 48. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA20100402TUL01Intercostal · crackedINTERCOSTAL CRACKED AT LEFT BUTTLINE 24 AND STATIONS 660 TO 680. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02-0G.SDR AALA20100331TUL08Bullnose · crackedNUMBER 2 ENGINE WING BULLNOSE CRACKED ON INBOARD SIDE. INSTALLED DOUBLER PER AARD 57-41-01-6.SDR AALA20100331TUL06Shear Tie · corrodedFORWARD CARGO DOOR LOWER EDGE AT STATION 580 SHEAR TIE IS CORRODED. REMOVED AND REPLACED SHEAR TIE WITH SERVICEABLE SHEAR TIE PER SRM 51-70-00-0G.SDR AALA20100124DFW02Battery Pack · dischargedAFT SECTION OF SEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK.SDR AALA2009021501040Engine · malfunctionedLAX - INFLIGHT SNA-ORD - RIGHT ENGINE COMPRESSOR STALLED ON TAKEOFF. EMERGENCY DECLARED, LANDED LAX WITHOUT INCIDENT WITH RIGHT ENGINE AT REDUCED POWER. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER 2 ENGINE ON FEBRUARY 15TH AT LAX. SYSTEM GROUND CHECK NOSDR AALA2009021301039Control Unit · inoperativeORD - CREW REPORTED ON CLIMBOUT IN FLIGHT SHUTDOWN OF RIGHT ENGINE, SINGLE ENGINE TIME 9 MINUTES. EMERGENCY DECLARED, RETURNED ORD WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED BLEED VALVE CONTROL UNIT AND TRANSIT PRESSURE UNIT. SYSTEM GROUND CSDR AALA200803052Battery Pack · dischargedMIA - EMERGENCY LIGHTS IN FIRST CLASS DIM. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200820033Floorbeam · corrodedFLOORBEAM CORRODED. REPAIRED IAW EA B757-53-004738.SDR AALA200820032Structure · corrodedAFT GUTTER BOX CORRODED. REPAIRED IAW SRM 51-40-02.SDR AALA200820024Floorbeam · corrodedFLOORBEAM CORRODED. REPAIRED IAW EA B757-53-004838 DATED 10/24/2008.SDR AALA200801386Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT SEAT ROWS 9 TO 15 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 9 TO 15. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801385Battery Pack · inoperativeDFW - EMERGENCY LIGHT AT RIGHT NR TWO DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT RIGHT NR TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801384Battery Pack · inoperativeDFW - EMERGENCY LIGHT AT LEFT NR TWO DOOR SIDEWALL INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT LEFT NR TWO DOOR SIDEWALL. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801383Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 31ABC INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 31ABC. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200800397Lamp · inoperativeDFW - EXTERIOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR. REPLACED LAMP FOR EXTERIOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072478Lamp · inoperativeDFW - EMERGENCY BULL NOSE LIGHT AT FORWARD LEFT INOPERATIVE. REPLACED LAMPS FOR EMERGENCY BULL NOSE LIGHT AT FORWARD LEFT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071886Bulb · inoperativeDFW - EMERGENCY LIGHT AT LEFT AFT OVERWING EXIT INOPERATIVE. REPLACED LAMP AND REMOVED LIGHT CORROSION FOR EMERGENCY LIGHT AT LEFT AFT OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071698Window · crackedORD INFLIGHT T2242/06SEP - RIGHT FORWARD WINDOW HEAT FAILED. TURNED OFF POWER TO WINDOW HEAT AND SECONDS LATER FIRST OFFICERS WINDOW DEVELOPED LARGE CRACK. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPLACED FIRST OFFICERS NUMBER ONE WINDOW. SYSTEM GROUNSDR AALA20071635Connector · looseMIA - EMERGENCY LIGHT AT SEAT 3E INOPERATIVE. RESEATED CONNECTOR FOR EMERGENCY LIGHT AT SEAT 3E. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071638Battery Pack · inoperativeMIA - EMERGENCY LIGHTS AT FORWARD TO MID COACH INOPERATIVE. REPLACED BATTERY PACK AT RIGHT NUBMER TWO DOOR FOR EMERGENCY LIGHTS AT FORWARD TO MID COACH. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071637Battery Pack · inoperativeMIA - EMERGENCY LIGHTS AT FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060474Switch · malfunctionedMIA - RECEIVED A BRIEF RIGHT ENGINE FIRE LIGHT/BELL AND A STATUS RIGHT ENGINE OVERHEAT TURBINE DETECTION 2. RETURNED TO MIA AND LANDED WITHOUT INCIDENT. AIRCRAFT TAKEN OUT OF SERVICE FOR EVALUATION. REPLACED NUMBER 2 ENGINE TURBINE OVERHEAT DETECTION SWITCHSDR AALA20050018Connector · inoperativeMIA - EMERGENCY LIGHT AT 1L INOPERATIVE. REPLACED CONNECTORS FOR EMERGENCY LIGHT AT 1L. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N640A, cancelled Feb 4, 2023