N795AS, cancelled Aug 17, 2016
Service difficulty reports · 149
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 = 'N795AS' AND deregistration_id = 'N795AS-2016-08-17' 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 = 'N795AS' AND deregistration_id = 'N795AS-2016-08-17' 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 ASAA1048156Skin · bulgedEXTERNAL FUSELAGE SKIN AT STA 186, 4 INCHES BELOW STR 24L IS BULGED OUT. CUT OUT DAMAGE AND INSTALLED DOUBLER REPAIR.SDR ASAA1048131Skin · dentedRIGHT O/B AFT FLAP AT APPROX 12 INCHES FROM I/B EDGE DENTED. REMOVED DAMAGED AREA, INSTALLED DOUBLER REPAIR.SDR ASAA1048130Skin · dentedDENT ON RT WING OUTBOARD AFT JUST O/B OF NR 7 CANOE. REMOVED DAMAGED AREA, INSTALLED DOUBLER REPAIR.SDR ASAA0945822Skin · dentedRIGHT I/B FORE FLAP UPPER SURFACE HAS CHAFED REPAIRS. REPAIRED DAMAGED AREAS IAW SRM.SDR ASAA0945819Skin · dentedRIGHT I/B FORE FLAP LOWER SURFACE PREVIOUS REPAIR HAS DENTS. REPAIRED DAMAGE IAW SRM.SDR ASAA0945818Skin · chafedNR 4 SPOILER IS CHAFED ON LOWER SURFACE. REPAIRED DAMAGE ON LOWER SURFACE IAW SRM.SDR ASAA0945817Cargo Track · corrodedAFT PIT CARGO TRACK CORRODED STA 847 RBL 13.8. REPAIRED TRACK BY SPLICING IN NEW SECTION.SDR ASAA0945673Splice · corrodedAFT PIT LOWER SPLICE STRAP STA 787 794 RBL 20 WL 156 CORRODED. REMOVED CORRODED STRAP RECEIVED LOCATED DRILLED AND INSTALLED NEW SPLICE STRAPSDR ASAA0945670Skin · crackedNR 1 SLAT CRACKED AROUND RIVET AT MIDDLE AUX TRACK. REMOVED DAMAGED SECTION OF SKIN FABRICATED TREATED PRIMED AND INSTALLED SKIN DOUBLER AND FILLER REPAIR IAW SRM 57 43 01.SDR ASAA0945669Skin · chafedLT INBD MID FLAP UPPER IB SURFACE CHAFED. CUT OUT DAMAGED AREA FABRICATED TREATED PRIMED AND BONDED SKIN DOUBLER AND FILLER REPAIR IAW SRM 57 30 01.SDR ASAA0945672Skin · chafedLT INBD FORE FLAP UPPER SURFACE IB EDGE CHAFED. REMOVED DAMAGED SKIN FABRICATED TREATED PRIMED AND BONDED DOUBLER REPAIR IAW SRM 51 70 10.SDR ASAA0945671Skin · chafedLT INBD FLAP UPPER SURFACE CHAFED AT PREVIOUS REPAIR. REMOVED PREVIOUS REPAIRS, FABRICATED TREATED, PRIMED AND INSTALLED SKIN DOUBLER REPAIR IAW SRM 51 70 10.SDR ASAA0945667Hinge Fitting · crackedL1 DOOR LOWER HINGE FITTING CRACKED. REMOVED AND REPLACED HINGE FITTING IAW SRM 51 40 02.SDR ASAA0945668Skin · dentedSKIN DENTED STA 1020 BETWEEN STR 25R 26R DENT IS WITHIN 3 INCH FROM SPLICE. REMOVED DAMAGED AREA FABRICATED TREATED PRIMED AND INSTALLED DOUBLER AND FILLER REPAIR IAW SRM 53 80 01.SDR ASAA0842967Skin · dentedDENT FOUND IN RIGHTHAND HORIZONTAL STABILIZER LEADING EDGE. INSTALLED EXTERNAL DOULBER PER ALK EA 5510 01322.SDR ASAA0842451Door · bindsFLT ATTENDANT HAS TROUBLE OPENING L1 DOOR. CARRIED OUT GENERAL VISUAL INSPECTION OF L1 DOOR. NO DEFECTS NOTED. OPERATIONAL CHECK COMPLETED, NO FAULTS FOUND. OP CHECKS GOOD PER MM 52-11-00.SDR ASAA0640964Skin · dentedSCRATCH AND DENT IN AFT CARGO DOOR APPROX 7" FROM LE OF DOOR 14" FROM BOTTOM. SCRATCHES 8" LONG ENDING IN A DENT 3.1" BY 1.4" BY .3" DEEP WITH GOUGE APPROX 1 2" LONG BY 1 4" WIDE. CUT OUT SKIN AT DAMAGED AREA AND INSTALLED REPAIR DOUBLER PER SRM 53 00 01 REPSDR ASAA0540696Threshold · corrodedFOUND CORROSION AT AFT CARGO BAY DOOR CUTOUT LOWER THRESHOLD. REMOVED AND REPLACED LOWER THRESHOLD IAW B737-400 SRM 51-40-02. (M)SDR ASAA0540764Shear Tie · corrodedPAE- CORROSION ON FWD CARGO FRAME SHEAR TIE AT BSTA 500B BL 0, STR 28 LT. FOUND CORROSION TO BE OUT OF LIMITS, FABRICATED AND INSTALLED REPAIR TO FRAME SHEAR TIE IAW SRM. (K)SDR ASAA0540739Support · corrodedPAE: CORROSION ON FLOOR TO SIDEWALL SUPPORT. REMOVED DAMAGED SUPPORT, FABRICATED AND NEW SUPPORT PIECE AND INSTALLED IAW SRM. (K)SDR ASAA0540741Shear Tie · corrodedPAE - FOUND CORROSION ON FORWARD CARGO FRAME SHEAR TIE. REMOVED CORROSION, CUT OUT FRAME SHEAR TIE, FABRICATED AND INSTALLED REPAIR IAW B737-400 SRM 53-00-07 FIG 201, REPAIR 3. (M)SDR ASAA0540742Shear Tie · corrodedPAE - FOUND CORROSION ON FORWARD CARGO FRAME SHEAR TIE. REMOVED DAMAGED SHEAR TIE, FABRICATED AND INSTALLED REPAIR IAW ASA EA 5310-02545. (M)SDR ASAA0540745Shear Tie · corrodedFOUND CORROSION AFT CARGO BAY SHEAR TIE. REMOVED DAMAGED SHEAR TIE, FABRICATED AND INSTALLED REPAIR PARTS IAW B737-400 SRM 53-00-07.SDR ASAA0540747Skin · chafedPAE - FOUND UPPER FUSELAGE SKIN CHAFED. REPAIRED DAMAGED SKIN BY ADDING DOUBLERS AND REPAIR STRAPS PER ASA EA 5330-02033. (M)SDR ASAA0540740Shear Tie · corrodedPAE - FOUND CORROSION ON FORWARD CARGO FRAME SHEAR TIE. FOUND CORROSION OUT OF LIMITS. FABRICATED AND INSTALLED REPAIR TO FRAME SHEAR TIE IAW B737-400 SRM 53-00-07. (M)SDR ASAA0540743Shear Tie · corrodedPAE - FOUND CORROSION ON FORWARD CARGO FRAME SHEAR TIE. REMOVED DAMAGED SHEAR TIE, FABRICATED AND INSTALLED REPAIR TO FRAME SHEAR TIE IAW B737-400 SRM 53-00-07. (M)SDR ASAA0540744Frame · crackedPAE - FOUND FRAME CRACKED AT BIN RAIL ATTACH CLIP. REMOVED CRACK IN FRAME, FABRICATED AND INSTALLED REPAIR PARTS IAW B737-400 SRM 53-00-07. (M)SDR ASAA0540746Frame · crackedPAE - REJECTED ITEM FROM CARD 4963163. FRAME CRACKED AT BIN RAIL SUPPORT STATION 907 BETWEEN STRINGER 8R AND 9R. DAMAGE REMOVED EXCEEDS ALLOWABLE LIMITS IN B737-400 SRM 53-00-07 REPAIR 2, DETAIL 1. INSTALLED FRAME REPAIR AT BS 907 FRAME BETWEEN STRINGER 8R SDR ASAA0540728Frame · crackedPAE - FOUND CRACKED FRAME AT BIN RAIL SUPPORT BRACKET LEFT SIDE. REPAIRED FRAME AT BIN RAIL SUPPORT BRACKET PER SRM 53-00-07, REPAIR 1. (M)SDR ASAA0540730Shear Tie · corrodedPAE - FOUND CORROSION ON FORWARD CARGO FRAME SHEAR TIE. FABRICATED AND INSTALLED REPAIR TO FRAME PER SRM 53-00-07. (M)SDR ASAA0540729Shear Tie · corrodedPAE - FOUND CORROSION ON FORWARD CARGO FRAME SHEAR TIE. CORRODED OUT OF LIMITS FABRICATED AND INSTALLED NEW SHEAR TIE PER SRM 53-00-07. (M)SDR ASAA0540703Shear Tie · corrodedPAE - FOUND CORROSION ON FORWARD CARGO FRAME SHEAR TIE. REMOVED DAMAGED SHEAR TIE, FABRICATED AND INSTALLED NEW SHEAR TIE IAW B737-400 SRM 53-00-07. (M)SDR ASAA0540702Sill · corrodedPAE - FOUND CORROSION ON AFT ENTRY DOOR MOPSILL. REMOVED AND REPLACED MOPSILL IAW B737-400 SRM 53-60-15. (M)SDR ASAA0540705Threshold · corrodedPAE - FOUND CORROSION AFT CARGO BAY DOOR CUTOUT LOWER THRESHOLD. REMOVED AND REPLACED LOWER THRESHOLD IAW B737-400 SRM 51-40-02. (M)SDR ASAA0540706Frame · crackedPAE - FOUND FRAME CRACKED AT BIN RAIL ATTACH CLIP. REMOVED CRACK IN FRAME, FABRICATED REPAIR PARTS AND INSTALLED IAW B737-400 SRM 53-00-07. (M)SDR ASAA0540704Stringer Clip · gougedPAE - FOUND AFT CARGO BAY STRINGER CLIP GOUGED. REMOVED AND REPLACED STRINGER CLIP IAW B737-400 SRM 51-40-02. (M)SDR ASAA0540697Seat Track · gougedPAE - FOUND MECHANICAL DAMAGE ON MAIN CABIN SEAT TRACK. REMOVED AND REPLACED SEAT TRACK IAW B737-400 SRM 53-00-52. (M)SDR ASAA0540699Skin · chafedPAE - FOUND RIGHT SKIN CHAFED AT LOWER AFT HORIZONTAL STAB FITTING. REMOVED DAMAGED SKIN, FABRICATED NEW SKIN AND INSTALLED IAW B737-400 SRM 51-40-02. (M)SDR ASAA0540698Seat Track · damagedPAE - MECHANICAL DAMAGE ON MAIN CABIN SEAT TRACK. REMOVED AND REPLACED SEAT TRACK IAW B737-400 SRM 53-00-52. (M)SDR ASAA0540695Stringer Clip · gougedAFT CARGO BAY STRINGER CLIP GOUGED. REMOVED AND REPLACED STRINGER CLIP IAW B737-400 SRM 51-40-02. (M)SDR ASAA0540212Skin · lightning strikeLIGHTING STRIKE AT FRAME 211.8 ON CREASE BEAM. REMOVED DAMAGED, COMPLIED WITH A HFEC INSPECTION IAW MFG NDT MANUAL, NO DEFECTS NOTED. FABRICATED AND INSTALLED A REPAIR FILLER, DOUBLER, AND TRIPLER IAW SRM. (K)SDR ASAA0540211Skin · dentedIB FORE FLAP HAS NUMEROUS DENTS IN LOWER SKIN SURFACE. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR DOUBLER IAW SRM. (K)SDR ASAA0540210Skin · chafedLT FUSELAGE EXTERNAL SKIN CHAFED AT LT STAB AFT OF BOTTOM LUG CUTOUT STA 1150-1140. REMOVED DAMAGED SKIN, FABRICATED AND INSTALLED REPLACEMENT SKIN IAW SRM. (K)SDR ASAA0540209Wedge · dentedLT WING IB MID FLAP WEDGE IS DENTED. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR DOUBLER IAW SRM. (K)SDR ASAA0540208Skin · delaminatedRUDDER IS DAMAGED AT LT SIDE LOWER EDGE. COMPLIED WITH A BOND REPAIR IAW SRM. (K)SDR ASAA0540207Skin · puncturedBOTTOM OF RUDDER IS PUNCTURED. COMPLIED WITH A BOND REPAIR IAW SRM. (K)SDR ASAA0440125Accessory Unit · inoperativeANC - FOUND THE TAKEOFF WARNING HORN SOUNDED WHEN THROTTLES ADVANCED TO TAKEOFF POWER. ABORTED TAKEOFF AT LESS THAN 50 KTS. REPLACED FLAP/SLAT ACCY UNIT. (M)SDR ASAA0240095Wire · disconnectedPDX - TRACK LIGHTS INOPERATIVE AT ROWS 21-24. RECONNECTED WIRES, OPS CHECKED NORMAL. (M)SDR ASAA0040052Snubber · inoperativeSEA - DURING MAINTENANCE CHECK, THE L1 DOOR SNUBBER WAS FOUND TO BE INOPERATIVE ALLOWING DOOR TO SLAM SHUT. REPLACED THE L1 DOOR SNUBBER AND THE DOOR OPERATED NORMALLY. (M)
Back to N795AS, cancelled Aug 17, 2016