N434AW
Service difficulty reports · 281
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 = 'N434AW' AND registry_match = 'registration' 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 = 'N434AW' AND registry_match = 'registration' 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 A6WA2017050244962Frame · corrodedFRAME BS 605 CORRODED BETWEEN STRINGERS 20L AND 20 R. REPLACED THE FRAME IAW SRM 51-42-06, AND 51-42-21.SDR A6WA201744974Frame · corrodedFRAME BS 589 CORRODE BETWEEN STRINGERS 24L TO 25R. REPAIRED THE FRAME IAW EA 253-00674, REV-IR.SDR A6WA2017050244963Frame · corrodedFRAME BS 574 CORRODED BETWEEN STR 26L AND 26R. REPAIRED THE FRAME IAW EA AWAC-CRJ253-00673, REV-IR.SDR A6WA2017042544944Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED AT FS 559.00 TO FS559+80, RBL42 TO RBL 47. REPAIRED FLOOR SILL IAW SUPPLEMENT 17-083 AND REO 601R-53-00-526 REV -- .SDR A6WA2017050244965Floorbeam · corrodedFLOORBEAM UPPER ANGLE AT BS 280 BETWEEN RBL 9 AND LBL 9 IS CORRODED. REPLACED THE FLOORBEAM ANGLE IAW SRM 51-42-06, AND 51-40-11.SDR A6WA2017050244969Floor Support · corrodedFLOOR SUPPORT CORRODED AT BS 559+102 TO 564, LBL 27. REPLACED THE FLOOR SUPPORT IAW SRM 53-00-43, REPAIR 2.SDR A6WA2017050244971Floor Support · corrodedMAIN CABIN FLOOR SUPPORT CORRODED AT BS 589 TO 621, RBL 27. REPLACED THE FLOOR SUPPORT IAW 15-279.SDR A6WA201744959Structure · corrodedPAX DOOR EDGE MEMBER CORRODED REMOVED AND REPLACED EDGE MEMBER IAW SRM 51-42-06.SDR A6WA2017050244968Floor Support · corrodedFLOOR SUPPORT CORRODED BS 569 TO 621, LBL 27. REPLACED THE FLOOR SUPPORT IAW REO 601R-53-00-0005, REV-B.SDR A6WA2016122844698Warning Message · illuminatedAFTER GEAR UP, GOT A GEAR DISAGREE WARNING WITH NOSE GEAR INDICATING NOT UP.SDR A6WA2016112144597Flap System · failedFLAPS FAILED AT 30 DEGREES ON FINAL APPROACH.SDR A6WA201644449Apu · failedDURING FIRST FLIGHT OF THE DAY CHECKS CREW REPORTED AN APU AUTO SHUTDOWN, APU OIL TEMP CAUTION AND APU FAULT CAUTION MESSAGE ON ED1. STRONG OIL ODOR THROUGH PACK AND IN AFT EQUIPMENT BAY.SDR A6WA201644318Steering Sys · malfunctionedAFTER T/O, SELECTED GEAR UP, RECEIVED GEAR DISAGREE WARNING, NWS INOPERATIVE CAUTION, WOW INPUT CAUTION, WOW OUTPUT STATUS MESSAGES. ON ED1, MAINS UP/LOCKED AND NOSE WAS DOWN/LOCKED. C/W QRH, MANUALLY EXTENDED THE GEAR, RECEIVED 3 GREEN DOWN. NWS INOPERATIVESDR A6WA201542967Actuator · malfunctionedAFTER TAKEOFF REC GRAVITY XFLOW FAIL STATUS MSG. DECLARED PRECAUTIONARY EMER & DIVERTED. AFTER APPROX 20 MIN MSG CLEARED ON ITS OWN. R & R GRAVITY XFLOW ELEC ACT IAW AMM 28-13-16. OPERATIONS CHECKED GOOD.SDR A6WA201542682Attach Bracket · crackedACFT POWER RECEPTACLE ATTACH BRACKET IS CRACKED.SDR A6WA201542666Mount Bracket · crackedNR 3 HYD RESERVOIR AFT MOUNT IS MOUNT.SDR A6WA201542668Mount Bracket · crackedLEFT 10TH STAGE BLEED LOOP MOUNT BRACKET IS CRACKED.SDR A6WA201542667Support Bracket · crackedLEFT ACM SUPPORT STRUCTURE BRACKET IS CRACKED.SDR A6WA201542669Bracket · crackedCRACKED BRACKET ON T2 SENSE LINE ON LT ENG.SDR A6WA201542664Intercostal · crackedCRACK IN UPPER CAP OF PAX DOOR INTERCOSTAL UNDER PANEL 832GL.SDR A6WA201542663Rib · crackedCRACK IN PAX DOOR RIB UPPER CAP RADIUS ABOUT 8" BEHIND AFT CAM LATCH.SDR A6WA201542658Screw · improper partRT SIDE SEAT RAIL HAS THREE EACH INCORRECT SCREWS 1 AT FS 448 & 2 AT APPROX FS 473.00.SDR A6WA201542660Skin · chafedUPPER CTR OF CARGO COMPARTMENT DOOR SKIN IS CHAFED.SDR A6WA201542659Drag Angle · crackedDRAG ANGLE ADJACENT TO LT BATTERY RIB IS CRACKED.SDR A6WA201542655Intercostal · crackedPAX DOOR INTERCOSTAL UNDER PANEL 832BR CRACKED.SDR A6WA201542654Stiffener · crackedRT ENG EXHAUST FAIRING 2ND STIFFENER CRACKED.SDR A6WA201542647Drag Angle · crackedDRAG ANGLE ADJACENT TO RT BATTERY RIB IS CRACKED.SDR A6WA201542646Angle · crackedLEFT OBLIQUE ANGLE AT AFT SIDE OF RPB CRACKED.SDR A6WA201542656Mount Fitting · crackedLEFT LOWER HYD COMPARTMENT ACCUMULATOR FWD MOUNT CLIP CRACKED.SDR A6WA201542653Fitting · crackedCLIP CRACKED AT FS 484 & RBL 36.SDR A6WA201441984Cable · damagedEMERGENCY FLOOR TRACK LIGHTING INOPERATIVE ROWS 9 - 12. R & R EMER FLOOR TRACK LIGHTING CABLE STRIP ASSEMBLY FROM ROW 9 - 12. OPERATIONS CHECKED GOOD AT THIS TIME. IAW SUPP 13-022 & AMM 33-51-01.SDR A6WA201441712Hydraulic System · low pressureHYD 2 LO PRESS CAUTION MSG DURING DESCENT. COMPLIED WITH QRH. HYD 2 QTY WENT TO ZERO. EDP RAN FOR 35 MINUTES WITH HYD 2 PRESS & QTY AT ZERO.SDR A6WA201312114202Drag Brace · defective3980 INFLIGHT RECEIVED GEAR DISAGREE MESSAGE, PERFORMED QRH & LANDED NORMALLY, GEAR HANDLE IN RETRACT POSITION BTMS READING VISIBLE APPROXIMATELY 20 SECONDS BEFORE NLG UNSAFE. R & R DRAG BRACE. FERRIED FOR EMERGENCY HANDLE MOD. SERVICE BULLETIN COMPLIANCE.SDR A6WA201306074996Doubler · gougedHORIZONTAL STAB LT LOWER H STA PIN DOUBLER HAS NUMEROUS GOUGES. R & R DOUBLER IAW SRM.SDR A6WA201306074988Sill · corrodedPAX DOOR LOWER SILL IS CORRODED. REMOVED CORRECTED SILL AND INSTALLED NEW SERVICEABLE LOWER FLOOR SILL.SDR A6WA20134M990Frame · corrodedCORROSION ON FWD & AFT SIDE OF FS349 FRAME LWR STR 25R-25L. R & R FRAME FS 349 LWR.SDR A6WA201306074995Seat Track · wornPILOT AND COPILOT SEAT TRACK FRONT SECTIONS WORN BEYOND REPAIRABLE LIMITS. C/W CARD NR/0001, SB 601R-53-022 INSTALLATION OF FWD SEAT TRACK SECTIONS.SDR A6WA2013060741002Trunnion · gougedAFT FACE OF RT FWD MLG TRUNNION FOUND GOUGES UNDER BUSHING FLANGE. REWORKED RT MLG FWD TRUNNION AFT FACE IAW REO 601R-57-21-1939, REV.SDR A6WA2013060741001Trunnion · damagedRIGHT MLG FWD TRUNNION ON INBD SIDE. REWORKED RT MLG FWD TRUNNION AT INBD SIDE IAW REO 601R-57-21-1942, REV.SDR A6WA2013060741000Trunnion · nickedAFTFACE OF RT MLG AFT TRUNNION HAS NICKS. REWORKED AFT FACE OF RT MLG AFT TRUNNION IAW REO 601R-57-21-1942, REV.SDR A6WA2013060741003Cleat · corrodedCORROSION FOUND ON PAX DOOR LOWER SILL CLEATS FWD & AFT. R & R PAX DOOR SILL CLEATS FWD & AFT IAW SRM 51-40-11 & SRM 51-42-06.SDR A6WA201306074998Skin · dentedDENT IN LOWER INBD SKIN OF RT INBD FLAP. REPAIRED DENT IAW EA 12-2013-277.SDR A6WA201306074994Sill · corrodedDOOR SILL IS CORRODED ON TOP AND BOTTOM SURFACE FROM FS621 TO FS559+112. REMOVED CORROSION BETWEEN FS559+112 AND 589. REMOVED UNSERVICEABLE SECTION OF FLOOR LANDING BETWEEN FS581 TO 621, FABRICATED AND INSTALLED NEW SERVICEABLE SECTION OF CARGO DOOR FLOOR LASDR A6WA201306074987Floor Support · corrodedCORROSION FOUND ON FLOOR SUPPORT STRUCTURE AT FS349 BELOW PAX DOOR AFT ANCHOR FITTING CONTINUES ON STRUCTURE BELOW FLOOR LEVEL 3 LOCATIONS WITHIN LIMITS 1 LOCATION OUT OF LIMITS REQ'S REO. BLENDED SMOOTH IAW REO 601R-53-21-2435.SDR A6WA201306074997Skin · dentedLEFT INBD FLAP DENT ON LOWR SKIN AFT OF OTBD HINGE ARM. REPAIRED LT INBD FLAP LOWER SKIN IAW SRM 57-52-00, REPAIR NR 3.SDR A6WA201306074989Sill · corrodedCORROSION FOUND ON RIGHT FLOOR SILL DIRECTLY FWD OF SERVICE DOOR AT FS 305.00 TO FS 310 MEASUREMENTS AFFECTED ARE 0.5" X 0.5" AROUND FASTENER HOLES. REMOVED CORROSION AND FOUND MATERIAL LOSS GREATER THAN ALLOWABLE LIMITS IAW SRM 51-21-06, TR 53-27. R & R PARSDR A6WA201306074999Access Panel · corrodedPITTING FOUND ON FUEL ACCESS PANEL 640BB HOLE NR 1 CUT OUT. BLEND & RESTORE FINISH IAW REO 601R-57-21-030, REV K.SDR A6WA201307081066Floor Support · crackedPAX CABIN FLOOR SUPPORT FS 280. RBL 9 INBD ANGLE IS CRACKED. REMOVED & REPLACED ANGLE IAW REO 601R-53-41-059.SDR A6WA201307241065Floor Support · crackedPAX CABIN FLOOR SUPPORT FS 280 LBL 9 INBD ANGLE IS CRACKED UPPER. R & R ANGLE .SDR A6WA201306074993Angle · crackedCLIP ANGLE IS CRACKED AT FS 484 AND LBL9. R & R CRACKED CLIP ANGLE.
Back to N434AW