N333SW, cancelled Sep 18, 2017
Service difficulty reports · 328
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 = 'N333SW' AND deregistration_id = 'N333SW-2017-09-18' 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 = 'N333SW' AND deregistration_id = 'N333SW-2017-09-18' 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 SWAA104478Slide · unwanted deployR2 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA104174Cover · looseOVERHEAD EMERGENCY EXIT BULLNOSE LIGHT COVER LOOSE AT ROW 10. SECURED COVER PER MM.SDR SWAA104053Light · inoperativeDURING SCHEDULED OTS CHECK, FOUND L2 DOOR EMERGENCY EXIT SLIDE LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA104041Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND RT HORIZONTAL STABILIZER ELEVATOR LOWER T/E SKIN HINGE CRACKED. REPAIRED SKIN PER AWA EA.SDR SWAA104052Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND RT HORIZONTAL STABILIZER LOWER T/E SKIN CRACKED AT STA 116.10. REPAIRED SKIN PER EA.SDR SWAA102306Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 394, STR 5R. REPAIRED SKIN PER EA.SDR SWAA102144Slide · looseL1 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA101959Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MM.SDR SWAA101867Light · inoperativeDURING SCHEDULED CV CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA101645Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA098035Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND LT WING UPPER WING SKIN CRACKED AT WBL 157. REPAIRED SKIN PER EA.SDR SWAA097401Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER EO.SDR SWAA097400Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER EO.SDR SWAA097399Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 360, BETWEEN STR 19R TO STR 20R. REPAIRED FRAME PER EO.SDR SWAA097398Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 663 TO BS 673, LBL 24.5. REPAIRED CHORD PER EO.SDR SWAA097397Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 706 TO BS 714, BBL 0.07. REPAIRED WEB PER EO.SDR SWAA097396Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 717, BBL 0.07. REPAIRED BEAM PER EO.SDR SWAA097395Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 344, BETWEEN STR 22L TO STR 23L. REPAIRED FRAME PER EO.SDR SWAA097286Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24.8. REPAIRED FLOORBEAM PER EO.SDR SWAA097285Angle · crackedDURING SCHEDULED 22Y CHECK, FOUND ANGLE SUPPORT CRACKED AT BS 34, STR 11L TO STR 12L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA097276Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 706 TO BS 711, LBL 24.5. REPAIRED FLOORBEAM PER EO.SDR SWAA097275Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 706, RBL 24.5. REPAIRED FLOORBEAM PER EO.SDR SWAA097274Battery Pack · inoperativeDURING SCHEDULED 22Y CHECK, FOUND EMERGENCY LIGHT BATTERY PACK INOP AT FWD GALLEY. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA097306Connector · disconnectedDURING SCHEDULED 22Y CHECK, FOUND EMERGENCY BULLNOSE LIGHTS INOP BETWEEN ROWS 12 & 20. RECONNECTED D2964 CONNECTOR PER MM.SDR SWAA097203Angle · corrodedDURING SCHEDULED 22Y CHECK, FOUND Z-ANGLE CORRODED BELOW R2 DOOR FLOOR SILL. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA097202Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 445.5, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA097168Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277.8, STR 11R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA097169Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND L2 DOOR EVAC SLIDE GIRT BAR FLOOR FITTINGS CORRODED. REMOVED AND REPLACED FITTINGS PER MM.SDR SWAA097167Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR EVAC SLIDE GIRT BAR FLOOR FITTINGS CORRODED. REMOVED AND REPLACED FITTINGS PER MM.SDR SWAA097166Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR EVAC SLIDE GIRT BAR FLOOR FITTINGS CORRODED. REMOVED AND REPLACED FITTINGS PER MM.SDR SWAA097165Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR EVAC SLIDE GIRT BAR FLOOR FITTINGS CORRODED. REMOVED AND REPLACED FITTINGS PER MM.SDR SWAA097163Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND EMERGENCY BULLNOSE LIGHT INOP AT 12 ABC. RELAMPED PER MM.SDR SWAA097162Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER FLANGE CORRODED AT BS 328, LBL 2. REPAIRED BEAM PER SRM.SDR SWAA097164Sign · damagedDURING SCHEDULED 22Y CHECK, FOUND RT OVERWING EMERGENCY EXIT SIGN DAMAGED. REMOVED AND REPLACED SIGN PER MM.SDR SWAA097161Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND SEVERAL EMERGENCY EXIT LIGHTS INOP. RELAMPED PER MM.SDR SWAA097135Lens · brokenDURING SCHEDULED 22Y CHECK, FOUND UPPER AFT EMERGENCY EXIT LIGHT LENS BROKEN AT LT SIDE. REMOVED AND REPLACED LENS PER MM.SDR SWAA097102Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 2R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097101Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097100Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097099Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 909, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA097038Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097037Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097036Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097035Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097033Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095299Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA095298Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA094846Slide · out of adjustDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA094845Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA094844Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.
Back to N333SW, cancelled Sep 18, 2017