N779AS, cancelled Mar 10, 2017
Service difficulty reports · 205
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 = 'N779AS' AND deregistration_id = 'N779AS-2017-03-10' 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 = 'N779AS' AND deregistration_id = 'N779AS-2017-03-10' 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 ASAA0640830Frame · crackedFOUND CRACKED FRAME WEB. REMOVED AND REPLACED FRAME PER SRM 51 40 02.SDR ASAA0640828Skin · dentedFOUND DENT IN FUSELAGE SKIN. REPAIRED PER EA 533 02125.SDR ASAA0640825Floorbeam · corrodedFLOORBEAM CORRODED. REPAIRED IAW SRM 53 10 51.SDR ASAA0640824Floorbeam · corrodedCORROSION ON UPPER FLANGE OF 986.5 FLOORBEAM. REPAIRED IAW EA 5310 02652.SDR ASAA0640823Skin · lightning strikePER EA 5330 1981 PERMINATE REPAIR REQUIRED TO LOCATION STATED ON LOGPAGE 5916421 W I 24 MONTHS OF THIS ENTRY DATE. REPAIRED PER EA 5330 02126.SDR ASAA0640826Skin · lightning strikeLIGHTING STRIKES ON SKIN AT CAPT'S NR 3 WINDOW LWR AFT CORNER. REPAIRED LIGHTING STRIKES ON SKIN AT CAPT'S NR 3 WINDOW CUT OUT LWR AFT CORNER.SDR ASAA0640822Frame · damagedELONGATED HOLES IN FRAME FLANGE. CUT OUT AND REMOVED 1.1 X .90 DAMAGED AREA ON FRAME UPPER FLANGE. FABRICATED AND INSTALLED REPAIR IAW SRM 51 70 11.SDR ASAA0640821Doubler · corrodedSKIN DOUBLER CORRODED. REMOVED AND REPLACED IAW SRM 51 40 02.SDR ASAA0640804Frame · crackedFOUND CRACK IN FRAME STRAP. REMOVED AND REPLACED FRAME STRAP PER SRM 51 40 02.SDR ASAA0640803Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM. REPAIRED PER ER 06 2584 AND EA 5310 02649.SDR ASAA0640802Frame · crackedFOUND CRACK IN FRAME. REPAIRED PER SRM 53 00 07.SDR ASAA0640801Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR ASAA0640797Failsafe · corrodedFOUND CORROSION ON FAIL/SAFE ANGLE. REPLACED PART PER SRM 51 40 02 AND DWG 65 47959.SDR ASAA0640796Frame · crackedCRACK IN FRAME FASTENER. REPAIRED FRAME PER SRM 53 00 07.SDR ASAA0640795Sill · corrodedFOUND CORROSION ON LT CREASE BEAM MOP SILL. REMOVED AND REPLACED MOPSILL PER SRM 51 40 02.SDR ASAA0640793Frame · corrodedFOUND CORROSION ON FRAME. REPAIRED PER SRM 53 00 07.SDR ASAA0640792Failsafe · corrodedFOUND CORROSION ON FAIL/SAFE. REPAIRED PER SRM 51 70 11.SDR ASAA0640791Frame · puncturedFOUND UPPER FRAME FLANGE PUNCTURED. CUT OUT DAMAGE AND INSTALLED REPAIR PER SRM 51 70 11.SDR ASAA0640786Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. CUT OUT DAMAGE AND INSTALLED REPAIR PER SRM 53 00 07.SDR ASAA0640785Frame · crackedFOUND CRACK IN FRAME. REMOVED DAMAGE IN FRAME FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53 00 07.SDR ASAA0640784Shear Tie · corrodedFOUND CORROSION ON AFT SIDE OF SHEAR TIE. REPLACED SHEAR TIE PER SRM 51 40 02.SDR ASAA0640783Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. CUT OUT AND INSTALLED REPAIR PER SRM 53 60 07.SDR ASAA0640782Sill · corrodedCORROSION ON RT CREASE BEAM MOPSILL. REMOVED AND REPLACED CREASE BEAM MOPSILL PER SRM 51-40-02.SDR ASAA0640781Angle · tool damageFWD CARGO DOOR HAS TOOLING MARKS ON FWD INBD L ANGLE LOCATED AT DOOR DAMPNER MOUNT FITTING. BLENDED DAMAGE FOUND OUT OF LIMITS FABRICATED AND INSTALLED NEW L ANGLE PER SRM 51 30 01.SDR ASAA0640780Stringer Clip · corrodedSTRINGER CLIP CORRODED. REMOVED CORROSION FOUND OUT OF LIMITS REPLACED STRINGER CLIP PER SRM 53 00 07 AND 51 40 02.SDR ASAA0640779Shear Tie · corrodedSHEAR TIE CORRODED. REMOVED DAMAGED SHEAR TIE FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53 00 07.SDR ASAA0640778Shear Tie · corrodedCORROSION ON SHEAR TIE. BLENDED FOUND OUT OF LIMITS REMOVED DAMAGE FABRICATED NEW SHEAR TIE AND INSTALLED PER SRM 53 00 07.SDR ASAA0640776Shear Tie · corrodedCORROSION ON SHEAR TIE. REPAIRED PER SRM 53 00 07 REPAIR 3.SDR ASAA0640775Shear Tie · corrodedCORROSION ON SHEAR TIE. FABRICATED AND INSTALLED SHEAR TIE PER SRM 53 00 07.SDR ASAA0640770Shear Tie · corrodedCORROSION ON SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR ASAA0640774Floorbeam · corrodedWHILE WORKING FOUND BSTA 360 FLOORBEAM CORRODED AROUND NUT PLATES. REPAIRED FLOORBEAM IAW SRM 53-00-51.SDR ASAA0640773Sill · corrodedCORROSION ON MOPSILL. REMOVED AND REPLACED PER SRM 51 40 02.SDR ASAA0640772Strap · corrodedCORROSION ON REINFORCEMENT STRAP. REMOVED AND REPLACED STRAP PER SRM 51 40 02.SDR ASAA0640771Shear Tie · corrodedCORROSION ON SHEAR TIE. FABRICATED AND INSTALLED SHEAR TIE PER SRM 53 00 07.SDR ASAA0640769Shear Tie · corrodedCORROSION ON SHEAR TIE. FABRICATED AND INSTALLED SHEAR TIE PER SRM 53-00-07.SDR ASAA0640766Doubler · corrodedWHILE WORKING FOUND CORROSION ON INTERNAL DOUBLER AT BSTA 794. REMOVED AND REPLACED INTERNAL DOUBLER PER SRM 53 00 04.SDR ASAA0640764Shear Tie · corrodedFOUND CORROSION ON FWD SIDE OF FRAME. REMOVED AND REPLACED SHEAR TIE PER SRM 53 00 07.SDR ASAA0640763Sill · corrodedFOUND CORROSION ON L 1 MOPSILL CORRODED UPPER AND LOWER SURFACES. REMOVED AND REPLACED MOPSILL L 1.SDR ASAA0640762Channel · corrodedFOUND CORROSION ON FWD ENTRY DOOR SUB THRESHOLD "U" AND "Z" CHANNELS UPPER AND LOWER SURFACES. REMOVED AND REPLACED "U" AND "Z" CHANNELS PER SRM 51 40 02.SDR ASAA0640761Frame · dentedFOUND FWD CARGO COMPARTMENT UPPER FLANGE DENTED. REPAIRED FRAME PER SRM 51 70 11.SDR ASAA0640760Shear Tie · corrodedFOUND CORROSION ON FWD SIDE OF SHEAR TIE. REMOVED AND REPLACED SHEAR TIE PER SRM 53 00 07.SDR ASAA0640758Tee Fitting · corrodedWHILE WORKING FOUND RT UPPER APU TORQUE BOX STRINGER CORRODED. REMOVED AND REPLACED RT UPPER APU TORQUE BOX STRINGER PER SRM 51 40 02.SDR ASAA0640757Tee Fitting · corrodedAPU COMPARTMENT CORROSION ON TEE FITTING AT FWD APU AIR INLET CUTOUT. REMOVED AND REPLACED T CHORD AT FWD APU AIR INLET CUTOUT PER SRM 51 40 02.SDR ASAA0640756Stringer · corrodedWHILE WORKING FOUND RT LOWER APU TORQUE BOX STRINGER CORRODED. REMOVED AND REPLACED RT LOWER APU TORQUE BOX STRINGER PER SRM 51 40 02.SDR ASAA0640755Tee Fitting · corrodedAPU COMPT CORROSION ON TEE FITTING AT AFT APU AIR INLET CUTOUT. REPLACED T CHORD AT AFT APU AIR INLET PER SRM 51 40 02.SDR ASAA0640754Frame · dentedFOUND FWD CARGO COMP FRAME UPPER FLANGE IS DENTED. CUT OUT DAMAGED SECTION OF FRAME 2" BY 6.2" FROM ORIGINAL THICKNESS OF .050". INSTALLED REPAIR PARTS AND REFINISHED PER SRM 53 00 07.SDR ASAA0640170Arm · wornL1 DOOR DOES NOT CLOSE PROPERLY. HANDLE DOES NOT FULLY LATCH DOWN WHEN CLOSING DOOR, HANDLE JAMS. FOUND L1 DOOR FWD LOWER ROLLER ARM GOUGED. GOUGE CAUSED BY WORN UPPER AND LWR HINGE ARMS MAKING DOOR SAG AND ROLLER ARM IMPACT GUIDE PLATE.SDR ASAA0540428Skin · puncturedRT IB FORE FLAP LWR SKIN PUNCTURED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR FILLERS AND DOUBLERS IAW SRM. (K)SDR ASAA0540427Wedge · dentedRT IB MID FLAP T/E WEDGE 7420R HAS SEVERAL DINGS. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR FILLERS AND DOUBLERS IAW SRM. (K)SDR ASAA0540426Skin · dentedLT IB FORE FLAP DENTED, DELAMINATED ON LOWER SKIN AT CENTER TRACK. REMOVED DAMAGE, FABRICATED AND INSTALLED SKIN SECTION AND DOUBLER IAW SRM. (K)
Back to N779AS, cancelled Mar 10, 2017