N320SW, cancelled Jun 3, 2008
Service difficulty reports · 211
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 = 'N320SW' AND deregistration_id = 'N320SW-2008-06-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 = 'N320SW' AND deregistration_id = 'N320SW-2008-06-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 SWAA961267Channel · corrodedDURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT CHANNELS CORRODED AT BS 727D PLUS 5 AND AT 772, LBL 12.5, LBL 3, 8 , 12.5, 8.10. REPAIRED PER BOEING SRM.SDR SWAA961266Skin · gougedDURING SCHEDULED D-CHECK, FUSELAGE SKIN GOUGED AT BS 368, BELOW S4L. REPAIRED PER BOEING SRM.SDR SWAA961265Web · crackedDURING SCHEDULED D-CHECK, WEB CRACKED BELOW LEFT EMERGENCY EXIT CUTOUT AT BS 637. REPLACED PER BOEING SRM.SDR SWAA961264Mopsill · corrodedDURING SCHEDULED D- CHECK, FOUND AFT GALLEY DOORWAY MOPSILL CORRODED FROM BS 947 TO 986 AND AT FWD SERVICE DOOR MOPSILL FROM BS 294 TO 338. REPAIRED PER BOEING SRM.SDR SWAA961263Support · corrodedDURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 986 TO 994, WL 208. REPLACED PER BOEING SRM.SDR SWAA961262Angle · crackedDURING SCHEDULED D-CHECK, FOUND UPPER ATTACH ANGLE ON SHEAR WEB CRACKED AT BS 927 TO 947. REPAIRED PER BOEING SRM.SDR SWAA961261Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT HAT SECTION ANGLE AT BS 907, BETWEEN S9 AND 8L, AND AT BS 400, BETWEEN S9 AND 8L. REPAIRED PER BOEING SRM.SDR SWAA961260Stringer · damagedDURING SCHEDULED D-CHECK, FOUND STRINGER 8R DAMAGED AT BS 335. REPLACED DAMAGED SECTION PER BOEING SRM.SDR SWAA961259Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT BS 663, S10R AT BS 500D, S19R AND AT BS 908, S4L. REPLACED PER BOEING SRM.SDR SWAA961258Skin · crackedDURING SCHEDULED D-CHECK, FOUND FWD SERVICE DOOR LOWER AFT SKIN CUTOUT CRACKED AT BS 328, RBL 65, WL 210. REPAIRED PER BOEING SRM.SDR SWAA950589Casting · crackedDURING SCHEDULED C1 CHECK, FOUND CRACK IN UPPER FWD CORNER OF FWD ENTRY DOOR LOWER CAM PLATE SUPPORT CASTING. REPAIRED PER SWA RA 1-353-1331 AND BOEING STRUCTURAL REPAIR MANUAL.
Back to N320SW, cancelled Jun 3, 2008