N665AA, cancelled Feb 4, 2023
Service difficulty reports · 59
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 = 'N665AA' AND deregistration_id = 'N665AA-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 = 'N665AA' AND deregistration_id = 'N665AA-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 AALA20150618012Antenna · failedAIR INTERRUPT, EMER DECLARED, LANDING UNEVENTFUL & ACFT OVERWEIGHT. DURING CLIMB WXR FAILED. R & R WX RADAR ANTENNA IAW AMM 34-43-05. PERFORMED OPERATIONAL CHECK. SYS CHECKED NORMAL.SDR AALA20150330009Slide · unsecureL4 DOOR WAS OPENED WHILE ARMED AT GATE, DOOR SLIDE FELL OUT OF BUSTLE & DOOR ASSIST BOTTLE DISCHARGED. ASSIST BOTTLE PRESS REPORTED TO BE LOW. REINSTALLED SLIDE. R & R ASSIST BOTTLE.SDR AALA20141130003Unknown · odorRETURNED, EMER DECLARED, LANDING UNEVENTFUL & ACFT OVERWEIGHT. DURING CLIMB AT 2600 FEET FLIGHT ATTENDANT REPORTED STRONG BURNING ELEC SMELL BETWEEN L2 & R2 DOORS. PERFORMED ENG & APU RUNS WITH NO FINDINGS. INSPECTED RECIRCULATION FANS & FILTERS, ALL CABIN SDR AALA20141130002Housing · dirtyRETURNED, EMER DECLARED, LANDING UNEVENTFUL & ACFT OVERWEIGHT. DURING CLIMB AT 5000 FEET FLIGHT ATTENDANT REPORTED STRONG BURNING ELEC SMELL BETWEEN L2 & R2 DOORS. CHECKED ALL CABIN LIGHTS, POWER PORTS, ELEC EQUIP, ELEC EQUIP BAY & CARGO COMPARTMENTS. NO EVSDR AALA20140909006Light · inoperativeLEFT NR 3 DOOR EMER LIGHT INOPERATIVE. REPLACED LAMP FOR LT NR 3 DOOR EMER LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140529012Pressure Deck · corrodedCORROSION IN THE RT WW ON THE LOWER SURFACE OF THE PRESS DECK AT STATION 1160. REMOVED CORROSION, ACCOMPLISHED HFEC INSPECTION & INSTALLED DOUBLER.SDR AALA20140221003Battery Pack · dischargedEMERGENCY LIGHTS IN FIRST CLASS SECTION INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS EMERGENCY LIGHTS, OPERATIONS CHECKED NORMAL.SDR AALA20140212013Hinge · damagedNR 2 ENG THRUST REVERSER AFT HINGE INBD FASTENER HOLE DAMAGED. INSTALLED FREEZE PLUGS & DOUBLER IAW EA B757-54-033589 & SRM 54-50-00.SDR AALA20130803010Control Module · faultySAP INFLIGHT MIA-TGU CREW REPORTED SPOILER EICAS MESSAGE ON DESCENT. FLIGHT DIVERTED SAP LANDED WITHOUT INCIDENT. PLACARDED FLIGHT SPOILER SYSTEM IAW MEL. FLIGHT CONTINUED TO DESTINATION. REPLACED 1L SPOILER CONTROL MODULE AT MIA ON 08/04/2013. SYSTEM GRSDR AALA20130311004Pump · failedDFW - CREW REPORTED NUMBER 2 CENTER HYDRAULIC OVERHEAT MESSAGE FOLLOWED BY EICAS MESSAGE AND LOSS OF SYSTEM. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER 2 CENTER ELECTRONIC HYDRAULIC PUMP. SYSTEM GRSDR AALA20120703003Ballast · inoperativeTHE 18ABC EMERGENCY HATCH DOOR LIGHT LEFT AFT INOPERATIVE. REMOVED AND REPLACED LEFT HATCH DOOR LIGHT BALLAST. OPS CHECK NORMAL.SDR AALA20111006TUL06Tear Strap · crackedTEARSTRAP CRACKED BOTTOM OF FLOORBEAM STATION 365 AND LEFT BUTTLINE 47. INSTALLED DOUBLER PER SRM 53-10-51-2R 1.SDR AALA20111006TUL05Doubler · corrodedAFT GALLEY DECK PLATE FORWARD RIGHT DOUBLER OUTBOARD OF CENTER CORRODED. REPLACED DOUBLER PER SRM 53-60-51-2R2.SDR AALA20111003TUL03Strap · crackedSTABILIZER STRAP CRACKED STATION 1380 RIGHT BUTTLINE 45. INSTALLED DOUBLER.SDR AALA20111003TUL02Web · crackedWEB CRACKED STATION 700 BELOW NUMBER 4 SEAT TRACK. ACCOMPLISHED SPLICE REPAIR.SDR AALA20110930TUL02Web · corrodedWEB INBOARD OF AFT CARGO DOOR SILL AT STATIONS 1410 TO 1420 CORRODED. REPLACED WEB.SDR AALA20110927TUL02Web · corrodedWEB OUTBOARD OF STRINGER 29 RIGHT IS CORRODED AT STATIONS 1620 TO 1640. REPLACED WEB PER AARD 51-20-00-1.SDR AALA20110924TUL01Slat · corrodedNUMBER 9 SLAT HAS CORROSION AROUND HI-LOK FASTENER, 65 INCHES FROM OUTBOARD END. INSTALLED FLUSH DOUBLER REPAIR PER AARD 57-43-00-1.SDR AALA20110922TUL02Skin · damagedFORWARD CARGO DOOR, OUTER DOOR SKIN EDGE BENT AT LOWER AFT CORNER. INSTALLED DOUBLER REPAIR ON LOWER AFT CORNER OUTER SKIN PER SRM 52-30-01 PAGE 1 AND EA COMP-52-019297.SDR AALA20110922TUL01Doubler · corrodedAFT PRESSURE DECK DOUBLER AT STA 1715 BUTTLINE 35 LEFT HAS CORROSION. REMOVED DOUBLER AND REINSTALLED REPAIR PER SRM 53-60-51-2R.SDR AALA20110921TUL03Stringer · damagedSTATION 1540 TO 1560 STRINGER 30 RIGHT DAMAGED. INSTALLED DOUBLER REPAIR SRM 53-00-01-2R-3.SDR AALA20110920TUL03Structure · crackedRIGHT NUMBER 2 PASSENGER DOOR INNER CHORD UPPER HINGE CUTOUT IS CRACKED. INSTALLED DOUBLER REPAIR PER EA 52-019135 DATED 09/20/2011.SDR AALA20110919TUL06Intercostal · corrodedFORWARD CARGO DOOR, 4TH INTERCOSTAL AFT OF FORWARD EDGE HAS CORROSION. INSTALLED NEW INTERCOSTAL PER ESO 90114.SDR AALA20110919TUL05Intercostal · corrodedFORWARD CARGO DOOR, 3RD INTERCOSTAL AFT OF FORWARD EDGE HAS CORROSION. INSTALLED NEW INTERCOSTAL PER ESO 90114.SDR AALA20110919TUL04Intercostal · corrodedFORWARD CARGO DOOR 2ND INTERCOSTAL AFT OF FORWARD EDGE HAS CORROSION. INSTALLED NEW INTERCOSTAL PER ESO 90114.SDR AALA20111010TUL03Skin · bentNUMBER 2 CARGO DOOR LOWER FORWARD CORNER DOOR SKIN BENT. DYE CHECKED AREA AND INSTALLED A DOUBLER REPAIR AT THE LOWER FORWARD CORNER OF THE NUMBER 2 CARGO DOOR PER SRM 52-30-01-2R.SDR AALA20110916TUL03Skin · bentNUMBER 2 CARGO DOOR, THE OUTER EDGE OF THE SKIN IS BENT AT THE LOWER FORWARD CORNER OF THE DOOR. STRAIGHTENED THE DAMAGED AREA ALONG THE OUTER EDGE OF THE SKIN CORNER. DYE CHECKED: NO CRACKS INDICATED. FABRICATED DOUBLER AND INSTALLED PER SRM 52-30-01-2R.SDR AALA20110912TUL09Floor Support · damagedFLOOR SUPPORT STRINGER BENT AND DENTED STATION 1430. REPLACED FLOOR SUPPORT STRINGER PER AARD 51-10-05-01.SDR AALA20110921TUL01Support Angle · corrodedSUPPORT ANGLE UNDER CREASE ANGLE AT STATION 1720 CORRODED. REPLACED SUPPORT ANGLE.SDR AALA20100601SJU01Pin · not seatedEMERGENCY LIGHTS INOPERATIVE FROM 26D THRU AFT DOORS. RESET PIN 23 AT LEFT NUMBER 4 DOOR EMERGENCY BATTERY MODULE LOCATED BETWEEN RIGHT AND LEFT LAVATORY. OPS CHECKED NORMAL.SDR AALA20100519DFW01Connector · looseEMERGENCY ESCAPE PATH LIGHTING INOPERATIVE. RE-SECURED CONNECTOR FOR EMERGENCY ESCAPE PATH LIGHTING. OPS CHECKED NORMAL.SDR AALA20100804TUL15Module · inoperativeROWS 26 TO 36 EMERGENCY LIGHTS AND LEFT AND RIGHT AFT ENTRY DOOR EXIT SIGN INOPERATIVE. REPLACED MODULE FOR ROWS 26 TO 36 EMERGENCY LIGHTS AND LEFT AND RIGHT AFT ENTRY DOOR EXIT SIGN. OPS CHECKED NORMAL.SDR AALA20100518DFW05Battery Pack · dischargedROWS 26 TO 36 EMERGENCY LIGHTS AND LEFT AND RIGHT AFT ENTRY DOOR EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK FOR ROWS 26 TO 36 EMERGENCY LIGHTS AND LEFT AND RIGHT AFT ENTRY DOOR EXIT SIGN. OPS CHECKED NORMAL.SDR AALA20100518DFW03Connector · looseTHE 17ABC OVERWING EMERGENCY LIGHT INOPERATIVE. RE-SECURED CONNECTOR FOR 17ABC OVERWING EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100518DFW04Connector · looseTHE 23D SEAT MOUNTED ESCAPE PATH LIGHT INOPERATIVE. SECURED CONNECTOR FOR 23D SEAT MOUNTED ESCAPE PATH LIGHT. OPS CHECKED NORMAL.SDR AALA20100518DFW02Connector · looseTHE 17ABC OVERWING EMERGENCY LIGHT INOPERATIVE. SECURED CONNECTOR FOR 17ABC OVERWING EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100518DFW01Connector · looseSEAT 11D EMERGENCY ESCAPE PATH LIGHTING INOPERATIVE. SECURED LOOSE CONNECTOR FOR SEAT 11D EMERGENCY ESCAPE PATH LIGHT. OPS CHECKED NORMAL.SDR AALA20100225JFK02Clamp · looseJFK - INFLIGHT LGA-MIA. CREW REPORTED PRESSURIZATION LOSS AFTER TAKEOFF. PROBLEM STARTED WITH LEFT BLEED FAULT. WHEN LEFT BLEED WAS SHUT DOWN, ALTITUDE WARNING ON PRESSURIZATION SYSTEM RIGHT PACK COULD NOT MAINTAIN CABIN PRESSURE. EMERGENCY DECLARED FLIGHTSDR AALA20100211TUL10Lug · corrodedCORROSION ON LUGS OF UPPER CASTING GATE ROD ATTACHMENT. REPAIRED PER EA 757-52-009071.SDR AALA20100209TUL07Skin · crackedTHE NUMBER 9 SLAT BACK SKIN IS CRACKED AT THE INBOARD DRIVE TRACK FITTING AREA. REPAIRED SLAT PER AARD 57-43-00-4.SDR AALA20100209TUL06Skin · crackedTHE NUMBER 9 SLAT BACK SKIN IS CRACKED AT THE OUTBOARD DRIVE TRACK FITTING AREA. REPAIRED SLAT PER AARD 57-43-00-4.SDR AALA20100209TUL05Skin · crackedTHE NUMBER 8 SLAT BACK SKIN HAS TWO CRACKS AT THE INBOARD DRIVE TRACK FITTING AREA. REPAIRED SLAT PER AARD 57-43-00-4.SDR AALA20100122LAS01Fairing · crackedLAS - INFLIGHT LAX-STL. CREW REPORTED LEFT ENGINE VIBRATION. EMERGENCY DECLARED DIVERTED LAS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT ENGINE NOSE CONE FAIRING DUE TO A CRACK FOUND. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20091231LGA02Lens · missingEMERGENCY LIGHT AT SEAT 18D MISSING LENS. REPLACED LENS.SDR AALA200801166Connector · looseMIA - EMERGENCY LIGHT AT SEAT 12D INOPERATIVE. SECURED CONNECTOR FOR EMERGENCY LIGHT AT SEAT 12D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803050Connector · burnedVVI INFLIGHT, AT CRUISE CREW REPORTED STRONG ELECTRICAL BURNING ODOR. FIRST OFFICER LOST AIRSPEED INDICATOR AND ALTIMETER WAS ERRATIC. CREW RECEIVED RUDDER RATIO AND MACH SPEED TRIM INDICATIONS. RETURNED TO VVI AND LANDED WITHOUT INCIDENT. FOUND LEFT DUCTSDR AALA20060574Bulb · inoperativeMIA - EMERGENCY EXIT LIGHT AT LEFT NUMBER FOUR DOOR INOPERATIVE. REPLACED LAMP FOR INOPERATIVE EMERGENCY EXIT LIGHT AT LEFT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050651A/C Pack · smokeCCS - INFLIGHT AIRCRAFT ARRIVED WITH ACRID SMELL IN COCKPIT AND NUMBER ONE FLIGHT ATTENDANT REPORTED A HAZY SMOKE IN FIRST CLASS CABIN. INSPECTED MAIN CABIN AND FIRST CLASS CABIN AND NO EVIDENCE OF ACRID SMELL. ACCOMPLISHED PACK BURN. SYSTEM GROUND CHECKED SDR AALA20041022Battery Pack · inoperativeMIA - EMERGENCY LIGHT BY RIGHT AFT LAVATORY INOPERATIVE. FOUND WIRE DISCONNECTED AT EMERGENCY LIGHT RIGHT HAND AFT LAVATORY. REPOSITIONED WIRE FOR EMERGENCY LIGHT AT RIGHT HAND AFT LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20021003Bottle · dischargedORD - R1 DOOR SLIDE BOTTLE INDICATES ZERO PSI. REPLACED SLIDE ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N665AA, cancelled Feb 4, 2023