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 ASAA1149310Rib · crackedRIGHT WING RIB LOWER CHORD AT WBL 135.5 CRACKED. REPAIRED RIB LOWER CHORD IAW ASA EA 400 57EA 05014.SDR ASAA1149298Frame · crackedBS 380 FRAME BETWEEN STR 8R AND 9R CRACKED. REPAIRED IAW ASA EA AD20062609 400 53 117.SDR ASAA1149297Frame · crackedBS 747 FRAME BETWEEN STR 8R AND 9R CRACKED. REPAIRED IAW ASA EA AD20062609 400 53 117.SDR ASAA1149296Frame · crackedBS 787 FRAME BETWEEN STR 8R AND 9R CRACKED. REPAIRED IAW ASA EA AD20062609 400 53 117.SDR ASAA1149295Frame · crackedBS 867 FRAME BETWEEN STR 8R AND 9R CRACKED. REPAIRED IAW ASA EA AD20062609 400 53 117.SDR ASAA1149294Frame · crackedBS 907 FRAME BETWEEN STR 8R AND 9R CRACKED. REPAIRED IAW ASA EA AD20062609 400 53 117.SDR ASAA1149293Frame · crackedBS 867 FRAME BETWEEN STR 8L AND 9L CRACKED. REPAIRED IAW ASA EA AD20062609 400 53 117.SDR ASAA1149292Frame · crackedBS 747 FRAME BETWEEN STR 8L AND 9L CRACKED. REPAIRED IAW ASA EA AD20062609 400 53 117.SDR ASAA1149291Frame · crackedBS 480 FRAME BETWEEN STR 8L AND 9L CRACKED. REPAIRED IAW ASA EA AD20062609 400 53 117.SDR ASAA1149290Frame · crackedBS 440 FRAME BETWEEN STR 8L AND 9L CRACKED. REPAIRED IAW ASA EA AD20062609 400 53 117.SDR ASAA1149289Frame · crackedBS 400 FRAME BETWEEN STR 8L AND 9L CRACKED. REPAIRED IAW ASA EA AD20062609 400 53 117.SDR ASAA1149288Frame · crackedBS 360 FRAME BETWEEN STR 8L AND 9L CRACKED REPAIRED IAW ASA EA AD20062609 400 53 117.SDR ASAA1149287Frame · crackedBS 500A FRAME BETWEEN STR 8R AND 9R CRACKED. REPAIRED IAW ASA EA AD20062609 400 53 117.SDR ASAA1149286Frame · crackedBS 440 FRAME BETWEEN STR 8R AND 9R CRACKED REPAIRED IAW ASA EA AD20062609 400 53 117.SDR ASAA1149271Frame · crackedBS 400 FRAME BETWEEN STR 8R AND 9R IS CRACKED. REPAIRED FRAME IAW ASA EA AD20062609 400 53 117.SDR ASAA1149230Floor Support · corrodedFORWARD CARGO BULKHEAD LOWER FLOOR SUPPORT BS 500G HAS CORROSION FROM STR 25L TO 25R, FABRICATED REPAIR PARTS AND INSTALLED IAW B737 400 SRM 51 40 05.SDR ASAA1149179Trans Panel · corrodedFORWARD CARGO COMPARTMENT LT TRANSITION PANEL ABOVE STR 26L CORRODED FROM BS 515D TO BS 500H. REMOVED CORRODED AND CRACKED TRANSITION PANEL AND INSTALLED REPLACEMENT PART IAW B737 400 SRM 53 30 15.SDR ASAA1149334Sill · corrodedFORWARD WET AREA LEFT SIDE MOP SILL CORRODED FROM BS 306 TO BS 360. REMOVED MOP SILL AND INSTALLED REPLACEMENT PART IAW B737 400 SRM 51 40 05.SDR ASAA1149330Sill · corrodedFORWARD WET AREA RIGHT SIDE MOP SILL CHORD IS CORRODED. REMOVED DAMAGED CHORD FABRICATED REPAIR PARTS AND INSTALLED IAW ASA EA 400 53EA 05105.SDR ASAA1149306Sill · corrodedR2 DOOR MOP SILL CORRODED. REMOVED MOP SILL AND INSTALLED REPLACEMENT PART IAW B737 400 SRM 51 40 02.SDR ASAA1149305Skate Angle · chafedVERTICAL STABILIZER LT AFT SKATE (CLOSEOUT) ANGLE AFT END CHAFED. REPAIRED SKATE ANLE IAW B737 400 SRM 53 80 71 REPAIR 1 FIG 201.SDR ASAA1149303Sill · corrodedL2 DOOR MOPSILL IS CORRODED. REMOVED MOPSILL AND INSTALLED REPLACEMENT PART IAW B737 400 SRM 51 40 02.SDR ASAA1149302Floorbeam · corrodedFLOORBEAM AT BS 986 UPPER CAP PREVIOUS REPAIR IS CORRODED FROM LBL 49 TO RBL 49. REMOVED PREVIOUS "T" CAP REPAIR FABRICATED NEW REPAIR PARTS AND INSTALLED IAW ASA EA 400 53EA 05061.SDR ASAA1149299Support Angle · corrodedR1 DOOR CUTOUT SCUFF PLATE SUPPORT ANGLE CORRODED BS 300 TO BS 332. REMOVED AND REPLACED SUPPORT ANGLE IAW B737 400 SRM 53 10 15 FIG 1.SDR ASAA1149234Skate Angle · chafedVERTICAL STABILIZER LT FORWARD SKATE ANGLE CHAFED. REMOVED ANGLE FABRICATED REPLACEMENT PART AND INSTALLED IAW B737 400 SRM 51 40 02.SDR ASAA1149232Skate Angle · chafedVERTICAL STABILIZER RT FORWARD SKATE ANGLE CHAFED. REMOVED ANGLE FABRICATED REPLACEMENT PART AND INSTALLED IAW B737 400 SRM 51 40 02.SDR ASAA1149155Skin · dentedRIGHT HORIZONTAL STABILIZER LEADING EDGE DENTED 63 INCHES FROM INBOARD EDGE. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED IAW B737 400 SRM 55 10 01.SDR ASAA1149337Panel · damagedRIGHT TRAILING EDGE CLOSE OUT PANEL IS CHAFED AND DENTED. FABRICATED REPLACEMENT PANEL AND INSTALLED IAW B737 400 SRM 51 40 05.SDR ASAA1149313Skin · damagedDOUBLE DRILLED HOLE THRU SKIN BS 727+10 BETWEEN STR 26R AND 27R. REPAIRED SKIN IAW ASA EA 400 57EA 05092.SDR ASAA0947149Skin · delaminatedRT WING NR 5 L/E SLAT T/E WEDGE DELAMINATED AT O/B UPPER SURFACE. REMOVED DAMAGED AREA FABRICATED REPAIR PARTS AND BONDED REPAIR.SDR ASAA0946340Relay · failedRED NOSE GEAR INDICATION ON APPR. CYCLED 2 TIMES 3RD CYCLE GREEN LIGHT INSPECTED & CYCLED NOSE GEAR. VERIFIED LOCK & POSITION SENSOR (S846 &S845) RESISTANCES. REPLACED NOSE GEAR LOCK SENSOR. PERFORMED SELF TEST FOR THE LANDING GEAR POSITION SWITCHES OPS GOSDR ASAA0843341Skin · dentedNR 7 SPOILER IS DENTED ABOVE THE ACTUATOR ON THE UPPER SURFACE. REMOVED DAMAGED AREA, FABBED DOUBLER & INSTALLED REPAIR IAW B737 400 SRM 57 70 01 REPAIR 4.SDR ASAA0843339Skin · dentedRT INBOARD FORE FLAP HAS MULTIPLE SMALL DENTS ON LOWER SURFACE ABOVE NR 3 & 4 TIRES 2 DENTS ON PREVIOUS REPAIRS. REMOVED DAMAGED AREA, FABBED FILLERS & DOUBLERS & BONDED REPAIRS IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0843342Skin · dentedLT WING INBOARD GROUND SPOILER NR 4 HAS SEVERAL DENTS ON THE LOWER SURFACE. PREPARED DAMAGED AREA, FABBED DOUBLERS & BONDED THE REPAIRS IAW B737 400 SRM 51 70 10.SDR ASAA0843336Skin · dentedNR 6 SPOILER HAS SEVERAL DENTS ON TOP. PREPPED DAMAGED AREA, FABBED DOUBLERS 2 EA & BONDED REPAIRS IAW B737 400 SRM 51 70 10.SDR ASAA0843340Skin · dentedLT OUTBOARD T/E AFT FLAP HAS NUMEROUS DENTS ON THE LOWER SURFACE. REMOVED DAMAGED AREA, FABBED FILLER & DOUBLER & BONDED THE REPAIR PARTS IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0843335Skin · chafedRT INBOARD AFT FLAP UPPER SURFACE IS CHAFED AT WBL 82. PREPPED DAMAGED AREA, FABBED DOUBLER & BONDED REPAIR IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA0843334Cargo Track · brokenFWD CARGO PIT LT CARGO TIE DOWN TRACK HAS A BROKEN LUG FOR THE AFT NET ATTACHMENT. REMOVED DAMAGED SECTION OF TRACK, FABBED REPLACEMENT TRACK & REPAIR PARTS & INSTALLED IAW B737 400 SRM 53 00 53 FIG 201.SDR ASAA0843338Skin · dentedREF SAD 6311478: DENT ON RT SIDE OF FUSELAGE AT APPROX STA 370 WL 206. DENT IS COMMON TO STR 17R. REMOVED DAMAGED AREA, FABBED FILLER DOUBLER & TRIPLER & INSTALLED REPAIR IAW ASA EA 5330 02379. REF LG PG 5130589 FOR REINSPECTION INFO. FLIGHT CYCLES AT INSTSDR ASAA0843337Skin · dentedREF SAD 6250170: FUSELAGE SKIN DENT 6' AFT OF AFT CARGO DOOR. DENT IS CREASED LOCATED AT STA 917 BELOW STR 23R. REMOVED DAMAGED AREA, FABBED DOUBLER & INSTALLED REPAIR IAW ASA EA 5330 02378. REF LG PG 5130588 FOR REINSPECTION INFO. FLIGHT CYCLES AT INSTALSDR ASAA0741706Scuff Plate · crackedAFT CARGO DOOR AFT SCUFF PLATE CRACKED. AFT CARGO PIT AFT SCUFF PLATE REPAIRED IAW ASA EA 5320 01456.SDR ASAA0741711Door · crackedRIGHT MLG INNER DOOR LOWER T/E CRACKED. REPAIRED GEAR DOOR IAW SRM 53-80-02 REPAIR 2 DETAIL 2.SDR ASAA0741710Web · corrodedAFT CARGO PIT INTERCOSTAL FOUND CORRODED. REPLACED INTERCOSTAL WITH FABRICATED REPAIR PART IAW SRM 51-40-02.SDR ASAA0741709Intercostal · corrodedAFT CARGO FLOOR INTERCOSTAL IS CORRODED. CORRODED FLOOR INTERCOSTAL REPLACED WITH FABRICATED REPAIR PART IAW SRM 53-30-01 AND 53-60-15 FIG 11.SDR ASAA0741708Support Bracket · crackedSYSTEM B-HYDRAULIC LINE SUPPORT BRACKET ON RIGHT MLG WW FWD BULKHEAD IS CRACKED. BRACKET REPAIRED IAW SRM 51-31-01.SDR ASAA0741707Skin · crackedRIGHT WING FIXED L/E SKIN AT NR 5 SLAT ACTUATOR CURTAIN CUTOUT CRACKED. RIGHT WING FIXED L/E SKIN AT NR 5 SLAT ACTUATOR CURTAIN CUTOUT REPAIRED SERVICEABLE IAW SRM 51-70-17.SDR ASAA0741705Web · corrodedAFT CARGO DOOR SURROUNDING WEB FOUND CORRODED. AFT CARGO DOOR SURROUNDING WEB REPLACED WITH FABRICATED REPAIR PART IAW SRM 51-30-01 AND 51-40-05.SDR ASAA0741704Shear Tie · crackedNR 2 ENGINE PYLON RIGHT SIDE END PANEL SUPPORT BRACKET IS CRACKED. BRACKET REPLACED WITH NEW PART.SDR ASAA0741695Skin · dentedRIGHT WING O/B FORE FLAP DENTED ON UPPER SURFACE. DENT REPAIRED IAW SRM 51-70-10 REPAIR 4.SDR ASAA0741694Stringer Clip · corrodedAFT CARGO PIT CLIP CORRODED. REPLACED WITH MADE REPAIR PART IAW SRM 51-40-02.
Back to N706AS, cancelled May 8, 2017