N396SW, cancelled Jul 9, 2022

Service difficulty reports · 397

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 = 'N396SW' AND deregistration_id = 'N396SW-2022-07-09'
  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.

SDR SWAA2015022536875Fitting · corrodedLEFT NOSE GEAR LOWER LOCK ACTUATOR BRACKET CORRODED. REPAIRED FITTING IAW EA.Feb 21, 2015 · N396SW · Boeing 7373H4 · Landing Gear Retraction/Extension SystemSDR SWAA2015012235951Lens · missingLEFT EMER LIGHT LENS MISSING AT ROW 18. INSTALLED LENS IAW MM.Jan 19, 2015 · N396SW · Boeing 7373H4 · Emergency LightingSDR SWAA2015010535449Slide · looseR2 DOOR SLIDE LOOSE. R & R SLIDE ASSEMBLY IAW MM.Jan 3, 2015 · N396SW · Boeing 7373H4 · Escape SlideSDR SWAA2014101032843Lens · looseEMERGENCY LIGHT LENS LOOSE ABOVE SEAT ROW 2 ABC. SECURED LENS IAW MM.Oct 9, 2014 · N396SW · Boeing 7373H4 · Emergency LightingSDR SWAA2014090931729Tee Fitting · corrodedRIGHT MLG WW HORIZONTAL TEE CORRODED AT BS 710. R & R TEE IAW EO & EA.Aug 28, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014090931728Tee Fitting · corrodedRIGHT MLG WW VERTICAL TEE CORRODED AT BS 710. R & R TEE IAW EO & EA.Aug 28, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014082831387Channel · crackedCHANNEL CRACKED AT BS 348.5 BETWEEN STRINGER 17L TO 16L. R & R CHANNEL IAW SRM.Aug 23, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014090831635Stiffener · crackedLEFT WING NR 3 FLAP TRACK FAIRING STIFFENER CRACKED. R & R STIFFENER IAW SRM & DWG.Aug 22, 2014 · N396SW · Boeing 7373H4 · Trailing Edge FlapsSDR SWAA2014090231540Fitting · crackedRIGHT WING GND SPOILER OTBD FITTING CRACKED. R & R FITTING IAW SRM & DWG.Aug 22, 2014 · N396SW · Boeing 7373H4 · SpoilersSDR SWAA2014090331558Frame · crackedFRAME CRACKED AT BS 787 BETWEEN STRINGER 26R TO 25R. REPAIRED FRAME IAW SRM.Aug 19, 2014 · N396SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2014090231539Strap · crackedSTRAP CRACKED BETWEEN BS 348.2 TO 351.2 STRINGER 16L. R & R STRAP IAW SRM & DWG.Aug 16, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014090231538Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907 STRINGER 3L. R & R SPLICE IAW SRM & DWG.Aug 16, 2014 · N396SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA2014090231447Frame · crackedFRAME CRACKED AT BS 360 BETWEEN STRINGER 28L TO 28R. REPAIRED FRAME IAW EA.Aug 15, 2014 · N396SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2014082531169Tie Clip · crackedTIE CLIP CRACKED AT BS 360 STRINGER 10L. R & R TIE CLIP IAW SRM & DWG.Aug 15, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014082531168Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STRINGER 9L. R & R TIE CLIP IAW SRM & DWG.Aug 15, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014082531167Tie Clip · crackedTIE CLIP CRACKED AT BS 360 STRINGER 8L. R & R TIE CLIP IAW SRM & DWG.Aug 15, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014082531166Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STRINGER 5L. R & R TIE CLIP IAW SRM & DWG.Aug 15, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014090931727Stiffener · corrodedAFT PRESS BULKHEAD Z STIFFENER CORRODED AT BS 1016, BL 0. REPAIRED Z STIFFENER IAW EA.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Main, BulkheadSDR SWAA2014090931726Bulkhead · corrodedAFT PRESS BULKHEAD WEB CORRODED AT BS 1016 RBL 5. REPAIRED WEB IAW EA NO.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Main, BulkheadSDR SWAA2014090431588Angle · crackedCLIP ANGLE CRACKED AT BS 348.2 STRINGER 15L. R & R ANGLE IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014090431587Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2 STRINGER 17L. R & R CHORD IAW EA.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2014090331557Tie Clip · crackedTIE CLIP CRACKED AT BS 380 STRINGER 28L. R & R TIE CLIP IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014090231551Shear Tie · corrodedSHEAR TIE CORRODED AT BS 344 STRINGER 26R. R & R SHEAR TIE IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA2014090231545Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 360 STRINGER 28L. R & R SPLICE IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA2014082831386Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360 STRINGER 7L. R & R CHANNEL IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA2014082731299Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5 STRINGER 23L. R & R SUPPORT IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014082731298Angle · crackedANGLE CRACKED AT BS 328+9 STRINGER 21L. R & R ANGLE IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014082731297Angle · crackedANGLE CRACKED AT BS 328 STRINGER 21L. R & R ANGLE IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014082731296Angle · crackedANGLE CRACKED AT BS 312+9 STRINGER 21L. R & R ANGLE IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014082731295Angle · crackedANGLE CRACKED AT BS 312 STRINGER 21L. R & R ANGLE IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014082631219Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 360 STRINGER 27L. R & R SPLICE IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA2014082131066Angle · crackedANGLE CRACKED ON PLATE NR 2 TRANSMISSION. R & R ANGLE IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Wing, Control SurfacesSDR SWAA2014082131065Angle · crackedANGLE CRACKED ON PLATE NR 1 TRANSMISSION. R & R ANGLE IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Wing, Control SurfacesSDR SWAA2014081931004Tie Clip · crackedTIE CLIP CRACKED AT BS 380 STRINGER 21L. R & R TIE CLIP IAW SRM & DWG.Aug 14, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014090231550Keelbeam · crackedKEEL BEAM WEB CRACKED AT BS 710. R & R WEB IAW SRM & DWG.Aug 13, 2014 · N396SW · Boeing 7373H4 · Fuselage Main, KeelSDR SWAA2014082531165Fitting · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE FITTING CRACKED AT BS 303.9, STRINGER 13L. R & R FITTING IAW SRM & DWG.Aug 13, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014090831634Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 25R. R & R TIE CLIP IAW EA.Aug 12, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014090431586Frame · crackedSTUB FRAME CRACKED AT BS 951 BETWEEN STRINGER 16R TO 17R. REPAIRED STUB FRAME IAW EA.Aug 12, 2014 · N396SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2014082731294Angle · crackedANGLE CRACKED AT BS 500C STRINGER 26R. R & R ANGLE IAW SRM.Aug 12, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014082631218Channel · crackedCHANNEL CRACKED AT BS 727 BL 0. R & R CHANNEL IAW SRM & DWG.Aug 12, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014082531163Angle · crackedANGLE CRACKED BETWEEN BS 927 TO 947.5, BL 0. R & R ANGLE IAW SRM & DWG.Aug 12, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014081931003Tie Clip · crackedTIE CLIP CRACKED AT BS 500A STRINGER 22R. R & R TIE CLIP IAW SRM.Aug 12, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014081931002Tie Clip · crackedTIE CLIP CRACKED AT BS 500C STRINGER 27L. R & R TIE CLIP IAW SRM & DWG.Aug 12, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014081530904Tie Clip · crackedTIE CLIP CRACKED AT BS 727C STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.Aug 12, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014081530898Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STRINGER 19L. R & R TIE CLIP IAW SRM & DWG.Aug 12, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014081530897Tie Clip · crackedTIE CLIP CRACKED AT BS 500B STRINGER 23L. R & R TIE CLIP IAW SRM & DWG.Aug 12, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014081530896Tie Clip · crackedTIE CLIP CRACKED AT BS 400, STRINGER 21L. R & R TIE CLIP IAW SRM & DWG.Aug 12, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2014091131829Skin · delaminatedRIGHT WING OTBD LOWER SURFACE INBD END OF OTBD AFT FLAP DELAMINATED. REPAIRED AFT FLAP IAW SRM.Aug 11, 2014 · N396SW · Boeing 7373H4 · Trailing Edge FlapsSDR SWAA2014090931725Skin · delaminatedRIGHT WING AILERON LOWER SURFACE DELAMINATED. R & R AILERON IAW AMM.Aug 11, 2014 · N396SW · Boeing 7373H4 · AileronsSDR SWAA2014090331556Plate · crackedPLATE CRACKED AT BS 794 STRINGER 25R. R & R PLATE IAW SRM & DWG.Aug 11, 2014 · N396SW · Boeing 7373H4 · Fuselage Miscellaneous Structure
Back to N396SW, cancelled Jul 9, 2022