N302SW, cancelled Sep 29, 2014
Service difficulty reports · 369
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 = 'N302SW' AND deregistration_id = 'N302SW-2014-09-29' 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 = 'N302SW' AND deregistration_id = 'N302SW-2014-09-29' 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 SWAA073061Torque Tube · wornDURING SCHEDULED HC2 CHECK, FOUND LEFT WING OUTBOARD T/E FLAP TORQUE TUBE WORN OUTBOARD OF 120 DEGREE GEARBOX. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA073060Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 271, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA073056Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072582Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 800, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA072581Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 782, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA072216Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 924, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA072217Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 384, STR 15L. REPAIRED SKIN PER SRM.SDR SWAA071776Glowstrip · missingEEPLS PHOTOLUMINESCENT STRIP MISSING AT ROW 5 DEF. INSTALLED STRIP PER MM.SDR SWAA071740Lamp · inoperativeDURING SCHEDULED HC1 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA071739Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA071738Skin · delaminatedDURING SCHEDULED HC1 CHECK, FOUND RIGHT WING INBOARD FORE FLAP UPPER AFT SURFACE DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA070997Hydraulic Line · leakingON SHORT FINAL -A- SYSTEM HYDRAULIC FLUID LOSS AND SYSTEM FAILURE. FOUND HYDRAULIC LINE LEAKING AT RT MLG RETRACT ACTUATOR. REMOVED AND REPLACED HYDRAULIC LINE PER MM.SDR SWAA070266Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 804, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA070265Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 494, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA070271Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 924, STR 4R. REPAIRED SKIN PER SWA EA.SDR SWAA070270Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 851, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA070269Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 972, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA070268Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 909, STR 3L. REPAIRED SKIN PER SWA EA.SDR SWAA070267Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 765, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA064480Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 582, STR 10L. REPAIRED PER SWA EA & SRM.SDR SWAA064479Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 370, STR 14R. REPAIRED PER SWA EA & SRM.SDR SWAA064478Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 573, STR 10R. REPAIRED PER SWA EA & SRM.SDR SWAA064477Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 18L. REPAIRED PER SWA EA & SRM.SDR SWAA064476Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 917, STR 22R. REPAIRED PER SWA EA & SRM.SDR SWAA064145Actuator · faultyLANDING HANDLE MOVED TO OFF POSITION, NLG DROPPED. CYCLED GEAR HANDLE ALL INDICATIONS NORMAL, MOVED HANDLE TO OFF POSITION. REMOVED AND REPLACED M983 LOGIC CARD AND NLG RETRACT ACTUATOR PER MM.SDR SWAA063662Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CORRODED FROM BS 523 TO BS 538, RBL 7. REPAIRED SKIN PER ER.SDR SWAA063661Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 533, STR 28R. REPAIRED SKIN PER SRM.SDR SWAA063623Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 285, STR 24R. REPAIRED SKIN PER ER.SDR SWAA063622Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 275, STR 22R. REPAIRED SKIN PER ER.SDR SWAA063619Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 326, STR 28R. REPAIRED SKIN PER ER.SDR SWAA063618Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 360, STR 28L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA063617Door Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063588Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 28R CORRODED AT BS 320. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA063544Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 360, STR 27R. REPAIRED SKIN PER SRM.SDR SWAA063543Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986, STR 2L. REPAIRED FRAME SECTION PER SRM.SDR SWAA063542Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 328, BL 0 TO RBL 42. REPAIRED FLOORBEAM CHORD PER SRM.SDR SWAA063541Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA063522Shear Tie · crackedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CRACKED AT BS 294, STR 12L. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA063504Girt Bar · looseDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOOK LOOSE. SECURED DOOR HOOK PER SRM.SDR SWAA063406Slide · out of adjustDURING SCHEDULED 22Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA062793Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 832, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA062472Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA062107Actuator · faultyNOSE GEAR WOULD NOT LOCK IN THE UP POSITION. CYCLED GEAR HANDLE OFF/UP GEAR LOCKED. REMOVED AND REPLACED NLG RETRACT ACTUATOR PER MM.SDR SWAA061843Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA060503Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA053386Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 12R. REPAIRED SKIN IAW EA.SDR SWAA053385Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 910, STR 4L. REPAIRED SKIN IAW EA.SDR SWAA052654Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 941, STR 4R. REPAIRED SKIN PER SWA EA.SDR SWAA052200Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA052108Rod · wornDURING SCHEDULED C2 CHECK, RT WING AILERON FAILED THE FREE PLAY CHECK. REMOVED AND REPLACED RT AILERON CONTROL ROD PER MM.
Back to N302SW, cancelled Sep 29, 2014