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 ASAA11410356Guide Arm · out of adjustL1 DOOR WILL NOT LATCH CLOSED. UPON INSPECTION FOUND JAM NUT BACKED OFF OF GUIDE ARM. ADJUSTED L1 DOOR GUIDE ARM REF MM 52 11 00 705 007 STEPS G.(1) (2)(C). DOOR FLUSHNESS AND DOOR CLEARANCE CHECKED GOOD REF MM 52 11 00 705 007 FIGURE 503. PERFORMED FORWARSDR ASAA1149264Trans Panel · corrodedAFT CARGO LT TRANSITION PANEL CORRODED BETWEEN BS 727B AND 727C. REPAIRED TRANSITION PANEL IAW B737 400 SRM 53 60 53 FIG 201 REPAIR 4.SDR ASAA1149263Channel · corrodedAFT PIT LT ZEE CHANNEL CORRODED SEVERAL AREAS FROM SPLICE AFT OF BS 787 TO BS 867. REPAIRED LT ZEE CHANNEL IAW B737 400 SRM 53 60 53 FIG 201 REPAIR 4.SDR ASAA1149258Shear Tie · corrodedCORROSION AT FRAME BS 727E SHEAR TIE STR 27R TO STR 27L. REPAIRED FRAME SHEAR TIE IAW B737 400 SRM 53 00 07 FIG 201 REPAIR 3.SDR ASAA1149257Web · corrodedCORROSION ON WEB AT BS 992 TO BS 1006 RBL 40. REMOVED WEB FABRICATED REPLACEMENT PART AND INSTALLED IAW B737 400 SRM 51 40 02 AND 51 40 05.SDR ASAA1149256Shear Tie · corrodedAFT PIT SHEAR TIE AT BS 787 BETWEEN STR 27R AND 25R CORRODED. REPAIRED SHEAR TIE IAW B737 400 SRM 53 00 07 FIG 201 REPAIR 3.SDR ASAA1149255Shear Tie · corrodedSHEAR TIE BS 787 STR 25R TO 26R CORRODED. REPAIRED SHEAR TIE IAW B737 400 SRM 53 00 07 FIG 201 REPAIR 3.SDR ASAA1149254Angle · corrodedAFT GALLEY FLOOR SUPPORT "Z" ANGLE AT BS 992 RBL 42 CORRODED. REMOVED CORRODED ANGLE FABRICATED AND INSTALLED REPLACEMENT PART IAW B737 400 SRM 51 40 05.SDR ASAA1149267Bracket · corrodedL1 DOOR GIRT BAR RECEPTACLE FLOOR FITTING SUPPORT CORRODED BS 344 LBL 56. REMOVED AND REPLACED BRACKET IAW B737 400 AMM 20 50 11 912 002.SDR ASAA1149265Bracket · corrodedL1 DOOR GIRT BAR RECEPTACLE FLOOR FITTING SUPPORT CORRODED BS 313 LBL 56. REMOVED AND REPLACED BRACKET IAW B737 400 AMM 20 50 11 912 002.SDR ASAA1149260Angle · corrodedAFT PIT FAIL SAFE CORRODED AFT SIDE BS 794 BETWEEN STR 25R AND 26R. REMOVED ANGLE FABRICATED REPLACEMENT PART AND INSTALLED IAW B737 400 SRM 51 40 02 AND 51 40 05.SDR ASAA1149266Channel · corrodedAFT PIT TRANSITION PANEL AFT OF DOOR OPENING FROM BS 847 TO BS 867 ALONG STR 25R CORRODED. REMOVED AND REPLACED TRANSITION PANEL IAW B737 400 SRM 51 40 02.SDR ASAA1149259Web · corrodedCORROSION ON WEB BS 992 TO BS 1006 RBL 40. REMOVED WEB FABRICATED REPLACEMENT PART AND INSTALLED IAW B737 400 SRM 51 40 02 AND 51 40 05.SDR ASAA1149268Angle · crackedLEFT WING STIFFENER JUST FORWARD OF THE NR 2 AILERON HINGE IS CRACKED APPROX RSS543. REMOVED AND REPLACED STIFFENER IAW B737 400 SRM 51 40 02.SDR ASAA1149181Skin · dentedLT HORIZONTAL STABILIZER LEADING EDGE DENTED. DENT IS 5 IN. L X 2.25 IN W X .052 IN DEEP. REMOVED DAMAGED SECTION FABRICATED REPAIR PARTS AND INSTALLED IAW B737 400 SRM 55 10 01.SDR ASAA1149262Web · corrodedAT R2 DOOR MOPSILL FOUND CORRODED WEB BS 947 TO BS 986 RBL 40. REMOVED WEB FABRICATED REPLACEMENT PART AND INSTALLED IAW SRM 51-40-02 AND 51-40-05.SDR ASAA1149261Web · corrodedR2 DOOR MOPSILL FOUND CORRODED ON WEB BS 986 TO BS 992 RBL 40. REMOVED WEB FABRICATED REPLACEMENT PART AND INSTALLED IAW SRM 51-40-02 AND 51-40-05.SDR ASAA1149229Sill · corrodedL2 DOOR MOP SILL WEB AT BS 966 TO BS 992 LBL 40 IS CORRODED. REMOVED WEB FABRICATED REPLACEMENT PART AND INSTALLED IAW B737 400 SRM 51 40 02.SDR ASAA1149228Sill · corrodedL2 DOOR MOP SILL WEB BETWEEN BS 947 AND BS 986 AT LBL 40 IS CORRODED. REMOVED WEB FABRICATED REPLACEMENT PART AND INSTALLED IAW B737 400 SRM 51 40 02.SDR ASAA1149184Shear Web · corrodedAFTER REMOVAL OF LT SHEAR WEB FOUND CORRODED. REMOVED CORROSION MATERIAL LOSS FOUND OUT OF LIMITS. FABRICATED REPLACEMENT WEB AND INSTALLED IAW SRM 53-60-51 AND 51-40-05.SDR ASAA1149183Shear Web · corrodedAFTER REMOVAL OF RT SHEAR WEB FOUND CORRODED. REMOVED CORROSION MATERIAL LOSS FOUND OUT OF LIMITS. FABRICATED REPLACEMENT WEB AND INSTALLED IAW SRM 53-60-51 AND 51-40-05.SDR ASAA1149322Seat Track · damagedRIGHT OUTBOARD SEAT TRACK GOUGED AND WORN BETWEEN BS 500E AND 520. REPAIRED SEAT TRACK IAW B737 400 SRM 53 00 52 FIG 201 REPAIR 2.SDR ASAA1149321Seat Track · damagedLEFT OUTBOARD SEAT TRACK GOUGED AND WORN AT BS 520. REPAIRED SEAT TRACK IAW B737 400 SRM 53 00 52 FIG 201 REPAIR 2.SDR ASAA1149320Seat Track · damagedLEFT INBOARD SEAT TRACK GOUGED AND WORN AT BS 520. REPAIRED SEAT TRACK IAW B737 400 SRM 53 00 52 FIG 201 REPAIR 2.SDR ASAA1149319Seat Track · damagedLEFT INBOARD SEAT TRACK GOUGED AND WORN BETWEEN BS 727G BS 747 BS 887. REPAIRED SEAT TRACK IAW B737 400 SRM 53 00 52 FIG 201 REPAIR 4.SDR ASAA1149231Seat Track · gougedRT OUTBOARD SEAT TRACK IS GOUGED AND WORN BETWEEN BS 540 BS 663.5 AND BS 685 BS 706. REMOVED DAMAGED SEAT TRACK AND INSTALLED REPLACEMENT PART IAW B737 400 AMM 20 50 11 912 002.SDR ASAA1149182Seat Track · gougedLEFT INBOARD SEAT TRACK GOUGED AND WORN BS 695.5. REMOVED DAMAGED SECTION AND INSTALLED REPLACEMENT IAW B737 400 SRM 53 00 52.SDR ASAA1149312Rib · crackedLEFT WING LOWER RIB CHORD IS CRACKED AT WBL 135.5. REPAIRED RIB LOWER CHORD IAW ASA EA 400 57EA 05014.SDR ASAA1149304Stiffener · corrodedRADIAL STIFFENER AT BS 1016 BL 0 IS CORRODED. REMOVED CORRODED AREA FABRICATED REPAIR PARTS AND INSTALLED IAW BOEING DWG 65 28106.SDR ASAA1149300Intercostal · corrodedINTERCOSTAL AT FORWARD EDGE OF R2 DOOR HAS CORROSION. FABRICATED REPLACEMENT INTERCOSTAL AND INSTALLED IAW B737 400 SRM 51 40 02 AND 51 40 05.SDR ASAA1149185Stiffener · corrodedFLOOR SUPPORT STIFFENER AT BS 950 HAS CORROSION AT FASTENER HOLES. REMOVED CORROSION FOUND OUT OF LIMITS. REMOVED AND REPLACED SUPPORT IAW B737 400 SRM 53 60 51 AND 51 40 02.SDR ASAA1149336Door Frame · corrodedL2 DOOR CUTOUT FORWARD FRAME CORRODED AT LOWER INBOARD EDGE. REPAIRED FRAME IAW ASA EA 400 53EA 05127.SDR ASAA1149324Cargo Track · bentRIGHT CARGO TRACK AT BS 767 IS BENT ON LOWER FLANGE. REPAIRED IAW B737 400 SRM 53 00 53 FIG 201.SDR ASAA1149323Cargo Track · corrodedRIGHT CARGO TRACK IS CORRODED FROM BS 767 TO BS 867. REPAIRED IAW ASA EA 400 53EA 04992.SDR ASAA1149318Support Angle · corrodedSIDEWALL SUPPORT ANGLE AT BS 727D IS CORRODED. REMOVED AND REPLACED SUPPORT IAW B737 400 SRM 51 40 02.SDR ASAA1149317Support · damagedSIDEWALL SUPPORT AT BS 727G IS BENT AND CORRODED. REMOVED AND REPLACED SUPPORT IAW B737 400 SRM 51 40 02.SDR ASAA1149316Support Angle · corrodedBULKHEAD LOWER SUPPORT ANGLE IS CORRODED. REMOVED AND REPLACED ANGLE IAW B737 400 SRM 51 40 02.SDR ASAA1149315Floor Support · damagedFLOOR SUPPORT AT RBL 8 BS 937 HAS DRILL STRIKES. REPAIRED IAW B737 400 SRM 53 00 53.SDR ASAA1149314Trans Panel · corrodedRIGHT TRANSITION PANEL IS CORRODED FROM BS 727 TO BS 767. REPAIRED IAW B737 400 SRM 53 60 53.SDR ASAA1149311Frame · dentedBS 747 FRAME IS DENTED ON UPPER FLANGE. CUT OUT DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED IAW ASA EA 400 53EA 05095.SDR ASAA1149309Frame · dentedBS 727A FRAME IS DENTED ON UPPER FLANGE. CUT OUT DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED IAW ASA EA 400 53EA 05099.SDR ASAA1149308Frame · dentedBS 727 FRAME IS DENTED ON UPPER EDGE. CUT OUT DAMAGE FABRICATED AND INSTALLED REPAIR PARTS IAW ASA EA 400 53EA 05101.SDR ASAA1149307Angle · corrodedAFT PIT REINFORCEMENT ANGLE CORRODED BS 767 STR 27R. REMOVED ANGLE (FAIL SAFE CHORD). FABRICATED AND INSTALLED REPLACEMENT PART IAW B737 400 SRM 53 00 07 FIG 1.SDR ASAA1149301Bracket · crackedAFT PIT BRACKET (CLIP) CRACKED FORWARD SIDE OF BS 807 INBOARD OF STR 25R. REMOVED AND REPLACED BRACKET IAW B737 400 SRM 51 40 22.SDR ASAA1149226Strap · crackedCABIN FLOOR SUPPORT TIE STRAP IS CRACKED AT RBL 24 AFT OF BS 312 (SEEN FROM E&E BAY). STOP DRILLED CRACK FABRICATED AND INSTALLED REPAIR DOUBLER IAW B737 400 SRM 53 10 51 DETAIL I REPAIR 4.SDR ASAA1149187Cusp Web · corrodedCUSP WEB BETWEEN BS 907 AND BS 927 RT SIDE CORRODED. REMOVED CORROSION FOUND OUT OF LIMITS. REMOVED AND REPLACED SUPPORT IAW SRM 53-60-51, 51-30-01, 51-40-02, 51-20-01 AND SOPM 20-41-02.SDR ASAA1149180Cusp Web · corrodedCUSP WEB CORRODED BETWEEN BS 807 TO BS 827 RIGHT SIDE. CUT OUT DAMAGED SECTION FABRICATED REPAIR PARTS AND INSTALLED IAW SRM 51-70-03.SDR ASAA1149156Cusp Web · corrodedCUSP WEB BETWEEN BS 400 AND BS 420 RIGHT IS CORRODED. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED IAW B737 400 SRM 51 70 13.SDR ASAA1149154Cusp Web · corrodedLEFT CUSP WEB JUST FORWARD OF BS 380 IS CORRODED. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED IAW B737 400 SRM 51 70 13.SDR ASAA1149153Cusp Web · corrodedLEFT CUSP WEB BETWEEN BS 685 AND BS 695 IS CORRODED. REMOVED WEB FABRICATED REPLACEMENT AND INSTALLED IAW B737 400 SRM 51 40 02.
Back to N706AS, cancelled May 8, 2017