N658AA, cancelled Feb 4, 2023
Service difficulty reports · 83
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 = 'N658AA' AND deregistration_id = 'N658AA-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 = 'N658AA' AND deregistration_id = 'N658AA-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 AALA20150120009Cover · missingDOOR L3 EMER EXIT LIGHT COVER MISSING. REPLACED DOOR L3 EMER LIGHT ASSEMBLY.SDR AALA20141201008Battery · dischargedCOACH SEAT EMER PATH LIGHTS INOPERATIVE AT ALL SEATS. R & R BATTERY & CHARGER ASSEMBLY AT M10800 IAW 33-51-07. SYS CHECKED NORMAL.SDR AALA20141201007Battery · dischargedCOACH SEAT EMER PATH LIGHTS INOPERATIVE AT ALL SEATS. R & R BATTERY & CHARGER ASSEMBLY AT M10799 IAW 33-51-07. SYS CHECKED NORMAL.SDR AALA20141201002Battery · dischargedCOACH SEAT EMER PATH LIGHTS INOPERATIVE AT ALL SEATS. R & R BATTERY & CHARGER ASSEMBLY AT M10801 IAW 33-51-07. SYS CHECKED NORMAL.SDR AALA20141201001Charger · inoperativeFIRST CLASS SEAT MOUNTED EMER PATH LIGHTS INOPERATIVE AT ALL SEATS. R & R BATTERY CHARGER ASSEMBLY AT M10798 IAW AMM 33-51-07. SYS CHECKED NORMAL.SDR AALA20140511001Frame · damagedUPPER CHORD COMMON TO STATION 231.25 & BL 0 DAMAGED. ACCOMPLISHED NESTED ANGLE REPAIR IAW EA B757-53-034845.SDR AALA20140505010Door Frame · crackedLEFT NR 2 DOOR UPPER HINGE CUT OUT IS CRACKED. INSTALLED REPAIR DOUBLER & STOP PIN FITTING IAW SRM 52-10-02-2R-1 & EA COMP-52-034741.SDR AALA20131204011Skin · crackedDURING ACCOMPLISHMENT OF THE AFT HINGE FITTING PREVENTATIVE MODIFICATION, ECO F1566, ON THE NR 1 PYLON ONE FASTENER HOLE THROUGH THE FITTING & STRUCTURE WAS OVERSIZED & HFEC INSPECTED. REMOVED CRACK BY ENLARGING HOLE, VERIFIED CRACK REMOVAL BY HFEC INSPECTIONSDR AALA20130302009Engine · failedPLS - INFLIGHT SJU-MIA. CREW REPORTED HYDRAULIC OVERTEMP INDICATION AND LOSS OF RIGHT HYDRAULIC QUANTITY FOLLOWED. RIGHT ENGINE OIL FILTER CLOG LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT DIVERTED PLS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICESDR AALA20120326005Battery Pack · dischargedLEFT NUMBER 4 DOOR EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR LEFT NUMBER 4 DOOR EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20120324004Lens · brokenLEFT NUMBER 4 DOOR EMERGENCY LIGHT LENS BROKEN. REPLACED LENS FOR LEFT NUMBER 4 DOOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20111217TUL05Actuator · leakingSJO - CREW REPORTED MAIN LANDING GEAR DOOR OPEN EICAS MESSAGE. FLIGHT RETURNED SJO LANDED WITHOUT INCIDENT. FOUND LANDING GEAR HYDRAULIC FUSE TRIPPED. REPLACED RIGHT GEAR TRUCK TILT ACTUATOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20110810TUL11Floorbeam · damagedHUMP IN PREVIOUS REPAIRS ON FLOORBEAM. PERFORM TEE CAP REPAIR PER EA B757-53-018541.SDR AALA20110810TUL12Web · corrodedBOTTOM OF WEB CORRODED AT FASTENER HOLE. REPAIRED WEB PER AARD 51-20-00-1 REPAIR 1, S/O-KTH0, BOEING DOCUMENT 146N87225-63 AND SRM 51-10-02 OG.SDR AALA20110808TUL08Structure · corrodedCUTOUT 2 INCHES SECTION OF 1380 FRAME LOWER CHORD, LOWER FLANGE RUNNING ON TOP OF LOWER T-CHORD TO FOM TO ACCESS CORROSION. INSTALLED REPAIR DOUBLERS, FILLER, SHIMS AND RELATED STRUCTURE AT STATION 1380 FRAME, OUTER CHORD PER SRM 51-70-12-0G AND EA B757-53-01SDR AALA20110808TUL07Frame · gougedFRAME GOUGED, LEFT SIDE STATION 1640 BETWEEN STRINGERS 7 AND 8. INSTALLED DOUBLER PER EA B757-53-018531 AND BOEING REPAIR SKETCH AAL/AAL-11-1981-01C.SDR AALA20110808TUL06Frame · gougedFRAME GOUGED, LEFT SIDE STATION 1640 BETWEEN STRINGERS 6 AND 7. INSTALLED DOUBLER AS PER EA. B757-53-018531 AND BOEING REPAIR SKETCH AAL/AAL-11-1981-01C.SDR AALA20110803TUL03Structure · corrodedAFT CARGO DOOR CUTOUT LOWER UPPER T-CHORD FROM STATIONS 1380 TO 1440 HAS CORROSION AROUND NUT PLATES. REPLACED UPPER CHORD PER AARD 51-10-05-1.SDR AALA20110803TUL02Web · corrodedCORROSION ON T-CORD WEB APPROXIMATE STATION 1420 STRINGER 26 RIGHT ON OUTBOARD FACE. INSTALLED SERVICEABLE WEB PER AARD 51-10-05-1.SDR AALA20110803TUL01Intercostal · damagedLEFT INTERCOSTAL DAMAGED. REPLACED INTERCOSTAL AND STRINGER PER SRM 51-10-02 OG.SDR AALA20110802TUL03Mount · corrodedLAVATORY MOUNT CORRODED. REPLACED LAVATORY MOUNT PER SRM 51-10-02 OG.SDR AALA20110802TUL02Structure · defectiveAFT DECK WILL NOT EXTEND UNDERNEATH THE ANGLE AT STATION 1720. REPLACED AFT DECK PER SRM 51-10-02 OG.SDR AALA20110801TUL01Crease Beam · corrodedCORROSION ON CREASE LEFT BEAM. REPLACED SECTION OF BEAM AND ACCOMPLISHED SPLICE REPAIR PER AARD 53-60-13-1.SDR AALA20110726TUL06Floorbeam · corrodedCORROSION IN NUMEROUS PLACES ON PREVIOUS REPAIRS TO THE FLOORBEAM AT 1640 AND LEFT BUTTLINE 48 TO RIGHT BUTTLINE 30. REPLACE THE UPPER CHORD OF T CAP ON FLOORBEAM FRAME STATION 1640 PER BOEING DRAWING LOR5L53005 REPAIR 5.SDR AALA20110722TUL05Angle · corrodedSTATION 682 Z-ANGLE CORRODED. REPLACED Z-ANGLE PER SRM 51-10-02-OG.SDR AALA20110722TUL01Web · corrodedWEB CORRODED STATION 1380 TO 1400 STRINGER 17 RIGHT. REPLACED WEB PER SRM 51-10-02-0G.SDR AALA20110721TUL13Intercostal · damagedLEFT SIDE STATION 1701, STRINGER 10 LEFT INTERCOSTAL DAMAGED. INSTALLED STRINGER/INTERCOSTAL PER SRM 51-10-02-0G PARAGRAPH NUMBER 9.SDR AALA20110721TUL12Fitting · corrodedSTATION 567.3, FORWARD CARGO DOORSILL AREA, FITTING FOR THRESHOLD SUPPORT CORRODED. INSTALLED FITTING ASSEMBLY PER SRM 51-10-02-0G AND IPC 53-33-63-01.SDR AALA20110721TUL06Intercostal · corrodedAFT CARGO INTERCOSTAL CORRODED STATIONS 1500 TO 1520 STRINGER 30. REPLACED INTERCOSTAL PER SRM 51-10-02-0G.SDR AALA20110721TUL05Doubler · dentedAFT CARGO DOOR- DENT IN OUTER SKIN 18 INCHES AFT OF FORWARD EDGE AND 4 INCHES UP FROM LOWER EDGE WITH ADL DOT NEXT TO IT. AFT CARGO DOOR CUT AND REMOVED DAMAGED AREA OF SKIN. COMPLETED DOUBLER INSTALLATION PER SRM 52-30-01-2R 4.SDR AALA20110721TUL04Intercostal · corrodedAFT CARGO INTERCOSTAL CORRODED. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-10-02-G9.SDR AALA20110720TUL03Web · corrodedWEB CORRODED STATIONS 1420 TO 1440. REPLACED WEB PER SRM 51-10-03-09.SDR AALA20110720TUL01Intercostal · corrodedAFT CARGO INTERCOSTAL STATION 1500 CORRODED. REPLACED INTERCOSTAL PER SRM 51-10-02-G9.SDR AALA20110710TUL02Skin · crackedCRACK IN COVE SKIN 29 INCHES FROM END OF NUMBER 9 SLAT. STOPPED DRILLED END OF CRACK. HFEC SURFACE SCAN CONFIRMS CRACK TERMINATION AT STOP DRILL. FABRICATED AND INSTALLED REPAIR PER AARD 57-43-00-4.SDR AALA20110707TUL05Pan · damagedLEFT NUMBER 1 DOOR, OUTER HANDLE PAN HAS DEEP GOUGE. REPLACED HANDLE PAN AND RE-INSTALLED TORQUE BOX PER ESO 90283.SDR AALA20110522DFW04Module · inoperativeALL EMERGENCY LIGHTS IN MODULE M10699 CIRCUIT FAIL WITHIN 15 SECONDS OF OPERATION. REMOVED AND REPLACED M10699. OPS CHECK NORMAL.SDR AALA20110522DFW03Light · inoperativeLEFT NUMBER 2 EMERGENCY SLIDE LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 2 EMERGENCY SLIDE LIGHT. OPS CHECK NORMAL.SDR AALA20110522DFW02Light · inoperativeAFT CARGO DOOR MOUNTED EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR AFT CARGO DOOR MOUNTED EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110324TUL06Battery Pack · dischargedLEFT NUMBER 2 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR LEFT NUMBER 2 DOOR EXTERNAL EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110324DFW01Light · inoperativeRIGHT NUMBER 4 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 4 DOOR EXTERNAL EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20100830DFW02Light · inoperativeLEFT NUMBER 1 EMERGENCY EXIT FLOOD LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 1 EMERGENCY EXIT FLOOD LIGHT. OPS CHECKED NORMAL.SDR AALA20100830DFW01Placard · peelingLEFT EMERGENCY EXIT LIGHT LENS PLACARD IS PEELING. REPLACED PLACARD.SDR AALA20101126TUL02Slide · out of positionLEFT NUMBER 3 DOOR SLIDE INADVERTENTLY UNSUCCESSFULLY DEPLOYED. SLIDE FELL FROM HOUSING AND ASSIST BOTTLE DISCHARGED. REPLACED LEFT NUMBER 3 DOOR SLIDE. OPS CHECK NORMAL.SDR AALA20100107TUL20Skin · crackedBOTH TRAINING EDGE SKINS ARE CRACKED ON NUMBER THREE SLAT AT INBOARD DRIVE TRACK. INSTALLED EXTERNAL DOUBLER REPAIR AT COVE SKIN AT INBOARD DRIVE TRACK UNDER SRM 57-43-00-4 AND ESO 90246.SDR AALA20100107TUL15Skin · corrodedSKIN CORRODED AT NUMBER THREE SLAT HI-LOK 72 INCHES FROM INBOARD END AND 16 INCHES FROM TRAILING EDGE. DAMAGED AREA REMOVED AND DOUBLERS INSTALLED PER ARRD 57- 43-00-01 AND ESO 90246.SDR AALA20100107TUL02Skin · crackedBOTH TRAILING EDGE SKINS ARE CRACKED ON NUMBER 1 SLAT AT OUTBOARD DRIVE TRACK. INSTALLED EXTERNAL DOUBLER ON COVE SKIN PER AARD-57-43-00-4.SDR AALA20100107TUL01Skin · crackedINBOARD COVE SKIN CRACKED ON NUMBER 1 SLAT AT INBOARD AUXILIARY ARM TRACK. INSTALLED EXTERNAL DOUBLER ON COVE SKIN PER AARD 57-43-00-4.SDR AALA20100105TUL21Skin · dentedDENT IN SLAT WITH HOLE AT 89 INCHES FROM INBOARD END NUMBER 5 SLAT TRAILING EDGE WEDGE SURFACE ON LEFT WING. HOT BONDED REPAIR DOUBLER PER SRM 51-70-10-2R, 2, FIG 203A.SDR AALA20091201BOG01Battery Pack · dischargedEMERGENCY AISLE LIGHTS AT SEATS 16D TO 26D WILL NOT TURN OFF. REPLACED BATTERY PACK.SDR AALA20091118SFO02Light · inoperativeLEFT NUMBER THREE DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LAMP.
Back to N658AA, cancelled Feb 4, 2023