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 SWAA053143Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 700, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA053123Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 767, BETWEEN LBL 7 TO LBL 13. REPAIRED SHEAR TIE PER SRM.SDR SWAA053122Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SWA EA.SDR SWAA053125Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 1016 BULKHEAD WEB CRACKED AT DOME CAP, 1 O'CLOCK POSITION. REPAIRED WEB PER SWA EA.SDR SWAA053124Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 12R. REPAIRED SKIN PER SWA EA.SDR SWAA053115Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 433, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA053114Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA053113Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 767, STR 25L. REPAIRED STRINGER PER SRM.SDR SWAA053112Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CRACKED AT BS 662, RBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053092Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 767, RBL 6. REPAIRED SHEAR TIE PER SRM.SDR SWAA053091Floor Support · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOOR SUPPORT CORRODED BETWEEN BS 859 TO BS 867, LBL 12.0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053090Floor Support · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOOR SUPPORT CORRODED BETWEEN BS 859 TO BS 867, LBL 8.0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053089Floor Support · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOOR SUPPORT CORRODED BETWEEN BS 859 TO BS 867, LBL 3.0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053088Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 12L. REPAIRED SKIN PER SWA EA.SDR SWAA053087Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 1016 BULKHEAD WEB CRACKED AT DOME CAP, 2 O'CLOCK AND 4 O'CLOCK POSITIONS. REPAIRED WEB PER SWA EA.SDR SWAA053086Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 773, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA053085Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 950, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA053084Lens · looseDURING SCHEDULED 1/4D CHECK, FOUND BULLNOSE EMERGENCY LIGHT LENS LOOSE AT ROW 10 ABC. REMOVED AND REPLACED LENS PER MM.SDR SWAA053083Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 348.2, STR 17L. REPAIRED FRAME WEB PER SRM.SDR SWAA053082Stringer · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 409, STR 17R. REPAIRED STRINGER PER SRM.SDR SWAA053066Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 259.5, WL 210, LT SIDE. REPAIRED SKIN PER SRM.SDR SWAA053065Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA053053Lens · missingDURING SCHEDULED 1/4D CHECK, FOUND CENTER CABIN EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA053052Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 426.25, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA053051Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500A, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA052338Keelbeam · corrodedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE KEEL BEAM CORRODED AT BS 536, LBL 6.5. REPAIRED KEEL BEAM PER SRM.SDR SWAA052318Flap · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA051983Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 311, STR 20R. MX FERRY TO PHX, REPAIRED SKIN PER SWA EA & SRM.SDR SWAA051581Skin · crackedDURING WALK AROUND INSP, FOUND FUSELAGE SKIN CRACKED AT BS 480 TO BS 500, STR 16L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA051342Tire · separatedDURING POST FLIGHT INSPECTION, FOUND LT MLG TIRE TREAD SEPARATED & AFT T/E FLAP DAMAGE. REMOVED AND REPLACED MLG TIRE ASSY & LT INBOARD AFT T/E FLAP PER MM.SDR SWAA051224Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500 + 13, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA051223Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 402, STR 16R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA050183Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 500A,STRINGER 16R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050149Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1 AND L1 DOOR EVAC SLIDES OUT OF ADJUST. ADJUSTED BOTH R1 AND L1 DOOR EVAC SLIDES PER MM.SDR SWAA050148Glowstrip · wornDURING SCHEDULED C4 CHECK, FOUND EMERGENCY EXIT PHOTOLUMINESCENT STRIP AT ROW 8 ABC, WORN. REMOVED AND REPLACED PHOTOLUMINESCENT STRIP PER MM.SDR SWAA043714Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 454, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA043006Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 430, STRINGER 17R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042926Skin · crackedDURING SCHEDULED C3 CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS AT BS 749, STRINGER 19R, BS 800, STRINGER 18R. REPAIRED SKIN SECTIONS PER EA.SDR SWAA042916Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C+16, ABOVE STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA042496Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 270, STRINGER 14L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042375Slide · dislodgedL1 DOOR EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040973Lens · missingDURING SCHEDULED C1 CHECK, FOUND AFT CABIN OVERHEAD EMERGENCY EXIT SIGN MISSING LENS. INSTALLED EMERGENCY EXIT LENS PER MM.SDR SWAA040972Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS AT BS 470, STRINGER 17R, BS 500D, STRINGER 16L. REPAIRED SKIN PER SRM.SDR SWAA040970Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 3 EACH FUSELAGE SKIN CRACKS AT BS 425, BS 452, STRINGER 16R, AND BS 390, STRINGER 17R. REPAIRED SKIN PER SRM.SDR SWAA040971Floorbeam · corrodedDURING SCHEDULED C1 CHECK, FOUND FLOORBEAM WEB AT BS 967, LBL 5, WL 208, CORRODED. REPAIRED WEB PER SRM.SDR SWAA031898Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED (4 EA) BS 500D, BETWEEN STR 15R AND STR 16R, BS 395 ABOVE STR 15L, BS 773 AT STR 19L AND BS 805 AT STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA031443Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663.75, BETWEEN STR 2L AND 3R. REPAIRED FRAME PER SRM.SDR SWAA031442Skin · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 947.5 AT STR 25L. REPAIRED SKIN PER SRM.SDR SWAA031436Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 20L. REPAIRED SKIN PER BFG ER.SDR SWAA031434Skin · crackedDURING SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 500C, ABOVE STR 15L. REPAIRED SKIN AT PAE DURING D-CHECK PER BFG ER.
Back to N305SW, cancelled Sep 1, 2011