N343NW
Service difficulty reports · 259
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 = 'N343NW' 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 = 'N343NW' 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 DALA2014121606552Skin · dentedDENT ON L2 DOOR SKIN. CUTOUT THE DAMAGED AREA IAW SRM 52-10-00, FIG 209, SHEET 3. FABRICATED A REPAIR DOUBLER IAW SRM 52-10-00, FIG 209 SRM 51-44-11 AND SRM 52-10-00 FIG 209. INSTALLED THE REPAIR IAW SRM 52-10-00, FIG 209 AND SRM 51-42-11.SDR DALA1016603243Light · inoperativeDURING TEST FOUND EXIT LIGHT AT SEAT 24C INOP. REPLACED LIGHT ASSEMBLY AND TESTS OK.SDR 0501893243Battery · dischargedDURING EMERGENCY LIGHT TEST DISCOVERED EPSU INT LOAD AFT L FAULT INDICATION. REMOVED AND REPLACED BATTERY. OPS CHECKED GOOD.SDR 0500303243Cable · brokenDURING LIGHT CHECK, FOUND RIGHT OVERWING SLIDE RELEASE CABLE BROKEN BETWEEN COUPLING AND SLIDE INFLATION BOTTLE. REPLACED SLIDE INFLATION BOTTLE ASSEMBLY WITH CABLE PER AMM.SDR 0300153243Controller · malfunctionedDURING CLIMB RECEIVED CABIN PRRESSURE EXCESS CABIN ALTITUDE MESSAGE AT 10,000 FT. LEVELED OFF AT 11,000 FT AND MESSAGE WENT AWAY. CLIMBED TO 12,800 FT AND MESSAGE RETURNED. LEVELED OFF AT 12,000 FT AND MESSAGE CLEARED FOLLOWED SHORTLY BY THE SAFETY VALVE OPENISDR 9901933243Brake · failedDURING POST FLIGHT INSPECTION, FOUND SEVERAL CARBON PIECES AROUND THE NR 1 BRAKE AND WHEEL ASSEMBLY. WHEEL REMOVAL REVEALED THAT THE BRAKE CARBON DISCS (ROTORS AND STATORS) WERE OXIDIZED AND REDUCED TO SEGMENTS. MAINTENANCE REPLACED THE NR 1 BRAKE AND WHEEL SDR 9721123243Retract Mech · malfunctionedDURING APPROACH, RECEIVED F/CTL FLAPS LOCKED, ALIGNMENT FAULT. CREW FOLLOWED COCKPIT OPERATING MANUAL PROCEDURES, DECLARED AN EMERGENCY, AND LANDED WITHOUT INCIDENT. MAINTENANCE ACCOMPLISHED CHECK AND RIG OF FLAP SYSTEM, OPERATIONAL CHECK OK.SDR 9704413243Windshield · crackedDURING TAKEOFF ROLL AT 150 KNOTS, THE CAPTAIN'S WINDSHIELD CRACKED VERTICALLY FROM TOP TO BOTTOM THEN CONTINUED CRACKING IN THE UPPER LEFT CORNER. AN EMERGENCY WAS DECLARED. THE AIRCRAFT RETURNED TO DTW AND LANDED OVERWEIGHT WITHOUT INCIDENT. MAINTENANCE RESDR 9626023243Actuator · leakingHYD-B RSVR LO LVL ANNUNCIATED. FOLLOWED COCKPIT OPERATING MANUAL PROCEDURES AND LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE NR 3 SPOILER ACTUATOR LEAKING. REPLACED THE SAME, LEAK OPS CHECK OK.
Back to N343NW