N682SW, cancelled May 6, 2015
Service difficulty reports · 361
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 = 'N682SW' AND deregistration_id = 'N682SW-2015-05-06' 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 = 'N682SW' AND deregistration_id = 'N682SW-2015-05-06' 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 SWAA95277Shear Web · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR WEB CRACKED AT BS 312, BL 0, WL 207. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA95276Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND STRINGER CORRODED ON RIGHT SIDE OF APU TORQUE BOX FROM BS 1088 TO 1138, WL 230. REPLACED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA95275Frame · mech damageDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME TO INTERCOSTAL STRAP AT BS 993, WL 247 DAMAGED. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA95274Angle · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME SUPPORT ANGLE CORRODED AT BS 1121, RT SIDE, 10 INCHES ABOVE APU AIR INLET OPENING. REPLACED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA95273Blkhd Stiffener · crackedDURING SCHEDULED D-CHECK, FOUND PRESSURE BULKHEAD VERTICAL STIFFENER CRACKED AT BS 178, LBL 5.7, WL 184. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA95272Skin · dentedDURING SCHEDULED D-CHECK, FOUND NUMBER 5 GROUND SPOILER DENTED 2 PLACES ON LOWER SURFACE. REPAIRED PER TRAMCO EWO 95-0222.SDR SWAA95271Skin · creasedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN CREASED AT BS 1100, AT S16L AND AT BS 1112, S17L. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA95270Skin · crackedDURING SCHEDULED D-CHECK, FOUND NUMBER 3 SLAT SKIN CRACKED AT T/E. REPAIRED PER BOEING DRAWING BAC 65C30133.SDR SWAA95269Skin · dentedDURING SCHEDULED D-CHECK, FOUND NUMBER 1 SPOILER SKIN DENTED 2 PLACES ON UPPER SURFACE. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA95268Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN DENTS AT BS 1012, AT S14-15L, AT BS 927 AND 947.5, BETWEEN S18 AND 19L, AT BS 887 AND 907, BETWEEN S17 AND 18L, AT BS 310 AND 326, S21 TO 22R, AT BS 1006, S12 TO 13L, AT 1004, S11 TO 12L, AT BS 351, BETWEEN S25 ANDSDR SWAA95267Clips · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT BS 480, S2L, S3L, AT BS 500D, S3L, AT BS 616, S3L, AND AT BS 440, S16L. REPLACED ALL PER BOEING STRUCTURAL REPAIR MANUAL.
Back to N682SW, cancelled May 6, 2015