N760AS
Service difficulty reports not matched to an aircraft · 283
They name N760AS, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. 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 = 'N760AS' AND registry_match IS NULL 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 = 'N760AS' AND registry_match IS NULL 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 ASAA0843768Skin · dentedNUMBER 8 SPOILER HAS PROTRUDING DENT ON UPPER SURFACE. REMOVED DAMAGED AREA. INSTALLED REPAIR DOUBLER PER SRM 57 70 01.SDR ASAA0843767Skin · dentedNUMBER 9 SPOILER UPPER SURFACE IS DENTED. INSTALLED REPAIR DOUBLER PER SRM 51 70 10.SDR ASAA0843723Skin · dentedNR 4 SPOILER HAS DENTS ON LOWER SURFACE IN LINE WITH ACTUATOR. PREPPED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR AND DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0843716Skin · puncturedRT WING I/B FORE FLAP LOWER SURFACE HAS VARIOUS DENTS WBL 73-93. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR SKIN AND DOUBLER IAW B737 400 SRM 51 70 10.SDR ASAA0843916Skin · dentedAFT CARGO DOOR HAS DENT ON EXTERNAL SKIN DOUBLER REMOVED AND REPLACED AFT CARGO DOOR IAW B737 400 AMM 52 31 404 022 B00.SDR ASAA0843829Skin · dented33 SPOILER UPPER SURFACE HAS DENT. PREPPED DAMAGED AREA FABRICATED AND INSTALLED REPAIR AND DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA0843747Skin · dentedBELOW AFT CARGO DOOR LARGE DENTS. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR DOUBLER AND TRIPLER IAW B737 400 SRM 53 00 01 REPAIR 31.SDR ASAA0742354Skin · damagedWATER SERVICE TRUCK PULLED AWAY FROM AIRCRAFT WITH THE HOSE CONNECTED TO SERVICE PANEL RIPPING OUT NIPPLE AND PAN ATTACHMENT. REMOVED AND REPLACED PAN AND ASSOCIATED FITTING IAW SRM 51-40-02 & EA5330 02272.SDR ASAA0741928Intercostal · crackedINTERCOSTAL CRACKED. REPLACED INTERCOSTAL IAW EA 5310 02729.SDR ASAA0741929Attach Angle · crackedINTERCOSTAL O/B FLANGE ATTACHMENT ANGLE CRACKED. INTERCOSTAL ATTACHMENT ANGLE REPAIRED IAW ERO 6993 AND EA 5310 02729. REPAIR TO BE INSPECTED PER ASA DWG A 5310023893 EVERY 6000 FLT CYCLES.SDR ASAA0741878Skin · gougedTHREE INCH GOUGE AT FUSELAGE SKIN. REPAIRED GOUGE IAW SRM 53-00-01 FIG 201 REPAIR 31.SDR ASAA0741877Shear Tie · crackedBODY FRAME TO SKIN ATTACHMENT SHEAR TIE CRACKED. SHEAR TIE REPLACED WITH MADE REPAIR PART IAW SRM 51-40-05.SDR ASAA0741875Skin · delaminatedNR 5 SLAT TRAILING EDGE DELAMINATED ON O/B END. NR 5 SLAT TRAILING EDGE DELAMINATION AT O/B END REPAIRED IAW SRM 51-70-10.SDR ASAA0741930Intercostal · crackedINTERCOSTAL WEB CRACKED. INTERCOSTAL WEB REPLACED IAW ERO 6993 AND EA 5310 02729. REPAIR TO BE INSPECTED PER ASA DWG A 5310023893.SDR ASAA0741642Bearing · erodedCATERING REPORTED THE L1 DOOR INOPERABLE. FERRIED TO SEA, REMOVED AND REPLACED R1 DOOR PER AMM.SDR ASAA0741445Stop · wornR2 SLIDE PACK LOOSE. R2 SLIDE PACK LOWER ATTACH FITTING DOES NOT ENGAGE FITTING ON DOOR. REMOVED AND REPLACED R2 SLIDE ASSY PER MM 25-61-35. REMOVED AND REPLACED R2 DOOR LINER ASSY PER MM 52-41-31. SHIMMED R2 DOOR SLIDE SUPPORT ASSY STOP EO 2560 01395. SLSDR ASAA0641124Fan · unknownEXITING COCKPIT THE F/O FOUND THE LT CABIN RECIRCULATION FAN CKT BKR OPEN OUT. REPLACED RECIRCULATION FAN WIRING AND RELAYS AT J 20 BOX IAW LOG PGS 6198774 AND 6198776 AS A PRECAUTIONARY MEASURE.SDR ASAA0640819Frame · dentedFOUND AFT CARGO FRAME DENTED. REPAIRED WITH FABRICATED REPAIR PART PER SRM 51 70 11.SDR ASAA0640818Skin · gougedFOUND RT OB AFT FLAP LE GOUGED. REPAIRED PER SRM 57 43 01 FIG 201.SDR ASAA0640817Frame · corrodedFOUND CORROSION ON FRAME REPAIRED FRAME PER SRM 53 00 07.SDR ASAA0640816Floorbeam · corrodedFOUND FLOORBEAM CORRODED. REPLACED FLOORBEAM PER EA 5310 01697.SDR ASAA0640815Frame · corrodedFOUND SKIN TO FRAME ATTACH ANGLE CORRODED AT BS 520 BETWEEN STR 27R AND 28R. ATTACH ANGLE REPLACED IAW SRM 51 30 01 53 00 07 AND 51 40 02.SDR ASAA0640814Frame · corrodedFOUND SKIN TO FRAME ATTACH ANGLE CORRODED AT BSTA 520 BETWEEN STR 27R AND 28R. ATTACH ANGLE REPLACED IAW SRM 51 30 01 5300 07 AND 51 40 02.SDR ASAA0640813Frame · corrodedFOUND FWD CARGO PIT FRAME TO SKIN AT BSTA 500C CORRODED. FRAME TO SKIN ATTACHMENT REPAIRED PER SRM 53 00 07.SDR ASAA0640812Frame · corrodedFOUND FWD CARGO FRAME TO SKIN AT BSTA 500C CORRODED. REPAIRED PER SRM 53 00 07.SDR ASAA0640811Frame · corrodedFOUND FWD CARGO PIT FRAME TO SKIN AT BSTA 500B CORRODED. REPAIRED PER SRM 53 00 07.SDR ASAA0640810Frame · dentedFOUND AFT CARGO FRAME DENTED. REPAIRED WITH FABRICATED PART IAW SRM 51 70 11.SDR ASAA0640809Skin · chafedRT PYLON IB SKIN CHAFED AT LE. REPAIRED PER EA 5430 01150.SDR ASAA0640222Guide · out of adjustL1 DOOR WILL NOT CLOSE FROM THE INSIDE UNLESS THE AFT PART OF THE DOOR IS PUSHED OUTBD WHILE CLOSING. REMOVED AND REPLACED BOTTOM GUIDE PLATE PER AMM 52 11 00 PG 407-408.SDR ASAA0440103Rib · crackedGYR - FOUND WING RIB LOWER CHORD IS CRACKED APPROXIMATELY .5 INCH LONG, CHORD TO SKIN ATTACH TEE AFT OF STRINGER. REPLACED DAMAGED RIB LOWER CHORD. (M)SDR ASAA0440094Skin · dentedGYR - FOUND DENT IN FUSELAGE SKIN, AF6 OF L-1 DOOR 8 FEET ABOVE VERTICAL. REPAIRED DENT IN FUSELAGE STATION 360 TO 380, STRINGER 17L AND 18L REF SRM 53-00-01 FIG 201. (M)SDR ASAA0440095Attach Fitting · corrodedGYR - FOUND ATTACH FITTING CORRODED. REPLACED ATTACH FITTING. (M)SDR ASAA0440097Floorbeam · corrodedGYR - FOUND MAIN DECK FLOORBEAM UPPER T-CAP STATION 360 HAS NUMEROUS AREAS OF CORROSION ON UPPER SURFACE. REPAIRED FLOORBEAM. (M)SDR ASAA0440090Shear Tie · corrodedGYR - FOUND FORWARD CARGO COMPARTMENT, STATION 520 RBL 3, LOWER FRAME SHEAR TIE 100 PERCENT EXFOLIATED. FABRICATED AND INSTALLED 65-46534-9 SHEAR TIE. (M)SDR ASAA0440096Floorbeam · corrodedGYR - FOUND MAIN DECK FLOORBEAM STATION 294.5 HAS CORROSION FROM LBL 12 TO RBL 50. REPAIRED FLOORBEAM T-CAP CHORD. (M)SDR ASAA0440092Crease Beam · corrodedGYR - FOUND R1 DOOR THRESHOLD CREASEBEAM AT STATION 294.5 APPROX RBL 55, CORRODED IN NUMEROUS AREAS OF UPPER SURFACE. REMOVED AND REPLACED R-1 DOOR THRESHOLD CHORD STATION 262 TO 380 RBL 55 PER SRM 51-40-02. (M)SDR ASAA0440093Floorbeam · corrodedGYR - FOUND MAIN DECK FLOORBEAM AT FS 294.5 APPROX LBL 12 TO RBL 50, UPPER T-CAP HAS SEVERAL AREAS OF CORROSION ON UPPER SURFACE. BLENDED CORROSION CK OUT OF LIMITS. REMOVED 'T' AND FABRICATED NEW 'T' AND INSTALLED 'T' AND REPAIR ANGLE PER SRM 53-10-51. (M)SDR ASAA0440086Floorbeam · corrodedGYR - MAIN DECK FLOORBEAM AT STATION 294.5 APPROX LBL 12 TO RBL 50, UPPER T-CAP HAS SEVERAL AREAS OF CORROSION ON UPPER SURFACE. BLENDED CORROSION CK OUT OF LIMITS. REMOVED 'T' AND REPAIR ANGLE EPR SRM 53-10-51. (M)SDR ASAA0440087Crease Beam · corrodedGYR - FOUND R1 DOOR THRESHOLD CREASEBEAM AT STATION 294.5 APPROX RBL 55, CORRODED IN NUMEROUS AREAS OF UPPER SURFACE. REMOVED AND REPLACED R1 DOOR THRESHOLD CHORD STATION 262 TO 380 RBL 55 PER SRM 51-40-02. (M)SDR ASAA0440079Shear Tie · corrodedGYR - FOUND FORWARD CARGO COMPARTMENT, STATION 520 RBL 3, LOWER FRAME SHEAR TIE 100 PERCENT EXFOLIATED. FABRICATED AND INSTALLED 65-46534-9 SHEAR TIE. (M)SDR ASAA0240016Floorbeam · corrodedPAE - DURING C-CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 45 TO RBL 25 AND WL 207. REPAIRED IAW SRM. (M)SDR ASAA0240014Channel · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY DOOR CUTOUT STRUCTURE U-CHANNEL HAS AREAS OF CORROSION BS 796-847, RBL 28 AND WL 155. REPAIRED IAW SRM. (M)SDR ASAA0240020Stringer · corrodedPAE - DURING C-CHECK, FOUND CORROSION AT BS 520 STRINGER 27R AND WL 148.5 FORWARD CARGO BAY. REPAIRED IAW SRM. (M)SDR ASAA0240015Skin · corrodedPAE - DURING C-CHECK, FOUND FUSELAGE SKIN CORRODED ON INTERIOR SKIN AT BS 500F, WL 149 AND STRINGER 27R. REPAIRED IAW SRM. (M)SDR ASAA0140004Wire · brokenSEA - DURING PREFLIGHT, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE. REPLACED BROKEN WIRES OPERATIONAL CHECKED NORMAL. (M)SDR ASAA0040130Wire · disconnectedPDX-FOUND EMERGENCY TRACK LIGHTS INOP AT ROW 18-19, DISCONNECTED.RECONNECTED TRACK LIGHTS, OPERATION CHECKED NORMAL, NO DEFECTS NOTED.SDR ASAA0040117Bulkhead · gougedSEA-DURING MAINTENANCE CHECK FOUND, FWD CARGO PIT LT, RT, AND CTR BULKHEAD PANEL GOUGED. REPAIRED I.A.W. EA 2550-01093.SDR ASAA0040108Wire · brokenPDX - PRIOR TO FLIGHT 95, THE MID CABIN EMERGENCY TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. REPAIRED BROKEN WIRE AT MODULE M1388 AND THE LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040062Handle · lack of lubePDX - DURING MAINTENANCE CHECK, THE R-1 DOOR WAS DIFFICULT TO OPEN. LUBED DOOR HANDLE MECHANISM AND THE DOOR OPERATED NORMALLY. (X)SDR ASAA0040048Door · out of rigPDX - PRIOR TO FLIGHT 712, THE L1 DOOR WAS DIFFICULT TO CLOSE. LUBRICATED AND RIGGED L1 DOOR, DOOR OPERATED NORMALLY. (M)
Back to N760AS