N967TW
Service difficulty reports · 120
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 = 'N967TW' 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 = 'N967TW' 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 ZW0A0303010Longeron · damagedLONGERON 19R AT STA 160 TO 154 WAS DAMAGED. REPAIRED PER ARA 18469. CHECK-C 1-22-03 STL.SDR ZW0A0303009Frame · damagedAT STA 160 THE FRAME WAS DAMAGED AT LONGERON 19R TO 22R. REPAIRED PER ARA 18469. CHECK-C 1-22-03 STL.SDR ZW0A0303008Skin · dentedFOUND DENT IN FUSELAGE SKIN AT STA 167, ABOVE LONGERON 20R. REPAIRED PER ARA 18469. CHECK-C 1-22-03 STL.SDR ZW0A0303007Frame · damagedAT STA 169 THE FRAME WAS DAMAGED AT LONGERON 19R TO 20R. REPAIRED PER ARA 18469. CHECK-C 1-22-03 STL.SDR ZW0A0303006Frame · damagedAT STA 169, THE FRAME FOOT WAS DAMAGED AT LONGERON 19R TO 20R. REPAIRED PER ARA 18469. CHECK-C 1-22-03 STL.SDR ZW0A0303005Frame · damagedAT STA 160 THE FRAME FOOT WAS DAMAGED AT LONGERON 20R TO LONGERON 18R. REPAIRED PER ARA 18469. CHECK-C 1-22-03 STL.SDR ZW0A0303004Skin · dentedSKIN AT STA 181 ABOVE LONGERON 20R WAS DENTED. REPAIRED PER ARA 18469. CHECK-C 1-22-03 STL.SDR ZW0A0210502Oven · malfunctionedSTRONG ELECTRICAL SMELL WAS NOTICED IN COCKPIT AND FORWARD GALLEY. SHUT OFF GALLEY POWER AND SMELL DISSIPATED. REPLACED THE NUMBER 2 GALLEY OVEN.SDR ZW0A0208301Hydraulic System · leakingHYD FLUID LEAK INTO APU INLET RESULTING IN SMOKE IN THE CABIN. RETURNED AIRCRAFT TO THE GATE. CHANGED WATER SEPARATORS AND PERFORMED MD9-49-06. PAC BURNOUT OP CHECK.SDR ZW0A0206101Battery · out of positionTHE EGRESS LIGHTS WERE INOPERATIVE AT ROW 14 THROUGH 19. REPOSITIONED THE BATTERY PACK BATTERIES.SDR ZW0A0206001BulbTHE EGRESS LIGHTS WERE INOPERATIVE FROM ROWS 21D TO 27D. REPLACED POWER SUPPLY, PN 60-0304-51, AND ALL THE BULBS. CHECK-C 5-26-01 STL. --CLOSED--SDR ZW0A0206002Sign · inoperativeTHE LOWER OVERWING EXIT SIGN WAS INOPERATIVE. REPLACED THE SIGN.SDR ZW0A0204606Door Frame · corrodedDURING CHECK-C MAINT FOUND CORROSION AROUND E/E COMPARTMENT DOOR FRAME. REMOVED AND REPLACED DOOR PAN STRUCTURE.SDR ZW0A0202604Skin · corrodedDURING CHECK-C MAINTENANCE FOUND CORROSION FROM LONGERON 29L TO 29R, STA 160 TO 218. REPLACED SKIN FROM STA 110 TO 229, STRINGER 26L TO 26R, PER SPM.SDR ZW0A0202605Skin · corrodedDURING CHECK-C MAINT THE FWD CARGO COMPT BELLY SKIN HAD CORROSION AT STA 218 TO 229, LONGERON 29L TO 29R. INSTALLED NEW SKIN PER DRAWING 5911401.SDR ZW0A0202403Bracket · crackedDURING CHECK-C FOUND AFT ACCY COMPARTMENT BRACKET CRACKED ABOVE RT VENT BOX FWD OF RUDDER TRIM DRUM. DOUBLER FABRICATED PER SRM 53-01, FIG 3 AND 4, PAGE 18.SDR ZW0A0202203Tie Clip · brokenDURING CHECK-C MAINT THE LT SIDE VENT BOX UPPER FORWARD STRUCTURAL TIE CLIP WAS FOUND BROKEN.SDR ZW0A0202004Tie Clip · brokenDURING CHECK-C MAINT THE UPPER FWD CORNER OF THE RT VENT BOX STRUCTURAL TIE CLIP WAS BROKEN. FABRICATED NEW CLIP AND INSTALLED PER SRM 51-30-6 AND SPM 6-30-07.SDR TWAA0017301Light · inoperativeBOTH FWD EMERGENCY EXIT SIDE WALL SIGNS, THE FLOOR EGRESS LIGHTS FROM ROWS 12 TO 22, AND THE CEILING EMERGENCY LIGHTS FROM ROWS 7 THRU 11 WERE INOPERATIVE. REPLACED THE BATTERIES (P/N 408822-101) FOR THE EMERGENCY EXIT SIGNS, REPLACED THE MODULE (P/N 0105606-SDR TWAA0008001Light · inoperativeTHE FORWARD PORTABLE EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE LIGHT, NO CHECK-C.
Back to N967TW