N303SW, cancelled Oct 26, 2017
Service difficulty reports · 391
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 = 'N303SW' AND deregistration_id = 'N303SW-2017-10-26' 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 = 'N303SW' AND deregistration_id = 'N303SW-2017-10-26' 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 SWAA060145Mount · brokenDURING SCHEDULED PM CHECK, FOUND EMERGENCY EXIT LIGHT BASE BATTERY MOUNT BROKEN. REMOVED AND REPLACED BATTERY BASE PER MM.SDR SWAA060144Battery Pack · inoperativeDURING SCHEDULED PM CHECK, FOUND EMERGENCY EXIT DOOR LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA053988Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 942, STR 24L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA053987Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 21L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA053986Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 368, STR 25L. REPAIRED SKIN PER SWA EA.SDR SWAA053631Pressure Panel · crackedDURING SCHEDULED SERVICE CHECK, FOUND NLG W/W LEFT FWD PRESSURE SIDE WEB CRACKED AT BS 251.625, WL 177. REPAIRED WEB PER SWA EA & SRM.SDR SWAA053438Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 700, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA053437Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA053436Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 446, STR 26L. REPAIRED SKIN PER SWA EA.SDR SWAA052994Skin · crackedDURING WALKAROUND INSP, FOUND FUSELAGE SKIN CRACKED AT BS 450, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA052701Door Frame · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR FWD FRAME CRACKED AT BALANCE CABLE PULLEY MOUNT BRACKET. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA052700Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 863, STR 16L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA052699Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 324, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA051566Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 861 TO BS 864, ABOVE STR 16L. REPAIRED SKIN PER SRM.SDR SWAA051079Light · looseLEFT OVERWING EMERGENCY EXIT LIGHT LOOSE. SECURED LIGHT PER MM.SDR SWAA050426Skin · crackedFOUND FUSELAGE SKIN AT BS 450, STRINGER 16R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043156Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500, STRINGER 16R. REPAIRED SKIN PER SRM.SDR SWAA043155Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 2 EA FUSELAGE SKIN CRACKS BETWEEN 937 & BS 947, STRINGER 25R. REPAIRED SKIN PER SRM.SDR SWAA043154Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 271, STRINGER 16R. REPAIRED SKIN PER SRM.SDR SWAA043153Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 908, STRINGER 4L. REPAIRED SKIN PER SRM.SDR SWAA043152Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 3 EA FUSELAGE SKIN CRACKS BETWEEN BS 450 & BS 500A, STRINGER 16L. REPAIRED SKIN PER SRM.SDR SWAA042207Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 517, STRINGER 12R, BS 520, STRINGER 12R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042197Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 510, STRINGER 15R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041579Stringer Clip · crackedDURING SCHEDULED SERVICE CHECK, FOUND STRINGER TIE CLIP AT BS 807, STRINGER 18L, CRACKED. REMOVED AND REPLACED STRINGER TIE PER SRM.SDR SWAA041578Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 813, STRINGER18L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041507Structure · delaminatedDURING SCHEDULED A1 CHECK, FOUND RIGHT WING T/E OUTBOARD AFT FLAP, DELAMINATED. REMOVED AND REPLACED RIGHT OUTBOARD AFT FLAP PER MM.SDR SWAA041303Slide · dislodgedL1 DOOR EVAC SLIDE FELL OUT OF CONTAINER, DID NOT DEPLOY. REINSTALLED L1 DOOR EVAC SLIDE PER MM.SDR SWAA041069Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 1000, STRINGER 20L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040039Mount · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION AT HORIZONTAL STABILIZER RIGHT CENTER SECTION HINGE HOUSING UPPER MOUNT LUG. REPAIRED MOUNT LUG PER ER.SDR SWAA040035Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 776, LBL 68, WL 208. REPAIRED WEB PER SRM.SDR SWAA040034Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 270, BETWEEN STRINGERS 15L AND 14L. REPAIRED SKIN CRACK PER SRM.SDR SWAA040007Skin · crackedDURING SCHEDULED D CHECK, FOUND AFT CARGO DOOR EXTERNAL SKIN CRACKED AT UPPER AFT CORNER OF HANDLE CUTOUT. REPAIRED PER SRM.SDR SWAA032839Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER 26L CRACKED AT BS 1020. REPAIRED STRINGER PER SRM.SDR SWAA032838Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, WL 202, RT SIDE. REPAIRED FRAME BFG ER.SDR SWAA032837Bear Strap · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN BEAR STRAP CORRODED AT BS 847, WL 148, RBL10. REPAIRED STRAP PER BFG ER.SDR SWAA032832Fitting · corrodedDURING SCHEDULED D CHECK, FOUND VERTICAL STAB ATTACH FITTING FRONT SPAR LEFT AND RIGHT AFT BODY CLEVICES CORRODED. REPAIRED FITTING PER BFG ER.SDR SWAA032768Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 44, WL 208, BS 986.5, LBL 12, WL 208, BS 986.5, LBL 13.5, BS 986, LBL 14, WL 209, BS 986, LBL 44, WL 209, BS 986.5 LBL 16, WL 210, BS 947.5, RBL 11, WL 208, BS 947.5, RBL 15 WL 208, BS 947, RBSDR SWAA032767Frame · corrodedDURING SCHEDULED D CHECK, FOUND FRAME CORRODED AT BS 986.5, RBL 46, WL 208. REPAIRED FRAME PER SRM.SDR SWAA032766Web · corrodedDURING SCHEDULED D CHECK, FOUND FLOOR WEB CORRODED AT BS 1016, LBL 5, WL 208. REPAIRED FLOOR WEB PER SRM.SDR SWAA032765Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 847, LBL 17, WL 148. REPAIRED SHEAR TIE PER SRM.SDR SWAA032757Splice · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM SPLICE CORRODED AT BS 290, RBL 53. REMOVED AND REPLACED CREASE BEAM SPLICE SECTION PER SRM.SDR SWAA032733Wedge · delaminatedDURING SCHEDULED D CHECK, FOUND NR 5 L/E SLAT T/E WEDGE INBOARD END DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA032719Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CORRODED AT BS 727, BS 767, BS 787 AND LBL 9, LBL 18, LBL 4 THROUGH RBL 4. REPAIRED SHEAR TIE PER SRM.SDR SWAA032718Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CORRODED AT BS 847 LBL 3. REPAIRED SHEAR TIE PER SRM.SDR SWAA032717Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FRAME CORRODED AT BS 807, RBL 4. REPAIRED FRAME PER SRM.SDR SWAA032716Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 859, RBL 3 AND LBL 17. REPAIRED CORROSION PER SRM.SDR SWAA032715Stringer Clip · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON STRINGER CLIP BS 847, RBL 13.8. REPAIRED STRINGER CLIP PER SRM.SDR SWAA032704Wedge · delaminatedDURING SCHEDULED D CHECK, FOUND NR 5 T/E FLAP WEDGE OUTBOARD END DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA032703Stringer · crackedDURING SCHEDULED D CHECK, FOUND CRACK IN STRINGER 7L BS 1012. REPAIRED STRINGER PER SRM.SDR SWAA032563Skin · crackedDURING SCHEDULED C2 CHECK, FOUND 8 EA FUSELAGE SKIN CRACKS AT BS 487, STR 26L, AT BS 803, STR 20L, AT BS 970, STR 24L, AT BS 910, STR 23R, AT BS 759, STR 18R, AT BS 933, STR 23R, AT BS 685, STR 10R, AND AT BS 580, STR 10L. REPAIRED SKIN PER SRM.
Back to N303SW, cancelled Oct 26, 2017