N306SW, cancelled Feb 18, 2011
Service difficulty reports · 313
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 = 'N306SW' AND deregistration_id = 'N306SW-2011-02-18' 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 = 'N306SW' AND deregistration_id = 'N306SW-2011-02-18' 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 SWAA031753Lens · missingDURING SCHEDULED C3 CHECK, FOUND OVERHEAD CEILING EMERGENCY EXIT LIGHT LENS MISSING AT ROW NR 2. INSTALLED EMERGENCY EXIT LIGHT LENS PER MM.SDR SWAA030979Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 430, FWD END OF NR 2 RADIO ALTIMETER ANTENNA CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA030975Light · inoperativeDURING SCHEDULED C2 CHECK, FOUND BOTH AFT SVC & AFT ENTRY OVERHEAD EMERGENCY EXIT LIGHTS INOP. RELAMPED BOTH AFT SVC & AFT ENTRY EMERGENCY EXIT LIGHTS PER MM.SDR SWAA030081Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 2 EA FUSELAGE SKIN CRACKS, BS 520, STRINGER 12R AND BS 515, STRINGER 16R. REPAIRED SKIN PER SRM.SDR SWAA030080Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED 1.5 LONG, BS 500D, STRINGER 7R. REPAIRED SKIN PER SRM.SDR SWAA020725Cable · frayedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR CABLE FRAYED. REMOVED AND REPLACED CABLE PER MM.SDR SWAA020724Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA013342Beam · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 663 FLOORBEAM CRACKED, BBL 0. REPAIRED BEAM PER BOEING SB 737-57-1210SDR SWAA013325Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, ABOVE STR 14L. REPAIRED FRAME PER SRM.SDR SWAA013320Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 540, STR 10R. REPAIRED FRAME PER SRM.SDR SWAA013319Stringer · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER CRACKED AT BS 500C, STR 15R. REPAIRED STR PER SRM.SDR SWAA013305Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKINCRACKED AT FWD ENTRY DOOR LOWER HINGE CUT OUT. REPAIRED SKIN PER SRM.SDR SWAA013304Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED (3 EA) AT BS 663.5, STRS 2L, 3L AND 2R. REPAIRED FRAME PER SRM.SDR SWAA013301Splice · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 10R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA013302Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 15L. REPAIRED FRAME PER SRM.SDR SWAA013277Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND WEB CRACKED AT BS 178, LBL 17.1 AND WL 183. REPAIRED WEB PER SRM.SDR SWAA013276Tie Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 663.5, STR 4R. REMOVED AND REPLACED STR TIE CLIP PER SRM.SDR SWAA013271Splice · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER SPLICES CRACKED (2 EA) AT STR 4L, BS 360 AND BS 908. REMOVED AND REPLACED STR SPLICES PER SRM.SDR SWAA013252Tie Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER TIE CLIPS CRACKED (2 EA) AT BS 616, STRS 5L AND 5R. REMOVED AND REPLACED TIE CLIPS PER SRM.SDR SWAA013251Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND FRAME SHEAR TIES CRACKED (2 EA) AT BS 360 BETWEEN STRS 13L AND 15L. REPAIRED SHEAR TIES PER SRM.SDR SWAA013250Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 14R. REPAIRED FRAME PER SRM.SDR SWAA013226Tie Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 767, STR 11R. REMOVED AND REPLACED TIE CLIP PER SRM.SDR SWAA013227Tie Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 685, STR 4R. REMOVED AND REPLACED TIE CLIP PER SRM.SDR SWAA013112Battery · dischargedDURING SCHEDULED RON, FOUND FWD SVC DOOR EXTERIOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA012840Battery · dischargedDURING SCHEDULED PM CHECK, FOUND FWD ENTRY DOOR OVERHEAD AND SEVERAL BULLNOSE EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA012770Target · out of adjWHEN GEAR LOWERED FOR LANDING, GREEN LIGHT FOR NOSE GEAR DID NOT ILLUMINATE. AFTER MANUAL EXTENSION ALL INDICATIONS OK. FOUND NOSE GEAR POSITION SENSOR TARGET GAP OUT OF TOLERANCE. ADJUSTED TARGET AND CLEANED SENSOR PER MM.SDR SWAA012635Skin · crackedDURING WALK AROUND INSPECTION FOUND FUSELAGE SKIN CRACKED 4 INCHES LONG BETWEEN BS 500A & BS 500C, STR 14R. REPAIRED SKIN PER SRM.SDR SWAA012438Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA011540Battery Pack · dischargedDURING SCHEDULED C3 CHECK, FOUND EEPLS INOP. REMOVED AND REPLACED FWD AND AFT EEPLS BATTERY PACKS PER MM.SDR SWAA011508Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 380, STR 15L. REPAIRED SKIN PER SRM.SDR SWAA011481Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA011509Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 480 & BS 500A, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA011506Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA011502Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED EMERGENCY EVAC SLIDE GIRT ASSY PER MM.SDR SWAA011482Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, JUST ABOVE STR 12L. REPAIRED SKIN PER SRM.SDR SWAA011343Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CASE. REINSTALLED SLIDE PER MM.SDR SWAA011325Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CASE. REINSTALLED SLIDE PER MM.SDR SWAA010747Skin · crackedDURING WALK AROUND INSPECTION, FOUND 4 EXTERNAL FUSELAGE SKIN CRACK AT BS 747, BELOW STR 18R. REPAIRED SKIN PER SRM.SDR SWAA010508Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND EXTERNAL FUSELAGE SKIN CRACKED AT AFT SVC DOOR LOWER FWD CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA010378Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA002185Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 1.25 INCH CRACK AT LT HORIZ STAB LWR SKIN, AFT SPAR, APPROX STA 157. REPAIRED SKIN PER SRM.SDR SWAA001539Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD RT SIDE CHORD CRACKED, WL 207. REPAIRED CHORD PER SRM.SDR SWAA001487Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD CRACKED, RBL 11.5 AND LBL 2.5. REPAIRED BULKHEAD PER SRM.SDR SWAA001389Stringer · crackedDURING SCHEDULED C4 CHECK, FOUND STRINGER 10L CRACKED, BS 490. REPAIRED STRINGER PER SRM.SDR SWAA000960Wire · brokenAIR TURNBACK, NR 1 L/E SLAT TRANSIT LIGHT ILLUMINATED WITH FLAPS RETRACTED. VERIFIED FLAP/SLAT POSITION AND DEFERRED PER MEL. LATER AT DAL DURING RON REPAIRED BROKEN WIRE SPLICE AT NR 1 L/E SLAT ROD END.SDR SWAA000821Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP FROM ROW 18 TO AFT END. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA000551Panel · looseCOCKPIT DOOR EMERGENCY EXIT PANELS LOOSE. R&R COCKPIT DOOR PANELS BRAKE AWAY PIN PER MM.SDR SWAA991480Skin · crackedDURING WALKAROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED, BS 751, STRINGER 18R. REPAIRED PER SRM.SDR SWAA991241Seal · failedAIR TURNBACK, IN FLIGHT SHUTDOWN. NR 1 ENG OIL QTY DECREASED TO LESS THAN .5 GAL, LOW OIL PRESS LIGHT ILLUMINATED. REMOVED AND REPLACED NR 1 ENG STARTER GEAR PAD SEAL PER MM.SDR SWAA990983Bracket · misalignedLEFT AFT ENTRY DOOR LATCH WILL NOT ENGAGE GIRT BAR. REPOSITIONED AFT GIRT BAR BRACKET PER MM.
Back to N306SW, cancelled Feb 18, 2011