N305SW, cancelled Sep 1, 2011
Service difficulty reports · 324
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 = 'N305SW' AND deregistration_id = 'N305SW-2011-09-01' 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 = 'N305SW' AND deregistration_id = 'N305SW-2011-09-01' 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 SWAA070809Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA070808Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA070810Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986, STR 27L. REPAIRED FRAME PER SWA EA.SDR SWAA070807Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 9L AND STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA070769Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 21R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070768Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 951, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070755Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070754Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070767Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070756Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070757Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070758Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070759Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 3R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070760Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 2R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070761Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 3R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070766Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070762Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 1L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070763Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070764Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070765Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070770Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 927, STR 24L. REPAIRED SHEAR TIE PER SRM.SDR SWAA070688Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 9L. REPAIRED FRAME PER SWA EA.SDR SWAA070687Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9L. REPAIRED FRAME PER SWA EA.SDR SWAA070667Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 18R. REPAIRED FRAME PER SRM.SDR SWAA070647Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 706, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA070645Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 506D, STR 7R. REPAIRED SKIN PER SRM.SDR SWAA070646Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503D, STR 8R. REPAIRED SKIN PER SRM.SDR SWAA063806Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 937, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA063805Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 907, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA063804Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP INBOARD LOWER CORNER DELAMINATED. REMOVED AND REPLACED T/E AFT FLAP PER MM.SDR SWAA063803Glowstrip · wornDURING SCHEDULED C2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 7 ABC. REMOVED AND REPLACED PHOTOLUMINESCENT STRIP PER MM.SDR SWAA063321Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 516, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA063237Support Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND RT MLG SIDE STRUT SUPPORT FITTING LUG CORRODED AT RT BS 685. REPAIRED FITTING PER SWA EA.SDR SWAA063236Support Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LT MLG SIDE STRUT SUPPORT FITTING LUG CORRODED AT LT BS 685. REPAIRED FITTING PER SWA EA.SDR SWAA063235Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA062124Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA061527Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 413, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA061526Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 434, STR 16R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA060869Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 512B, STR 16L. MX FERRY TO DAL FOR REPAIRS. REPAIRED SKIN PER SWA EA.SDR SWAA060868Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 455, STR 16L. MX FERRY TO DAL FOR REPAIRS. REPAIRED SKIN PER SRM.SDR SWAA060867Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 270, STR 15R. MX FERRY TO DAL FOR REPAIRS. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060866Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 266, STR 9L. MX FERRY TO DAL FOR REPAIRS. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060865Cover · missingDURING SCHEDULED C4 CHECK, FOUND EEPLS STRIP COVER MISSING AT ROW 8 ABC. REMOVED AND REPLACED STRIP PER MM.SDR SWAA060864Tab · crackedDURING SCHEDULED C4 CHECK, FOUND RT ELEVATOR TAB CRACKED AT NR 2 HINGE CUTOUT. REMOVED AND REPLACED TAB PER MM.SDR SWAA060344Skin · crackedDURING WALKAROUND INSP, FOUND FUSELAGE SKIN CRACKED AT BS 420, STR 17R. REPAIRED SKIN PER SWA EA.SDR SWAA054142Cover · missingEMERGENCY EXIT BULLNOSE LIGHT COVER MISSING AT ROW 18. INSTALLED COVER PER MM.SDR SWAA053866Lens · looseDURING SCHEDULED C3 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA053146Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, BETWEEN STR 19R TO STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA053145Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 390, STR 17R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA053144Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 404, STR 17R. REPAIRED SKIN PER SWA EA & SRM.
Back to N305SW, cancelled Sep 1, 2011