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 ASAA11410330Floorbeam · corrodedFLOORBEAM AT STA 328 BL 0 OUTBOARD TO SERVICE DOOR HAS AREAS OF CORROSION. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW B737 400 SRM 53 10 51. REPAIRED FLOORBEAM IAW B737 400 SRM 53 10 51 FIG 201 REPAIR 5.SDR ASAA11410328Web · damagedLT FLOOR WEB AT FS 986 IS CRACKED AND CORRODED. REMOVED CRACKED LT FLOOR WEB IAW B737 400 SRM 51 40 02. FABRICATED NEW SHEAR WEB IAW B737 400 SRM 51 40 05. INSTALLED NEW WEB IAW B737 400 SRM 51 40 02.SDR ASAA11410299Shear Web · corrodedCABIN SHEER WEB CORRODED AT STRINGER 17L BETWEEN FS 500F 500G. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. FABRICATED NEW SHEAR WEB AND INSTALLED IAW B737 400 SRM 53 30 13 FIG 101 51 30 01 FIG 7 AND 51 40 02.SDR ASAA11410276Sill · corrodedPASSENGER CABIN L1 DOOR INTERCHORD (MOP SILL) CORRODED AT STA 312 TO STA 344 UPPER FLANGE. REPLACED INTERCHORD IAW B737 400 SRM 51 40 02.SDR ASAA11410305Frame · crackedFOUND CRACKED AT PSU MOUNT BRACKET FS 480 BETWEEN STRINGERS 8R + 9R. ACCOMPLISHED FRAME REPAIR IAW EA AD20062609 400 53 123.SDR ASAA11410304Frame · crackedFRAME CRACKED AT PSU MOUNT BRACKET AT FS 747 BETWEEN STRINGERS 8R + 9R. ACCOMPLISHED FRAME REPAIR IAW EA AD20062609 400 53 123.SDR ASAA11410302Frame · crackedCABIN FRAME CRACKED AT PSU ATTACH BRACKET AT FS 400 BETWEEN STRINGER 8L + 9L. ACCOMLISHED FRAME REPAIR IAW EA 20062609 400 53 123.SDR ASAA1140300Frame · crackedFRAME CRACKED AT PSU MOUNT BRACKET BETWEEN 8R+9R. ACCOMPLISHED FRAME REAPIR IAW EA AD 20062609 100 52 123.SDR ASAA11410298Stringer · crackedSTRINGER (12 R) CRACKED AT FS 291. REPLACED STRINGER IAW EA 400 53EA 06151.SDR ASAA11410297Stringer · crackedSTRINGER 13R CRACKED AT FS 291. REPLACED STRINGER IAW ASA EA 400 53EA 06151.SDR ASAA11410270Sill · corrodedR1 DOOR MPSILL/INNER CHORD IS CORRODED. REPLACED R1 DOOR MOPSILL/INNER CHORD IAW B737 400 SRM 51 40 02.SDR ASAA11410269Stringer Clip · crackedSTRINGER CLIP AT STA 277 STR 12L IS CRACKED. REPLACED STRINGER CLIP IAW B737 400 SRM 51 40 02.SDR ASAA1149560Guide Arm · out of adjustFORWARD ENTRY DOOR L1 WILL NOT CLOSE. THE FLAP ON THE TOP IS NOT GOING INTO PLACE PROPERLY. FOUND AFT LATCH ROLLERS NOT ENGAGING LATCH FITTINGS DUE TO AFT DOOR EDGE LAGGING FORWARD EDGE. ADJUSTED GUIDE ARM IAW B737 400 AMM 52 11 00.SDR ASAA1149353Plate · looseR1 (FORWARD GALLEY SERVICE DOOR) HARD TO CLOSE FOUND UPPER HINGE LOWER CAM PLATE ATTACH BOLTS LOOSE. TIGHTEN BOLTS. DOOR OPS CHECKS OK PER B737 400 AMM 52 41 00 705 001 1.SDR ASAA1048571Jam-Nut · looseFORWARD ENTRY DOOR L1 HARD TO CLOSE. FOUND GUIDE ARM JAM NUT LOOSE. REPLACED L1 DOOR GUIDE ARM PER MM 52 11 21.SDR ASAA1047676Skin · crackedLEFT WING L/E SKIN CRACKED AT I/B CORNER OF NR 1 K-FLAP O/B SPRING DOOR CUTOUT. REPAIRED L/E SKIN AT I/B CORNER OF NR 1 K-FLAP O/B SPRING DOOR CUTOUT.SDR ASAA1047612Skin · crackedFUSELAGE SKIN HAS A CRACK IN SKIN BS 727D STR 10L.SDR ASAA1047683Attach Fitting · crackedSTRINGER 11L INTERCOSTAL WEB AFT ATTACH CLIP IS CRACKED AT RADIUS AT BS 360. REMOVED CRACKED CLIP INSTALLED NEW CLIP.SDR ASAA1047682Attach Fitting · crackedSTRINGER 8L INTERCOSTAL WEB AFT ATTACH CLIP IS CRACKED AT RIVET HOLE AT BS 360. REMOVED CRACKED CLIP INSTALLED NEW CLIP.SDR ASAA1047601Attach Fitting · crackedSTRINGER 8L INTERCOSTAL WEB AFT ATTACH CLIP IS CRACKED AT RIVET HOLE AT BS 360.SDR ASAA1047600Intercostal · crackedSTRINGER 11L INTERCOSTAL WEB AFT ATTACH CLIP IS CRACKED AT RADIUS AT BS 360.SDR ASAA1047599Pan · crackedAFT ENTRY DOOR LINER LOWER ATTACH PAN IS CRACKED. REMOVED AND REPLACED DOOR LINER LOWER ATTACH PAN PER AMM 52-13-61.SDR ASAA1047598Door Frame · crackedFWD CARGO DOORWAY FWD FRAME IS CRACKED AT 25R LOWER DOOR STOP. REMOVED CRACKED FRAME AND INSTALLED NEW FRAME.SDR ASAA0944150Skin · puncturedLT INBD FORE FLAP LOWER SURFACE PUNCTURED. REMOVED DAMAGED AREA FABRICATED FILLER AND DOUBLER INSTALLED IAW SRM 51 70 10.SDR ASAA0944161Skin · puncturedRT IB MID FLAP TRAILING EDGE WEDGE HAS A PUNCTURE IB OF 2ND TRACK. REMOVED EXISTING DOUBLER FABBED REPAIR PARTS AND BONDED REPAIR IAW B737 400 SRM 51 70 10.SDR ASAA0944162Skin · dentedRT EXTERNAL FUSELAGE DENTED AT STA 236 BELOW AND AFT OF EXTERNAL POWER DOOR. REMOVED DAMAGED AREA FABBED REPAIR PARTS INSTALLED THE REPAIR IAW AAR EA 13108 AND ASA EA 400 53 EA 00454.SDR ASAA0944146Skin · dentedLT INBD MID FLAP T/E WEDGE LOWER SURFACE HAS MULTIPLE SHARP DENTS AT INBD CORNER AT PREVIOUS REPAIR. REMOVED PREVIOUS REPAIR FABBED REPAIR PARTS AND BONDED IAW SRM51 70 10.SDR ASAA0944151Skin · damagedLT DOOR UPPER AFT CORNER CURLED BACK. REMOVED DAMAGED AREA FABRICATED FILLER AND DOUBLER INSTALLED IAW SRM 52-00-01.SDR ASAA0944160Skin · puncturedRUDDER PUNCTURED RT SIDE APPROX. 16" FROM 88" FROM LOWER EDGE. PREPPED PUNCTURED AREA AND REPAIRED AREA IAW B737 400 SRM 51 70 03 REP 2.SDR ASAA0944140Skin · delaminatedLT IB MID FLAP T/E WEDGE IS DELAMINATED UPPER SURFACE CENTER. REMOVED DAMAGED AREA FABRICATED REPAIR PARTS BONDED REPAIR IAW SRM 51 70 10 REP 4.SDR ASAA0944154Skin · crackedFUSELAGE SKIN CRACKED AFT OF STA 303 BELOW LT DOOR UPPER HINGE REMOVED DAMAGED SKIN. FABRICATED INSTALLED REPLACEMENT GAP COVER IAW SRM 51 40 02.SDR ASAA0944149Doubler · puncturedLT INBD MID FLAP LOWER SURFACE PREVIOUS REPAIR DOUBLER PUNCTURED. REMOVED DAMAGED AREA FABRICATED FILLER AND DOUBLER INSTALLED IAW SRM 51 70 10.SDR ASAA0944148Skin · dentedLT NR 3 SPOILER UPPER SKIN DENTED .45 INCH DIAMETER AND .004 DEEP A/Y=112. REMOVED DAMAGED AREA FABRICATED AND INSTALLED DOUBLER IAW SRM 51 70 10.SDR ASAA0944147Skin · dentedNR 3 SPOILER UPPER SKIN HAS A CLUSTER OF DENTS 1.8 IN FWD OF T/E. REMOVED DAMAGED AREA FABRICATED FILLER AND DOUBLER BONDED REPAIR IAW SRM 51 70 10.SDR ASAA0944145Skin · dentedLT IB FORE FLAP UPPER SURFACE DENTED. REMOVED DAMAGED AREA FABRICATED FILLER AND DOUBLER BONDED REPAIR IAW SRM 51 70 10.SDR ASAA0944143Skin · dentedNR 2 SPOILER UPPER SKIN IS DENTED. PREPPED DAMAGED AREA FABRICATED DOUBLER AND BONDED REPAIR IAW SRM 51 70 10 REPAIR 2.SDR ASAA0944142Skin · chafedRT OTBD MID FLAP CHAFED ABOVE NR 7 FLAP TRACK FAIRING. REMOVED DAMAGED AREA FABRICATED REPAIR PARTS AND BONDED REPAIR IAW SRM 51 70 10.SDR ASAA0944141Skin · chafedLT OB FORE FLAP IB LEADING EDGE IS CHAFED. REMOVED DAMAGED AREA FABRICATED HEAT TREATED AND INSTALLED REPLACEMENT SKIN IAW SOPM 20 50 01.SDR ASAA0944139Skin · dentedLT IB FORE FLAP LOWER SURFACE HAS A CLUSTER OF 20 DENTS BEHIND NR 2 TIRE. REMOVED DAMAGED AREA FABRICATED FILLER AND DOUBLER BONDED REPAIR IAW SRM 51 70 10.SDR ASAA0944153Skin · dentedRT HORIZ STAB AT STA101 HAS A DENTS ON THE LEADING EDGE. REMOVED PREVIOUS REPAIR FABRICATED FILLER AND DOUBLER INSTALLED IAW SRM 55 10 01.SDR ASAA0944152Skin · dentedRT HORIZ STAB AT STA 92.7 HAS 2 DENTS ON THE LEADING EDGE. REMOVED PREVIOUS REPAIR FABRICATED FILLER AND DOUBLER INSTALLED IAW SRM 55 10 01.SDR ASAA0843005Skin · dentedAFT CARGO DOOR DENTS WITH SCRATCHES AND DENTS WITH CREASES IN 3 AREAS. REMOVED AFT CARGO DOOR EXTERNAL SKIN. FABRICATED LOCATED DRILLED AND INSTALLED A REPLACEMENT SKIN IAW B737 400 SRM 52 30 01 FIG 201.SDR ASAA0742151Latch · misinstalledFLIGHT ATTENDANT UNABLE TO ARM L2 DOOR. FOUND LATCH ASSY INSTALLED INCORRECTLY. PROPERLY INSTALLED LATCH ASSY. (REF MM25 61 35 PG 209 & MM SUPP 25 61 35)SDR ASAA0741942Skin · dentedDENT IN FUSELAGE SKIN. REPAIRED IAW EA 5330 02224 AND SRM 53-00-01 REPAIR 31 DETAIL 9.SDR ASAA0741481A/C Pack · leakingSMOKE IN CABIN ON TAKEOFF OUT OF ADQ. REMOVED AND REPLACED LEFT PACK ACM PER AMM 21-51-11. OPS AND LEAK CHECK GOOD.SDR ASAA0640836Skin · dentedFUSELAGE SKIN DENTED ATR AFT SIDE OF FWD DOOR CUTOUT. REPAIRED DENT PER EA 5330 02181.SDR ASAA0640835Frame · crackedFRAME CRACKED AT STOP PAD FITTING. REPAIRED FRAME PER EA 5310 02653 AND ER 06 2544.SDR ASAA0640834Floorbeam · corrodedFLOORBEAM CORRODED. REPAIRED PER EA 5310 02651.SDR ASAA0640833Door Frame · corrodedAFT CARGO BAY DOORWAY FRAME CORRODED. REMOVED AND REPLACED FRAME PER SRM 51-40-02 AND DWG 65 47959.SDR ASAA0640832Retainer · corrodedCORROSION IN RIGHT AFT OVERWING EXIT LWR SEAL RETAINER. REMOVED AND REPLACED LWR SEAL RETAINER PER SRM 51-40-02.
Back to N779AS, cancelled Mar 10, 2017