N102SW, cancelled Mar 3, 2006
Service difficulty reports · 147
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 = 'N102SW' AND deregistration_id = 'N102SW-2006-03-03' 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 = 'N102SW' AND deregistration_id = 'N102SW-2006-03-03' 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 SWAA011154Indicator · inoperativeAIR TURNBACK, WX RADAR INDICATOR INOP OUT DURING TAKEOFF. R&R WX RADAR INDICATOR PER MM, OPS CHECK GOOD.SDR SWAA011153Sensor · faultyAIR TURNBACK, NR 4 KRUGER FLAP IN TRANSIT LIGHT WOULD NOT EXTINGUISH AT FLAPS 10 DEG POSITION. R&R NR 4 KRUGER FLAP DOWN SENSOR PER MM & BAC WDM. OPS CHECK GOOD.SDR SWAA011098Transmitter · faultyAIR TURNBACK, NR1 ENG OIL OVERTEMP INDICATION. SHUT DOWN ENGINE. R&R OIL FILTER, OIL TEMP BULB & PRESSURE TRANSMITTER PER MM. PERFORMED BREATHER PRESSURE CHECK PER SWA SAM 146. NO DEFECTS NOTED.SDR SWAA010886Skin · crackedDURING WALKAROUND INSPECTION, FOUND EXTERNAL FUSELAGE SKIN CRACKED AT STR 22R, BS 927 & 947.5. REPAIRED SKIN PER SRM.SDR SWAA010795Slide · out of positionAFT ENTRY AND SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY''S PER MM.SDR SWAA010594Cap · missingDURING SCHEDULED C3 CHECK, FOUND EEPLS END CAP MISSING AT FWD SECTION. INSTALLED END CAP PER MM.SDR SWAA010469Slide · out of positionAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA010237Light · looseAFT ENTRY DOOR EMERGENCY EXIT LIGHT COVER LOOSE. SECURED LIGHT COVER PER MM.SDR SWAA010093Window · crackedAIR TURNBACK, R1 WINDOW CRACKED DURING T/O. REMOVED AND REPLACED WINDOW PER MM. PRESS AND LEAK CHECK GOOD PER MM.SDR SWA002788Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWA002782Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA002667Slide · out of positionAFT SVC & AFT ENTRY DOOR EMERGENCY EVAC SLIDE ASSY PRESS INDICATORS OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002591Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. READJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA002535Slide · out of positionAFT SERVICE DOOR EVAC SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002508Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA002493Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002463Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND BOTH AFT EMERGENCY EVAC DOORS SLIDE PRESS IND OUT OF VIEW. ADJUSTED SLIDE ASSYS PER MM.SDR SWAA002255Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001944Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY ASSY PER MM.SDR SWAA001765Slide · dislodgedAFT SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REPOSITIONED SLIDE PER MM.SDR SWAA001564Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND STRINGER 21R CORRODED, BS 903. REPAIRED STRINGER PER SRM.SDR SWAA001563Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND STRINGER 21R CORRODED, BS 903. REPAIRED STRINGER PER SRM.SDR SWAA001562Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 1016 BULKHEAD CRACKED, LBL 30, WL 290. REPAIRED BULKHEAD PER SB.SDR SWAA001535Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND RT HORIZONTAL STAB CENTER SECTION REAR SPAR UPPER AND LOWER AFT LUGS CORRODED. REPAIRED FITTING LUGS PER SRM ACO ER 00-0809.SDR SWAA001497Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER 13R CRACKED, BS 807. REPAIRED STRINGER SECTION PER SRM.SDR SWAA001396Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION DAMAGE AT SHEAR TIE, BS 727A, LBL 1. REPAIRED SHEAR TIE SECTION PER SRM.SDR SWAA001388Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND BS 1121, LBL 30 SHEAR TIE CRACKED. REPAIRED SHEAR TIE SECTION PER SRM.SDR SWAA001387Frame · crackedDURING SCHEDULED D-CHECK, FOUND AFT SERVICE DOOR FUSELAGE CUTOUT STUB FRAME CRACKED, BS 954, STRINGER 10R. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA001386Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 2 STRINGER CLIPS CRACKED, BS 597 AND BS 616, STRINGER 4L. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA001376Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CRACKED, BS 1154, STRINGER 5R. REPAIRED STRINGER SECTION PER SRM.SDR SWAA001375Stringer · crackedDURING SCHEDULED D-CHECK, FOUND 2 STRINGER SPLICES CRACKED, BS 907, STRINGERS 4L AND 4R. REMOVED AND REPLACED STRINGER SPLICES PER SRM.SDR SWAA001374Spar · crackedDURING SCHEDULED D-CHECK, FOUND RT WING AFT SPAR MOST I/B FASTENER HOLE CRACKED IN UPPER CHORD. REPAIRED PER ER 00-0797.SDR SWAA001369Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED, BS 189, LBL 31. REPAIRED FRAME SECTION PER SRM.SDR SWAA001368Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM CRACKED AT FASTENER HOLE, BS 178 - BS 188, LBL 31. REMOVED AND REPLACED CREASE BEAM SECTION PER SRM.SDR SWAA001367Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED, BS 727B STR 6L, BS 787 STR 11L, BS 767 STR 7R, BS 807, STR 8R, BS 767 STR 3R, BS 727A STR 2R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA001366Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND STRINGER 23R CORRODED, BS 907. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA001351Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 7 STRINGER CLIPS CRACKED, BS 727A, STR 7L, STR 7R, STR 10R, BS 727B, STR 8R, BS 767, STR 7L, BS 787, STR 10L, AND BS 827, STR 6L. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA001350Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED, BS 360, BETWEEN STRINGERS 14R - 15R. REPAIRED SHEAR TIE PER SRM.SDR SWAA001327Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 5 STRINGER CLIPS CRACKED, BS 727A, STRINGER 14L, BS 727B, STRINGERS 9R, 7R AND 4L, BS 847, STRINGER 10R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA001319Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND STRINGER 26R CORRODED, BS 1009. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA001318Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER 15L CRACKED, BS 360. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA001312Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME SUPPORT CRACKED, BS 332, STRINGER 7R. REMOVED AND REPLACED FRAME SUPPORT SECTION PER SRM.SDR SWAA001311Skin · crackedDURING SCHEDULED D-CHECK, FOUND AFT SERVICE DOOR UPPER HINGE FUSELAGE SKIN CUTOUT CRACKED. REPAIRED SKIN PER SRM.SDR SWAA001310Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOOR BEAM CORRODED, BS 967, LBL 18, WL 208. REPAIRED BEAM PER SRM.SDR SWAA001291Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME, BS 616, RBL 64, WL 201. REPAIRED FRAME PER SRM AND TRM.SDR SWAA001290Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME, BS 807, STRINGER 11R. REPAIRED FRAME PER SRM.SDR SWAA001289Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION AT STRINGER 27R, BS 907. REPAIRED STRINGER SECTION PER SRM.SDR SWAA001288Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND I/B CREASE BEAM CRACKED AT TWO PLACES, BS 520, RBL 64. REPAIRED CREASE BEAM PER SRM.SDR SWAA001274Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD CRACKED AT 3 PLACES, LBL 5 TO LBL 12. BULKHEAD WEB REPLACED PER ACO.SDR SWAA001273Stiffener · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD VERTICAL STIFFENERS CRACKED, LBL 7 AND RBL 17, WL 225. REMOVED AND REPLACED VERTICAL STIFFENERS PER SRM AND ACO.
Back to N102SW, cancelled Mar 3, 2006