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 ASAA11410136Skin · crackedFUSELAGE SKIN HAS A SUBSURFACE CRACK AT BS 727D+3 JUST BELOW STR 23R. ACCOMPLISHED FUSELAGE SKIN REPAIR PER ASA ER 11 03655 ASA EA 400 533A 06137.SDR ASAA11410053Keelbeam · corrodedCORROSION LT W/W LT KEEL BEAM HAS CORROSION AT SURROUNDING AREAS OF NUT PLATES FROM BS 674 BS 727 WL 148 (LOWER SURFACE OF LOWER CHORD). REMOVED NUT PLATES BLENDED CORROSION. DAMAGE ALL WITHIN LIMITS. REFINISHED SURFACES AND REPLACED NUT PLATES PER B737 400SDR ASAA11410048Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD IS CRACKED AT BS 665 BL 0 WL 208. REPAIRD LONGITUDINAL FLOORBEAM UPPER CHORD PER ASA EA 400 57EA 06079.SDR ASAA11410013Floor Support · crackedFLOOR SUPPORT IS CRACKED AT BS 359 BL 0 WL 208. REMOVED AND REPLACED INTERCOSTAL PER B737 400 SRM 51 40 02.SDR ASAA0945922Battery Pack · dischargedEMERGENCY EXIT LIGHTS AT AFT ENTRY DOOR AND AFT CEILING GO ON FOR TWO SECONDS AND THEN OFF. REPLACED M1197 BATTERY PACK REF MM 33 51 51, OPS NORMAL PER SAME.SDR ASAA0944252Guide Arm · looseL1 DOOR HARD TO OPEN & CLOSE. FOUND L 1 DOOR GUIDE ARM LOOSE & OUT OF ADJUSTMENT. R&R GUIDE ARM & ADJUSTED REF. AMM 52 11 21 004 404 007 015 B00. L 1 DOOR STILL HARD TO CLOSE REMOVED DOOR LINER & ADJUSTED HORZ ROD & ALL DOOR STOP PINS REF. AMM 52 11 21 004SDR ASAA0843914Stringer Clip · crackedSTRINGER CLIP CRACKED. REPLACED CLIP PER ASA DWG A53100265816.SDR ASAA0843859Intercostal · crackedINTERCOSTAL CRACKED AND FASTENER HOLES STA 380-400. REMOVED CORRODED INTERCOSTAL INSTALLED REPLACEMENT INTERCOSTAL IAW SRM 51-40-2.SDR ASAA0843917Stringer Clip · crackedSTRINGER CLIP CRACKED. REPLACED CLIP PER ASA DWG A53100265816.SDR ASAA0843915Stringer Clip · crackedSTRINGER CLIP CRACKED. REPLACED CLIP PER ASA DWG A53100265816.SDR ASAA0843912Stringer Clip · crackedSTRINGER CLIP CRACKED. REPLACED CLIP PER DWG A53100265816.SDR ASAA0843831Strap · crackedFLOORBEAM STABILIZER STRAP BROKEN/CRACKED. REMOVED CRACKED SECTION OF STRAP FABRICATED REPAIR FILLER AND STRAP INSTALLED FILLER AND STRAP IAW SRM 51-70-13 FIG 1.SDR ASAA0843919Skin · delaminatedLEFT WING OUTBOARD AFT FLAP TE IS DELAMINATED AT INBOARD CORNER. REMOVED DELAMINATED SECTION. INSTALLED FILLER DOUBLER AND BONDED REPAIR PER SRM 51-70-10.SDR ASAA0843858Intercostal · corrodedINTERCOSTAL CORRODED STA 747 767 STR 26R. REMOVED CORRODED INTERCOSTAL INSTALLED REPLACEMENT INTERCOSTAL IAW SRM 51 40 2.SDR ASAA0843821Intercostal · corrodedAFT CARGO PIT CORRODED INTERCOSTAL STA 787 TO STA 793 STR 26R AREA. REMOVED DAMAGED INTERCOSTAL, LOCATED, DRILLED AND INSTALLED REPLACEMENT INTERCOSTAL IAW SRM 51-40-02 AND 51-40-05.SDR ASAA0843810Skin · dentedNUMEROUS DENTS ON LT OTBD TE OF AFT FLAP LOWER SURFACE. PREPPED DAMAGED AREA FABRICATED AND INSTALLED REPAIR AND DOUBLER AND FILLER IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0843795Skin · dentedLT OTBD AFT FLAP LOWER SURFACE DENTED PREPPED AREA FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0843775Stringer Clip · corrodedSTRINGER CLIP IS CORRODED. REPLACED CLIP PER SRM 51-40-02 AND DWG 69-35352 B.SDR ASAA0843814Skin · delaminatedNR 5 SPOILER INSERTS CORRODED/SKIN DELAMINATED. REMOVED DAMAGED AREA FABRICATED AND INSTALLED REPAIR FILLERS AND DOUBLERS IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0843782Skin · dentedNUMBER 5 SPOILER LOWER SURFACE DENTED. REMOVED DAMAGED AREA AND INSTALLED REPAIR FILLER AND DOUBLER PER SRM 51 70 10.SDR ASAA0843776Splice Plate · corrodedL1 DOOR CUTOUT INNER CHORD SPLICE PLATE IS CORRODED. REPLACED SPLICE PLATE PER SRM 51 40 05.SDR ASAA0843715Skin · crackedCRACK IN LT ELEVATOR UPPER SKIN O/B OF TAB CONTROL ROD. REMOVED DAMAGED AREA OF SKIN, PREPPED AREA AND REPAIR, INSTALLED REPAIR PLIES IAW 737 400 SRM 51 70 10 REPAIR 1.SDR ASAA0843833Skin · chafedRT INBD MID FLAP T/E WEDGE CHAFED. REMOVED AND REPLACED T/E WEDGE IAW B737 400 SRM 51 40 02.SDR ASAA0843722Skin · dentedNR 4 SLAT T/E WEDGE UPPER SURFACE IS DENTED. PREPPED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR AND DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA0843861Skin · chafedRT OB MID FLAP TE SKIN IS CHAFED. REMOVED DAMAGED AREA FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW B737 400 SRM 51 70 10 REPAIR GENERAL.SDR ASAA0843809Frame · crackedRT FUSELAGE INNER FRAME CHORD CRACKED AT STA 616. REMOVED CRACKED SECTION FABRICATED AND INSTALLED FILLER AND STIFFENER ANGLE IAW ASA EO 5310 02528.SDR ASAA0843811Skin · delaminatedNR 3 SLAT T/E WEDGE DELAMINATED AT INBD AND OTBD ENDS. PREPPED DELAMINATED AREAS FABRICATED AND INSTALLED REPAIR CORE FILLER AND DOUBLER IAW SRM 51-70-10 REPAIR 4.SDR ASAA0843913Frame · crackedLT FUSELAGE FRAME INNER CHORD CRACKED AT STA 616. REMOVED DAMAGE FABRICATED AND INSTALLED REPAIR FILLER AND STIFFENING ANGLE IAW EO 5310 02528.SDR ASAA0843921Bear Strap · crackedL1 DOOR LOWER HINGE CUTOUT SKIN AND BEARSTRAP CRACKED REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR TRIPLER, REPAIR DOUBLER, REPAIR FILLERS, STRUCTURAL FILLER IAW ASA EA 400-53EA-00284.SDR ASAA0843918Bear Strap · crackedL1 DOOR UPPER HINGE CUTOUT SKIN AND BEARSTRAP CRACKED. REMOVED DAMAGE FABRICATED AND INSTALLED BEARSTRAP FILLER REPAIR DOUBLER REPAIR FILLER IAW ASA EA 400 53EA 00284.SDR ASAA0843882Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION INSTALLED REPAIR ANGLES AND FILLERS PER ASA EA 400 53EA 00267.SDR ASAA0843808Frame · corrodedFRAME AT STA 500D IS CORRODED. REMOVED CORROSION FABRICATED AND INSTALLED REPAIR ANGLE AND FILLER IAW SRM 51-70-11 REPAIR 2.SDR ASAA0843777Floorbeam · corrodedFLOORBEAM CORRODED. REPLACED BEAM CHORD PER SRM 51 40 02.SDR ASAA0843746Intercostal · crackedCRACKED INTERCOSTAL AT STA 277. REMOVED CRACKED INTERCOSTAL, INSTALLED NEW INTERCOSTAL IAW B737 400 SRM 51 40 02.SDR ASAA0843719Shear Tie · gougedSHEAR TIE STA 303.1 STR 15L IS GOUGED. REMOVED DAMAGED SHEAR TIE, FABRICATED AND INSTALLED REPLACEMENT SHEAR TIE IAW B737 400 SRM 51 30 01 AND BOEING DRAWING 65 17684.SDR ASAA0843717Web · damagedRT SHEAR WEB IS SCRATCHED STA 755. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR DOUBLER IAW B737 400 SRM 51 70 13.SDR ASAA0843926Frame · crackedFRAME CRACKED STA 867 STR 8 9L. CUTOUT DAMAGE FABRICATED AND INSTALLED REPAIR ANGLES AND FILLER IAW ASA EA 400 53EA 00267.SDR ASAA0843925Frame · crackedFRAME CRACKED STA 787 STR 8 9L. CUTOUT DAMAGE FABRICATED AND INSTALLED REPAIR ANGLES AND FILLER IAW ASA EA 400 53EA 00267.SDR ASAA0843911Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400-53EA-00267.SDR ASAA0843909Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400-53EA-00267.SDR ASAA0843908Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400-53EA-00267.SDR ASAA0843907Frame · crackedFRAMED CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400-53EA-00267.SDR ASAA0843905Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400 53EA 00267.SDR ASAA0843895Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400 53EA 00267.SDR ASAA0843894Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER EA 400 53EA 00267.SDR ASAA0843893Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400 53EA 00267.SDR ASAA0843892Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400-53EA-164.SDR ASAA0843891Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER EA 400 53EA 00267.SDR ASAA0843902Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER EA 400 53EA 00267.SDR ASAA0843901Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER EA 400-53EA-00267.
Back to N760AS