N794AS
Service difficulty reports not matched to an aircraft · 126
They name N794AS, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. 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 = 'N794AS' AND registry_match IS NULL 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 = 'N794AS' AND registry_match IS NULL 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 ASAA0540543Skin · puncturedOKC - FOUND DURING RIGHT WING INBOARD MID FLAP T/E PANEL LOWER SKIN IS PUNCTURED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PIECES PER B737-200 SRM 51-70-10. (M)SDR ASAA0540542Crease Beam · corrodedOKC - FOUND CORROSION ON CREASE BEAM AT L-2 DOOR, BS 947-987. REMOVED CORRODED PART AND REPLACED WITH NEW PART PER B737-200 SRM 51-40-2. (M)SDR ASAA0540526Shear Tie · dentedOKC - FOUND SHEAR TIE AT BS 500C STRINGER 28 LEFT-28-RT IS CORRODED. REMOVED CORRODED SECTION OF SHEAR TIE, FABRICATED AND INSTALLED REPAIR PIECES IAW B737-400 SRM 53-00-02 FIG 201. (M)SDR ASAA0540524Skin · delaminatedOKC - FOUND RIGHT AILERON LOWER SKIN DELAMINATED ON FORWARD INBOARD CORNER. PREPPED AREA, APPLIED BONDED GRAPHITE LAYUP IAW B737-400 SRM 51-70-17. (M)SDR ASAA0540163Threshold · corrodedPAE - AFT CARGO BAY, DOOR THRESHOLD CORRODED UPPER SURFACE BS 794-834, RBL 25 TO 34, WL 156. REPLACED AFT CARGO BAY DOOR THRESHOLD UPPER SURFACE BS 794-834, RBL 25-34, WL 156. (M)SDR ASAA0540189Stringer · gougedPAE - FOUND STRINGER IS GOUGED AT AFT CARGO BAY. REMOVED DAMAGED SECTION OF STRINGER, FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR ASAA0540188Stringer · gougedPAE - FOUND STRINGER IS GOUGED AT AFT CARGO BAY. REMOVED DAMAGED SECTION OF STRINGER, FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR ASAA0540176Floor Support · corrodedPAE - FOUND AFT CARGO BAY, FLOOR SUPPORT CORRODED AT BS 794 TO 847. REMOVED AND REPLACED FLOOR SUPPORT. (M)SDR ASAA0540Support · corrodedPAE - FOUND AFT CARGO BAY, FLOOR TO SIDEWALL SUPPORT CORRODED. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT. (M)SDR ASAA0540175Support · corrodedPAE - FOUND AFT CARGO BAY, FLOOR TO SIDEWALL SUPPORT CORRODED. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT. (M)SDR ASAA0540174Support · corrodedPAE - AFT CARGO BAY, FLOOR TO SIDEWALL SUPPORT CORRODED. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT. (M)SDR ASAA0540173Support · corrodedPAE - AFT CARGO BAY, FLOOR TO SIDEWALL SUPPORT AT BS 930-947, RBL 23 HAS CORROSION AT NUTPLATE LOCATIONS. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT AT BS 930-947, RBL 23. (M)SDR ASAA0540165Support · corrodedPAE - FOUND AFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED. REMOVED, FABRICATED AND INSTALLED FLOOR TO SIDEWALL SUPPORT. (M)SDR ASAA0540164Floor Support · corrodedPAE - FOUND AFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED. REMOVED, FABRICATED AND INSTALLED FLOOR TO SIDEWALL SUPPORT. (M)SDR ASAA0540162Floor Support · corrodedPAE - AFT CARGO BAY, AT PREVIOUS REPAIR, FLOOR SUPPORT CORRODED AND MISSING NUTPLATES UNDER FLOOR SPLICE AT B-STA 771, WL 156, LBL 3. REMOVED CORRODED FLOOR SUPPORT AT PREVIOUS REPAIR, FABRICATED AND INSTALLED REPAIR PARTS. (K)SDR ASA0440193Battery Pack · dischargedLT AFT OUTSIDE OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED BATTERY PACK.SDR ASAA0440038Skin · dentedGYR - FOUND TEMP REPAIR TO DENT IN EXTERIOR SKIN. REPAIRED DENT IN FUSELAGE SKIN AT STATION 279 BETWEEN STRINGER 18L-19L IAW SRM. (M)SDR ASAA0240253Support · crackedPAE - DURING C-CHECKED, FOUND SHELF SUPPORT ABOVE AUTOGYROS IN E/E BAY IS CRACKED. REPAIRED IAW SRM. (M)SDR ASAA0240251Support · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION ON UPPER SURFACE RIGHT BS 847. REPAIRED IAW SRM. (M)SDR ASAA0240250Support · corrodedPAE - DURING C-CHECK, FOUND CORROSION IN AFT CARGO BAY AFT BULKHEAD LOWER SUPPORT AT LEFT BL 24 TO RT BL 24. REPAIRED IAW SRM. (M)SDR ASAA0240252Support · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY FLOOR TO SIDEWALL SUPPORTS HAVE CORROSION ON UPPER SURFACES AT BS 727 TO BS 877. REPAIRED IAW SRM. (M)SDR ASAA0040104Wire · disconnectedANC - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROWS 14 AND 15 WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING/LIGHTS AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9940059Door Mechanism · lack of lubeSEA - FLIGHT 429 - L1 DOOR DIFFICULT TO OPEN AND WAS MAKING A POPPING SOUND WHEN OPENING AND CLOSING. INSPECTED DOOR AND FOUND CAM PLATE DRY. LUBRICATED DOOR HINGES AND SNUBBER. DOOR OPERATED NORMALLY. (M)SDR ASAA9940010Mechanism · lubeSEA - PRIOR TO FLT 681 - THE L1 DOOR WAS VERY DIFFICULT TO OPEN. LUBRICATED THE L1 DOOR CAM PLATES AND THE DOOR OPERATED NORMALLY. (M)SDR ASAA9840090Guide Arm · out of adjustSEA - PRIOR TO FLT 446, THE L1 DOOR WAS FOUND TO BE DIFFICULT TO CLOSE. ADJUSTED UPPER GUIDE ARM AND DOOR OPERATED NORMALLY. (M)SDR ASAA9840079Door · lack of lubeSFO - FLT 291 - PRIOR TO FLIGHT, CREW REPORTED THE L1 DOOR WAS DIFFICULT TO CLOSE. LUBRICATED DOOR AND DOOR OPERATED NORMALLY. (X)
Back to N794AS