N706AS, cancelled May 8, 2017
Service difficulty reports · 179
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 = 'N706AS' AND deregistration_id = 'N706AS-2017-05-08' 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 = 'N706AS' AND deregistration_id = 'N706AS-2017-05-08' 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 ASAA0741693Frame · corrodedAFT CARGO PIT FRAME DOUBLER FOUND CORRODED. FRAME REPLACED WITH NEW PART IAW SRM 51-40-05.SDR ASAA0640456Floorbeam · corrodedFOUND FLOORBEAM CORRODED AROUND NUTPLATE HOLES. REMOVED COMPLETE UPPER TEE HORIZONTAL FLANGE FABRICATED AND INSTALLED UPPER TEE SPLICE ANGLES STRAPS FILLERS AND SHEAR TIES IAW ASA EA 5310 02615.SDR ASAA0640455Floorbeam · corrodedFOUND FLOORBEAM HAS CORROSION AROUND NUTPLATE HOLES. REMOVED COMPLETE UPPER TEE HORIZONTAL FLANGE FABRICATED AND INSTALLED UPPER TEE SPLICE ANGLES SPLICE STRAPS FILLERS AND SHEAR TIES PER ASA EA 5310 02615.SDR ASAA0640450Cargo Track · damagedFOUND LT CARGO TRACK TIE DOWN LUG MISSING JUST FWD OF BSTA 500. REMOVED DAMAGED SECTION OF TRACK FABRICATED AND INSTALLED REPLACEMENT SECTION OF TRACK IAW ASA EA 5310 02614.SDR ASAA0640448Doubler · crackedFOUND RT HORIZONTAL STAB LE BONDED DOUBLER IS CRACKED AT LE. REMOVED DAMAGE FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW ASA EA 5510 01236.SDR ASAA0640449Skin · damagedNR 1 SLAT DAMAGED IN 2 PLACES ON UPPER SIDE. REMOVED DAMAGED AREAS FABRICATED AND INSTALLED REPAIR PIECES IAW SRM 51 70 10.SDR ASAA0640413Structure · delaminatedNR 2 SLAT DELAMINATED AT OB TE. REMOVED DAMAGED AREA FABRICATED AND INSTALLED REPAIR PIECES PER SRM 51 70 10.SDR ASAA0640412Frame · leakingFOUND RUDDER T/E HAS LIGHTING STRIKE 10" FROM TOP ON LT SIDE. REMOVED DAMAGED CONDUCTIVE FRAME FABRICATED AND INSTALLED REPLACEMENT CONDUCTIVE FRAME PER SRM.SDR ASAA0640387Skin · dentedLT VERTICAL STABILIZER LE HAS GROUP OF DENTS AT STAB STA 90. CUT OUT DAMAGE FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW SRM 55 10 01 FIG 201 REPAIR 2.SDR ASAA0640388Skin · delaminatedLT OB AFT FLAP TE REPAIR AT IB END DELAMINATED. REMOVED PREVIOUS REPAIR PREPPED AREA FABRICATED AND INSTALLED SKIN AND DOUBLER PIECES IAW SRM 51 70 10.SDR ASAA0640386Sill · corrodedFOUND R2 DOOR LOWER SILL INNER CHORD IS CORRODED. REMOVED CORRODED INNER CHORD INSTALLED NEW INNER CHORD IAW SRM 51 40 02 AND 51 40 05.SDR ASAA0640385Sill · corrodedFOUND L2 DOOR LOWER SILL INNER CHORD IS CORRODED. REMOVED CORRODED INNER CHORD INSTALLED NEW INNER CHORD PER SRM 51 40 02 AND 51 40 05.SDR ASAA0640374Sill · corrodedFOUND R2 DOOR LOWER SILL INNER CHORD IS CORRODED. REMOVED CORRODED INNER CHORD INSTALLED NEW INNER CHORD IAW SRM 51 40 02 AND 51 40 05.SDR ASAA0640320Structure · crackedFOUND LT ELEVLATOR TAB NR 1 HINGE CUTOUT LE HAS MINOR CRACK. REPAIRED LT ELEVLATOR TAB IAW SRM 51 70 05 REPAIR 11.SDR ASAA0640319Attach Angle · corrodedFOUND R1 DOOR SURROUND FWD ATTACH ANGLE FROM LWR SILL TO 294.5 FRAME CORRODED. REMOVED CORRODED ANGLE FABRICATED AND INSTALLED ANGLE IAW SRM 51 40 02.SDR ASAA0640318Sill · corrodedFOUND L1 DOOR CUTOUT LOWER SILL INNER CHORD CORRODED. REMOVED CORRODED CHORD REPLACED WITH NEW CHORD IAW SRM 51 40 05.SDR ASAA0640278Frame · crackedFRAME IS CRACKED BETWEEN STRINGERS. REMOVED AND REPLACED FRAME SECTION IAW SRM 51-10-02.SDR ASAA0640277Frame · corrodedFRAME CORRODED. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM.SDR ASAA0540555Switch · failedPHX - AT 31,000 FEET AFTER 90 MINUTES IN CRUISE, PRESSURIZATION FAILED. AUTO THROTTLE AND TRANSPONDER FAILED AT SAME TIME. AUTO SPEED BRAKE WARNING LIGHT ILLUMINATED ALSO. REPLACED GROUND SAFETY SWITCH S-105, PER AMM 32-09-01. ALSO REFERENCE EA 3209-01001 SDR ASAA0540359Wedge · dentedLT IB MID FLAP AFT WEDGE HAS NUMEROUS DENTS. REMOVED DAMAGED AREA. FABRICATED AND INSTALLED FILLERS AND DOUBLERS AND INSTALLED REPAIR PIECES IAW SRM. (K)SDR ASAA0540358Skin · debondedLT OB AFT FLAP PREVIOUSLY INSTALLED REPAIR IS DEBONDING AT IB AFT CORNER. REMOVED DAMAGED AREA. FABRICATED AND INSTALLED FILLER AND DOUBLER AND INSTALLED REPAIR PIECES IAW SRM. (K)SDR ASAA0540357Skin · scratchedFWD CARGO DOOR SCRATCHED. REMOVED DAMAGE, FABRICATED AND INSTALLED DOUBLER IAW SRM. (K)SDR ASAA0540356Strap · corrodedAFT PIT FLOOR BEAM STRAP HAS CORROSION AS MARKED. REMOVED DAMAGED STRAP, INSTALLED NEW STRAP IAW SRM. (K)SDR ASAA0540355Web · corrodedAFT CARGO DOOR OPENING THRESHOLD WEB IS CORRODED. REMOVED AND REPLACED WEB ASSEMBLY IAW SRM. (K)SDR ASAA0540354Skin · dentedRT IB MID FLAP AFT WEDGE HAS NUMEROUS DENTS. REMOVED DENTED AREA OF LOWER SKIN, FABRICATED AND INSTALLED FILLERS AND DOUBLERS IAW SRM. (K)SDR ASAA0440137Nozzle · damagedFOUND LEFT NR 1 ENGINE EXHAUST NOZZLE AND PLUG ROTOR AND STATOR HAVE SUSTAINED SEVERE DAMAGE, RIPPED AND TORN BLADE SEGMENTS WITH MISSING MATERIAL. REMOVED AND REPLACED ENGINE PER T/C'S 4855400 AND 48571016. (M)SDR ASAA0440078Starter · failedOAK - FOUND INSPECTED NR 2 ENGINE, FOUND THE NR 2 STARTER HAD COME APART AND WAS DAMAGED. REMOVED AND REPLACED THE NR 2 ENGINE STARTER PER AMM. (M)SDR ASAA0140078Sliding Window · bindingSEA - DURING LINE CHECK, FOUND FIRST OFFICERS SLIDING WINDOW HARD TO OPEN AND CLOSE. REMOVED, REPLACED AND RIGGED, WINDOW IAW MM, OPS NORMAL. (M)SDR ASAA0140034Skin · puncturedPAE - DURING LINE CHECK, FOUND PUNCTURE IN SKIN AT BS 363 TO 371, WATER LINE 207 AND STRINGER 17L. REPAIRED IAW EA 5330-01509. (M)
Back to N706AS, cancelled May 8, 2017