N312SW, cancelled Oct 31, 2011
Service difficulty reports · 320
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 = 'N312SW' AND deregistration_id = 'N312SW-2011-10-31' 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 = 'N312SW' AND deregistration_id = 'N312SW-2011-10-31' 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 SWAA072250Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 923, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA072248Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 507, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA071842Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 372, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA071572Bar · corrodedDURING SCHEDULED SERVICE CHECK, FOUND RIGHT WING STABILIZER BAR CORRODED. REMOVED AND REPLACED RIGHT WING STABILIZER BAR PER MM.SDR SWAA070289Wedge · debondedDURING SCHEDULED C4 CHECK, FOUND RIGHT WING INBOARD MID FLAP T/E WEDGE DISBONDED AT OUTBOARD END. REMOVED AND REPLACED MID FLAP WEDGE PER MM.SDR SWAA070288Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR CUTOUT FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA070287Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA070231Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA064979Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 415 TO BS 447, BL 0. REPAIRED SKIN PER ER.SDR SWAA064981Battery · inoperativeDURING SCHEDULED SPV CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA064980Lamp · inoperativeDURING SCHEDULED SPV CHECK, FOUND L1 DOOR EMERGENCY EXIT SLIDE LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA064975Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 910, STR 4L. REPAIRED SKIN PER ER.SDR SWAA064974Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 427, BBL 0, RADIO ALT ANTENNA CUTOUT. REPAIRED SKIN PER ER.SDR SWAA064869Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 15L CRACKED AT BS 360. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA063683Pressure Panel · crackedDURING SCHEDULED C3 CHECK, FOUND NLG W/W WEB CRACKED AT RT BS 259, WL 174. REPAIRED WEB PER SWA EA.SDR SWAA063682Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 405, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA062096Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 516, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA062095Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED EVAC SLIDE CABLE PER MM.SDR SWAA062094Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED EVAC SLIDE CABLE PER MM.SDR SWAA062093Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 456, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA061222Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 468, S16R. REPAIRED SKIN PER SRM.SDR SWAA061221Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA061009Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 913, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA060328Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 306 TO BS 308.5, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA060327Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 512.5 TO BS 516A, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA053727Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 466, STR 26L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA053726Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 373, STR 17R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA052925Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 514.50, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA052896Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500A, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA052895Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 412.375, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA052669Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK HOUSING & CHARGER PER MM.SDR SWAA052495Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE FELL OUT. REINSTALLED SLIDE PER MM.SDR SWAA052026Splice · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER SPLICE CORRODED AT BS 360, STR 27L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA052018Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE STUB FRAMES CRACKED AT BS 188, LT & RT SIDE, WL 208. REMOVED AND REPLACED STUB FRAMES PER SRM.SDR SWAA052017Web · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE FLOOR WEB CRACKS BETWEEN BS 188 TO BS 196, LT & RT SIDE, WL 208. REPAIRED FLOOR WEB PER SRM.SDR SWAA052016Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME INNER CHORD CRACKED AT BS 348, LBL 50, WL 208. REPAIRED FRAME INNER CHORD PER SRM.SDR SWAA052015Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT & RT VERTICAL STAB FWD & AFT FAILSAFE CLEVIS LUG FACES CORRODED. REPAIRED LUG FACES PER BFG ER.SDR SWAA051986Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 712, LBL 25, WL 203. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA051985Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 360, STR 28R TO STR 28L, WL 149. REPAIRED FRAME PER SRM.SDR SWAA051984Splice · corrodedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CORRODED AT BS 907, STR 22R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA051973Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 907, STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA051972Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 870, STR 26R. REPAIRED STRINGER PER SRM.SDR SWAA051971Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, STR 25L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA051970Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE SHEAR TIES CORRODED AT BS 787 & BS 807, STR 26L TO STR 26R. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR SWAA051969Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 767, STR 25L TO STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA051968Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE SHEAR TIES CORRODED AT BS 727E & BS 747, STR 27L TO STR 26R. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR SWAA051967Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT & RT VERTICAL STAB ATTACH FITTING FWD & AFT PRIMARY CLEVIS LUG FACES CORRODED. REPAIRED LUG FACES PER BFG ER.SDR SWAA051966Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CREASE BEAM WEB AT BS 312, RBL 60. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR SWAA051965Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD & AFT GIRT BAR FLOOR FITTINGS CORRODED. REMOVED AND REPLACED FITTINGS PER MM.SDR SWAA051945Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BETWEEN BS 727B TO BS 727E, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.
Back to N312SW, cancelled Oct 31, 2011