N711UW
Service difficulty reports · 260
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 = 'N711UW' 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 = 'N711UW' 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 USAA020456Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED 2 SQUARE INCH, AFT END OF BEAM AT LEFT AFT LAVATORY, AFT INBOARD ATT HOLE. DEFECTIVE PART REPLACED WITH IDENT PART NR. (M)SDR USAA020455Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED .25 INCH, FLOORBOARD ATTACH HOLE, FORWARD OF FORWARD GIRT BAR PAD. CLEANED CORRODED AREA, DIMENSIONAL CHECK PER SRM AND INSTALLED REPAIR ANGLES PER SRM 53-41-14 FIG 201. (M)SDR USAA020454Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED .25 INCH, Y503.2, 1 INCH AFT OF C-14. BLENDED DAMAGED AREA PER TYPICAL REPAIR 53-11-01. (M)SDR USAA020453Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED 1 SQUARE INCH, FRAME 66 AT STATION 71292 LEFT AFT LAVATORY AREA. REMOVED CORROSION, USED NDT PROCEDURE, SEALED AND RESTORED FINISH PER EA 94371. (M)SDR USAASA01046Wire · damagedCLT - THE EMERGENCY AISLE LIGHT AT SEAT 17C WAS INOPERATIVE. MAINTENANCE REPAIRED WIRING AT SEAT 17C EMERGENCY LIGHT CONNECTOR. (M)SDR USAA990691Doubler · crackedPIT - PILOT REPORT INDICATED OUTBOARD LEG COMPLETELY CRACKED OFF. INBOARD LEG 2.50 INCH CRACK AT PANEL ATTACH DOUBLER AT BOTH FORWARD EXTENDING LEGS BETWEEN RIBS 23 AND 24, LT WING. MANUFACTURED NEW DOUBLER 2024-T3 0.063 INCH PER SRM 57-51-26 FIG 9. (X)SDR USAA990690Panel · brokenPIT - PILOT REPORT INDICATED 1.50 INCH BY 3.25 INCH PIECE MISSING INBOARD AFT CORNER, 3 SCREWS PULLED THROUGH UPPER AILERON INBOARD ACCESS PANEL 575AT LEFT WING. DEFECTIVE PART REPLACED WITH IDENTICAL PART NUMBER. (X)SDR USAA990689Angle · crackedPIT - PILOT REPORT INDICATED 3 INCH CRACK, PIECE MISSING AT INBOARD ATTACH ANGLE FOR PANEL 575AT LEFT WING. MANUFACTURED NEW ANGLE OF 2024-TE 0.063 INCH PER DWG D575-41499. (X)SDR USAA990688Skin · crackedPIT - PILOT REPORT INDICATED ONE EACH 2 INCH LONG CRACK AND 3.50 INCH LONG CRACK AT LEFT AILERON AT INBOARD END LEFT AILERON UPPER SURFACE LEADING EDGE. DEFECTIVE PART REPLACED WITH IDENTICAL PART NUMBER. (X)SDR 99ZZZX3465Beam · brokenPIT - PILOT REPORT INDICATED 12 INCH SECTION BROKEN OFF BEAM ASSEMBLY, TIE, ATTACHED TO PANEL 575AT LEFT WING. DEFECTIVE PART REPLACED WITH IDENTICAL PART NUMBER. (X)
Back to N711UW