N319SW, cancelled Aug 28, 2008
Service difficulty reports · 200
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 = 'N319SW' AND deregistration_id = 'N319SW-2008-08-28' 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 = 'N319SW' AND deregistration_id = 'N319SW-2008-08-28' 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 SWAA012235Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND BEADED WEB CRACKED AT BS 663, LBL 32. REPAIRED WEB PER SWA T1-353-046.SDR SWAA012252Stringer Clip · corrodedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIPS CORRODED AT STR 26R, BS 727E, BS 767 & BS 787. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA011715Lens · missingOVER HEAD BIN BULL NOSE EMERGENCY EXIT LENS MISSING AT ROW 20 DEF. REPLACED LENS PER MM.SDR SWAA011385Light · inoperativeDURING SCHEDULED BC4 CHECK, FOUND OVERHEAD BIN BULL NOSE EMERGENCY EXIT LIGHT INOP. REPAIRED EGRESS LIGHT PER MM.SDR SWAA010864Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA010681Skin · crackedDURING WALK AROUND INSPECTION, FOUND 3 EXTERNAL FUSELAGE SKIN CRACK AT BS 760, BELOW STR 19R. REPAIRED SKIN PER SRM.SDR SWAA010228Cover · crackedDURING SCHEDULED C3 CHECK, FOUND EEPLS TRACK COVERS CRACKED AT ROW 1 & AT AFT GALLEY. REMOVED AND REPLACED TRACK COVERS PER MM.SDR SWAA010184Screw · missingFWD ENTRY DOOR EMERGENCY EVAC SLIDE ASSY MISSING SCREW. INSTALLED SCREW INBOARD SIDE PER MM.SDR SWAA002072Slat · crackedDURING SCHEDULED C2 CHECK, FOUND NR 1 SLAT LOWER SKIN CRACKED 6 AFT OF ANTI-ICE DUCT. REPAIRED SLAT PER T1-657-012.SDR SWAA002027Stiffener · crackedMX FERRY TO DAL, MLG WHEEL WELL VERTICAL STIFFENER CRACKED. REMOVED AND REPLACED STIFFENER PER SRM.SDR SWAA001917Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT AT DALFORT, FOUND 19 CRACKS AT BS 178 BULKHEAD, LBL 26 - RBL 15. REPAIRED BULKHEAD PER SRM & XEA X2-53-283.SDR SWAA001916Frame · crackedDURING SCHEDULED SPECIAL VISIT AT DALFORT, FOUND BS 178 LT SIDE CHORD CRACKED AT WL 207. REMOVED AND REPLACED SIDE CHORD PER ACO 7338-53.SDR SWAA001875Frame · crackedDURING SCHEDULED SPECIAL VISIT AT DALFORT, FOUND BS 178 BULKHEAD VERTICAL CHORD CRACKED AT LBL 5.7, WL 184.5. REPAIRED CHORD PER SRM.SDR SWAA001874Frame · crackedDURING SCHEDULED SPECIAL VISIT AT DALFORT, FOUND BS 178 RT SIDE CHORD CRACKED AT WL 207. REPAIRED RT SIDE CHORD PER ACO7342-53.SDR SWAA001873Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT AT DALFORT, FOUND BS 178 BULKHEAD WEB CRACKED AT WL 188.5, LBL 75 & RBL 75, WL 205, RBL 26. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA000229Spoiler Mixer · bindingAILERON STIFF AND FEELS BINDING WHEN MAKING LEFT ROLL. REMOVED AND REPLACED SPOILER MIXER, RATIO CHANGER AND AILERON BUS DRUM BEARING PER MM. OPS CHECK GOOD.SDR SWAA991080Sensor · malfunctionedAIR TURNBACK, LANDING GEAR WOULD NOT RETRACT DURING TAKEOFF. HANDLE WOULD NOT MOVE ABOVE OFF POSITON. ADJUSTED MAIN GEAR SAFETY SENSOR AND PERFORMED GEAR SWING CHECK PER MM.SDR SWAA991069Light · looseDURING SCHEDULED C1 CHECK, FOUND EMERGENCY ESCAPE FLOOR TRACK LIGHT LOOSE NEXT TO AFT GALLEY. RESECURED TRACK LIGHT PER MM.SDR SWAA990664Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND 4 CRACKS AT BS 178 BULKHEAD BETWEEN LBL12.5-RBL 9.5. REPAIRED BULKHEAD PER SRM.SDR SWAA990206Bulkhead · crackedDURING SCHEDULED SC CHECK, FOUND BS 1016 BULKHEAD CRACKED NEAR S6L. REPAIRED PER SWA RA 1-353-2005.SDR SWAA982937Lamp · failedDURING SCHEDULED SC CHECK, FOUND ROW 22 BULLNOSE EMERG LIGHT INOP. RELAMPED PER BOEING M/M.SDR SWAA981212Intercostal · crackedDURING SCHEDULED CI-CHECK, FOUND CRACKED AFT CARGO DOOR UPLOCK INTERCOSTAL. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA971040Fire Warning · malfunctionedON DESCENT, AFTER STARTING APU, CREW RECIEVED FIRE WARNING. CREW COMPLIED WITH CHECKLIST AND EXPENDED BOTH FIRE BOTTLES. INSPECTED AND FOUND NO EVIDENCE OF FIRE OR OVERHEAT CONDTION. REMOVED AND REPLACED APU TAILPIPE MUFFLER, AND FIRE EXTINGUISHER BOTTLES PSDR SWAA970491Skin · crackedDURING SCHEDULED A CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 516 TO 520, AT S12L. REPAIRED PER BOEING SRM.SDR SWAA970490Skin · crackedDURING SCHEDULED A CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 942, AT S24L. REPAIRED PER BOEING SRM.SDR SWAA970489Skin · crackedDURING SCHEDULED A CHECK, FOUND FWD GALLEY DOOR SKIN CUTOUT CRACKED 3.2. REPAIRED PER BOEING SRM.SDR SWAA961242Rib · crackedDURING SCHEDULED D-CHECK, FOUND RT HORZ STAB L/E RIBS NR 1, 3, 4, 5, 6 AND 7 CRACKED. REPAIRED PER BOEING SRM.SDR SWAA961231Frame · damagedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME. REPAIRED PER BOEING SRM.SDR SWAA961230Support · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FLOOR SUPPORT AT BS 540, RBL 2, WL 208. REPLACED PER BOEING SRM.SDR SWAA961229Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 64, WL 202. REPAIRED PER BOEING SRM.SDR SWAA961228Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 296, RBL 54, WL 209. REPAIRED PER BOEING SRM.SDR SWAA961227Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOOR BEAM CORRODED AT BS 986.5, RBL 26, RBL 4-5, AND AT LBL 3-5, WL 208. REPAIRED PER BOEING SRM.SDR SWAA961226Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN DENTED AT BS 1000, UNDER S14L. REPAIRED PER BOEING SRM.SDR SWAA961225Clip · brokenDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS BROKEN AT BS 616, S1, 2L, 4L, AT BS 663, S10R, S10L, AND AT BS 639, S1, 2R, AND S2L. REPLACED PER BOEING SR.SDR SWAA961224Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE DENTED AT BS 415, BETWEEN S24 AND 26R. REPAIRED PER BOEING SRM.SDR SWAA961223Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE DENTED BETWEEN BS 390 AND 398, BETWEEN S24 AND 25R. REPAIRED PER BOEING SRM.SDR SWAA961222Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE DENTED AT BS 814, LBL 7, WL 146, AT S28L. REPAIRED PER BOEING SRM.SDR SWAA961221Web · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 PRESSURE WEB CRACKED 2 PLACES AT WL 201, LBL 4.7, AND AT WL 198, LBL 4.7. REPAIRED PER TRAMCO EWO 96-0621.SDR SWAA961220Web · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 PRESSURE WEB CRACKED 2 PLACES AT WL 201, RBL 4.7, AND AT WL 198, RBL 4.7. REPAIRED PER TRAMCO EWO 96-0621.SDR SWAA961219Web · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 PRESSURE WEB CRACKED AT WL 219, RBL 10.7. REPAIRED PER TRAMCO EWO 96-0621.SDR SWAA961218Chord · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 SIDE CHORD CRACKED 1 INCH LT SIDE AT APPROXIMATELY WL 195. CUT OUT DAMAGED SECTION AND REPLACED PER BOEING SRM.SDR SWAA961217Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO BAY FLOOR BEAM CORRODED FROM 727-947.5, RBL 13.8, WL 155.5. REPLACED DAMAGED SECTION PER BOEING SRM.SDR SWAA961216Frame · crackedDURING SCHEDULED D-CHECK, FWD SERVICE DOOR FRAME CUT-OUT WEB CRACKED. REPLACED DAMAGED SECTION PER BOEING SRM.SDR SWAA961215Frame · crackedDURING SCHEDULED D-CHECK, FWD GALLEY DOOR AFT SIDE FRAME CRACKED AT NR 4 STOP FITTING CUTOUT. REPLACED PER BOEING SRM.SDR SWAA960963Skin · dentedDURING SCHEDULED TC CHECK, FOUND FUSELAGE SKIN DENTED AT BS 887 BETWEEN S16 AND 17L, BS 500 S22 TO 23L. REPAIRED PER BOEING SRM.SDR SWAA960962Skin · gougedDURING SCHEDULED TC CHECK, FOUND FUSELAGE SKIN GOUGED AT BS 360, BETWEEN S5L AND S6L. REPAIRED PER BOEING SRM.SDR SWAA960961Skin · lightning strikeDURING SCHEDULED TC CHECK, FOUND FUSELAGE SKIN DAMAGED FROM LIGHTNING STRIKE AT BS LOWER CORNER L1 DOOR CUTOUT. REPAIRED PER BOEING SRM.SDR SWAA960960Skin · lightning strikeDURING SCHEDULED BC2 CHECK, FOUND FUSELAGE SKIN DAMAGED FROM LIGHTNING STRIKE AT BS 480 BELOW S18L. REPAIRED PER BOEING SRM.SDR SWAA960301Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EMERGENCY EXIT LIGHT INOP. REPLACED BATTERY PACK AND CHARGER HOUSING PER BOEING M/M.SDR SWAA950550Strap · crackedDURING SCHEDULED B/C1 CHECK, FOUND FLOOR BEAM SUPPORT STRAP CRACKED AT RBL 31 IN E AND E COMPARTMENT. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.
Back to N319SW, cancelled Aug 28, 2008