N511SW, cancelled Jan 2, 2019
Service difficulty reports · 300
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 = 'N511SW' AND deregistration_id = 'N511SW-2019-01-02' 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 = 'N511SW' AND deregistration_id = 'N511SW-2019-01-02' 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 SWAA103465Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 5 SLAT O/B WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA100891Wedge · delaminatedDURING SCHEDULED OTS CHECK, FOUND LT WING NR 2 SLAT T/E WEDGE DELAMINATED. REMOVED AND REPLACED NR 2 SLAT PER MM.SDR SWAA100829Keelbeam · crackedDURING SCHEDULED OTS CHECK, FOUND WHEEL WELL KEEL BEAM WEB CRACKED AT BS 711. REMOVED AND REPLACED WEB PER SRM.SDR SWAA100830Angle · crackedDURING SCHEDULED OTS CHECK, FOUND LT KEEL BEAM Z-ANGLE CRACKED AT BS 711. REPAIRED Z-ANGLE PER SRM.SDR SWAA100800Lens · looseDURING SCHEDULED 2HC1 CHECK, FOUND RT EEPLS LENS LOOSE AT ROW 5. SECURED LENS PER MM.SDR SWAA100201Sign · looseL1 DOOR EMERGENCY EXIT SIGN LOOSE. REMOVED AND REPLACED SIGN PER MM.SDR SWAA097533Stiffener · crackedDURING SCHEDULED MV2 CHECK, FOUND LT MAIN WHEEL WELL BULKHEAD SUPPORT STIFFENER CRACKED AT BS 633, LBL 6. REPAIRED STIFFENER PER EA.SDR SWAA097173Slide · low pressureDURING SCHEDULED MV1 CHECK, FOUND L2 DOOR EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA096236Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 310, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA096235Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND AFT PRESSURE BULKHEAD CRACKED AT BS 1016, STR 15R. REPAIRED BULKHEAD PER SRM.SDR SWAA095638Light · looseRIGHT OVERHEAD BULLNOSE EMERGENCY EXIT LIGHT LOOSE AT ROW 1. SECURED LIGHT PER MM.SDR SWAA095046Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA095045Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA094985Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA094894Slide · unserviceableL1 DOOR EMERGENCY EVAC SLIDE PRESSURE OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA092818Lens · looseDURING SCHEDULED MV2 CHECK, FOUND EMERGENCY EXIT BULLNOSE LIGHT LOOSE AT ROW 15. REMOVED AND REPLACED LENS PER MM.SDR SWAA092747Light · looseBULLNOSE EMERGENCY EXIT LIGHT LOOSE AT ROW 15. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA091249Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 794.2, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA091240Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727C+16 TO 727D, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA091239Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 800, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA086018Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 440, STR 1. REPAIRED SKIN PER SWA EA.SDR SWAA083900Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND LT WING NR 3 L/E SLAT CRACKED AT OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA083816Light · debondedDURING SCHEDULED 18Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT ASSY DISBONDED AT ROW 14 DEF. REPAIRED LIGHT ASSY PER MM.SDR SWAA083707Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986.5, STR 2L. REPAIRED FRAME PER SRM.SDR SWAA083706Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 344, STR 9R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083677Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 11R. R&R STRINGER CLIP PER SRM.SDR SWAA083586Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083585Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083584Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083587Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083588Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083558Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 380, BL 0. REPAIRED SKIN PER SRM.SDR SWAA083467Fitting · corrodedDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA083427Fitting · corrodedDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA082826Bulb · faultyNR 1 ENGINE OIL TEMP CLIMBED INTO RED BAND. NR 1 ENGINE WAS SHUTDOWN PER QRH. REMOVED AND REPLACED OIL TEMP BULB PER MM.SDR SWAA082381Sign · looseLEFT OVERWING EMERGENCY EXIT LIGHT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA081521Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 942, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA081522Flap · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING INBOARD FOREFLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA081523Skin · crackedDURING SCHEDULED C4 CHECK, FOUND RT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 140. REPAIRED SKIN PER SRM.SDR SWAA081524Skin · crackedDURING SCHEDULED C4 CHECK, FOUND RT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 129. REPAIRED SKIN PER SRM.SDR SWAA081525Bearing · wornDURING SCHEDULED C4 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 TAB HINGE BUSHING AND BEARING PER SWA EA.SDR SWAA081526Bushing · wornDURING SCHEDULED C4 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 TAB HINGE BUSHING AND BEARING PER SWA EA.SDR SWAA080744Bear Strap · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED AT AFT CARGO DOOR LOWER FWD CUTOUT BS 798. REPAIRED SKIN PER SRM.SDR SWAA080136Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 932, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA080022Mount · wornDURING SCHEDULED SERVICE CHECK, FOUND NR 1 ENGINE FWD OUTBOARD MOUNT WORN. REMOVED AND REPLACED MOUNT PER MM.SDR SWAA076079Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 751 AND BS 781, STR 18L AND STR 19L. REPAIRED SKIN PER SRM.SDR SWAA076078Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075324Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA075323Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA074730Light · looseR1 DOOR EMERGENCY EXIT LIGHT ASSY LOOSE. REMOVED AND REPLACED LIGHT ASSY PER MM.
Back to N511SW, cancelled Jan 2, 2019