N357SW, cancelled Mar 22, 2018
Service difficulty reports · 356
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 = 'N357SW' AND deregistration_id = 'N357SW-2018-03-22' 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 = 'N357SW' AND deregistration_id = 'N357SW-2018-03-22' 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 SWAA082805Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA082776Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 188, STR 17L. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA082775Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 188, STR 17R. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA082774Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 6R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA082769Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082743Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082744Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082745Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 867 TO BS 887, LBL 65. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082746Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 188, STR 17R. REPAIRED FRAME CHORD PER SRM.SDR SWAA082754Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082586Pressure Panel · crackedDURING SCHEDULED SPV CHECK, FOUND NLG W/W RIGHT CEILING PANEL WEB CUTOUT CRACKED AT RBL 2.7. REPAIRED WEB PER ACO.SDR SWAA082560Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082561Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082562Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082563Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082564Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082565Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT CRACKED AT BS 413, LBL 3. REPAIRED SKIN PER SRM.SDR SWAA082535Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082566Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082567Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082540Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082539Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082538Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082537Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082536Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082511Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082459Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082458Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082457Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 8R AND STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082456Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082416Sign · brokenDURING SCHEDULED SPV CHECK, FOUND FWD CABIN EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED SIGN ASSY PER MM.SDR SWAA081222Slat · crackedDURING SCHEDULED HC2 CHECK, FOUND LT WING NR1 L/E SLAT CRACKED AT OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA075037Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 945, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA072959Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA071152Skin · chafedDURING SCHEDULED BRDG CHECK, FOUND UPPER FUSELAGE SKIN CHAFED AT DORSAL FIN SECTION BS 857 TO BS 870. REPAIRED SKIN PER EA.SDR SWAA071111Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR CUTOUT FWD FRAME CRACKED AT BS 303, STR 16L. REPAIRED FRAME SECTION PER SRM.SDR SWAA071090Fitting · corrodedDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA071055Shear Tie · crackedDURING SCHEDULED 14Y CHECK, FOUND SHEAR TIE CRACKED AT BS AT BS 294, STR 10L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA071032Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 742D, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA071031Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 743D, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA070999Handle · out of adjustDURING SCHEDULED 14Y CHECK, FOUND FLIGHT COMPT R2 WINDOW EMERGENCY RELEASE HANDLE INOP. ADJUSTED R2 WINDOW RELEASE HANDLE PER MM.SDR SWAA070920Torque Tube · wornDURING SCHEDULED BRDG CHECK, FOUND RIGHT WING AFT FLAP OUTBOARD TORQUE TUBE FAILED CHECK. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA070652Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 743D, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA070653Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 742D, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA064082Lens · looseDURING SCHEDULED C4 CHECK, FOUND RT FWD CABIN EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LIGHT LENS PER MM.SDR SWAA063988Fitting · corrodedDURING SCHEDULED A2 CHECK, FOUND LT MLG FWD OUTBOARD HANGER FITTING CORRODED. REMOVED AND REPLACED HANGER FITTING PER SWA EA.SDR SWAA062256Fan · faultyON FINAL DESCENT, ODOR COMING FROM GASPER VENTS IN THE CABIN. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA061520Actuator · failedAIR TURNBACK, RT MLG UNSAFE GEAR INDICATION, GEAR HANDLE IN THE UP POSITION, RED UNSAFE LIGHT ILLUMINATED. REMOVED AND REPLACED RT MLG ACTUATOR PER MM.SDR SWAA061180Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA061179Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT, LOWER AFT CORNER. REPAIRED SKIN PER SRM.
Back to N357SW, cancelled Mar 22, 2018