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 SWAA032135Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED (2 EA) BS 847 AT STR 16L AND BS 945 AT STR 21L. REPAIRED SKIN PER SRM.SDR SWAA032058Strip · looseEEPLS PHOTOLUMINESCENT STRIP LOOSE IN CABIN. SECURED EEPLS PER MM.SDR SWAA031564Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 360, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA031563Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D + 6, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA030917Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED ( 3 EA ) AT STR 26L, BS 395, BS 430 & BS 455. REPAIRED SKIN PER SRM.SDR SWAA030431Slide · out of positionDURING SCHEDULED RON, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030127Skin · crackedDURING SCHEDULED BC3 CHECK, FOUND FUSELAGE SKIN CRACKS AT BS 848 STR 16L AND BS 972 STR 21L. REPAIRED FUSELAGE SKIN CRACKS PER SRM.SDR SWAA022560Bushing · wornDURING SCHEDULED SERVICE CHECK, SWA SI 11139-55, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED HARDWARE AND BUSHINGS AT NR 1 ELEV TAB HINGE PER MM.SDR SWAA022404Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED (2 EA) AT STR 18L, BS 485 AND BS 492. REPAIRED SKIN PER SRM.SDR SWAA021907Light · inoperativeAFT CABIN OVERHEAD EMERGENCY EXIT LIGHT INOP. RELAMPED EXIT LIGHT PER MM.SDR SWAA021756Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED AT BS 375, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA021376Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 500D PLUS 4, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA021361Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 500D + 4, ABOVE STR 16R. REPAIRED SKIN PER SRM.SDR SWAA021002Spoiler · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND NR 4 GROUND SPOILER DELAMINATED. REMOVED AND REPLACED NR 4 GROUND SPOILER PER MM.SDR SWAA020882Rod End · wornDURING SCHEDULED C4 CHECK, FOUND BOTH LT AND RT ELEVATOR TAB PUSH ROD ENDS WORN. REMOVED AND REPLACED TAB ROD ENDS PER MM.SDR SWAA020224Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED (1.9 INCHES LONG), BS 727E, STRINGER 19R. REPAIRED SKIN PER SRM.SDR SWAA020223Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED (3 INCHES LONG), BS 500C, STRINGER 15R. REPAIRED SKIN PER SWA RA.SDR SWAA012741Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 270, BETWEEN STR 9L & 10L. REPAIRED SKIN PER SRM.SDR SWAA012674Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND TIE CLIP CRACKED AT BS 663, STR 4R. REMOVED AND REPLACED TIE CLIP PER SRM.SDR SWAA012667Splice · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA012666Tie Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER TIE CLIPS CRACKED ( 2 EA ) AT BS 400, STR 4R, BS 767, STR 11L. R&R TIE CLIP PER SRM.SDR SWAA012692Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 927, BBL 0. REPAIRED FRAME PER SRM.SDR SWAA012668Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAMES CRACKED ( 2 EA ) AT BS 500A & BS 500B, STR 14R. REPAIRED FRAMES PER SRM.SDR SWAA012238Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REINSTALLED EVAC SLIDE PER MM.SDR SWAA011784Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT STRINGER 10L, BS 500A & BS 400. REPAIRED SKIN PER SRM.SDR SWAA011783Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA011782Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT STRINGER 10R, BS 500C & BS 727B. REPAIRED SKIN PER SRM.SDR SWAA011777Lens · missingDURING SCHEDULED C1 CHECK, FOUND EMERGENCY EXIT LIGHT LENS MISSING AT FWD CABIN CEILING. INSTALLED LENS PER MM.SDR SWAA011597Slide · unserviceableDURING SCHEDULED RON CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA010995Stiffener · crackedDURING SCHEDULED RON CHECK, FOUND WING CENTER SECTION REAR SPAR ZEE STIFFENER CRACKED AT LBL 6.15. REPAIRED STIFFENER PER SWA RA.SDR SWAA010769Skin · crackedDURING SCHEDULED C4 CHECK, FOUND 4 INCH EXTERNAL FUSELAGE SKIN CRACK AT BS 927, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA010768Lens · missingDURING SCHEDULED C4 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA010784Skin · crackedDURING SCHEDULED C4 CHECK, FOUND 1.25 EXTERNAL FUSELAGE SKIN CRACK AT BS 927, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA010783Skin · crackedDURING SCHEDULED C4 CHECK, FOUND 6 EXTERNAL FUSELAGE SKIN CRACK AT BS 420, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA010782Skin · crackedDURING SCHEDULED C4 CHECK, FOUND 2.5 EXTERNAL FUSELAGE SKIN CRACK AT BS 727B, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA010781Skin · crackedDURING SCHEDULED C4 CHECK, FOUND 2 EXTERNAL FUSELAGE SKIN CRACKS AT BS 500B, STR 10R, 1 IN LENGTH & BS 500C, STR 10R, 3 IN LENGTH. REPAIRED SKIN PER SRM.SDR SWAA010780Skin · crackedDURING SCHEDULED C4 CHECK, FOUND 5 EXTERNAL FUSELAGE SKIN CRACK AT BS 500, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA010779Skin · crackedDURING SCHEDULED CHECK, FOUND 3.25 EXTERNAL FUSELAGE SKIN CRACK AT BS 787, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA010778Skin · crackedDURING SCHEDULED C4 CHECK, FOUND NR 1 L/E SLAT LOWER SKIN CRACKED AT 2 FASTENER HOLES, AFT ROW, OUTBD MAIN TRACK. REPAIRED SLAT SKIN.SDR SWAA002677Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 1.5 EXTERNAL FUSELAGE SKIN CRACK, LT SIDE, AT BS 518, WL 250. REPAIRED SKIN PER SRM.SDR SWAA002505Retainer · looseDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY RETAINER LOOSE. SECURED RETAINER PER MM.SDR SWAA002364Slide · out of adjAFT SVC EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002289Slide · dislodgedAFT SVC EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA002262Battery · inoperativeLOWER AFT EMERGENCY FLASHLIGHT DOES NOT SHOW CHARGE. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA001755Frame · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND CRACKED BS 178 VERT CHORD, WL 184, LBL 5.7. REPAIRED CHORD PER SRM.SDR SWAA001628Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FELL A FEW INCHES OUT OF CONTAINER AS DOOR WAS OPENING. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001332Skin · crackedDURING WALK AROUND CHECK, FOUND FUSELAGE EXTERNAL SKIN CRACKED, BS 505, STRINGER 10R, BS 734, STRINGER 20R AND BS 525, STRINGER 10L. REPAIRED SKIN PER SRM.SDR SWAA001202Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 2, 3 INCH LONG CRACKS AT FUSELAGE EXTERNAL SKIN, BS 500 AND BS 887, ABOVE STR 10L. REPAIRED SKIN PER SRM.SDR SWAA000250Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE EXTERNAL SKIN CRACKED, AFT ENTRY DOOR UPPER AFT CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA000248Skin · crackedDURING SCHEDULED C4 CHECK, FOUND EXTERNAL FUSELAGE SKIN CRACKED, BS 520, STRINGER 10R AND BS 500, STRINGER 10L. REPAIRED SKIN PER SRM.
Back to N303SW, cancelled Oct 26, 2017